U4-7059 - SQL problem upgrading from 7.2.8 to 7.3.0 RC

Created by Mark Smit 02 Sep 2015, 13:19:36 Updated by Shannon Deminick 07 Sep 2015, 21:46:36

Running the umbraco installer gives the following error:

Displayed: http://snag.gy/Zcts9.jpg In the log:

2015-09-02 14:54:05,678 [P11784/D21/T42] INFO Umbraco.Core.Persistence.UmbracoDatabase - at System.Data.SqlClient.SqlConnection.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 asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteNonQuery() in c:\Code\github\SamSaffron\MiniProfiler\StackExchange.Profiling\Data\ProfiledDbCommand.cs:line 279 at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass1.b__0() at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func1 func) at Umbraco.Core.Persistence.Database.Execute(String sql, Object[] args) 2015-09-02 14:54:05,678 [P11784/D21/T42] ERROR Umbraco.Core.DatabaseContext - Database configuration failed System.Data.SqlClient.SqlException (0x80131904): Column 'umbracoLanguage.id' is not the same data type as referencing column 'cmsLanguageText.languageId' in foreign key 'FK_cmsLanguageText_umbracoLanguage_id'. Could not create constraint or index. See previous errors. at System.Data.SqlClient.SqlConnection.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 asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteNonQuery() in c:\Code\github\SamSaffron\MiniProfiler\StackExchange.Profiling\Data\ProfiledDbCommand.cs:line 279 at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass1.<ExecuteNonQueryWithRetry>b__0() at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func1 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:672a87ed-423f-464d-9329-9ada03bd571b Error Number:1778,State:0,Class:16 2015-09-02 14:54:05,679 [P11784/D21/T42] 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: Newsletter,vFALMFullPropertyData,vFALMFullContent,UFRecords,UFRecordFields,UFRecordDataString,UFRecordDataLongString,UFRecordDataInteger,UFRecordDataBit,vABCFullPropertyData,vABCFullContent,UFRecordDataDateTime,UFUserSecurity,UFUserFormSecurity,vMultipleImagePicker,CMSImportState,umbracoUserLogins,CMSImportScheduledTask,CMSImportRelation,CMSImportMediaRelation,CMSImportScheduledItems,vabcFolderbrowser,vOrganisatiesbrowser,vInhoud,vActueelbrowser,vVerhalenbrowser,umbracoAccess,umbracoAccessRule,umbracoCacheInstruction,umbracoExternalLogin,umbracoMigration

The following columns were found in the database, but are not in the current schema: cmsTemplate,master,cmsPropertyType,helpText,Newsletter,Id,Newsletter,Name,Newsletter,Email,vFALMFullPropertyData,contentNodeId,vFALMFullPropertyData,versionId,vFALMFullPropertyData,dataInt,vFALMFullPropertyData,dataDate,vFALMFullPropertyData,dataNvarchar,vFALMFullPropertyData,dataNtext,vFALMFullPropertyData,contentTypeId,vFALMFullPropertyData,Alias,vFALMFullPropertyData,Name,vFALMFullPropertyData,tabId,vFALMFullPropertyData,sortOrder,vFALMFullPropertyData,dbType,vFALMFullContent,name,vFALMFullContent,createBy,vFALMFullContent,createDate,vFALMFullContent,ID,vFALMFullContent,documentType,vFALMFullContent,template,vFALMFullContent,lastPublished,vFALMFullContent,updateDate,vFALMFullContent,releaseDate,vFALMFullContent,expireDate,vFALMFullContent,parentID,vFALMFullContent,path,vFALMFullContent,VersionId,vFALMFullContent,level,UFRecords,Id,UFRecords,Form,UFRecords,Created,UFRecords,Updated,UFRecords,CurrentPage,UFRecords,UmbracoPageId,UFRecords,IP,UFRecords,MemberKey,UFRecords,UniqueId,UFRecords,State,UFRecords,RecordData,UFRecordFields,Key,UFRecordFields,FieldId,UFRecordFields,Record,UFRecordFields,Alias,UFRecordFields,DataType,UFRecordDataString,Id,UFRecordDataString,Key,UFRecordDataString,Value,cmsContentVersion,LanguageLocale,UFRecordDataLongString,Id,UFRecordDataLongString,Key,UFRecordDataLongString,Value,UFRecordDataInteger,Id,UFRecordDataInteger,Key,UFRecordDataInteger,Value,UFRecordDataBit,Id,UFRecordDataBit,Key,UFRecordDataBit,Value,vABCFullPropertyData,contentNodeId,vABCFullPropertyData,versionId,vABCFullPropertyData,dataInt,vABCFullPropertyData,dataDate,vABCFullPropertyData,dataNvarchar,vABCFullPropertyData,dataNtext,vABCFullPropertyData,contentTypeId,vABCFullPropertyData,Alias,vABCFullPropertyData,Name,vABCFullPropertyData,tabId,vABCFullPropertyData,sortOrder,vABCFullPropertyData,dbType,vABCFullContent,name,vABCFullContent,createBy,vABCFullContent,createDate,vABCFullContent,ID,vABCFullContent,documentTypeID,vABCFullContent,documentType,vABCFullContent,template,vABCFullContent,published,vABCFullContent,lastPublished,vABCFullContent,updateDate,vABCFullContent,releaseDate,vABCFullContent,expireDate,vABCFullContent,parentID,vABCFullContent,path,vABCFullContent,VersionId,vABCFullContent,level,UFRecordDataDateTime,Id,UFRecordDataDateTime,Key,UFRecordDataDateTime,Value,UFUserSecurity,User,UFUserSecurity,ManageDataSources,UFUserSecurity,ManagePreValueSources,UFUserSecurity,ManageWorkflows,UFUserSecurity,ManageForms,UFUserFormSecurity,Id,UFUserFormSecurity,User,UFUserFormSecurity,Form,UFUserFormSecurity,HasAccess,UFUserFormSecurity,AllowInEditor,UFUserFormSecurity,SecurityType,vMultipleImagePicker,name,vMultipleImagePicker,createBy,vMultipleImagePicker,createDate,vMultipleImagePicker,ID,vMultipleImagePicker,documentTypeID,vMultipleImagePicker,documentType,vMultipleImagePicker,template,vMultipleImagePicker,published,vMultipleImagePicker,lastPublished,vMultipleImagePicker,updateDate,vMultipleImagePicker,releaseDate,vMultipleImagePicker,expireDate,vMultipleImagePicker,parentID,vMultipleImagePicker,path,vMultipleImagePicker,VersionId,vMultipleImagePicker,level,CMSImportState,Id,CMSImportState,UniqueIdentifier,CMSImportState,Name,CMSImportState,ImportState,CMSImportState,Parent,CMSImportState,ImportProvider,umbracoUserLogins,contextID,umbracoUserLogins,userID,umbracoUserLogins,timeout,CMSImportScheduledTask,ScheduleId,CMSImportScheduledTask,ScheduleGUID,CMSImportScheduledTask,ImportStateGUID,CMSImportScheduledTask,ScheduledTaskName,CMSImportScheduledTask,NotifyEmailAddress,CMSImportScheduledTask,ExecuteEvery,CMSImportScheduledTask,ExecuteDays,CMSImportScheduledTask,ExecuteHour,CMSImportScheduledTask,ExecuteMinute,CMSImportScheduledTask,ImportAsUser,CMSImportRelation,Id,CMSImportRelation,UmbracoID,CMSImportRelation,DataSourceKey,CMSImportRelation,ImportProvider,CMSImportRelation,Updated,CMSImportMediaRelation,Id,CMSImportMediaRelation,UmbracoMediaId,CMSImportMediaRelation,SourceUrl,CMSImportMediaRelation,ByteSize,CMSImportScheduledItems,ScheduledItemId,CMSImportScheduledItems,ScheduleldTaskId,CMSImportScheduledItems,ScheduledOn,CMSImportScheduledItems,ExecutedOn,CMSImportScheduledItems,InProgress,vabcFolderbrowser,name,vabcFolderbrowser,createBy,vabcFolderbrowser,createDate,vabcFolderbrowser,ID,vabcFolderbrowser,documentTypeID,vabcFolderbrowser,documentType,vabcFolderbrowser,template,vabcFolderbrowser,published,vabcFolderbrowser,lastPublished,vabcFolderbrowser,updateDate,vabcFolderbrowser,releaseDate,vabcFolderbrowser,expireDate,vabcFolderbrowser,parentID,vabcFolderbrowser,path,vabcFolderbrowser,VersionId,vabcFolderbrowser,level,vabcFolderbrowser,themas,vabcFolderbrowser,tijdvakken,vabcFolderbrowser,regios,vabcFolderbrowser,gemeente,vOrganisatiesbrowser,name,vOrganisatiesbrowser,createBy,vOrganisatiesbrowser,createDate,vOrganisatiesbrowser,ID,vOrganisatiesbrowser,documentTypeID,vOrganisatiesbrowser,documentType,vOrganisatiesbrowser,template,vOrganisatiesbrowser,published,vOrganisatiesbrowser,lastPublished,vOrganisatiesbrowser,updateDate,vOrganisatiesbrowser,releaseDate,vOrganisatiesbrowser,expireDate,vOrganisatiesbrowser,parentID,vOrganisatiesbrowser,path,vOrganisatiesbrowser,VersionId,vOrganisatiesbrowser,level,vOrganisatiesbrowser,themas,vOrganisatiesbrowser,tijdvakken,vOrganisatiesbrowser,regios,vOrganisatiesbrowser,gemeente,vInhoud,name,vInhoud,createBy,vInhoud,createDate,vInhoud,ID,vInhoud,documentTypeID,vInhoud,documentType,vInhoud,template,vInhoud,published,vInhoud,lastPublished,vInhoud,updateDate,vInhoud,releaseDate,vInhoud,expireDate,vInhoud,parentID,vInhoud,path,vInhoud,VersionId,vInhoud,level,vActueelbrowser,name,vActueelbrowser,createBy,vActueelbrowser,createDate,vActueelbrowser,ID,vActueelbrowser,documentTypeID,vActueelbrowser,documentType,vActueelbrowser,template,vActueelbrowser,published,vActueelbrowser,lastPublished,vActueelbrowser,updateDate,vActueelbrowser,releaseDate,vActueelbrowser,expireDate,vActueelbrowser,parentID,vActueelbrowser,path,vActueelbrowser,VersionId,vActueelbrowser,level,vActueelbrowser,themas,vActueelbrowser,tijdvakken,vActueelbrowser,regios,vActueelbrowser,gemeente,vVerhalenbrowser,name,vVerhalenbrowser,createBy,vVerhalenbrowser,createDate,vVerhalenbrowser,ID,vVerhalenbrowser,documentTypeID,vVerhalenbrowser,documentType,vVerhalenbrowser,template,vVerhalenbrowser,published,vVerhalenbrowser,lastPublished,vVerhalenbrowser,updateDate,vVerhalenbrowser,releaseDate,vVerhalenbrowser,expireDate,vVerhalenbrowser,parentID,vVerhalenbrowser,path,vVerhalenbrowser,VersionId,vVerhalenbrowser,level,vVerhalenbrowser,themas,vVerhalenbrowser,tijdvakken,vVerhalenbrowser,regios,vVerhalenbrowser,gemeente,cmsPropertyType,UniqueID,umbracoUser,securityStampToken,umbracoUser,failedLoginAttempts,umbracoUser,lastLockoutDate,umbracoUser,lastPasswordChangeDate,umbracoUser,lastLoginDate,umbracoAccess,id,umbracoAccess,nodeId,umbracoAccess,loginNodeId,umbracoAccess,noAccessNodeId,umbracoAccess,createDate,umbracoAccess,updateDate,umbracoAccessRule,id,umbracoAccessRule,accessId,umbracoAccessRule,ruleValue,umbracoAccessRule,ruleType,umbracoAccessRule,createDate,umbracoAccessRule,updateDate,umbracoCacheInstruction,id,umbracoCacheInstruction,utcStamp,umbracoCacheInstruction,jsonInstruction,umbracoCacheInstruction,originated,umbracoExternalLogin,id,umbracoExternalLogin,userId,umbracoExternalLogin,loginProvider,umbracoExternalLogin,providerKey,umbracoExternalLogin,createDate,umbracoMigration,id,umbracoMigration,name,umbracoMigration,createDate,umbracoMigration,version

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_cmsContent_umbracoNode,FK_cmsContentType_umbracoNode,FK_cmsContentVersion_cmsContent,FK_cmsContentXml_cmsContent,FK_cmsDataType_umbracoNode,FK_cmsDataTypePreValues_cmsDataType,FK_cmsDocument_cmsContent,FK_cmsDocument_cmsTemplate,FK_cmsDocument_umbracoNode,FK_cmsDocumentType_cmsContentType,FK_cmsDocumentType_cmsTemplate,FK_cmsDocumentType_umbracoNode,FK_cmsLanguageText_cmsDictionary,FK_cmsMacroProperty_cmsMacro,FK_cmsMember_cmsContent,FK_cmsMember_umbracoNode,FK_cmsMember2MemberGroup_cmsMember,FK_cmsMember2MemberGroup_umbracoNode,FK_cmsMemberType_cmsContentType,FK_cmsMemberType_umbracoNode,FK_cmsPreviewXml_cmsContent,FK_cmsPreviewXml_cmsContentVersion,FK_cmsPropertyData_cmsPropertyType,FK_cmsPropertyData_umbracoNode,FK_cmsPropertyType_cmsContentType,FK_cmsPropertyType_cmsDataType,FK_cmsPropertyType_cmsTab,FK_cmsStylesheet_umbracoNode,FK_cmsStylesheetProperty_umbracoNode,FK_cmsTab_cmsContentType,FK_cmsTask_cmsTaskType,FK_cmsTask_umbracoNode,FK_cmsTemplate_cmsTemplate,FK_umbracoDomains_umbracoNode,FK_umbracoNode_umbracoNode,FK_umbracoRelation_umbracoRelationType,FK_umbracoUser2NodeNotify_umbracoNode,FK_umbracoUser2NodeNotify_umbracoUser,FK_umbracoUser2NodePermission_umbracoNode,FK_umbracoUser2NodePermission_umbracoUser,FK_user_userType,FK_umbracoNode_umbracoNode_id,FK_cmsContentType_umbracoNode_id,FK_cmsContent_umbracoNode_id,FK_cmsContentVersion_cmsContent_nodeId,FK_cmsDocument_umbracoNode_id,FK_cmsDocument_cmsContent_nodeId,FK_cmsDocument_cmsTemplate_nodeId,FK_cmsDocumentType_umbracoNode_id,FK_cmsDocumentType_cmsContentType_nodeId,FK_cmsDocumentType_cmsTemplate_nodeId,FK_cmsDataType_umbracoNode_id,FK_cmsDataTypePreValues_cmsDataType_nodeId,FK_cmsDictionary_cmsDictionary_id,FK_cmsLanguageText_umbracoLanguage_id,FK_cmsLanguageText_cmsDictionary_id,FK_umbracoDomains_umbracoNode_id,FK_cmsMacroProperty_cmsMacro_id,FK_cmsMemberType_umbracoNode_id,FK_cmsMemberType_cmsContentType_nodeId,FK_cmsMember_cmsContent_nodeId,FK_cmsMember_umbracoNode_id,FK_cmsMember2MemberGroup_cmsMember_nodeId,FK_cmsMember2MemberGroup_umbracoNode_id,FK_cmsContentXml_cmsContent_nodeId,FK_cmsPreviewXml_cmsContent_nodeId,FK_cmsPreviewXml_cmsContentVersion_VersionId,FK_cmsPropertyTypeGroup_cmsContentType_nodeId,FK_cmsPropertyType_cmsDataType_nodeId,FK_cmsPropertyType_cmsContentType_nodeId,FK_cmsPropertyType_cmsPropertyTypeGroup_id,FK_cmsPropertyData_umbracoNode_id,FK_cmsPropertyData_cmsPropertyType_id,FK_umbracoRelation_umbracoRelationType_id,FK_cmsStylesheet_umbracoNode_id,FK_cmsTagRelationship_cmsTags_id,FK_umbracoUser_umbracoUserType_id,FK_cmsTask_cmsTaskType_id,FK_cmsTask_umbracoNode_id,FK_cmsContentType2ContentType_umbracoNode_parent,FK_cmsContentType2ContentType_umbracoNode_child,FK_umbracoUser2app_umbracoUser_id,FK_umbracoUser2NodeNotify_umbracoUser_id,FK_umbracoUser2NodeNotify_umbracoNode_id,FK_umbracoUser2NodePermission_umbracoUser_id,FK_umbracoUser2NodePermission_umbracoNode_id,FK_umbracoAccess_umbracoNode_id,FK_umbracoAccess_umbracoNode_id1,FK_umbracoAccess_umbracoNode_id2,FK_umbracoAccessRule_umbracoAccess_id,PK_UFRecordDataBit,PK_UFRecordDataDateTime,PK_UFRecordDataInteger,PK_UFRecordDataLongString,PK_UFRecordDataString,PK_UFRecordFields,PK_UFRecords,PK__cmsContentVersio__38996AB5,PK_CMSImportMediaRelation,PK_CMSImportRelation,PK_CMSImportScheduledItems,PK_CMSImportScheduledTask,PK_CMSImportState,PK_cmsTab,PK_domains,PK_language,PK_macro,PK_macroProperty,PK_templates,PK_userType,PK_cmsTemplate,PK_cmsContentVersion,PK_umbracoLanguage,PK_umbracoDomains,PK_cmsMacro,PK_cmsMacroProperty,PK_cmsPropertyTypeGroup,PK_umbracoUserType,PK_umbracoAccess,PK_umbracoAccessRule,PK_umbracoCacheInstruction,PK_umbracoExternalLogin,PK_umbracoMigration,IX_cmsContentVersion,IX_cmsDataType,IX_cmsDictionary,IX_cmsTaskType,IX_cmsTemplate,IX_umbracoLanguage,IX_umbracoUser,IX_umbracoNodeTrashed,IX_umbracoNodeParentId,IX_umbracoNodeUniqueID,IX_umbracoNodeObjectType,IX_cmsContentType_icon,IX_cmsTemplate_nodeId,IX_cmsContentVersion_ContentId,IX_cmsContentVersion_VersionId,IX_cmsDocument_published,IX_cmsDocument_newest,IX_cmsDataType_nodeId,IX_cmsDictionary_id,IX_umbracoLanguage_languageISOCode,IX_umbracoLog,IX_cmsMacroPropertyAlias,IX_cmsMacroProperty_Alias,IX_cmsPropertyTypeUniqueID,IX_cmsPropertyData,IX_cmsPropertyData_1,IX_cmsPropertyData_2,IX_cmsPropertyData_3,IX_cmsTags,IX_umbracoUser_userLogin,IX_cmsTaskType_alias,IX_computerName,IX_umbracoServer_isActive,IX_umbracoAccess_nodeId,IX_umbracoAccessRule,IX_umbracoMigration

The following indexes were found in the database, but are not in the current schema: IX_Icon,IX_cmsContentVersion,IX_cmsDataType,IX_cmsDictionary,IX_cmsMacro_Alias,IX_cmsTaskType,IX_cmsTemplate,IX_databit_recordfield,IX_datadatetime_recordfield,IX_datainteger_recordfield,IX_datalongstring_recordfield,IX_datastring_recordfield,Id,IX_umbracoLanguage,IX_umbracoUser,IX_umbracoUserLogins_Index,IX_cmsContentType_icon,IX_cmsTemplate_nodeId,IX_cmsContentVersion_VersionId,IX_cmsDataType_nodeId,IX_cmsDictionary_id,IX_umbracoLanguage_languageISOCode,IX_cmsMacroPropertyAlias,IX_cmsPropertyTypeUniqueID,IX_umbracoUser_userLogin,IX_cmsTaskType_alias,IX_umbracoAccess_nodeId,IX_umbracoAccessRule,IX_umbracoMigration

The following unknown constraints (Primary Keys, Foreign Keys and Indexes) were found in the database, but are not in the current schema: Id,cmsTags_cmsTagRelationship

2015-09-02 14:54:05,680 [P11784/D21/T42] 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: Column 'umbracoLanguage.id' is not the same data type as referencing column 'cmsLanguageText.languageId' in foreign key 'FK_cmsLanguageText_umbracoLanguage_id'. Could not create constraint or index. See previous errors. Please check log file for additional information (can be found in '/App_Data/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) 2015-09-02 14:54:05,680 [P11784/D21/T42] INFO Umbraco.Web.Install.Controllers.InstallApiController - Step completed (took 4380ms) 2015-09-02 14:54:05,680 [P11784/D21/T42] 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: Column 'umbracoLanguage.id' is not the same data type as referencing column 'cmsLanguageText.languageId' in foreign key 'FK_cmsLanguageText_umbracoLanguage_id'. Could not create constraint or index. See previous errors. Please check log file for additional information (can be found in '/App_Data/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)

Comments

Shannon Deminick 07 Sep 2015, 18:37:07

In older versions of umbraco the pk for umbracoLanguage was smallint instead of just int. I'll update the migration to ensure the pk is changed to int and then the foreign key is made


Shannon Deminick 07 Sep 2015, 21:46:33

Fixed in rev: b3664d2391b85d28037bf2045beab061f639913c Also found out that on some super old db's a required index is missing on the dictionary so fixed that too.


Priority: Major

Type: Bug

State: Fixed

Assignee:

Difficulty: Normal

Category: Installation

Backwards Compatible: True

Fix Submitted:

Affected versions: 7.3.0

Due in version: 7.3.0

Sprint:

Story Points:

Cycle: