3.5 to 3.9 upgrade issues?

Hi, Is there any know issues upgrading from 3.5 to 3.9? Also can I just upgrade to 3.9, or do I have to go from 3.6, 3.7, 3.8, etc?

Thanks, Jeff - Buffalo Icon Apparel

Hello,

There is no any issue.

You cant upgrade database like 3.50 to 3.90. But your customize code you can copy paste direct in 3.90 code.

You have to go step by step for database upgrade. 3.50 to 3.60 then 3.60 to 3.70 then 3.70 to 3.80 then 3.80 to 3.90

PM me if you want any commercial help. We are provide service for same.

Thanks,
Jatin

I have a long-standing site running on nopCommerce v3.5, hosted at GoDaddy on one of their (now) "Classic" hosting packages, and I'm attempting to upgrade everything to the newest version of nopCommerce (v3.9 as of this writing). The GoDaddy hosting is a Windows account (obviously) running IIS 7.0 and is configured for a .NET v4.0/4.5 application pool.

I duplicated my site locally to a Windows 10 Home Premium machine running IIS (v10.0.14393.0) and Microsoft SQL Server 2012 Express Edition.

Running the v3.6 upgrade script on the v3.5 install fails with the following multiple errors.

[code](285 row(s) affected)
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.

(2 row(s) affected)
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.

(2 row(s) affected)
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.

(2 row(s) affected)

(2 row(s) affected)

(2 row(s) affected)

(2 row(s) affected)
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.

(2 row(s) affected)

(2 row(s) affected)

(2 row(s) affected)

(2 row(s) affected)

(2 row(s) affected)

(2 row(s) affected)
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.

(2 row(s) affected)
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.

(2 row(s) affected)

(2 row(s) affected)

(2 row(s) affected)

(2 row(s) affected)
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.

(2 row(s) affected)

(2 row(s) affected)
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.

(2 row(s) affected)

(2 row(s) affected)

(2 row(s) affected)

(2 row(s) affected)
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902
Cannot insert the value NULL into column 'Id', table 'wrb2017.dbo.LocaleStringResource'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 902

Hello,

Mostly every error is with one table and is about some null records. I would suggest you to check this table in existing database and repair it manually before you start upgrade.

atulrungta wrote:

Atul,

Can you recommend what to do to check and repair that database?

I am getting the issue with an upgrade from nopCommerce 3.5 to 3.6.

Before I run the upgrade script, if I run this script on the 3.5 database:

SELECT TOP (10000) [Id]
      ,[LanguageId]
      ,[ResourceName]
      ,[ResourceValue]
  FROM [AutoImages360].[dbo].[LocaleStringResource]
  WHERE Id IS NULL OR LanguageId IS NULL OR ResourceName IS NULL OR ResourceValue IS NULL

It does not find any rows out of 4,767 rows in the table.

If there are nulls in that table, where are they?

Thanks,
Tony

It's not about the data in your existing tables.  When upgrading, the script has the NEW resources that have been added to the system. They get INSERTed into the LocaleStringResource table.  You can see the string resources in the upgrade.sql as an XML structure - e.g.

--new locale resources
declare @resources xml
--a resource will be deleted if its value is empty
set @resources='
<Language>
  <LocaleResource Name="Admin.Configuration.Settings.Shipping.NotifyCustomerAboutShippingFromMultipleLocations">
    <Value>Notify customer about shipping from multiple locations</Value>
  </LocaleResource> 
...
</Language>

Which is then 'parsed' by SQL code via

INSERT INTO #LocaleStringResourceTmp (ResourceName, ResourceValue)
SELECT  nref.value('@Name', 'nvarchar(200)'), nref.value('Value[1]', 'nvarchar(MAX)')
FROM  @resources.nodes('//Language/LocaleResource') AS R(nref)

...etc.

So, it's more likely that there is a problem with the XML string, or maybe you have 'lost' the LocaleStringResource table's IDENTITY property which auto-populates the Id field.

Thanks for your help.

New York wrote:

So, should I download the UpgradeScript again?

New York wrote:

How would I check this?  The website seems to be running OK and there are no errors in the System log.
Also, the LocaleStringResource does have an Id column.

Thanks,
Tony

See what happens when you do this (in a tool like SSMS, logged into your database)

INSERT INTO LocaleStringResource (LanguageId, ResourceName, ResourceValue) VALUES (1, 'TestName', 'TestValue');


(If successful, then you can...
DELETE LocaleStringResource WHERE ResourceName = 'TestName'
)