Umbraco upgrade 10.1.0 - 11.4.1 "Invalid column name 'hasAccessToAllLanguages'"
Trying to upgrade an Umbraco 10.1.0 site to 11.4.1. Fresh database copy from the 10.1.0 site. Login to authorize upgrade, and no response, but found this in the logs.
{"@t":"2023-07-13T16:27:44.7753377Z","@mt":"Exception ({InstanceId}).","@l":"Error","@x":"Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'hasAccessToAllLanguages'.\r\n at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action````1 wrapCloseInAction)\r\n at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action``1 wrapCloseInAction)\r\n at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n at Microsoft.Data.SqlClient.SqlDataReader.TryConsumeMetaData()\r\n at Microsoft.Data.SqlClient.SqlDataReader.get_MetaData()\r\n at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)\r\n at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean isAsync, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)\r\n at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource``1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry, String method)\r\n at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)\r\n at Microsoft.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)\r\n at Microsoft.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)\r\n at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteDbDataReader(CommandBehavior behavior) in C:\\projects\\dotnet\\src\\MiniProfiler.Shared\\Data\\ProfiledDbCommand.cs:line 216\r\n at Umbraco.Cms.Infrastructure.Persistence.FaultHandling.FaultHandlingDbCommand.<>c__DisplayClass35_0.<ExecuteDbDataReader>b__0()\r\n at Umbraco.Cms.Infrastructure.Persistence.FaultHandling.FaultHandlingDbCommand.<>c__DisplayClass38_0``1.<Execute>b__0()\r\n at Umbraco.Cms.Infrastructure.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func``1 func)\r\n at Umbraco.Cms.Infrastructure.Persistence.FaultHandling.FaultHandlingDbCommand.Execute[T](Func``1 f)\r\n at Umbraco.Cms.Infrastructure.Persistence.FaultHandling.FaultHandlingDbCommand.ExecuteDbDataReader(CommandBehavior behavior)\r\n at NPoco.Database.<>c__DisplayClass298_0.<ExecuteReaderHelper>b__0()\r\n at NPoco.Database.ExecutionHook[T](Func``1 action)\r\n at NPoco.Database.ExecuteReaderHelper(DbCommand cmd)\r\n at NPoco.Database.ExecuteDataReader(DbCommand cmd, Boolean sync)\r\nClientConnectionId:485bdd3d-ba93-496f-baa9-528f2fb6e454\r\nError Number:207,State:1,Class:16","InstanceId":"e47fcc64","SourceContext":"Umbraco.Cms.Infrastructure.Persistence.UmbracoDatabase","ActionId":"048f90da-a001-42f8-a04e-f8285164fe51","ActionName":"Umbraco.Cms.Web.BackOffice.Controllers.AuthenticationController.PostLogin (Umbraco.Web.BackOffice)","RequestId":"40000004-0006-f600-b63f-84710c7967bb","RequestPath":"/umbraco/backoffice/umbracoapi/authentication/PostLogin","ProcessId":21232,"ProcessName":"iisexpress","ThreadId":35,"ApplicationId":"eb58031534376564132a9a38a82e4203a190365f","MachineName":"ALANZ4","Log4NetLevel":"ERROR","HttpRequestId":"80cd6b8d-621c-4824-8be9-bde04c7d3f0a","HttpRequestNumber":2,"HttpSessionId":"eeb70a00-f8e7-466b-9da8-bb24266df531","IP":"::1"}
{"@t":"2023-07-13T16:27:45.2456626Z","@mt":"Exception ({InstanceId}).","@l":"Error","@x":"Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid object name 'umbracoUserGroup2Language'.\r\n at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action``1 wrapCloseInAction)\r\n at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action``1 wrapCloseInAction)\r\n at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n at Microsoft.Data.SqlClient.SqlDataReader.TryConsumeMetaData()\r\n at Microsoft.Data.SqlClient.SqlDataReader.get_MetaData()\r\n at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)\r\n at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean isAsync, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)\r\n at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource``1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry, String method)\r\n at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)\r\n at Microsoft.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)\r\n at Microsoft.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)\r\n at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteDbDataReader(CommandBehavior behavior) in C:\\projects\\dotnet\\src\\MiniProfiler.Shared\\Data\\ProfiledDbCommand.cs:line 216\r\n at Umbraco.Cms.Infrastructure.Persistence.FaultHandling.FaultHandlingDbCommand.<>c__DisplayClass35_0.<ExecuteDbDataReader>b__0()\r\n at Umbraco.Cms.Infrastructure.Persistence.FaultHandling.FaultHandlingDbCommand.<>c__DisplayClass38_0``1.<Execute>b__0()\r\n at Umbraco.Cms.Infrastructure.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func``1 func)\r\n at Umbraco.Cms.Infrastructure.Persistence.FaultHandling.FaultHandlingDbCommand.Execute[T](Func``1 f)\r\n at Umbraco.Cms.Infrastructure.Persistence.FaultHandling.FaultHandlingDbCommand.ExecuteDbDataReader(CommandBehavior behavior)\r\n at NPoco.Database.<>c__DisplayClass298_0.<ExecuteReaderHelper>b__0()\r\n at NPoco.Database.ExecutionHook[T](Func``1 action)\r\n at NPoco.Database.ExecuteReaderHelper(DbCommand cmd)\r\n at NPoco.Database.ExecuteDataReader(DbCommand cmd, Boolean sync)\r\nClientConnectionId:485bdd3d-ba93-496f-baa9-528f2fb6e454\r\nError Number:208,State:1,Class:16","InstanceId":"e47fcc64","SourceContext":"Umbraco.Cms.Infrastructure.Persistence.UmbracoDatabase","ActionId":"048f90da-a001-42f8-a04e-f8285164fe51","ActionName":"Umbraco.Cms.Web.BackOffice.Controllers.AuthenticationController.PostLogin (Umbraco.Web.BackOffice)","RequestId":"40000004-0006-f600-b63f-84710c7967bb","RequestPath":"/umbraco/backoffice/umbracoapi/authentication/PostLogin","ProcessId":21232,"ProcessName":"iisexpress","ThreadId":35,"ApplicationId":"eb58031534376564132a9a38a82e4203a190365f","MachineName":"ALANZ4","Log4NetLevel":"ERROR","HttpRequestId":"80cd6b8d-621c-4824-8be9-bde04c7d3f0a","HttpRequestNumber":2,"HttpSessionId":"eeb70a00-f8e7-466b-9da8-bb24266df531","IP":"::1"}
Trying to fix this, created a new 10.1.0 website to confirm the database was working correctly. It is.
Then I used nuget to update to 10.6.1, which worked fine, and Umbraco loaded in the new version.
Then I used nuget to update to 11.1.0, which failed with the following message:
Error during installation
The database failed to upgrade. ERROR: The database configuration failed with the following message: The migration plan does not support migrating from state "{83AF7945-DADE-4A02-9041-F3F6EBFAC319}". Please check log file for additional information (can be found in 'LoggingSettings.Directory')
Tried updating to 11.0.0, and get the upgrade message
Detected current version (83af7945), which needs to be upgraded to 11.0.0 (3f5d492a). To compare versions and read a report of changes between versions, use the View Report button below.
And the error message...
The database failed to upgrade. ERROR: The database configuration failed with the following message: The migration plan does not support migrating from state "{83AF7945-DADE-4A02-9041-F3F6EBFAC319}". Please check log file for additional information (can be found in '~/umbraco/Logs')
Thanks for the details Alan, upgrade documentation is always lacking with Umbraco - and a bit of a mystery. You likely have just saved someone hours, if not days, of troubleshooting. Hopefully better upgrade documentation will be produced in the future - one of the biggest gaps with the CMS.
I have just upgraded from 10.0.0 to 10.4.0 and the upgrade were successful.
However I found in logs two following entires:
Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid object
name 'umbracoUserGroup2Language'.
Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column
name 'hasAccessToAllLanguages'.
Do you know what those columns relate to? Just wanted to double check whether the upgrade is not missing anything. Are those columns from older versions or should be somewhere in the upgraded db?
Umbraco upgrade 10.1.0 - 11.4.1 "Invalid column name 'hasAccessToAllLanguages'"
Trying to upgrade an Umbraco 10.1.0 site to 11.4.1. Fresh database copy from the 10.1.0 site. Login to authorize upgrade, and no response, but found this in the logs.
Trying to fix this, created a new 10.1.0 website to confirm the database was working correctly. It is.
Then I used nuget to update to 10.6.1, which worked fine, and Umbraco loaded in the new version.
Then I used nuget to update to 11.1.0, which failed with the following message:
Reverted in Nuget to 10.6.1, and Umbraco is working again.
Tried updating to 11.0.0, and get the upgrade message
And the error message...
Ok, now I tried 11.4.2, and it worked.
This is a hugely frustrating process, with little documentation.
I don't see any documentation on how/where the GUIDs are mapped to versions, which makes diagnosing problems very difficult.
Works great when it works great, but when it doesn't, it's a nightmare.
Thanks for the details Alan, upgrade documentation is always lacking with Umbraco - and a bit of a mystery. You likely have just saved someone hours, if not days, of troubleshooting. Hopefully better upgrade documentation will be produced in the future - one of the biggest gaps with the CMS.
I have just upgraded from 10.0.0 to 10.4.0 and the upgrade were successful. However I found in logs two following entires:
Do you know what those columns relate to? Just wanted to double check whether the upgrade is not missing anything. Are those columns from older versions or should be somewhere in the upgraded db?
is working on a reply...