1.4

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
14 years ago
Thankyou for the new upgrade!

Can you please advise if there were database modifications between 1.30 and 1.40

Thanks,
Matthew
14 years ago
The answer is yes....
14 years ago
do you know if there is a list of those changes?
14 years ago
Look at the upgrade sql script in install/scripts
14 years ago
On GoDaddy SQL Server Web Admin:

If I execute nopCommerce_upgrade.sql (from /Install/Scripts/1.40) in Query Analyzer I get this error:

Invalid column name 'RequiresTextOption'. Invalid column name 'TextOptionPrompt'.

On Microsoft SQL Server Management Studio Express:

Msg 207, Level 16, State 1, Procedure Nop_ProductVariantInsert, Line 78
Invalid column name 'RequiresTextOption'.
Msg 207, Level 16, State 1, Procedure Nop_ProductVariantInsert, Line 79
Invalid column name 'TextOptionPrompt'.
Msg 207, Level 16, State 1, Procedure Nop_ProductVariantUpdate, Line 0
Invalid column name 'RequiresTextOption'.
Msg 207, Level 16, State 1, Procedure Nop_ProductVariantUpdate, Line 0
Invalid column name 'TextOptionPrompt'.
Msg 207, Level 16, State 1, Procedure Nop_OrderProductVariantInsert, Line 37
Invalid column name 'TextOption'.
Msg 207, Level 16, State 1, Procedure Nop_OrderProductVariantUpdate, Line 0
Invalid column name 'TextOption'.
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.