Error on Installation Upgraded from 3.70 to 4.0

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
6 years ago
Copied 3.7 DB from Arvixe to a Trial account on SmarterASP using MS SQL Server Management Studio / Export & Import Wizard.  

Ran 3.8, 3.9 and 4.0 nopCommerce Upgrade Scripts on new DB using script execution tool in SmarterASP CPanel

FTP'd nopCommerce 4.0 nosource files to host site

Copied old settings.txt and installedplugins.txt

Getting this error on first load:

An error occurred while starting the application.

.NET Framework 4.6.1590.0 X86 v4.0.0.0    |   Microsoft.AspNetCore.Hosting version 2.0.0-rtm-26452    |    Microsoft Windows 6.3.9600    |   Need help?



Log file shows this:

Application startup exception: System.Data.Entity.Infrastructure.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. ---> System.Data.Entity.Core.UpdateException: An error occurred while updating the entries. See the inner exception for details. ---> System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'Id', table 'myDBname.dbo.Log'; column does not allow nulls. INSERT fails.
The statement has been terminated.


Any suggestions, greatly appreciated.
6 years ago
Maybe this https://www.nopcommerce.com/boards/t/46750/error-after-migration-cannot-insert-the-value-null-dbolog.aspx

(Otherwise, the Id column of the log table should be an Identity column and auto-increment; maybe that got lost during upgrade)
6 years ago
Yes.  Appears to be an issue with the wizard not retaining the Primary Key on ID fields.  Problem is, I don't know how else to get the data out Arvixe with any other method, yet...
6 years ago
Easier than I was making it.  Can export .bak file from Arvixe cpanel and import into SmarterASP via their cpanel.
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.