4.20 to 4.30 upgrade - failed

I have a demo store (basic install) that I use for testing updates ect. Currently the upgrade script to go from 4.20 to 4.30 generates several errors, and the website fails to start after the upgrade. For reference this 4.20 install is only about a week old.

SQL upgrade output:

(304 rows affected)
Msg 208, Level 16, State 1, Line 968
Invalid object name 'Language'.
Msg 208, Level 16, State 1, Line 1027
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 1035
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 1043
Invalid object name 'Setting'.
Msg 208, Level 16, State 6, Procedure DeleteGuests, Line 3 [Batch Start Line 1066]
Invalid object name 'DeleteGuests'.
Msg 208, Level 16, State 1, Line 1143
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 1152
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 1160
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 1168
Invalid object name 'Setting'.
Msg 4902, Level 16, State 1, Line 1178
Cannot find the object "Order" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1185
Cannot find the object "Discount" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1191
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 1373]
Invalid object name 'ProductLoadAllPaged'.
Msg 208, Level 16, State 6, Procedure DeleteGuests, Line 3 [Batch Start Line 1977]
Invalid object name 'DeleteGuests'.
Msg 4902, Level 16, State 1, Line 2065
Cannot find the object "GenericAttribute" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Line 2071
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 2079
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 2087
Invalid object name 'Setting'.
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 6, Procedure ProductLoadAllPaged, Line 3 [Batch Start Line 2116]
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 2906
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 2914
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 3010
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3033
Invalid object name 'ActivityLogType'.
Msg 208, Level 16, State 1, Line 3047
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3104
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3122
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3130
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3138
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3151
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3159
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3167
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'.

(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 3233
Invalid object name 'Country'.
Msg 4902, Level 16, State 1, Line 3241
Cannot find the object "dbo.RewardPointsHistory" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Line 3246
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3254
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3262
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3271
Invalid object name 'Setting'.

Website output

An unhandled exception occurred while processing the request.
SqlException: Invalid column name 'CreatedOrUpdatedDateUTC'.
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, bool breakConnection, Action<Action> wrapCloseInAction)

SqlException: Invalid column name 'CreatedOrUpdatedDateUTC'.
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, bool breakConnection, Action<Action> wrapCloseInAction)
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, bool breakConnection, Action<Action> wrapCloseInAction)
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, bool callerHasConnectionLock, bool asyncClose)
System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, out bool dataReady)
System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
System.Data.SqlClient.SqlDataReader.get_MetaData()
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, string resetOptionsString)
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, bool returnStream, bool async, int timeout, out Task task, bool asyncWrite, SqlDataReader ds)
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, bool returnStream, string method)
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
LinqToDB.Data.DbCommandProcessor.DbCommandProcessorExtensions.ExecuteReaderExt(IDbCommand cmd, CommandBehavior commandBehavior)
LinqToDB.Data.DataConnection.ExecuteReader(IDbCommand command, CommandBehavior commandBehavior)
LinqToDB.Data.DataConnection.ExecuteReader(CommandBehavior commandBehavior)
LinqToDB.DataContext+QueryRunner.ExecuteReader()
LinqToDB.Linq.QueryRunner.ExecuteQuery<T>(Query query, IDataContext dataContext, Mapper<T> mapper, Expression expression, object[] ps, int queryNumber)+MoveNext()
System.Collections.Generic.List<T>..ctor(IEnumerable<T> collection)
System.Linq.Enumerable.ToList<TSource>(IEnumerable<TSource> source)
Nop.Services.Caching.Extensions.IQueryableExtensions.ToCachedList<T>(IQueryable<T> query, CacheKey cacheKey) in IQueryableExtensions.cs
Nop.Services.Common.GenericAttributeService.GetAttributesForEntity(int entityId, string keyGroup) in GenericAttributeService.cs
Nop.Services.Common.GenericAttributeService.GetAttribute<TPropType>(BaseEntity entity, string key, int storeId, TPropType defaultValue) in GenericAttributeService.cs
Nop.Web.Framework.WebWorkContext.get_WorkingLanguage() in WebWorkContext.cs
Nop.Web.Framework.Globalization.CultureMiddleware.SetWorkingCulture(IWebHelper webHelper, IWorkContext workContext) in CultureMiddleware.cs
Nop.Web.Framework.Globalization.CultureMiddleware.Invoke(HttpContext context, IWebHelper webHelper, IWorkContext workContext) in CultureMiddleware.cs
Microsoft.AspNetCore.Builder.UseMiddlewareExtensions+<>c__DisplayClass4_1.<UseMiddleware>b__2(HttpContext context)
Microsoft.AspNetCore.Localization.RequestLocalizationMiddleware.Invoke(HttpContext context)
Microsoft.AspNetCore.Session.SessionMiddleware.Invoke(HttpContext context)
Microsoft.AspNetCore.Session.SessionMiddleware.Invoke(HttpContext context)
Nop.Services.Installation.InstallUrlMiddleware.Invoke(HttpContext context, IWebHelper webHelper) in InstallUrlMiddleware.cs
Nop.Services.Common.KeepAliveMiddleware.Invoke(HttpContext context, IWebHelper webHelper) in KeepAliveMiddleware.cs
Microsoft.AspNetCore.ResponseCompression.ResponseCompressionMiddleware.Invoke(HttpContext context)
Microsoft.AspNetCore.Diagnostics.StatusCodePagesMiddleware.Invoke(HttpContext context)
Microsoft.AspNetCore.Diagnostics.StatusCodePagesMiddleware.Invoke(HttpContext context)
Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddleware.<Invoke>g__Awaited|6_0(ExceptionHandlerMiddleware middleware, HttpContext context, Task task)
Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddleware.HandleException(HttpContext context, ExceptionDispatchInfo edi)
Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddleware.<Invoke>g__Awaited|6_0(ExceptionHandlerMiddleware middleware, HttpContext context, Task task)
Microsoft.AspNetCore.Diagnostics.DeveloperExceptionPageMiddleware.Invoke(HttpContext context)

This wont help you, but i upgraded a demo store right now without any issues.

304 rows affected.

Thanks for the response, at least I know someone has seen this. :)

I deleted the website and database, downloaded the current 4.20 files (nopCommerce_4.20_NoSource_FrameworkDependent) and installed a fresh copy of NopCommerce 4.20. with sample data, No errors. I downloaded the new 4.30 release and the nopCommerce_4.30_UpgradeScripts. Ran the scripts against the new database and got the exact same results.

SQL Output

(304 rows affected)
Msg 208, Level 16, State 1, Line 968
Invalid object name 'Language'.
Msg 208, Level 16, State 1, Line 1027
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 1035
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 1043
Invalid object name 'Setting'.
Msg 208, Level 16, State 6, Procedure DeleteGuests, Line 3 [Batch Start Line 1066]
Invalid object name 'DeleteGuests'.
Msg 208, Level 16, State 1, Line 1143
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 1152
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 1160
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 1168
Invalid object name 'Setting'.
Msg 4902, Level 16, State 1, Line 1178
Cannot find the object "Order" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1185
Cannot find the object "Discount" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1191
Cannot find the object "RewardPointsHistory" because it does not exist or you do not have permissions.

(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 6, Procedure ProductLoadAllPaged, Line 3 [Batch Start Line 1373]
Invalid object name 'ProductLoadAllPaged'.
Msg 208, Level 16, State 6, Procedure DeleteGuests, Line 3 [Batch Start Line 1977]
Invalid object name 'DeleteGuests'.
Msg 4902, Level 16, State 1, Line 2065
Cannot find the object "GenericAttribute" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Line 2071
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 2079
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 2087
Invalid object name 'Setting'.
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 6, Procedure ProductLoadAllPaged, Line 3 [Batch Start Line 2116]
Invalid object name 'ProductLoadAllPaged'.

(168 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 2906
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 2914
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 3010
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3033
Invalid object name 'ActivityLogType'.
Msg 208, Level 16, State 1, Line 3047
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3104
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3122
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3130
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3138
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3151
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3159
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3167
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'.

(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 3233
Invalid object name 'Country'.
Msg 4902, Level 16, State 1, Line 3241
Cannot find the object "dbo.RewardPointsHistory" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Line 3246
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3254
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3262
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3271
Invalid object name 'Setting'.

Completion time: 2020-05-20T09:33:21.9801913-05:00

Website Output

An unhandled exception occurred while processing the request.
SqlException: Invalid column name 'CreatedOrUpdatedDateUTC'.
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, bool breakConnection, Action<Action> wrapCloseInAction)

SqlException: Invalid column name 'CreatedOrUpdatedDateUTC'.
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, bool breakConnection, Action<Action> wrapCloseInAction)
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, bool breakConnection, Action<Action> wrapCloseInAction)
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, bool callerHasConnectionLock, bool asyncClose)
System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, out bool dataReady)
System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
System.Data.SqlClient.SqlDataReader.get_MetaData()
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, string resetOptionsString)
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, bool returnStream, bool async, int timeout, out Task task, bool asyncWrite, SqlDataReader ds)
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, bool returnStream, TaskCompletionSource<object> completion, int timeout, out Task task, bool asyncWrite, string method)
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, bool returnStream, string method)
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
LinqToDB.Data.DbCommandProcessor.DbCommandProcessorExtensions.ExecuteReaderExt(IDbCommand cmd, CommandBehavior commandBehavior)
LinqToDB.Data.DataConnection.ExecuteReader(IDbCommand command, CommandBehavior commandBehavior)
LinqToDB.Data.DataConnection.ExecuteReader(CommandBehavior commandBehavior)
LinqToDB.DataContext+QueryRunner.ExecuteReader()
LinqToDB.Linq.QueryRunner.ExecuteQuery<T>(Query query, IDataContext dataContext, Mapper<T> mapper, Expression expression, object[] ps, int queryNumber)+MoveNext()
System.Collections.Generic.List<T>..ctor(IEnumerable<T> collection)
System.Linq.Enumerable.ToList<TSource>(IEnumerable<TSource> source)
Nop.Core.Caching.MemoryCacheManager.Get<T>(CacheKey key, Func<T> acquire) in MemoryCacheManager.cs
Nop.Services.Caching.Extensions.IQueryableExtensions.ToCachedList<T>(IQueryable<T> query, CacheKey cacheKey) in IQueryableExtensions.cs
Nop.Services.Common.GenericAttributeService.GetAttributesForEntity(int entityId, string keyGroup) in GenericAttributeService.cs
Nop.Services.Common.GenericAttributeService.GetAttribute<TPropType>(BaseEntity entity, string key, int storeId, TPropType defaultValue) in GenericAttributeService.cs
Nop.Web.Framework.WebWorkContext.get_WorkingLanguage() in WebWorkContext.cs
Nop.Web.Framework.Globalization.CultureMiddleware.SetWorkingCulture(IWebHelper webHelper, IWorkContext workContext) in CultureMiddleware.cs
Nop.Web.Framework.Globalization.CultureMiddleware.Invoke(HttpContext context, IWebHelper webHelper, IWorkContext workContext) in CultureMiddleware.cs
Microsoft.AspNetCore.Builder.UseMiddlewareExtensions+<>c__DisplayClass4_1.<UseMiddleware>b__2(HttpContext context)
Microsoft.AspNetCore.Localization.RequestLocalizationMiddleware.Invoke(HttpContext context)
Microsoft.AspNetCore.Session.SessionMiddleware.Invoke(HttpContext context)
Microsoft.AspNetCore.Session.SessionMiddleware.Invoke(HttpContext context)
Nop.Services.Installation.InstallUrlMiddleware.Invoke(HttpContext context, IWebHelper webHelper) in InstallUrlMiddleware.cs
Nop.Services.Common.KeepAliveMiddleware.Invoke(HttpContext context, IWebHelper webHelper) in KeepAliveMiddleware.cs
Microsoft.AspNetCore.ResponseCompression.ResponseCompressionMiddleware.Invoke(HttpContext context)
Microsoft.AspNetCore.Diagnostics.StatusCodePagesMiddleware.Invoke(HttpContext context)
Microsoft.AspNetCore.Diagnostics.StatusCodePagesMiddleware.Invoke(HttpContext context)
Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddleware.<Invoke>g__Awaited|6_0(ExceptionHandlerMiddleware middleware, HttpContext context, Task task)
Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddleware.HandleException(HttpContext context, ExceptionDispatchInfo edi)
Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddleware.<Invoke>g__Awaited|6_0(ExceptionHandlerMiddleware middleware, HttpContext context, Task task)
Microsoft.AspNetCore.Diagnostics.DeveloperExceptionPageMiddleware.Invoke(HttpContext context)

silly questions, assuming those tables like Setting and Order still exist in your 4.2 database, does the db user have full permissions to alter tables?  probably needs "db_owner" permissions for installation/upgrade

As a test I deleted the two settings files dataSettings.json and plugins.json, dropped and recreated a new demo database. Restarted the website and was prompted to install the software.  The install process and competed without any issues. So the default install process of a new deployment of 4.30 works fine.

af1racing wrote:

The SQL user account for the website is created with the db_owner role in membership. However I am connecting to the SQL Server as SA to run the script. So permissions should not be an issue for the upgrade.

So the problem is that I can not drop and recreate my clients database clean to upgrade the site. The in-place upgrade really needs to work. And so far as I can see it does not.

so starting at your first error and looking at Line 968 in the SQL from here: https://github.com/nopSolutions/nopCommerce/blob/develop/upgradescripts/4.20-4.30%20(under%20development)/upgrade.sql

it has created a temp table from XML of all its language resources and then begins to select against the [Language] table for updates.  I would try to debug with a breakpoint on that line in SSMS with a restored backup of the 4.2 database to see at which point it fails.

I for some reason can not find the break point button / key / option in SSMS 18.5.

Hi Tom,

Not an issue I've run into, I'll try it on my dev box and see what happens here..

Is the original db created under the dbo  schema? So objects are dbo.customer dbo.settings etc?

Jon