Copied to clipboard

Flag this post as spam?

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


  • jonok 297 posts 657 karma points
    May 08, 2019 @ 02:11
    jonok
    0

    "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)
    
Please Sign in or register to post replies

Write your reply to:

Draft