Looking for the v10 manual? Visit our new user's guide!
Search Descriptions Version
This article applies to: MultiStore

NULL Value Error thrown on cart page after upgrading to MSx 9300 when adding a promo

Any cart that at some point has been on version 5.9 or earlier and has upgraded to 9.3 (MSx 9300) is going to get this error the first time a promo is added to the cart:

    Page URL: /shoppingcart.aspx
    Source: System.Data.Linq
    Message: The null value cannot be assigned to a member with type System.Int32 which is a non-nullable value type.

Database issue on dbo.ShoppingCart

The fix is to run the query below on the DB which you can do in your admin console - Configuration - Advanced - Run SQL:

    ALTER TABLE dbo.ShoppingCart
    ADD CONSTRAINT DF_ShoppingCart_RecurringIndex DEFAULT(0) FOR RecurringIndex