Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Alan Draper 52 posts 135 karma points
    Jul 13, 2023 @ 16:40
    Alan Draper
    0

    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"}
    
  • Alan Draper 52 posts 135 karma points
    Jul 13, 2023 @ 16:57
    Alan Draper
    0

    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')

  • Alan Draper 52 posts 135 karma points
    Jul 13, 2023 @ 17:00
    Alan Draper
    0

    Reverted in Nuget to 10.6.1, and Umbraco is working again.

  • Alan Draper 52 posts 135 karma points
    Jul 13, 2023 @ 17:04
    Alan Draper
    0

    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')

  • Alan Draper 52 posts 135 karma points
    Jul 13, 2023 @ 18:51
    Alan Draper
    1

    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.

  • Brian Milinski 42 posts 165 karma points
    Jul 17, 2023 @ 14:22
    Brian Milinski
    0

    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.

  • ewuski 97 posts 263 karma points
    Nov 19, 2023 @ 14:39
    ewuski
    0

    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?

Please Sign in or register to post replies

Write your reply to:

Draft