614 users online

Upgrade scrpit error nop 2.2 to 2.3

Posted: 3 months ago Quote
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..
This post/answer is useful
-1
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: 3 months ago Quote
I had the same errors.
Any suggestions?
Ciao, Diego.
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: 3 months ago Quote
ANy help would be great, I am stuck & not able to upgrade :(
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: 3 months ago Quote
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 post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)