Hi
i upgrade my umbraco followed by the general general and specefic version tutorial.
after upgrade i run the umbraco for upgrade install and i encounter with the following error
tracelog is :
2017-10-04 12:39:42,835 [P9688/D4/T18] ERROR Umbraco.Web.Install.Controllers.InstallApiController - Installation step DatabaseUpgrade failed.
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Umbraco.Web.Install.InstallException: The database failed to upgrade. ERROR: The database configuration failed with the following message: The object 'umbracoUserFKumbracoUserumbracoUserTypeid' is dependent on column 'userType'.
ALTER TABLE DROP COLUMN userType failed because one or more objects access this column.
Please check log file for additional information (can be found in '/AppData/Logs/UmbracoTraceLog.txt')
at Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep.Execute(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.ExecuteStep(InstallSetupStep step, JToken instruction)
2017-10-04 12:39:42,836 [P9688/D4/T18] INFO Umbraco.Web.Install.Controllers.InstallApiController - Step completed (took 524ms)
2017-10-04 12:39:42,836 [P9688/D4/T18] ERROR Umbraco.Web.Install.Controllers.InstallApiController - An error occurred during installation step DatabaseUpgrade
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Umbraco.Web.Install.InstallException: The database failed to upgrade. ERROR: The database configuration failed with the following message: The object 'umbracoUserFKumbracoUserumbracoUserTypeid' is dependent on column 'userType'.
ALTER TABLE DROP COLUMN userType failed because one or more objects access this column.
Please check log file for additional information (can be found in '/AppData/Logs/UmbracoTraceLog.txt')
at Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep.Execute(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.ExecuteStep(InstallSetupStep step, JToken instruction)
at Umbraco.Web.Install.Controllers.InstallApiController.PostPerformInstall(InstallInstructions installModel)
2017-10-04 12:39:58,249 [P9688/D2/T13] INFO Umbraco.Core.UmbracoApplicationBase - Application shutdown. Details: ConfigurationChange
i can't upgrade any 7.6.* to 7.7.*
all the errors was the same error i posted above.
The database failed to upgrade. ERROR: The database configuration failed with the following message: The object 'umbracoUserFKumbracoUserumbracoUserTypeid' is dependent on column 'userType'.
ALTER TABLE DROP COLUMN userType failed because one or more objects access this column. Please check log file for additional information (can be found in '/App_Data/Logs/UmbracoTraceLog.txt')
I get the exact same error when trying to upgrade from 7.6.8. I've tried both via nuget and manually several times, first time was with 7.7.2, then 7.7.3 and finally 7.7.4.
My stacktrace looks like this:
2017-10-28 15:35:03,874 [P21936/D7/T11] ERROR Umbraco.Core.Persistence.UmbracoDatabase - Exception (5941c565).
System.Data.SqlClient.SqlException (0x80131904): The object 'umbracoUserFKumbracoUserumbracoUserTypeid' is dependent on column 'userType'.
ALTER TABLE DROP COLUMN userType failed because one or more objects access this column.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteNonQuery() in c:\Code\github\SamSaffron\MiniProfiler\StackExchange.Profiling\Data\ProfiledDbCommand.cs:line 266
at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass2_0.<ExecuteNonQueryWithRetry>b__0()
at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func1 func)
at Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteNonQueryWithRetry(IDbCommand command, RetryPolicy cmdRetryPolicy, RetryPolicy conRetryPolicy)
at Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteNonQueryWithRetry(IDbCommand command, RetryPolicy retryPolicy)
at Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteNonQueryWithRetry(IDbCommand command)
at Umbraco.Core.Persistence.Database.Execute(String sql, Object[] args)
ClientConnectionId:b6fe1d41-a9e1-437a-ae62-8496814bc103
Error Number:5074,State:1,Class:16
2017-10-28 15:35:03,878 [P21936/D7/T11] ERROR Umbraco.Core.DatabaseContext - Database configuration failed
System.Data.SqlClient.SqlException (0x80131904): The object 'umbracoUserFKumbracoUserumbracoUserTypeid' is dependent on column 'userType'.
ALTER TABLE DROP COLUMN userType failed because one or more objects access this column.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteNonQuery() in c:\Code\github\SamSaffron\MiniProfiler\StackExchange.Profiling\Data\ProfiledDbCommand.cs:line 266
at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass2_0.<ExecuteNonQueryWithRetry>b__0()
at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func1 func)
at Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteNonQueryWithRetry(IDbCommand command, RetryPolicy cmdRetryPolicy, RetryPolicy conRetryPolicy)
at Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteNonQueryWithRetry(IDbCommand command, RetryPolicy retryPolicy)
at Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteNonQueryWithRetry(IDbCommand command)
at Umbraco.Core.Persistence.Database.Execute(String sql, Object[] args)
at Umbraco.Core.Persistence.Migrations.MigrationRunner.ExecuteMigrations(IMigrationContext context, Database database)
at Umbraco.Core.Persistence.Migrations.MigrationRunner.Execute(Database database, DatabaseProviders databaseProvider, Boolean isUpgrade)
at Umbraco.Core.Persistence.Migrations.MigrationRunner.Execute(Database database, Boolean isUpgrade)
at Umbraco.Core.DatabaseContext.UpgradeSchemaAndData(IMigrationEntryService migrationEntryService)
ClientConnectionId:b6fe1d41-a9e1-437a-ae62-8496814bc103
Error Number:5074,State:1,Class:16
2017-10-28 15:35:03,882 [P21936/D7/T11] INFO Umbraco.Core.DatabaseContext - The database schema validation produced the following summary:
The following tables were found in the database, but are not in the current schema:
umbracoUser2app,umbracoUser2NodePermission,umbracoUserType,umbracoUserGroup,umbracoUser2UserGroup,umbracoUserGroup2NodePermission,umbracoUserGroup2App,umbracoUserStartNode
The following columns were found in the database, but are not in the current schema:
umbracoUser,userType,umbracoUser,startStructureID,umbracoUser,startMediaID,umbracoUser2app,user,umbracoUser2app,app,umbracoUser2NodePermission,userId,umbracoUser2NodePermission,nodeId,umbracoUser2NodePermission,permission,umbracoUserType,id,umbracoUserType,userTypeAlias,umbracoUserType,userTypeName,umbracoUserType,userTypeDefaultPermissions,umbracoUser,passwordConfig,umbracoUser,emailConfirmedDate,umbracoUser,invitedDate,umbracoUser,createDate,umbracoUser,updateDate,umbracoUser,avatar,umbracoUserGroup,id,umbracoUserGroup,userGroupAlias,umbracoUserGroup,userGroupName,umbracoUserGroup,userGroupDefaultPermissions,umbracoUserGroup,createDate,umbracoUserGroup,updateDate,umbracoUserGroup,icon,umbracoUserGroup,startContentId,umbracoUserGroup,startMediaId,umbracoUser2UserGroup,userId,umbracoUser2UserGroup,userGroupId,umbracoUserGroup2NodePermission,userGroupId,umbracoUserGroup2NodePermission,nodeId,umbracoUserGroup2NodePermission,permission,umbracoUserGroup2App,userGroupId,umbracoUserGroup2App,app,umbracoUserStartNode,id,umbracoUserStartNode,userId,umbracoUserStartNode,startNode,umbracoUserStartNode,startNodeType
The following constraints (Primary Keys, Foreign Keys and Indexes) were found in the database, but are not in the current schema:
FKumbracoNodeumbracoNodeid,FKcmsContentTypeumbracoNodeid,FKcmsTemplateumbracoNode,FKcmsContentumbracoNodeid,FKcmsContentcmsContentTypenodeId,FKcmsContentVersioncmsContentnodeId,FKcmsDocumentcmsContentnodeId,FKcmsDocumentumbracoNodeid,FKcmsDocumentcmsTemplatenodeId,FKcmsDocumentTypecmsContentTypenodeId,FKcmsDocumentTypeumbracoNodeid,FKcmsDocumentTypecmsTemplatenodeId,FKcmsDataTypeumbracoNodeid,FKcmsDataTypePreValuescmsDataTypenodeId,FKcmsDictionarycmsDictionaryid,FKcmsLanguageTextumbracoLanguageid,FKcmsLanguageTextcmsDictionaryid,FKumbracoDomainsumbracoNodeid,FKcmsMacroPropertycmsMacroid,FKcmsMemberTypeumbracoNodeid,FKcmsMemberTypecmsContentTypenodeId,FKcmsMembercmsContentnodeId,FKcmsMemberumbracoNodeid,FKcmsMember2MemberGroupcmsMembernodeId,FKcmsMember2MemberGroupumbracoNodeid,FKcmsContentXmlcmsContentnodeId,FKcmsPreviewXmlcmsContentnodeId,FKcmsPreviewXmlcmsContentVersionVersionId,FKcmsPropertyTypeGroupcmsContentTypenodeId,FKcmsPropertyTypecmsDataTypenodeId,FKcmsPropertyTypecmsContentTypenodeId,FKcmsPropertyTypecmsPropertyTypeGroupid,FKcmsPropertyDataumbracoNodeid,FKcmsPropertyDatacmsPropertyTypeid,FKumbracoRelationumbracoNode,FKumbracoRelationumbracoNode1,FKumbracoRelationumbracoRelationTypeid,FKcmsTagscmsTags,FKcmsTagRelationshipcmsContent,FKcmsTagRelationshipcmsTagsid,FKcmsTagRelationshipcmsPropertyType,FKcmsTaskcmsTaskTypeid,FKcmsTaskumbracoNodeid,FKcmsTaskumbracoUser,FKcmsTaskumbracoUser1,FKcmsContentType2ContentTypeumbracoNodeparent,FKcmsContentType2ContentTypeumbracoNodechild,FKcmsContentTypeAllowedContentTypecmsContentType,FKcmsContentTypeAllowedContentTypecmsContentType1,FKumbracoUser2NodeNotifyumbracoUserid,FKumbracoUser2NodeNotifyumbracoNodeid,FKumbracoAccessumbracoNodeid,FKumbracoAccessumbracoNodeid1,FKumbracoAccessumbracoNodeid2,FKumbracoAccessRuleumbracoAccessid,FKumbracoRedirectUrlumbracoNodeuniqueID,FKstartContentIdumbracoNodeid,FKstartMediaIdumbracoNodeid,FKumbracoUser2UserGroupumbracoUserid,FKumbracoUser2UserGroupumbracoUserGroupid,FKumbracoUserGroup2NodePermissionumbracoUserGroupid,FKumbracoUserGroup2NodePermissionumbracoNodeid,FKumbracoUserGroup2AppumbracoUserGroupid,FKumbracoUserStartNodeumbracoUserid,FKumbracoUserStartNodeumbracoNodeid,PKstructure,PKcmsContentType,PKcmsTemplate,PKcmsContent,PKcmsContentVersion,PKcmsDocument,PKcmsDocumentType,PKcmsDataType,PKcmsDataTypePreValues,PKcmsDictionary,PKumbracoLanguage,PKcmsLanguageText,PKumbracoDomains,PKumbracoLog,PKcmsMacro,PKcmsMacroProperty,PKcmsMemberType,PKcmsMember,PKcmsMember2MemberGroup,PKcmsContentXml,PKcmsContentPreviewXml,PKcmsPropertyTypeGroup,PKcmsPropertyType,PKcmsPropertyData,PKumbracoRelationType,PKumbracoRelation,PKcmsTags,PKcmsTagRelationship,PKuser,PKcmsTaskType,PKcmsTask,PKcmsContentType2ContentType,PKcmsContentTypeAllowedContentType,PKumbracoUser2NodeNotify,PKumbracoServer,PKumbracoAccess,PKumbracoAccessRule,PKumbracoCacheInstruction,PKumbracoExternalLogin,PKumbracoMigration,PKumbracoRedirectUrl,PKumbracoUserGroup,PKuser2userGroup,PKumbracoUserGroup2NodePermission,PKuserGroup2App,PKuserStartNode,IXumbracoNodeTrashed,IXumbracoNodeParentId,IXumbracoNodePath,IXumbracoNodeUniqueID,IXumbracoNodeObjectType,IXcmsContentType,IXcmsContentTypeicon,IXcmsTemplatenodeId,IXcmsContent,IXcmsContentVersionContentId,IXcmsContentVersionVersionId,IXcmsDocument,IXcmsDocumentpublished,IXcmsDocumentnewest,IXcmsDataTypenodeId,IXcmsDictionaryid,IXcmsDictionarykey,IXumbracoLanguagelanguageISOCode,IXumbracoLog,IXcmsMacroUniqueId,IXcmsMacroPropertyAlias,IXcmsMacroPropertyUniquePropertyId,IXcmsMacroPropertyAlias,IXcmsMemberLoginName,IXcmsPropertyTypeGroupUniqueID,IXcmsPropertyTypeUniqueID,IXcmsPropertyData1,IXcmsPropertyData2,IXcmsPropertyData3,IXumbracoRelationTypeUniqueId,IXumbracoRelationTypename,IXumbracoRelationTypealias,IXumbracoRelationparentChildType,IXcmsTags,IXumbracoUseruserLogin,IXcmsTaskTypealias,IXcomputerName,IXumbracoServerisActive,IXumbracoAccessnodeId,IXumbracoAccessRule,IXumbracoMigration,IXumbracoRedirectUrl,IXumbracoUserGroupuserGroupAlias,IXumbracoUserGroupuserGroupName,IXumbracoUser2NodePermissionnodeId,IXumbracoUserStartNodestartNodeType
The following indexes were found in the database, but are not in the current schema:
cmsContentPKcmsContent,cmsContentTypePKcmsContentType,cmsContentType2ContentTypePKcmsContentType2ContentType,cmsContentTypeAllowedContentTypePKcmsContentTypeAllowedContentType,cmsContentVersionPKcmsContentVersion,cmsContentXmlPKcmsContentXml,cmsDataTypePKcmsDataType,cmsDataTypePreValuesPKcmsDataTypePreValues,cmsDictionaryPKcmsDictionary,cmsDocumentPKcmsDocument,cmsDocumentTypePKcmsDocumentType,cmsLanguageTextPKcmsLanguageText,cmsMacroPKcmsMacro,cmsMacroPropertyPKcmsMacroProperty,cmsMemberPKcmsMember,cmsMember2MemberGroupPKcmsMember2MemberGroup,cmsMemberTypePKcmsMemberType,cmsPreviewXmlPKcmsContentPreviewXml,cmsPropertyDataPKcmsPropertyData,cmsPropertyTypePKcmsPropertyType,cmsPropertyTypeGroupPKcmsPropertyTypeGroup,cmsTagRelationshipPKcmsTagRelationship,cmsTagsPKcmsTags,cmsTaskPKcmsTask,cmsTaskTypePKcmsTaskType,cmsTemplatePKcmsTemplate,umbracoAccessPKumbracoAccess,umbracoAccessRulePKumbracoAccessRule,umbracoCacheInstructionPKumbracoCacheInstruction,umbracoDomainsPKumbracoDomains,umbracoExternalLoginPKumbracoExternalLogin,umbracoLanguagePKumbracoLanguage,umbracoLogPKumbracoLog,umbracoMigrationPKumbracoMigration,umbracoNodePKstructure,umbracoRedirectUrlPKumbracoRedirectUrl,umbracoRelationPKumbracoRelation,umbracoRelationTypePKumbracoRelationType,umbracoServerPKumbracoServer,umbracoUserPKuser,umbracoUser2appPKuser2app,umbracoUser2NodeNotifyPKumbracoUser2NodeNotify,umbracoUser2NodePermissionPKumbracoUser2NodePermission,umbracoUserTypePKumbracoUserType,IXcmsDictionarykey,IXumbracoUserGroupuserGroupAlias,IXumbracoUserGroupuserGroupName,IXumbracoUserStartNodestartNodeType
The following unknown constraints (Primary Keys, Foreign Keys and Indexes) were found in the database, but are not in the current schema:
cmsContentFKcmsContentcmsContentTypenodeId,cmsContentFKcmsContentumbracoNodeid,cmsContentPKcmsContent,cmsContentTypeFKcmsContentTypeumbracoNodeid,cmsContentTypePKcmsContentType,cmsContentType2ContentTypeFKcmsContentType2ContentTypeumbracoNodechild,cmsContentType2ContentTypeFKcmsContentType2ContentTypeumbracoNodeparent,cmsContentType2ContentTypePKcmsContentType2ContentType,cmsContentTypeAllowedContentTypeFKcmsContentTypeAllowedContentTypecmsContentType,cmsContentTypeAllowedContentTypeFKcmsContentTypeAllowedContentTypecmsContentType1,cmsContentTypeAllowedContentTypePKcmsContentTypeAllowedContentType,cmsContentVersionFKcmsContentVersioncmsContentnodeId,cmsContentVersionPKcmsContentVersion,cmsContentXmlFKcmsContentXmlcmsContentnodeId,cmsContentXmlPKcmsContentXml,cmsDataTypeFKcmsDataTypeumbracoNodeid,cmsDataTypePKcmsDataType,cmsDataTypePreValuesFKcmsDataTypePreValuescmsDataTypenodeId,cmsDataTypePreValuesPKcmsDataTypePreValues,cmsDictionaryFKcmsDictionarycmsDictionaryid,cmsDictionaryPKcmsDictionary,cmsDocumentFKcmsDocumentcmsContentnodeId,cmsDocumentFKcmsDocumentcmsTemplatenodeId,cmsDocumentFKcmsDocumentumbracoNodeid,cmsDocumentPKcmsDocument,cmsDocumentTypeFKcmsDocumentTypecmsContentTypenodeId,cmsDocumentTypeFKcmsDocumentTypecmsTemplatenodeId,cmsDocumentTypeFKcmsDocumentTypeumbracoNodeid,cmsDocumentTypePKcmsDocumentType,cmsLanguageTextFKcmsLanguageTextcmsDictionaryid,cmsLanguageTextFKcmsLanguageTextumbracoLanguageid,cmsLanguageTextPKcmsLanguageText,cmsMacroPKcmsMacro,cmsMacroPropertyFKcmsMacroPropertycmsMacroid,cmsMacroPropertyPKcmsMacroProperty,cmsMemberFKcmsMembercmsContentnodeId,cmsMemberFKcmsMemberumbracoNodeid,cmsMemberPKcmsMember,cmsMember2MemberGroupFKcmsMember2MemberGroupcmsMembernodeId,cmsMember2MemberGroupFKcmsMember2MemberGroupumbracoNodeid,cmsMember2MemberGroupPKcmsMember2MemberGroup,cmsMemberTypeFKcmsMemberTypecmsContentTypenodeId,cmsMemberTypeFKcmsMemberTypeumbracoNodeid,cmsMemberTypePKcmsMemberType,cmsPreviewXmlFKcmsPreviewXmlcmsContentnodeId,cmsPreviewXmlFKcmsPreviewXmlcmsContentVersionVersionId,cmsPreviewXmlPKcmsContentPreviewXml,cmsPropertyDataFKcmsPropertyDatacmsPropertyTypeid,cmsPropertyDataFKcmsPropertyDataumbracoNodeid,cmsPropertyDataPKcmsPropertyData,cmsPropertyTypeFKcmsPropertyTypecmsContentTypenodeId,cmsPropertyTypeFKcmsPropertyTypecmsDataTypenodeId,cmsPropertyTypeFKcmsPropertyTypecmsPropertyTypeGroupid,cmsPropertyTypePKcmsPropertyType,cmsPropertyTypeGroupFKcmsPropertyTypeGroupcmsContentTypenodeId,cmsPropertyTypeGroupPKcmsPropertyTypeGroup,cmsTagRelationshipFKcmsTagRelationshipcmsContent,cmsTagRelationshipFKcmsTagRelationshipcmsPropertyType,cmsTagRelationshipFKcmsTagRelationshipcmsTagsid,cmsTagRelationshipPKcmsTagRelationship,cmsTagsFKcmsTagscmsTags,cmsTagsPKcmsTags,cmsTaskFKcmsTaskcmsTaskTypeid,cmsTaskFKcmsTaskumbracoNodeid,cmsTaskFKcmsTaskumbracoUser,cmsTaskFKcmsTaskumbracoUser1,cmsTaskPKcmsTask,cmsTaskTypePKcmsTaskType,cmsTemplateFKcmsTemplateumbracoNode,cmsTemplatePKcmsTemplate,umbracoAccessFKumbracoAccessumbracoNodeid,umbracoAccessFKumbracoAccessumbracoNodeid1,umbracoAccessFKumbracoAccessumbracoNodeid2,umbracoAccessPKumbracoAccess,umbracoAccessRuleFKumbracoAccessRuleumbracoAccessid,umbracoAccessRulePKumbracoAccessRule,umbracoCacheInstructionPKumbracoCacheInstruction,umbracoDomainsFKumbracoDomainsumbracoNodeid,umbracoDomainsPKumbracoDomains,umbracoExternalLoginPKumbracoExternalLogin,umbracoLanguagePKumbracoLanguage,umbracoLogPKumbracoLog,umbracoMigrationPKumbracoMigration,umbracoNodeFKumbracoNodeumbracoNodeid,umbracoNodePKstructure,umbracoRedirectUrlFKumbracoRedirectUrlumbracoNodeuniqueID,umbracoRedirectUrlPKumbracoRedirectUrl,umbracoRelationFKumbracoRelationumbracoNode,umbracoRelationFKumbracoRelationumbracoNode1,umbracoRelationFKumbracoRelationumbracoRelationTypeid,umbracoRelationPKumbracoRelation,umbracoRelationTypePKumbracoRelationType,umbracoServerPKumbracoServer,umbracoUserFKumbracoUserumbracoUserTypeid,umbracoUserPKuser,umbracoUser2appFKumbracoUser2appumbracoUserid,umbracoUser2appPKuser2app,umbracoUser2NodeNotifyFKumbracoUser2NodeNotifyumbracoNodeid,umbracoUser2NodeNotifyFKumbracoUser2NodeNotifyumbracoUserid,umbracoUser2NodeNotifyPKumbracoUser2NodeNotify,umbracoUser2NodePermissionFKumbracoUser2NodePermissionumbracoNodeid,umbracoUser2NodePermissionFKumbracoUser2NodePermissionumbracoUserid,umbracoUser2NodePermissionPKumbracoUser2NodePermission,umbracoUserTypePKumbracoUserType
2017-10-28 15:35:03,884 [P21936/D7/T11] ERROR Umbraco.Web.Install.Controllers.InstallApiController - Installation step DatabaseUpgrade failed.
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Umbraco.Web.Install.InstallException: The database failed to upgrade. ERROR: The database configuration failed with the following message: The object 'umbracoUserFKumbracoUserumbracoUserTypeid' is dependent on column 'userType'.
ALTER TABLE DROP COLUMN userType failed because one or more objects access this column.
Please check log file for additional information (can be found in '/AppData/Logs/UmbracoTraceLog.txt')
at Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep.Execute(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.ExecuteStep(InstallSetupStep step, JToken instruction)
2017-10-28 15:35:03,885 [P21936/D7/T11] INFO Umbraco.Web.Install.Controllers.InstallApiController - Step completed (took 893ms)
2017-10-28 15:35:03,886 [P21936/D7/T11] ERROR Umbraco.Web.Install.Controllers.InstallApiController - An error occurred during installation step DatabaseUpgrade
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Umbraco.Web.Install.InstallException: The database failed to upgrade. ERROR: The database configuration failed with the following message: The object 'umbracoUserFKumbracoUserumbracoUserTypeid' is dependent on column 'userType'.
ALTER TABLE DROP COLUMN userType failed because one or more objects access this column.
Please check log file for additional information (can be found in '/AppData/Logs/UmbracoTraceLog.txt')
at Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep.Execute(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.ExecuteStep(InstallSetupStep step, JToken instruction)
at Umbraco.Web.Install.Controllers.InstallApiController.PostPerformInstall(InstallInstructions installModel)
2017-10-28 15:35:16,289 [P21936/D5/T11] INFO Umbraco.Core.UmbracoApplicationBase - Application shutdown. Details: ConfigurationChange
Thank you for your response Wilfred. I tried downloading a clean Umbraco 7.7.4 and pointed it at my 7.6.8 database and tried doing the upgrade again. Unfortunately I get the same error.
It seems your databases have a Foreign Key named "umbracoUserFKumbracoUserumbracoUserTypeid" in the table umbracoUser but this line of code expects the name of the FK to be "FKumbracoUserumbracoUserType_id". You could try deleting the FK before doing the upgrade but please don't test my assumption in production.
I've run into similar errors in the past, the answer Paul Seal linked to may work but it'll only compound the error - the next time you upgrade, you'll most likely run into the same error or something similar.
Instead, try simply editing your web.config file (backup your database first) - change the umbracoConfigurationStatus value to 7.2.8. If I remember correctly, this will run all migrations again as that's when they were first introduced. This will hopefully fix your error now, and stop this from happening again when upgrading in the future.
Problem Upgradin Umbraco to 7.7.2
Hi
i upgrade my umbraco followed by the general general and specefic version tutorial.
after upgrade i run the umbraco for upgrade install and i encounter with the following error
tracelog is :
2017-10-04 12:39:42,835 [P9688/D4/T18] ERROR Umbraco.Web.Install.Controllers.InstallApiController - Installation step DatabaseUpgrade failed. System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Umbraco.Web.Install.InstallException: The database failed to upgrade. ERROR: The database configuration failed with the following message: The object 'umbracoUserFKumbracoUserumbracoUserTypeid' is dependent on column 'userType'. ALTER TABLE DROP COLUMN userType failed because one or more objects access this column. Please check log file for additional information (can be found in '/AppData/Logs/UmbracoTraceLog.txt') at Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep.Execute(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.ExecuteStep(InstallSetupStep step, JToken instruction) 2017-10-04 12:39:42,836 [P9688/D4/T18] INFO Umbraco.Web.Install.Controllers.InstallApiController - Step completed (took 524ms) 2017-10-04 12:39:42,836 [P9688/D4/T18] ERROR Umbraco.Web.Install.Controllers.InstallApiController - An error occurred during installation step DatabaseUpgrade System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Umbraco.Web.Install.InstallException: The database failed to upgrade. ERROR: The database configuration failed with the following message: The object 'umbracoUserFKumbracoUserumbracoUserTypeid' is dependent on column 'userType'. ALTER TABLE DROP COLUMN userType failed because one or more objects access this column. Please check log file for additional information (can be found in '/AppData/Logs/UmbracoTraceLog.txt') at Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep.Execute(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.ExecuteStep(InstallSetupStep step, JToken instruction) at Umbraco.Web.Install.Controllers.InstallApiController.PostPerformInstall(InstallInstructions installModel) 2017-10-04 12:39:58,249 [P9688/D2/T13] INFO Umbraco.Core.UmbracoApplicationBase - Application shutdown. Details: ConfigurationChange
Hi Shakib
Do you have some custom columns in your database?
Alex
No i don't have any customization in my database
From which version did you make the upgrade?
i coulden't solve the problem
is there a way to solve this ??
from 7.6.4 to 7.7.2
i can't upgrade any 7.6.* to 7.7.*
all the errors was the same error i posted above.
The database failed to upgrade. ERROR: The database configuration failed with the following message: The object 'umbracoUserFKumbracoUserumbracoUserTypeid' is dependent on column 'userType'. ALTER TABLE DROP COLUMN userType failed because one or more objects access this column. Please check log file for additional information (can be found in '/App_Data/Logs/UmbracoTraceLog.txt')
I get the exact same error when trying to upgrade from 7.6.8. I've tried both via nuget and manually several times, first time was with 7.7.2, then 7.7.3 and finally 7.7.4.
My stacktrace looks like this:
2017-10-28 15:35:03,874 [P21936/D7/T11] ERROR Umbraco.Core.Persistence.UmbracoDatabase - Exception (5941c565). System.Data.SqlClient.SqlException (0x80131904): The object 'umbracoUserFKumbracoUserumbracoUserTypeid' is dependent on column 'userType'. ALTER TABLE DROP COLUMN userType failed because one or more objects access this column. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action
1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteNonQuery() in c:\Code\github\SamSaffron\MiniProfiler\StackExchange.Profiling\Data\ProfiledDbCommand.cs:line 266 at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass2_0.<ExecuteNonQueryWithRetry>b__0() at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func1 func) at Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteNonQueryWithRetry(IDbCommand command, RetryPolicy cmdRetryPolicy, RetryPolicy conRetryPolicy) at Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteNonQueryWithRetry(IDbCommand command, RetryPolicy retryPolicy) at Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteNonQueryWithRetry(IDbCommand command) at Umbraco.Core.Persistence.Database.Execute(String sql, Object[] args) ClientConnectionId:b6fe1d41-a9e1-437a-ae62-8496814bc103 Error Number:5074,State:1,Class:16 2017-10-28 15:35:03,878 [P21936/D7/T11] ERROR Umbraco.Core.DatabaseContext - Database configuration failed System.Data.SqlClient.SqlException (0x80131904): The object 'umbracoUserFKumbracoUserumbracoUserTypeid' is dependent on column 'userType'. ALTER TABLE DROP COLUMN userType failed because one or more objects access this column. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteNonQuery() in c:\Code\github\SamSaffron\MiniProfiler\StackExchange.Profiling\Data\ProfiledDbCommand.cs:line 266 at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass2_0.<ExecuteNonQueryWithRetry>b__0() at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func1 func) at Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteNonQueryWithRetry(IDbCommand command, RetryPolicy cmdRetryPolicy, RetryPolicy conRetryPolicy) at Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteNonQueryWithRetry(IDbCommand command, RetryPolicy retryPolicy) at Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteNonQueryWithRetry(IDbCommand command) at Umbraco.Core.Persistence.Database.Execute(String sql, Object[] args) at Umbraco.Core.Persistence.Migrations.MigrationRunner.ExecuteMigrations(IMigrationContext context, Database database) at Umbraco.Core.Persistence.Migrations.MigrationRunner.Execute(Database database, DatabaseProviders databaseProvider, Boolean isUpgrade) at Umbraco.Core.Persistence.Migrations.MigrationRunner.Execute(Database database, Boolean isUpgrade) at Umbraco.Core.DatabaseContext.UpgradeSchemaAndData(IMigrationEntryService migrationEntryService) ClientConnectionId:b6fe1d41-a9e1-437a-ae62-8496814bc103 Error Number:5074,State:1,Class:16 2017-10-28 15:35:03,882 [P21936/D7/T11] INFO Umbraco.Core.DatabaseContext - The database schema validation produced the following summary: The following tables were found in the database, but are not in the current schema: umbracoUser2app,umbracoUser2NodePermission,umbracoUserType,umbracoUserGroup,umbracoUser2UserGroup,umbracoUserGroup2NodePermission,umbracoUserGroup2App,umbracoUserStartNodeThe following columns were found in the database, but are not in the current schema: umbracoUser,userType,umbracoUser,startStructureID,umbracoUser,startMediaID,umbracoUser2app,user,umbracoUser2app,app,umbracoUser2NodePermission,userId,umbracoUser2NodePermission,nodeId,umbracoUser2NodePermission,permission,umbracoUserType,id,umbracoUserType,userTypeAlias,umbracoUserType,userTypeName,umbracoUserType,userTypeDefaultPermissions,umbracoUser,passwordConfig,umbracoUser,emailConfirmedDate,umbracoUser,invitedDate,umbracoUser,createDate,umbracoUser,updateDate,umbracoUser,avatar,umbracoUserGroup,id,umbracoUserGroup,userGroupAlias,umbracoUserGroup,userGroupName,umbracoUserGroup,userGroupDefaultPermissions,umbracoUserGroup,createDate,umbracoUserGroup,updateDate,umbracoUserGroup,icon,umbracoUserGroup,startContentId,umbracoUserGroup,startMediaId,umbracoUser2UserGroup,userId,umbracoUser2UserGroup,userGroupId,umbracoUserGroup2NodePermission,userGroupId,umbracoUserGroup2NodePermission,nodeId,umbracoUserGroup2NodePermission,permission,umbracoUserGroup2App,userGroupId,umbracoUserGroup2App,app,umbracoUserStartNode,id,umbracoUserStartNode,userId,umbracoUserStartNode,startNode,umbracoUserStartNode,startNodeType
The following constraints (Primary Keys, Foreign Keys and Indexes) were found in the database, but are not in the current schema: FKumbracoNodeumbracoNodeid,FKcmsContentTypeumbracoNodeid,FKcmsTemplateumbracoNode,FKcmsContentumbracoNodeid,FKcmsContentcmsContentTypenodeId,FKcmsContentVersioncmsContentnodeId,FKcmsDocumentcmsContentnodeId,FKcmsDocumentumbracoNodeid,FKcmsDocumentcmsTemplatenodeId,FKcmsDocumentTypecmsContentTypenodeId,FKcmsDocumentTypeumbracoNodeid,FKcmsDocumentTypecmsTemplatenodeId,FKcmsDataTypeumbracoNodeid,FKcmsDataTypePreValuescmsDataTypenodeId,FKcmsDictionarycmsDictionaryid,FKcmsLanguageTextumbracoLanguageid,FKcmsLanguageTextcmsDictionaryid,FKumbracoDomainsumbracoNodeid,FKcmsMacroPropertycmsMacroid,FKcmsMemberTypeumbracoNodeid,FKcmsMemberTypecmsContentTypenodeId,FKcmsMembercmsContentnodeId,FKcmsMemberumbracoNodeid,FKcmsMember2MemberGroupcmsMembernodeId,FKcmsMember2MemberGroupumbracoNodeid,FKcmsContentXmlcmsContentnodeId,FKcmsPreviewXmlcmsContentnodeId,FKcmsPreviewXmlcmsContentVersionVersionId,FKcmsPropertyTypeGroupcmsContentTypenodeId,FKcmsPropertyTypecmsDataTypenodeId,FKcmsPropertyTypecmsContentTypenodeId,FKcmsPropertyTypecmsPropertyTypeGroupid,FKcmsPropertyDataumbracoNodeid,FKcmsPropertyDatacmsPropertyTypeid,FKumbracoRelationumbracoNode,FKumbracoRelationumbracoNode1,FKumbracoRelationumbracoRelationTypeid,FKcmsTagscmsTags,FKcmsTagRelationshipcmsContent,FKcmsTagRelationshipcmsTagsid,FKcmsTagRelationshipcmsPropertyType,FKcmsTaskcmsTaskTypeid,FKcmsTaskumbracoNodeid,FKcmsTaskumbracoUser,FKcmsTaskumbracoUser1,FKcmsContentType2ContentTypeumbracoNodeparent,FKcmsContentType2ContentTypeumbracoNodechild,FKcmsContentTypeAllowedContentTypecmsContentType,FKcmsContentTypeAllowedContentTypecmsContentType1,FKumbracoUser2NodeNotifyumbracoUserid,FKumbracoUser2NodeNotifyumbracoNodeid,FKumbracoAccessumbracoNodeid,FKumbracoAccessumbracoNodeid1,FKumbracoAccessumbracoNodeid2,FKumbracoAccessRuleumbracoAccessid,FKumbracoRedirectUrlumbracoNodeuniqueID,FKstartContentIdumbracoNodeid,FKstartMediaIdumbracoNodeid,FKumbracoUser2UserGroupumbracoUserid,FKumbracoUser2UserGroupumbracoUserGroupid,FKumbracoUserGroup2NodePermissionumbracoUserGroupid,FKumbracoUserGroup2NodePermissionumbracoNodeid,FKumbracoUserGroup2AppumbracoUserGroupid,FKumbracoUserStartNodeumbracoUserid,FKumbracoUserStartNodeumbracoNodeid,PKstructure,PKcmsContentType,PKcmsTemplate,PKcmsContent,PKcmsContentVersion,PKcmsDocument,PKcmsDocumentType,PKcmsDataType,PKcmsDataTypePreValues,PKcmsDictionary,PKumbracoLanguage,PKcmsLanguageText,PKumbracoDomains,PKumbracoLog,PKcmsMacro,PKcmsMacroProperty,PKcmsMemberType,PKcmsMember,PKcmsMember2MemberGroup,PKcmsContentXml,PKcmsContentPreviewXml,PKcmsPropertyTypeGroup,PKcmsPropertyType,PKcmsPropertyData,PKumbracoRelationType,PKumbracoRelation,PKcmsTags,PKcmsTagRelationship,PKuser,PKcmsTaskType,PKcmsTask,PKcmsContentType2ContentType,PKcmsContentTypeAllowedContentType,PKumbracoUser2NodeNotify,PKumbracoServer,PKumbracoAccess,PKumbracoAccessRule,PKumbracoCacheInstruction,PKumbracoExternalLogin,PKumbracoMigration,PKumbracoRedirectUrl,PKumbracoUserGroup,PKuser2userGroup,PKumbracoUserGroup2NodePermission,PKuserGroup2App,PKuserStartNode,IXumbracoNodeTrashed,IXumbracoNodeParentId,IXumbracoNodePath,IXumbracoNodeUniqueID,IXumbracoNodeObjectType,IXcmsContentType,IXcmsContentTypeicon,IXcmsTemplatenodeId,IXcmsContent,IXcmsContentVersionContentId,IXcmsContentVersionVersionId,IXcmsDocument,IXcmsDocumentpublished,IXcmsDocumentnewest,IXcmsDataTypenodeId,IXcmsDictionaryid,IXcmsDictionarykey,IXumbracoLanguagelanguageISOCode,IXumbracoLog,IXcmsMacroUniqueId,IXcmsMacroPropertyAlias,IXcmsMacroPropertyUniquePropertyId,IXcmsMacroPropertyAlias,IXcmsMemberLoginName,IXcmsPropertyTypeGroupUniqueID,IXcmsPropertyTypeUniqueID,IXcmsPropertyData1,IXcmsPropertyData2,IXcmsPropertyData3,IXumbracoRelationTypeUniqueId,IXumbracoRelationTypename,IXumbracoRelationTypealias,IXumbracoRelationparentChildType,IXcmsTags,IXumbracoUseruserLogin,IXcmsTaskTypealias,IXcomputerName,IXumbracoServerisActive,IXumbracoAccessnodeId,IXumbracoAccessRule,IXumbracoMigration,IXumbracoRedirectUrl,IXumbracoUserGroupuserGroupAlias,IXumbracoUserGroupuserGroupName,IXumbracoUser2NodePermissionnodeId,IXumbracoUserStartNodestartNodeType
The following indexes were found in the database, but are not in the current schema: cmsContentPKcmsContent,cmsContentTypePKcmsContentType,cmsContentType2ContentTypePKcmsContentType2ContentType,cmsContentTypeAllowedContentTypePKcmsContentTypeAllowedContentType,cmsContentVersionPKcmsContentVersion,cmsContentXmlPKcmsContentXml,cmsDataTypePKcmsDataType,cmsDataTypePreValuesPKcmsDataTypePreValues,cmsDictionaryPKcmsDictionary,cmsDocumentPKcmsDocument,cmsDocumentTypePKcmsDocumentType,cmsLanguageTextPKcmsLanguageText,cmsMacroPKcmsMacro,cmsMacroPropertyPKcmsMacroProperty,cmsMemberPKcmsMember,cmsMember2MemberGroupPKcmsMember2MemberGroup,cmsMemberTypePKcmsMemberType,cmsPreviewXmlPKcmsContentPreviewXml,cmsPropertyDataPKcmsPropertyData,cmsPropertyTypePKcmsPropertyType,cmsPropertyTypeGroupPKcmsPropertyTypeGroup,cmsTagRelationshipPKcmsTagRelationship,cmsTagsPKcmsTags,cmsTaskPKcmsTask,cmsTaskTypePKcmsTaskType,cmsTemplatePKcmsTemplate,umbracoAccessPKumbracoAccess,umbracoAccessRulePKumbracoAccessRule,umbracoCacheInstructionPKumbracoCacheInstruction,umbracoDomainsPKumbracoDomains,umbracoExternalLoginPKumbracoExternalLogin,umbracoLanguagePKumbracoLanguage,umbracoLogPKumbracoLog,umbracoMigrationPKumbracoMigration,umbracoNodePKstructure,umbracoRedirectUrlPKumbracoRedirectUrl,umbracoRelationPKumbracoRelation,umbracoRelationTypePKumbracoRelationType,umbracoServerPKumbracoServer,umbracoUserPKuser,umbracoUser2appPKuser2app,umbracoUser2NodeNotifyPKumbracoUser2NodeNotify,umbracoUser2NodePermissionPKumbracoUser2NodePermission,umbracoUserTypePKumbracoUserType,IXcmsDictionarykey,IXumbracoUserGroupuserGroupAlias,IXumbracoUserGroupuserGroupName,IXumbracoUserStartNodestartNodeType
The following unknown constraints (Primary Keys, Foreign Keys and Indexes) were found in the database, but are not in the current schema: cmsContentFKcmsContentcmsContentTypenodeId,cmsContentFKcmsContentumbracoNodeid,cmsContentPKcmsContent,cmsContentTypeFKcmsContentTypeumbracoNodeid,cmsContentTypePKcmsContentType,cmsContentType2ContentTypeFKcmsContentType2ContentTypeumbracoNodechild,cmsContentType2ContentTypeFKcmsContentType2ContentTypeumbracoNodeparent,cmsContentType2ContentTypePKcmsContentType2ContentType,cmsContentTypeAllowedContentTypeFKcmsContentTypeAllowedContentTypecmsContentType,cmsContentTypeAllowedContentTypeFKcmsContentTypeAllowedContentTypecmsContentType1,cmsContentTypeAllowedContentTypePKcmsContentTypeAllowedContentType,cmsContentVersionFKcmsContentVersioncmsContentnodeId,cmsContentVersionPKcmsContentVersion,cmsContentXmlFKcmsContentXmlcmsContentnodeId,cmsContentXmlPKcmsContentXml,cmsDataTypeFKcmsDataTypeumbracoNodeid,cmsDataTypePKcmsDataType,cmsDataTypePreValuesFKcmsDataTypePreValuescmsDataTypenodeId,cmsDataTypePreValuesPKcmsDataTypePreValues,cmsDictionaryFKcmsDictionarycmsDictionaryid,cmsDictionaryPKcmsDictionary,cmsDocumentFKcmsDocumentcmsContentnodeId,cmsDocumentFKcmsDocumentcmsTemplatenodeId,cmsDocumentFKcmsDocumentumbracoNodeid,cmsDocumentPKcmsDocument,cmsDocumentTypeFKcmsDocumentTypecmsContentTypenodeId,cmsDocumentTypeFKcmsDocumentTypecmsTemplatenodeId,cmsDocumentTypeFKcmsDocumentTypeumbracoNodeid,cmsDocumentTypePKcmsDocumentType,cmsLanguageTextFKcmsLanguageTextcmsDictionaryid,cmsLanguageTextFKcmsLanguageTextumbracoLanguageid,cmsLanguageTextPKcmsLanguageText,cmsMacroPKcmsMacro,cmsMacroPropertyFKcmsMacroPropertycmsMacroid,cmsMacroPropertyPKcmsMacroProperty,cmsMemberFKcmsMembercmsContentnodeId,cmsMemberFKcmsMemberumbracoNodeid,cmsMemberPKcmsMember,cmsMember2MemberGroupFKcmsMember2MemberGroupcmsMembernodeId,cmsMember2MemberGroupFKcmsMember2MemberGroupumbracoNodeid,cmsMember2MemberGroupPKcmsMember2MemberGroup,cmsMemberTypeFKcmsMemberTypecmsContentTypenodeId,cmsMemberTypeFKcmsMemberTypeumbracoNodeid,cmsMemberTypePKcmsMemberType,cmsPreviewXmlFKcmsPreviewXmlcmsContentnodeId,cmsPreviewXmlFKcmsPreviewXmlcmsContentVersionVersionId,cmsPreviewXmlPKcmsContentPreviewXml,cmsPropertyDataFKcmsPropertyDatacmsPropertyTypeid,cmsPropertyDataFKcmsPropertyDataumbracoNodeid,cmsPropertyDataPKcmsPropertyData,cmsPropertyTypeFKcmsPropertyTypecmsContentTypenodeId,cmsPropertyTypeFKcmsPropertyTypecmsDataTypenodeId,cmsPropertyTypeFKcmsPropertyTypecmsPropertyTypeGroupid,cmsPropertyTypePKcmsPropertyType,cmsPropertyTypeGroupFKcmsPropertyTypeGroupcmsContentTypenodeId,cmsPropertyTypeGroupPKcmsPropertyTypeGroup,cmsTagRelationshipFKcmsTagRelationshipcmsContent,cmsTagRelationshipFKcmsTagRelationshipcmsPropertyType,cmsTagRelationshipFKcmsTagRelationshipcmsTagsid,cmsTagRelationshipPKcmsTagRelationship,cmsTagsFKcmsTagscmsTags,cmsTagsPKcmsTags,cmsTaskFKcmsTaskcmsTaskTypeid,cmsTaskFKcmsTaskumbracoNodeid,cmsTaskFKcmsTaskumbracoUser,cmsTaskFKcmsTaskumbracoUser1,cmsTaskPKcmsTask,cmsTaskTypePKcmsTaskType,cmsTemplateFKcmsTemplateumbracoNode,cmsTemplatePKcmsTemplate,umbracoAccessFKumbracoAccessumbracoNodeid,umbracoAccessFKumbracoAccessumbracoNodeid1,umbracoAccessFKumbracoAccessumbracoNodeid2,umbracoAccessPKumbracoAccess,umbracoAccessRuleFKumbracoAccessRuleumbracoAccessid,umbracoAccessRulePKumbracoAccessRule,umbracoCacheInstructionPKumbracoCacheInstruction,umbracoDomainsFKumbracoDomainsumbracoNodeid,umbracoDomainsPKumbracoDomains,umbracoExternalLoginPKumbracoExternalLogin,umbracoLanguagePKumbracoLanguage,umbracoLogPKumbracoLog,umbracoMigrationPKumbracoMigration,umbracoNodeFKumbracoNodeumbracoNodeid,umbracoNodePKstructure,umbracoRedirectUrlFKumbracoRedirectUrlumbracoNodeuniqueID,umbracoRedirectUrlPKumbracoRedirectUrl,umbracoRelationFKumbracoRelationumbracoNode,umbracoRelationFKumbracoRelationumbracoNode1,umbracoRelationFKumbracoRelationumbracoRelationTypeid,umbracoRelationPKumbracoRelation,umbracoRelationTypePKumbracoRelationType,umbracoServerPKumbracoServer,umbracoUserFKumbracoUserumbracoUserTypeid,umbracoUserPKuser,umbracoUser2appFKumbracoUser2appumbracoUserid,umbracoUser2appPKuser2app,umbracoUser2NodeNotifyFKumbracoUser2NodeNotifyumbracoNodeid,umbracoUser2NodeNotifyFKumbracoUser2NodeNotifyumbracoUserid,umbracoUser2NodeNotifyPKumbracoUser2NodeNotify,umbracoUser2NodePermissionFKumbracoUser2NodePermissionumbracoNodeid,umbracoUser2NodePermissionFKumbracoUser2NodePermissionumbracoUserid,umbracoUser2NodePermissionPKumbracoUser2NodePermission,umbracoUserTypePKumbracoUserType
2017-10-28 15:35:03,884 [P21936/D7/T11] ERROR Umbraco.Web.Install.Controllers.InstallApiController - Installation step DatabaseUpgrade failed. System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Umbraco.Web.Install.InstallException: The database failed to upgrade. ERROR: The database configuration failed with the following message: The object 'umbracoUserFKumbracoUserumbracoUserTypeid' is dependent on column 'userType'. ALTER TABLE DROP COLUMN userType failed because one or more objects access this column. Please check log file for additional information (can be found in '/AppData/Logs/UmbracoTraceLog.txt') at Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep.Execute(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.ExecuteStep(InstallSetupStep step, JToken instruction) 2017-10-28 15:35:03,885 [P21936/D7/T11] INFO Umbraco.Web.Install.Controllers.InstallApiController - Step completed (took 893ms) 2017-10-28 15:35:03,886 [P21936/D7/T11] ERROR Umbraco.Web.Install.Controllers.InstallApiController - An error occurred during installation step DatabaseUpgrade System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Umbraco.Web.Install.InstallException: The database failed to upgrade. ERROR: The database configuration failed with the following message: The object 'umbracoUserFKumbracoUserumbracoUserTypeid' is dependent on column 'userType'. ALTER TABLE DROP COLUMN userType failed because one or more objects access this column. Please check log file for additional information (can be found in '/AppData/Logs/UmbracoTraceLog.txt') at Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep.Execute(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.ExecuteStep(InstallSetupStep step, JToken instruction) at Umbraco.Web.Install.Controllers.InstallApiController.PostPerformInstall(InstallInstructions installModel) 2017-10-28 15:35:16,289 [P21936/D5/T11] INFO Umbraco.Core.UmbracoApplicationBase - Application shutdown. Details: ConfigurationChange
In general, if there is a problem with upgrading the database.
umbracoConfigurationStatus wil tell Umbraco from what version it need to upgrade the database from.
If this does not fix the problem then there is probably a specific problem with the Umbraco installation you use.
Thank you for your response Wilfred. I tried downloading a clean Umbraco 7.7.4 and pointed it at my 7.6.8 database and tried doing the upgrade again. Unfortunately I get the same error.
I'm getting the same error trying to upgrade from 7.6.5 to 7.7.4
I was able to resolve the issue by going into SQL Server logins and confirming my membership for the database in question.
Apparently this will solve your error:
It seems your databases have a Foreign Key named "umbracoUserFKumbracoUserumbracoUserTypeid" in the table umbracoUser but this line of code expects the name of the FK to be "FKumbracoUserumbracoUserType_id". You could try deleting the FK before doing the upgrade but please don't test my assumption in production.
Found here http://issues.umbraco.org/issue/U4-10525#comment=67-43010
I've run into similar errors in the past, the answer Paul Seal linked to may work but it'll only compound the error - the next time you upgrade, you'll most likely run into the same error or something similar.
Instead, try simply editing your
web.configfile (backup your database first) - change theumbracoConfigurationStatusvalue to7.2.8. If I remember correctly, this will run all migrations again as that's when they were first introduced. This will hopefully fix your error now, and stop this from happening again when upgrading in the future.is working on a reply...