Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 2 of 2

Thread: Help with product variants

  1. 05-09-2010, 07:57 AM #1
    HomeIndoor is offline Member
    Join Date
    Nov 2008
    Posts
    64

    Question Help with product variants

    We recently upgraded to version ML 8.0.1.2/8.0.1.2 of the storefront.and noticed that when we add a product to the store we get the following error

    Cannot insert the value NULL into column 'DisplayOrder', table 'homeindoor_msk.dbo.ProductVariant'; column does not allow nulls. INSERT fails.
    The statement has been terminated.

    So our normal plan of action was to go into the database and set the default value. As soon as we fix this, then we will get another Cannot insert the value NULL into another column. And after fixing this area, this simple continues on. I have confirmed we our DBA that their is a string that sets the variants when a product is created is not working correctly.

    This is the last error that we got

    [SqlException (0x80131904): Cannot insert the value NULL into column 'DisplayOrder', table 'homeindoor_msk.dbo.ProductVariant'; column does not allow nulls. INSERT fails.

    After spending 3 hours going down the list of items that we kept getting this error for everything was working fine, but now this created another problem. The product page would not display any prices, so we fix one problem, but created another problem. Right now we are looking for a solution to fix this variant issue. All help will be appreciated.
    Last edited by ASPAlfred; 05-09-2010 at 05:54 PM.
  2. 05-09-2010, 05:53 PM #2
    ASPAlfred is offline Senior Member
    Join Date
    Nov 2007
    Posts
    2,244

    Default

    It looks like that particular table was using a different schema (homeindoor_msk.dbo.ProductVariant'), you need to reset it to dbo. Try running the "Reset Tables to dbo Schema" script from the db folder and see if that resolves the issue. Otherwise, send this into support and will take a look.