1.40 upgrade script error

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'.

http://infoappz.com/nopScreenshot.jpg This is how the admin area looks like.

You should execute nopCommerce_upgrade.sql script ONLY ONCE! Please restore your database backup (v1.30) and try to execute it one more time

I'm having the same problem. What is the proper order of installing a clean Database for 1.40 ?

I'm running in the following order:
1. nopCommerce_createDatabase.sql ( installs successfully )
2. nopCommerce_createData.sql ( installs successfully )
3. nopCommerce_upgrade.sql from 1.40 folder ( fails with the above mentioned errors )

Thank you,
Zohrab Broyan.

Don't use the upgrade script if you are doing a clean install.

i.e. you are not doing an upgrade from a previous version if you are doing a new install.

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.