upgrade from 7613 to 770 - Using Umbraco And Getting Started

Go to solution

Press Ctrl / CMD + C to copy this to your clipboard.

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

Upgrade from 7.6.13 to 7.7.0

Using Umbraco And Getting Started

Umbraco 7

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

Copy Link

Jeremias 53 posts 278 karma points

Jan 24, 2018 @ 14:14

0

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

Copy Link
Fuji Kusaka 2203 posts 4220 karma points

Jan 25, 2018 @ 05:21

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

Copy Link
is working on a reply...

Please Sign in or register to post replies