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 will be occured if we have made localization with our nopcommerce 1.4 site. When we have more than 1 language installed in our database and set our local language as the default language instead of english. Our admin area's resoureces' caption will display with data from "LocaleResource Name" field, not the "Value" filed in "LocaleStringResource" Table. nopCommerce 1.40 has not separate the localization of it's public store front and admin area.
I also got this bug. I Dashboard menu was display as "Admin.Dashboard", Store Statistics menu was display as "Store Statistics" for example. The submenus were mixed up because of too long text displayed.
I have to select the language to be English everytime i loggin in the admin area to make it looked fine. So, I create a new sql script and copy the data of "LocaleStringResource" Table from the "nopCommerce_upgrade.sql" file extracted from nopComerce 1.40 Installation Set (line 1 - 9380) into my new sql script file.
The new sql script file should begin with
--new locale resources declare @resources xml set @resources=' <Language LanguageID="7"> <LocaleResource Name="Address.FirstNameIsRequired"> <Value>First name is required</Value> </LocaleResource> .... .... ....
Ending with
.... .... CLOSE cur_localeresource DEALLOCATE cur_localeresource
DROP TABLE #LocaleStringResourceTmp GO
In the new sql script we have to change the LanguageID Value in Line No. 4 (9 of "nopCommerce_upgrade.sql") In my case (Thai Language), LanguageID must be "8" Then, I change the value of each LocaleResource Record to "Thai" as I needed, and save the file.
I run my new adminlocaleresource.sql script file in my database and go back to my admin area and refresh, then every resources had been shown as it should be.