Challenge upgrading from 1.5 then to 1.6 then to 1.7

9 years ago
Msg 207, Level 16, State 1, Procedure Nop_ProductVariantInsert, Line 105
Invalid column name 'CustomerEntersPrice'.
Msg 207, Level 16, State 1, Procedure Nop_ProductVariantInsert, Line 106
Invalid column name 'MinimumCustomerEnteredPrice'.
Msg 207, Level 16, State 1, Procedure Nop_ProductVariantInsert, Line 107
Invalid column name 'MaximumCustomerEnteredPrice'.
Msg 207, Level 16, State 1, Procedure Nop_ProductVariantUpdate, Line 104
Invalid column name 'CustomerEntersPrice'.
Msg 207, Level 16, State 1, Procedure Nop_ProductVariantUpdate, Line 105
Invalid column name 'MinimumCustomerEnteredPrice'.
Msg 207, Level 16, State 1, Procedure Nop_ProductVariantUpdate, Line 106
Invalid column name 'MaximumCustomerEnteredPrice'.
Msg 207, Level 16, State 1, Procedure Nop_GiftCardLoadAll, Line 27
Invalid column name 'IsRecipientNotified'.

These are the errors I got when I ran the upgrade script.

This resulted in the following error on the site on initial load.  I'm certain I started the upgrade with a 1.6 database and I'm certain that the application binding is pointing to the right database (and version).

Exception Details: System.Data.SqlClient.SqlException: Invalid column name 'FlagImageFileName'.

I have a fairly large database so I don't look forward to a 1.7 clean setup where I manually port the data over.

Any insight is appreciated.
9 years ago
Of course... "certain" could mean so many things...

Turns out, it was a 1.5 database and I hadn't rolled it to 1.6 yet.

Hopefully that helps someone in the future that gets the same error

Jared Nielsen
www.FUZION.org