Copied to clipboard

Flag this post as spam?

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


  • Fuji Kusaka 2203 posts 4220 karma points
    Jan 23, 2018 @ 10:43
    Fuji Kusaka
    0

    Upgrade from 7.6.13 to 7.7.0

    Hi,

    We're trying to do a manual upgrade from 7.6.13 to 7.7.0 but unfortunately getting this error when "Authorizing Upgrade" .

    The database failed to upgrade. ERROR: The database configuration failed with the following message: Cannot insert duplicate key row in object 'dbo.umbracoUserGroup' with unique index 'IX_umbracoUserGroup_userGroupAlias'. The duplicate key value is (Admin).
     The statement has been terminated. Please check log file for additional information (can be found in '/App_Data/Logs/UmbracoTraceLog.txt')
    

    Anyone can help ?
    From the tracelogs.

    2018-01-23 15:04:47,692 [P4768/D14/T25] INFO  Umbraco.Web.Install.Controllers.InstallApiController - Executing installation step: Permissions
     2018-01-23 15:04:47,751 [P4768/D14/T25] INFO  Umbraco.Web.Install.Controllers.InstallApiController - Step completed (took 59ms)
     2018-01-23 15:04:48,316 [P4768/D14/T25] INFO  Umbraco.Web.Install.Controllers.InstallApiController - Executing installation step: Upgrade
     2018-01-23 15:04:48,320 [P4768/D14/T25] INFO  Umbraco.Web.Install.Controllers.InstallApiController - Step completed (took 3ms)
     2018-01-23 15:04:48,800 [P4768/D14/T25] INFO  Umbraco.Web.Install.Controllers.InstallApiController - Executing installation step: DatabaseInstall
     2018-01-23 15:04:48,806 [P4768/D14/T25] INFO  Umbraco.Core.DatabaseContext - Database configuration status: Started
     2018-01-23 15:04:48,806 [P4768/D14/T25] INFO  Umbraco.Core.DatabaseContext - Database requires upgrade
     2018-01-23 15:04:48,806 [P4768/D14/T25] INFO  Umbraco.Web.Install.Controllers.InstallApiController - Step completed (took 8ms)
     2018-01-23 15:04:49,264 [P4768/D14/T35] INFO  Umbraco.Web.Install.Controllers.InstallApiController - Executing installation step: DatabaseUpgrade
     2018-01-23 15:04:49,271 [P4768/D14/T35] INFO  Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep - Running 'Upgrade' service
     2018-01-23 15:04:49,275 [P4768/D14/T35] INFO  Umbraco.Core.DatabaseContext - Database upgrade started
     2018-01-23 15:04:49,313 [P4768/D14/T35] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Initializing database migrations
     2018-01-23 15:04:49,314 [P4768/D14/T35] INFO  Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable
     2018-01-23 15:04:49,314 [P4768/D14/T35] INFO  Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms)
     2018-01-23 15:04:49,315 [P4768/D14/T35] INFO  Umbraco.Core.PluginManager - Resolving Umbraco.Core.Persistence.Migrations.IMigration
     2018-01-23 15:04:49,326 [P4768/D14/T35] INFO  Umbraco.Core.PluginManager - Resolved Umbraco.Core.Persistence.Migrations.IMigration (took 10ms)
     2018-01-23 15:04:49,481 [P4768/D14/T35] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'UpdateUserTables' to context
     2018-01-23 15:04:49,777 [P4768/D14/T35] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddUserGroupTables' to context
     2018-01-23 15:04:49,787 [P4768/D14/T35] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddUserStartNodeTable' to context
     2018-01-23 15:04:49,789 [P4768/D14/T35] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'ReduceDictionaryKeyColumnsSize' to context
     2018-01-23 15:04:49,790 [P4768/D14/T35] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddIndexToDictionaryKeyColumn' to context
     2018-01-23 15:04:49,792 [P4768/D14/T35] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'EnsureContentTemplatePermissions' to context
     2018-01-23 15:04:49,822 [P4768/D14/T35] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 1: ALTER TABLE [umbracoUser] ADD [createDate] DATETIME NOT NULL CONSTRAINT [DF_umbracoUser_createDate] DEFAULT (GETDATE())
    
     2018-01-23 15:04:49,835 [P4768/D14/T35] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 2: ALTER TABLE [umbracoUser] ADD [updateDate] DATETIME NOT NULL CONSTRAINT [DF_umbracoUser_updateDate] DEFAULT (GETDATE())
    
     2018-01-23 15:04:49,839 [P4768/D14/T35] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 3: ALTER TABLE [umbracoUser] ADD [emailConfirmedDate] DATETIME NULL
    
     2018-01-23 15:04:49,842 [P4768/D14/T35] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 4: ALTER TABLE [umbracoUser] ADD [invitedDate] DATETIME NULL
    
     2018-01-23 15:04:49,844 [P4768/D14/T35] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 5: ALTER TABLE [umbracoUser] ADD [avatar] NVARCHAR(500) NULL
    
     2018-01-23 15:04:49,846 [P4768/D14/T35] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 6: ALTER TABLE [umbracoUser] ADD [passwordConfig] NVARCHAR(500) NULL
    
     2018-01-23 15:04:49,849 [P4768/D14/T35] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - <log4net.Error>Exception during StringFormat: Input string was not in a correct format. <format>Executing sql statement 7: UPDATE umbracoUser SET passwordConfig = '{"hashAlgorithm":"HMACSHA256"}'
    </format><args>{}</args></log4net.Error>
     2018-01-23 15:04:49,946 [P4768/D14/T35] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 8: CREATE TABLE [umbracoUserGroup] ([id] INTEGER NOT NULL IDENTITY(1,1),
    [userGroupAlias] NVARCHAR(200) NOT NULL,
    [userGroupName] NVARCHAR(200) NOT NULL,
    [userGroupDefaultPermissions] NVARCHAR(50) NULL,
    [createDate] DATETIME NOT NULL CONSTRAINT [DF_umbracoUserGroup_createDate] DEFAULT (GETDATE()),
    [updateDate] DATETIME NOT NULL CONSTRAINT [DF_umbracoUserGroup_updateDate] DEFAULT (GETDATE()),
    [icon] NVARCHAR(255) NULL,
    [startContentId] INTEGER NULL,
    [startMediaId] INTEGER NULL)
    
     2018-01-23 15:04:49,961 [P4768/D14/T35] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 9: ALTER TABLE [umbracoUserGroup] ADD CONSTRAINT [PK_umbracoUserGroup] PRIMARY KEY CLUSTERED ([id])
    
     2018-01-23 15:04:49,965 [P4768/D14/T35] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 10: ALTER TABLE [umbracoUserGroup] ADD CONSTRAINT [FK_startContentId_umbracoNode_id] FOREIGN KEY ([startContentId]) REFERENCES [umbracoNode] ([id])
    
     2018-01-23 15:04:49,968 [P4768/D14/T35] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 11: ALTER TABLE [umbracoUserGroup] ADD CONSTRAINT [FK_startMediaId_umbracoNode_id] FOREIGN KEY ([startMediaId]) REFERENCES [umbracoNode] ([id])
    
     2018-01-23 15:04:49,970 [P4768/D14/T35] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 12: CREATE UNIQUE NONCLUSTERED INDEX [IX_umbracoUserGroup_userGroupAlias] ON [umbracoUserGroup] ([userGroupAlias])
    
     2018-01-23 15:04:49,973 [P4768/D14/T35] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 13: CREATE UNIQUE NONCLUSTERED INDEX [IX_umbracoUserGroup_userGroupName] ON [umbracoUserGroup] ([userGroupName])
    
     2018-01-23 15:04:49,975 [P4768/D14/T35] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 14: CREATE TABLE [umbracoUser2UserGroup] ([userId] INTEGER NOT NULL,
    [userGroupId] INTEGER NOT NULL)
    
     2018-01-23 15:04:49,978 [P4768/D14/T35] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 15: ALTER TABLE [umbracoUser2UserGroup] ADD CONSTRAINT [PK_user2userGroup] PRIMARY KEY CLUSTERED ([userId], [userGroupId])
    
     2018-01-23 15:04:49,982 [P4768/D14/T35] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 16: ALTER TABLE [umbracoUser2UserGroup] ADD CONSTRAINT [FK_umbracoUser2UserGroup_umbracoUser_id] FOREIGN KEY ([userId]) REFERENCES [umbracoUser] ([id])
    
     2018-01-23 15:04:49,985 [P4768/D14/T35] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 17: ALTER TABLE [umbracoUser2UserGroup] ADD CONSTRAINT [FK_umbracoUser2UserGroup_umbracoUserGroup_id] FOREIGN KEY ([userGroupId]) REFERENCES [umbracoUserGroup] ([id])
    
     2018-01-23 15:04:49,988 [P4768/D14/T35] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 18: CREATE TABLE [umbracoUserGroup2App] ([userGroupId] INTEGER NOT NULL,
    [app] NVARCHAR(50) NOT NULL)
    
     2018-01-23 15:04:49,990 [P4768/D14/T35] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 19: ALTER TABLE [umbracoUserGroup2App] ADD CONSTRAINT [PK_userGroup2App] PRIMARY KEY CLUSTERED ([userGroupId], [app])
    
     2018-01-23 15:04:49,993 [P4768/D14/T35] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 20: ALTER TABLE [umbracoUserGroup2App] ADD CONSTRAINT [FK_umbracoUserGroup2App_umbracoUserGroup_id] FOREIGN KEY ([userGroupId]) REFERENCES [umbracoUserGroup] ([id])
    
     2018-01-23 15:04:49,997 [P4768/D14/T35] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 21: CREATE TABLE [umbracoUserGroup2NodePermission] ([userGroupId] INTEGER NOT NULL,
    [nodeId] INTEGER NOT NULL,
    [permission] NVARCHAR(255) NOT NULL)
    
     2018-01-23 15:04:49,999 [P4768/D14/T35] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 22: ALTER TABLE [umbracoUserGroup2NodePermission] ADD CONSTRAINT [PK_umbracoUserGroup2NodePermission] PRIMARY KEY CLUSTERED ([userGroupId], [nodeId], [permission])
    
     2018-01-23 15:04:50,003 [P4768/D14/T35] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 23: ALTER TABLE [umbracoUserGroup2NodePermission] ADD CONSTRAINT [FK_umbracoUserGroup2NodePermission_umbracoUserGroup_id] FOREIGN KEY ([userGroupId]) REFERENCES [umbracoUserGroup] ([id])
    
     2018-01-23 15:04:50,006 [P4768/D14/T35] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 24: ALTER TABLE [umbracoUserGroup2NodePermission] ADD CONSTRAINT [FK_umbracoUserGroup2NodePermission_umbracoNode_id] FOREIGN KEY ([nodeId]) REFERENCES [umbracoNode] ([id])
    
     2018-01-23 15:04:50,008 [P4768/D14/T35] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 25: CREATE NONCLUSTERED INDEX [IX_umbracoUser2NodePermission_nodeId] ON [umbracoUserGroup2NodePermission] ([nodeId])
    
     2018-01-23 15:04:50,010 [P4768/D14/T35] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 26: INSERT INTO umbracoUserGroup(userGroupAlias, userGroupName)
    SELECT 'permissionGroupFor' + userLogin, 'Migrated Permission Group for ' + userLogin
    FROM umbracoUser
    WHERE (id IN (
    SELECT userid
    FROM umbracoUser2NodePermission
    ))
    AND id > 0
    
     2018-01-23 15:04:50,017 [P4768/D14/T35] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 27: INSERT INTO umbracoUser2UserGroup (userId, userGroupId)
    SELECT u.id, ug.id
    FROM umbracoUser u
    INNER JOIN umbracoUserGroup ug ON ug.userGroupAlias COLLATE DATABASE_DEFAULT = 'permissionGroupFor' + userLogin COLLATE DATABASE_DEFAULT
    
     2018-01-23 15:04:50,021 [P4768/D14/T35] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 28: INSERT INTO umbracoUserGroup2NodePermission (userGroupId,nodeId,permission)
    SELECT ug.id, nodeId, permission
    FROM umbracoUserGroup ug
    INNER JOIN umbracoUser2UserGroup u2ug ON u2ug.userGroupId = ug.id
    INNER JOIN umbracoUser u ON u.id = u2ug.userId
    INNER JOIN umbracoUser2NodePermission u2np ON u2np.userId = u.id
    WHERE ug.userGroupAlias COLLATE DATABASE_DEFAULT NOT IN (
    SELECT userTypeAlias COLLATE DATABASE_DEFAULT
    FROM umbracoUserType
    )
    
     2018-01-23 15:04:50,043 [P4768/D14/T35] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 29: INSERT INTO umbracoUserGroup2app (userGroupId,app)
    SELECT ug.id, app
    FROM umbracoUserGroup ug
    INNER JOIN umbracoUser2UserGroup u2ug ON u2ug.userGroupId = ug.id
    INNER JOIN umbracoUser u ON u.id = u2ug.userId
    INNER JOIN umbracoUser2app u2a ON u2a.[user] = u.id
    WHERE ug.userGroupAlias COLLATE DATABASE_DEFAULT NOT IN (
    SELECT userTypeAlias COLLATE DATABASE_DEFAULT
    FROM umbracoUserType
    )
    
     2018-01-23 15:04:50,055 [P4768/D14/T35] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 30: INSERT INTO umbracoUserGroup (userGroupAlias, userGroupName, userGroupDefaultPermissions)
    SELECT userTypeAlias, userTypeName, userTypeDefaultPermissions
    FROM umbracoUserType
    
     2018-01-23 15:04:50,078 [P4768/D14/T35] ERROR Umbraco.Core.Persistence.UmbracoDatabase - Exception (1a0c6e29).
    System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.umbracoUserGroup' with unique index 'IX_umbracoUserGroup_userGroupAlias'. The duplicate key value is (Admin).
    The statement has been terminated.
       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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass2_0.<ExecuteNonQueryWithRetry>b__0()
       at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
       at Umbraco.Core.Persistence.Database.Execute(String sql, Object[] args)
    ClientConnectionId:6bf76c6c-0c69-411b-9a12-757123494cb6
    Error Number:2601,State:1,Class:14
    ClientConnectionId before routing:5028801d-b33b-4b26-8c42-575e672cddb3
    Routing Destination:e4c143437f6f.tr21.westeurope1-a.worker.database.windows.net,11022
     2018-01-23 15:04:50,106 [P4768/D14/T35] ERROR Umbraco.Core.DatabaseContext - Database configuration failed
    System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.umbracoUserGroup' with unique index 'IX_umbracoUserGroup_userGroupAlias'. The duplicate key value is (Admin).
    The statement has been terminated.
       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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass2_0.<ExecuteNonQueryWithRetry>b__0()
       at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
       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.DatabaseContext.UpgradeSchemaAndData(IMigrationEntryService migrationEntryService)
    ClientConnectionId:6bf76c6c-0c69-411b-9a12-757123494cb6
    Error Number:2601,State:1,Class:14
    ClientConnectionId before routing:5028801d-b33b-4b26-8c42-575e672cddb3
    Routing Destination:e4c143437f6f.tr21.westeurope1-a.worker.database.windows.net,11022
     2018-01-23 15:04:50,125 [P4768/D14/T35] 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,database_firewall_rules,UCUserSettings,UFRecordDataBit,UFRecordDataDateTime,UFRecordDataInteger,UFRecordDataLongString,UFRecordDataString,UFRecordFields,UFRecords,UFUserFormSecurity,UFUserSecurity,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,database_firewall_rules,id,database_firewall_rules,name,database_firewall_rules,start_ip_address,database_firewall_rules,end_ip_address,database_firewall_rules,create_date,database_firewall_rules,modify_date,UCUserSettings,User,UCUserSettings,Key,UCUserSettings,Value,UFRecordDataBit,Id,UFRecordDataBit,Key,UFRecordDataBit,Value,UFRecordDataDateTime,Id,UFRecordDataDateTime,Key,UFRecordDataDateTime,Value,UFRecordDataInteger,Id,UFRecordDataInteger,Key,UFRecordDataInteger,Value,UFRecordDataLongString,Id,UFRecordDataLongString,Key,UFRecordDataLongString,Value,UFRecordDataString,Id,UFRecordDataString,Key,UFRecordDataString,Value,UFRecordFields,Key,UFRecordFields,FieldId,UFRecordFields,Record,UFRecordFields,Alias,UFRecordFields,DataType,UFRecords,Id,UFRecords,Form,UFRecords,Created,UFRecords,Updated,UFRecords,CurrentPage,UFRecords,UmbracoPageId,UFRecords,IP,UFRecords,MemberKey,UFRecords,UniqueId,UFRecords,State,UFRecords,RecordData,UFUserFormSecurity,Id,UFUserFormSecurity,User,UFUserFormSecurity,Form,UFUserFormSecurity,HasAccess,UFUserFormSecurity,AllowInEditor,UFUserFormSecurity,SecurityType,UFUserSecurity,User,UFUserSecurity,ManageDataSources,UFUserSecurity,ManagePreValueSources,UFUserSecurity,ManageWorkflows,UFUserSecurity,ManageForms,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:
    FK_UFRecordDataBit_UFRecordFields_Key,FK_UFRecordDataDateTime_UFRecordFields_Key,FK_UFRecordDataInteger_UFRecordFields_Key,FK_UFRecordDataLongString_UFRecordFields_Key,FK_UFRecordDataString_UFRecordFields_Key,FK_umbracoUser_umbracoUserType_id,FK_umbracoUser2app_umbracoUser_id,FK_umbracoUser2NodePermission_umbracoNode_id,FK_umbracoUser2NodePermission_umbracoUser_id,FK_startContentId_umbracoNode_id,FK_startMediaId_umbracoNode_id,FK_umbracoUser2UserGroup_umbracoUser_id,FK_umbracoUser2UserGroup_umbracoUserGroup_id,FK_umbracoUserGroup2NodePermission_umbracoUserGroup_id,FK_umbracoUserGroup2NodePermission_umbracoNode_id,FK_umbracoUserGroup2App_umbracoUserGroup_id,FK_umbracoUserStartNode_umbracoUser_id,FK_umbracoUserStartNode_umbracoNode_id,PK_UCUserSettings,PK_UFRecordDataBit,PK_UFRecordDataDateTime,PK_UFRecordDataInteger,PK_UFRecordDataLongString,PK_UFRecordDataString,PK_UFRecordFields,PK_UFRecords,PK_umbracoUser2NodePermission,PK_umbracoUserType,PK_user2app,PK_umbracoUserGroup,PK_user2userGroup,PK_umbracoUserGroup2NodePermission,PK_userGroup2App,PK_userStartNode,IX_umbracoNodeTrashed,IX_umbracoNodeParentId,IX_umbracoNodePath,IX_umbracoNodeUniqueID,IX_umbracoNodeObjectType,IX_cmsContentType,IX_cmsContentType_icon,IX_cmsTemplate_nodeId,IX_cmsContent,IX_cmsContentVersion_ContentId,IX_cmsContentVersion_VersionId,IX_cmsDocument,IX_cmsDocument_published,IX_cmsDocument_newest,IX_cmsDataType_nodeId,IX_cmsDictionary_id,IX_cmsDictionary_key,IX_umbracoLanguage_languageISOCode,IX_umbracoLog,IX_cmsMacro_UniqueId,IX_cmsMacroPropertyAlias,IX_cmsMacroProperty_UniquePropertyId,IX_cmsMacroProperty_Alias,IX_cmsMember_LoginName,IX_cmsPropertyTypeGroupUniqueID,IX_cmsPropertyTypeUniqueID,IX_cmsPropertyData_1,IX_cmsPropertyData_2,IX_cmsPropertyData_3,IX_umbracoRelationType_UniqueId,IX_umbracoRelationType_name,IX_umbracoRelationType_alias,IX_umbracoRelation_parentChildType,IX_cmsTags,IX_umbracoUser_userLogin,IX_cmsTaskType_alias,IX_computerName,IX_umbracoServer_isActive,IX_umbracoAccess_nodeId,IX_umbracoAccessRule,IX_umbracoMigration,IX_umbracoRedirectUrl,IX_umbracoUserGroup_userGroupAlias,IX_umbracoUserGroup_userGroupName,IX_umbracoUser2NodePermission_nodeId,IX_umbracoUserStartNode_startNodeType
    
    The following indexes were found in the database, but are not in the current schema:
    IX_databit_recordfield,IX_datadatetime_recordfield,IX_datainteger_recordfield,IX_datalongstring_recordfield,IX_datastring_recordfield,Id,IX_cmsDictionary_key,IX_umbracoUserGroup_userGroupAlias,IX_umbracoUserGroup_userGroupName,IX_umbracoUserStartNode_startNodeType
    
    The following unknown constraints (Primary Keys, Foreign Keys and Indexes) were found in the database, but are not in the current schema:
    Id
    
  • Jeremias 49 posts 273 karma points
    Jan 24, 2018 @ 14:14
    Jeremias
    0

    Can it be, that you have to delete this keys?

    enter image description here

  • Fuji Kusaka 2203 posts 4220 karma points
    Jan 25, 2018 @ 05:21
    Fuji Kusaka
    100

    Finally fix it, looks like we had a duplicate "User type Alias" Admin which prevented the upgrade.

    Our current structure we usually assign a UserType to a group of Users. With 7.7.0 since userGroup is new it kind of clash and prevent the upgrade.

    There are few things to update manually like trees.config and applications.config which comes with the new settings from 7.7

Please Sign in or register to post replies

Write your reply to:

Draft