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'.
http://infoappz.com/nopScreenshot.jpg This is how the admin area looks like.
Column "RequiresTextOption" and "TextOptionPrompt" are not existed in the table "Nop_ProductVariant" any more, for all store procs related to the table, please remove these two parameters, otherwise it will cause error when doing upgrade.
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.