JackNopper wrote:I just upgraded successfully from 3.50 to 3.60. Now, when I try to upgrade from 3.60 to 3.70 I receive the following error after restarting the website. I executed the nopCommerce upgrade script and the ShopAll script successfully, copied the Plugins and Themes folders and restored the old AppData settings files (I will post the entire stack if someone wants to see it). Looking though the nopCommerce upgrade script, I noticed that it drops two columns named "HasDiscountsApplied":
Invalid column name 'HasDiscountsApplied'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Invalid column name 'HasDiscountsApplied'.
Source Error:
Line 31: else
Line 32: {
Line 33: @Html.Action("TopMenu", "Catalog")
Line 34: }
Line 35: </div>
Source File: c:\HostingSpaces\admin1\shop.milwaukeemap.com\wwwroot\Themes\ShopAll\Views\Shared\_Root.cshtml Line: 33
Hi,
As I have replied to your ticket:
It sounds like you have done everything correctly.
Yes, the upgrade script drops the "HasDiscountsApplied" column, but we have never had a problem with that.
I think you are missing something, but I am not sure what.
Please take a look once more in the upgrade process and ensure that everything was done:
1. Back-up your database.
2. Back-up your InstalledPlugins.txt and Settings.txt files.
3. For each mid-version, run the upgrade scripts if has any - first nopCommerce`s, then our.
4. Download the latest nopCommerce version and place it in the folder you want.
5. Place the InstalledPlugins.txt and Settings.txt files in the App_Data folder.
6. Download our products and place them in the corresponding folders.
7. Add a blank space to the end of the Global.asax file to trigger full site restart.
8. Run nopCommerce.
If anyone have seen this, they can share their experience too !