I have version 4.2 with the Minimal theme installed (modified). I would like to upgrade to the latest versions -> nop4.3. I downloaded the zipped packages and created a new folder with the latest bits. Before attempting to run the new version, I used the SQL upgrade file and tried to update the existing database from version 4.2 and was presented with the following errors from SQL management Studio.
Am I doing something wrong? Do I need to do anything else before upgrading the Database with the SQL File? Please advise.
(312 rows affected)
Msg 208, Level 16, State 1, Line 992
Invalid object name 'Language'.
Msg 208, Level 16, State 1, Line 1051
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 1059
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 1067
Invalid object name 'Setting'.
Msg 208, Level 16, State 6, Procedure DeleteGuests, Line 3 [Batch Start Line 1090]
Invalid object name 'DeleteGuests'.
Msg 208, Level 16, State 1, Line 1167
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 1176
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 1184
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 1192
Invalid object name 'Setting'.
Msg 4902, Level 16, State 1, Line 1202
Cannot find the object "Order" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1209
Cannot find the object "Discount" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1215
Cannot find the object "RewardPointsHistory" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 6, Procedure ProductLoadAllPaged, Line 3 [Batch Start Line 1397]
Invalid object name 'ProductLoadAllPaged'.
Msg 208, Level 16, State 6, Procedure DeleteGuests, Line 3 [Batch Start Line 2001]
Invalid object name 'DeleteGuests'.
Msg 4902, Level 16, State 1, Line 2089
Cannot find the object "GenericAttribute" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Line 2095
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 2103
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 2111
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 2119
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 2127
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 2135
Invalid object name 'Setting'.
Msg 208, Level 16, State 6, Procedure ProductLoadAllPaged, Line 3 [Batch Start Line 2140]
Invalid object name 'ProductLoadAllPaged'.
(0 rows affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
Msg 208, Level 16, State 1, Line 2930
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 2938
Invalid object name 'Setting'.
(168 rows affected)
Caution: Changing any part of an object name could break scripts and stored procedures.
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
Msg 208, Level 16, State 1, Line 3034
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3057
Invalid object name 'ActivityLogType'.
Msg 208, Level 16, State 1, Line 3071
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3128
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3146
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3154
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3162
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3175
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3183
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3191
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3199
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3207
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3215
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3223
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3231
Invalid object name 'Setting'.
(7 rows affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
Msg 208, Level 16, State 1, Line 3257
Invalid object name 'Country'.
Msg 4902, Level 16, State 1, Line 3265
Cannot find the object "RewardPointsHistory" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Line 3270
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3278
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3286
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3295
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3303
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3311
Invalid object name 'Setting'.
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)