Challenge upgrading from 1.5 then to 1.6 then to 1.7

Posted: July 11, 2010 at 1:52 AM Quote #20982
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.
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: July 11, 2010 at 4:21 AM Quote #20983
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
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Premium support services
  • Dedicated premium support services provided by core developers are intended for persons who run mission critical websites, work on projects with tight deadlines, or want to get dedicated support.
Professional services
  • Want to open a new store? Want to take your store to the next level? Need a custom extension? We can customize nopCommerce to fit your store perfectly. Request a quote to get started.