We have recently moved a site from Azure to a new hosting solution (Windows server. Using IIS and SQL server 2022)
After the move, we are unable to perform rollback on content pages.
If we try, we get a Server error that says "Failed to get versions for content item with id 1146".
Checking the logs gives us an error that says the following:
Unhandled controller exception occurred for request '"https://www.sitename.dk/umbraco/backoffice/UmbracoApi/Content/GetPagedContentVersions?contentId=1146&pageNumber=1&pageSize=15&culture="'
the stack trace contains this in the first few lines:
System.Data.SqlClient.SqlException (0x80131904): Invalid column name
'id'. at System.Data.SqlClient.SqlConnection.OnError(SqlException
exception, Boolean breakConnection, Action`1 wrapCloseInAction) at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at
System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream,
BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject
stateObj, Boolean& dataReady) at
System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at
System.Data.SqlClient.SqlDataReader.get_MetaData()
(The stack trace is a lot longer than this, but I just included the first few lines to ease readability. I can supply the rest if need be.)
Rollback works just fine on azure, so this didn't happen until we moved servers.
Issue with Rollback on Umbraco 8 after move from Azure.
We have recently moved a site from Azure to a new hosting solution (Windows server. Using IIS and SQL server 2022) After the move, we are unable to perform rollback on content pages.
If we try, we get a Server error that says "Failed to get versions for content item with id 1146".
Checking the logs gives us an error that says the following:
the stack trace contains this in the first few lines:
(The stack trace is a lot longer than this, but I just included the first few lines to ease readability. I can supply the rest if need be.)
Rollback works just fine on azure, so this didn't happen until we moved servers.
Has anyone experienced this before?
Hi @Elisabeth
Umbraco 8.18.7, SQL Server 2022
Did you get to the bottom of this? Our Rollback page will not render and comes up with the same error as you in the logs.
Local dev currently is SQL Server 2016.
Also had nucache issues with this version of SQL Server outlined here with a fix - https://github.com/umbraco/Umbraco-CMS/pull/14173
Cheers
Jules
Hi, Unfurtunately we haven't found a solution yet. The only thing we can do right now is rolling back SQL Server to an earlier version.
Sorry I couldn't give you more uplifting news.
is working on a reply...