Copied to clipboard

Flag this post as spam?

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


  • Shakib 32 posts 134 karma points
    Oct 04, 2017 @ 09:28
    Shakib
    0

    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
    enter image description here

    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

  • Alex Skrypnyk 5774 posts 21998 karma points MVP 4x admin c-trib
    Oct 04, 2017 @ 09:32
    Alex Skrypnyk
    0

    Hi Shakib

    Do you have some custom columns in your database?

    Alex

  • Shakib 32 posts 134 karma points
    Oct 04, 2017 @ 09:34
    Shakib
    0

    No i don't have any customization in my database

  • Alex Skrypnyk 5774 posts 21998 karma points MVP 4x admin c-trib
    Oct 04, 2017 @ 09:36
    Alex Skrypnyk
    0

    From which version did you make the upgrade?

  • Shakib 32 posts 134 karma points
    Oct 06, 2017 @ 17:15
    Shakib
    0

    i coulden't solve the problem
    is there a way to solve this ??

  • Shakib 32 posts 134 karma points
    Oct 04, 2017 @ 09:37
    Shakib
    0

    from 7.6.4 to 7.7.2

  • Shakib 32 posts 134 karma points
    Oct 04, 2017 @ 13:14
    Shakib
    0

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

  • Thor Madsen-Holm 82 posts 212 karma points c-trib
    Oct 28, 2017 @ 13:52
    Thor Madsen-Holm
    0

    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

  • Wilfried Jonker 6 posts 76 karma points
    Oct 28, 2017 @ 15:21
    Wilfried Jonker
    0

    In general, if there is a problem with upgrading the database.

    • Download the correct (clean) Umbraco version https://our.umbraco.org/contribute/releases/ (7.7.2).
    • Set the settings in the web.config correct, importent in this case is to set umbracoConfigurationStatus to the previous Umbra version (7.6.4).

    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.

  • Thor Madsen-Holm 82 posts 212 karma points c-trib
    Oct 29, 2017 @ 13:00
    Thor Madsen-Holm
    0

    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.

  • Dean Wiseman 21 posts 90 karma points
    Nov 03, 2017 @ 17:19
    Dean Wiseman
    0

    I'm getting the same error trying to upgrade from 7.6.5 to 7.7.4

  • Dean Wiseman 21 posts 90 karma points
    Nov 03, 2017 @ 17:48
    Dean Wiseman
    0

    I was able to resolve the issue by going into SQL Server logins and confirming my membership for the database in question.

  • Paul Seal 425 posts 2327 karma points MVP 3x c-trib
    Nov 09, 2017 @ 17:30
    Paul Seal
    2

    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

  • Ben Palmer 163 posts 806 karma points c-trib
    Nov 11, 2017 @ 12:46
    Ben Palmer
    0

    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.

Please Sign in or register to post replies

Write your reply to:

Draft