Upgrade scrpit error nop 2.2 to 2.3

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
12 years ago
I am want to upgrade my nop2.2 to 2.4, so i am trying to upgrade from 2.2 to 2.3 frist and getting following error while excuting SQL script..

(113 row(s) affected)
Msg 208, Level 16, State 1, Line 363
Invalid object name 'Language'.
Msg 208, Level 16, State 1, Line 7
Invalid object name 'Setting'.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.Log" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Line 3
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'Setting'.
Msg 4902, Level 16, State 1, Line 6
Cannot find the object "dbo.Category" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'dbo.Category'.
Msg 4902, Level 16, State 1, Line 2
Cannot find the object "dbo.Category" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 4
Cannot find the object "dbo.Category" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'dbo.Category'.
Msg 4902, Level 16, State 1, Line 5
Cannot find the object "dbo.Manufacturer" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'dbo.Manufacturer'.
Msg 4902, Level 16, State 1, Line 2
Cannot find the object "dbo.Manufacturer" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 4
Cannot find the object "dbo.Manufacturer" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'dbo.Manufacturer'.
Msg 4902, Level 16, State 1, Line 5
Cannot find the object "dbo.ProductVariant" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 3
Cannot find the object "dbo.ProductVariant" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 3
Cannot find the object "dbo.ProductVariant" because it does not exist or you do not have permissions.

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)
Msg 1767, Level 16, State 0, Line 1
Foreign key 'BackInStockSubscription_ProductVariant' references invalid table 'dbo.ProductVariant'.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
Msg 1767, Level 16, State 0, Line 1
Foreign key 'BackInStockSubscription_Customer' references invalid table 'dbo.Customer'.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
Msg 4902, Level 16, State 1, Line 3
Cannot find the object "dbo.ProductVariant" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.ProductVariant'.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.ProductVariant" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3
Invalid object name 'dbo.MessageTemplate'.
Msg 208, Level 16, State 1, Line 3
Invalid object name 'PermissionRecord'.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'PermissionRecord'.
Msg 208, Level 16, State 1, Line 5
Invalid object name 'dbo.PermissionRecord'.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'dbo.PermissionRecord'.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'dbo.PermissionRecord'.
Msg 208, Level 16, State 1, Line 4
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 4
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 4
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3
Invalid object name 'Setting'.
Msg 4902, Level 16, State 1, Line 5
Cannot find the object "dbo.ProductVariant" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Line 3
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3
Invalid object name 'Setting'.

Any help would be really helpfull..
12 years ago
I had the same errors.
Any suggestions?
Ciao, Diego.
12 years ago
ANy help would be great, I am stuck & not able to upgrade :(
12 years ago
Its sad there isnt any reposne on this.. I am stucking using 2.2 and cant move forward, i have 2000
+ products, export to excel also not working.. and no help whats so ever on this issue.. very disappointing..
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.