"Invalid column name 'controlId'" error when upgrading from 7.5.4 to 7.14
I am trying to upgrade a site on a client's production server from 7.5.4 to 7.14, and I am getting the following error on the install/upgrade screen: Invalid column name 'controlId'
I performed the upgrade locally and it all worked, so I'm not sure if it is to do with the security on the production database server. I can't download the database (and do the upgrade locally) as they have strict security regulations, so I'm stuck with trying to get it upgraded on their prod server.
Here is the trace from the log, any advice or assitance would be greatly appreciated as I have spent several hours now on this and I'm pulling my hair out:
2019-05-08 11:31:33,825 [P2856/D18/T91] INFO Umbraco.Core.CoreBootManager - Umbraco 7.14.0 application starting on WSWEBSERV
2019-05-08 11:31:33,825 [P2856/D18/T91] INFO Umbraco.Core.PluginManager - Determining hash of code files on disk
2019-05-08 11:31:33,841 [P2856/D18/T91] INFO Umbraco.Core.PluginManager - Hash determined (took 21ms)
2019-05-08 11:31:33,872 [P2856/D18/T91] INFO Umbraco.Core.MainDom - Acquiring MainDom...
2019-05-08 11:31:33,872 [P2856/D18/T91] INFO Umbraco.Core.MainDom - Acquired MainDom.
2019-05-08 11:31:33,888 [P2856/D18/T91] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable
2019-05-08 11:31:33,935 [P2856/D18/T91] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 56ms)
2019-05-08 11:31:33,935 [P2856/D18/T91] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IApplicationStartupHandler
2019-05-08 11:31:33,935 [P2856/D18/T91] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IApplicationStartupHandler (took 1ms)
2019-05-08 11:31:33,966 [P2856/D18/T91] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable
2019-05-08 11:31:33,966 [P2856/D18/T91] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms)
2019-05-08 11:31:33,966 [P2856/D18/T91] INFO Umbraco.Core.PluginManager - Resolving Umbraco.Core.PropertyEditors.IPropertyEditorValueConverter
2019-05-08 11:31:33,966 [P2856/D18/T91] INFO Umbraco.Core.PluginManager - Resolved Umbraco.Core.PropertyEditors.IPropertyEditorValueConverter (took 0ms)
2019-05-08 11:31:33,966 [P2856/D18/T91] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable
2019-05-08 11:31:33,966 [P2856/D18/T91] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms)
2019-05-08 11:31:33,966 [P2856/D18/T91] INFO Umbraco.Core.PluginManager - Resolving Umbraco.Core.PropertyEditors.IPropertyValueConverter
2019-05-08 11:31:33,966 [P2856/D18/T91] INFO Umbraco.Core.PluginManager - Resolved Umbraco.Core.PropertyEditors.IPropertyValueConverter (took 2ms)
2019-05-08 11:31:33,982 [P2856/D18/T91] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable
2019-05-08 11:31:33,982 [P2856/D18/T91] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms)
2019-05-08 11:31:33,982 [P2856/D18/T91] INFO Umbraco.Core.PluginManager - Resolving Umbraco.Web.Mvc.SurfaceController
2019-05-08 11:31:33,982 [P2856/D18/T91] INFO Umbraco.Core.PluginManager - Resolved Umbraco.Web.Mvc.SurfaceController (took 0ms)
2019-05-08 11:31:33,982 [P2856/D18/T91] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable
2019-05-08 11:31:33,982 [P2856/D18/T91] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms)
2019-05-08 11:31:33,982 [P2856/D18/T91] INFO Umbraco.Core.PluginManager - Resolving Umbraco.Web.WebApi.UmbracoApiController
2019-05-08 11:31:33,982 [P2856/D18/T91] INFO Umbraco.Core.PluginManager - Resolved Umbraco.Web.WebApi.UmbracoApiController (took 0ms)
2019-05-08 11:31:35,950 [P2856/D18/T91] INFO Umbraco.Core.CoreBootManager - Umbraco application startup complete (took 2231ms)
2019-05-08 11:31:36,263 [P2856/D18/T60] INFO Umbraco.Core.Sync.ApplicationUrlHelper - New ApplicationUrl detected: http://domainhere.com:80/umbraco
2019-05-08 11:31:36,263 [P2856/D18/T60] INFO Umbraco.Core.Sync.ApplicationUrlHelper - ApplicationUrl: http://domainhere.com:80/umbraco (UmbracoModule request)
2019-05-08 11:31:38,326 [P2856/D18/T63] INFO Umbraco.Core.DatabaseContext - CanConnect = True
2019-05-08 11:31:41,389 [P2856/D18/T71] INFO Umbraco.Web.Install.Controllers.InstallApiController - Executing installation step: Permissions
2019-05-08 11:31:41,389 [P2856/D18/T71] INFO Umbraco.Web.Install.Controllers.InstallApiController - Step completed (took 3ms)
2019-05-08 11:31:41,452 [P2856/D18/T79] INFO Umbraco.Web.Install.Controllers.InstallApiController - Executing installation step: Upgrade
2019-05-08 11:31:41,452 [P2856/D18/T79] INFO Umbraco.Web.Install.Controllers.InstallApiController - Step completed (took 0ms)
2019-05-08 11:31:41,452 [P2856/D18/T79] ERROR Umbraco.Core.Persistence.UmbracoDatabase - Exception (98c66fb6).
System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'controlId'.
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()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass5_0.<ExecuteReaderWithRetry>b__0()
at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
at Umbraco.Core.Persistence.Database.<Query>d__74`1.MoveNext()
ClientConnectionId:27947ba2-3cc7-441d-83bb-4d83d01fd75a
Error Number:207,State:1,Class:16
2019-05-08 11:31:41,467 [P2856/D18/T79] ERROR Umbraco.Web.Install.Controllers.InstallApiController - Checking if step requires execution (MajorVersion7UpgradeReport) failed.
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Data.SqlClient.SqlException: Invalid column name 'controlId'.
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()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass5_0.<ExecuteReaderWithRetry>b__0()
at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
at Umbraco.Core.Persistence.Database.<Query>d__74`1.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at Umbraco.Web.Install.InstallSteps.MajorVersion7UpgradeReport.CreateReport()
at Umbraco.Web.Install.InstallSteps.MajorVersion7UpgradeReport.RequiresExecution(Object model)
--- End of inner exception stack trace ---
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at Umbraco.Web.Install.Controllers.InstallApiController.StepRequiresExecution(InstallSetupStep step, JToken instruction)
2019-05-08 11:31:41,467 [P2856/D18/T79] ERROR Umbraco.Web.Install.Controllers.InstallApiController - An error occurred during installation step Upgrade
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Data.SqlClient.SqlException: Invalid column name 'controlId'.
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()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass5_0.<ExecuteReaderWithRetry>b__0()
at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
at Umbraco.Core.Persistence.Database.<Query>d__74`1.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at Umbraco.Web.Install.InstallSteps.MajorVersion7UpgradeReport.CreateReport()
at Umbraco.Web.Install.InstallSteps.MajorVersion7UpgradeReport.RequiresExecution(Object model)
--- End of inner exception stack trace ---
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at Umbraco.Web.Install.Controllers.InstallApiController.StepRequiresExecution(InstallSetupStep step, JToken instruction)
at Umbraco.Web.Install.Controllers.InstallApiController.IterateNextRequiredStep(InstallSetupStep current, Queue`1 queue, Guid installId, InstallInstructions installModel)
at Umbraco.Web.Install.Controllers.InstallApiController.PostPerformInstall(InstallInstructions installModel)
"Invalid column name 'controlId'" error when upgrading from 7.5.4 to 7.14
I am trying to upgrade a site on a client's production server from 7.5.4 to 7.14, and I am getting the following error on the install/upgrade screen: Invalid column name 'controlId'
I performed the upgrade locally and it all worked, so I'm not sure if it is to do with the security on the production database server. I can't download the database (and do the upgrade locally) as they have strict security regulations, so I'm stuck with trying to get it upgraded on their prod server.
Here is the trace from the log, any advice or assitance would be greatly appreciated as I have spent several hours now on this and I'm pulling my hair out:
is working on a reply...