SQL Upgrade script fails from 1.40 to 1.50

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
14 anni tempo fa
Hello I am trying to upgrade from 1.40 to 1.50, but the SQL Upgrade script failed.

I receive a lot of the next errors:

Cannot insert the value NULL into column 'LocaleStringResourceID', table 'Divas150.dbo.Nop_LocaleStringResource'; column does not allow nulls. INSERT fails.

Before when I upgraded from 1.30 to 1.40 I didn't have any issues.
14 anni tempo fa
are you doing the upgrade locally or over a hosted database?

so far i only ran it over a current database using servermanagement studio - it was completed without problems
14 anni tempo fa
I ran the script locally with sql management studio.
14 anni tempo fa
did you make any structural changes to your original database ?

where did Divas150 come from?
14 anni tempo fa
No, I didn't do any structural change to my db.

I exported the data from the original 1.40 DB to another database (Divas150) in which I am testing. I don't know if this is the reason (maybe I have to cpy the DB in another way).

I just have problems with the next 2 tables:

Nop_LocaleStringResource and Nop_Setting
14 anni tempo fa
Hello,

During upgrade from 1.40 to 1.50 I have a message (step 3):
Upgrade script from your version is not available
What is wrong?
13 anni tempo fa
gRRuby wrote:
Hello,

During upgrade from 1.40 to 1.50 I have a message (step 3):
Upgrade script from your version is not available
What is wrong?


Hi gRRuby,

Can you check your existing database's user? You required to grant a user that have priviledge to upgrade your script.
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.