I'm stuck in an upgrade from 6.1.5 to 7.3.1. Seems, as if the upgrade procedure relies on a database object 'umbracoMigration' which doesn't exist in the database.
This is the text in the umbracoTraceLog file:
2015-11-01 15:11:25,515 [P9044/D5/T7] ERROR Umbraco.Core.DatabaseContext - Database configuration failed
System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'umbracoMigration'.
bei System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
bei System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
bei System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
bei System.Data.SqlClient.SqlDataReader.get_MetaData()
bei System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
bei System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
bei System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
bei System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
bei System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
bei Umbraco.Core.Persistence.Database.<Query>d__7`1.MoveNext()
bei System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source)
bei Umbraco.Core.Persistence.Repositories.MigrationEntryRepository.FindEntry(String migrationName, SemVersion version)
bei Umbraco.Core.Services.MigrationEntryService.FindEntry(String migrationName, SemVersion version)
bei Umbraco.Core.Persistence.Migrations.MigrationRunner.ExecuteMigrations(IMigrationContext context, Database database)
bei Umbraco.Core.Persistence.Migrations.MigrationRunner.Execute(Database database, DatabaseProviders databaseProvider, Boolean isUpgrade)
bei Umbraco.Core.DatabaseContext.UpgradeSchemaAndData(IMigrationEntryService migrationEntryService)
immediately after the error another message appears:
Fehlernummer (Error Number):208,Status (State):1,Klasse (Class):16
2015-11-01 15:11:25,519 [P9044/D5/T7] 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:
cmsMacroPropertyType,umbracoUserLogins,umbracoAccess,umbracoAccessRule,umbracoCacheInstruction,umbracoExternalLogin,umbracoMigration
The following columns were found in the database, but are not in the current schema:
cmsContentVersion,LanguageLocale,cmsDataType,controlId,cmsDocument,alias,cmsMacroProperty,macroPropertyHidden,cmsMacroProperty,macroPropertyType,cmsMacroPropertyType,id,cmsMacroPropertyType,macroPropertyTypeAlias,cmsMacroPropertyType,macroPropertyTypeRenderAssembly,cmsMacroPropertyType,macroPropertyTypeRenderType,cmsMacroPropertyType,macroPropertyTypeBaseType,cmsPropertyType,helpText,cmsTemplate,master,umbracoUser,userDefaultPermissions,umbracoUser,defaultToLiveEditing,umbracoUserLogins,contextID,umbracoUserLogins,userID,umbracoUserLogins,timeout,cmsDataType,propertyEditorAlias,cmsMacroProperty,editorAlias,cmsPropertyType,UniqueID,cmsTagRelationship,propertyTypeId,umbracoUser,securityStampToken,umbracoUser,failedLoginAttempts,umbracoUser,lastLockoutDate,umbracoUser,lastPasswordChangeDate,umbracoUser,lastLoginDate,umbracoServer,isMaster,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_cmsMacroProperty_cmsMacroPropertyType_id,FK_cmsTagRelationship_umbracoNode_id,FK_cmsTemplate_cmsTemplate,FK_cmsContent_cmsContentType_nodeId,FK_cmsDictionary_cmsDictionary_id,FK_cmsLanguageText_umbracoLanguage_id,FK_cmsTags_cmsTags,FK_cmsTagRelationship_cmsContent,FK_cmsTagRelationship_cmsPropertyType,FK_umbracoAccess_umbracoNode_id,FK_umbracoAccess_umbracoNode_id1,FK_umbracoAccess_umbracoNode_id2,FK_umbracoAccessRule_umbracoAccess_id,PK_cmsMacroPropertyType,PK_cmsPreviewXml,PK_cmsContentPreviewXml,PK_umbracoAccess,PK_umbracoAccessRule,PK_umbracoCacheInstruction,PK_umbracoExternalLogin,PK_umbracoMigration,IX_umbracoNodeTrashed,IX_umbracoNodeParentId,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_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:
umbracoUserLogins_Index,IX_umbracoNodeTrashed,IX_umbracoNodeUniqueID,IX_cmsContentVersion_ContentId,IX_cmsDocument_published,IX_cmsDocument_newest,IX_cmsMacroPropertyAlias,IX_cmsMacroProperty_Alias,IX_cmsPropertyTypeUniqueID,IX_cmsTags,IX_umbracoAccess_nodeId,IX_umbracoAccessRule,IX_umbracoMigration
The error suggests, that there is an object 'umbracoMigration' which shouldn't be there, because it's not part of the Schema. This seems to be a contradictionary message to the former error message. And I can't see that object in the database.
Does anybody have any insight in this matter? What is 'umbracoMigration' for?
The umbracoMigration table is a new table that stores which "migrations" have run. Currently it will only store the installed version of Umbraco so we can detect if an upgrade is necessary. This table was introduced in v7.3.0. So if you've upgraded your site to 7.3.1 and the upgrade installer ran then it will add "7.3.1" into a new row. Then when you deploy the new files to your next environment (your staging site or your live site for example) it will look in the database on that environment and see that the upgrade hasn't completed there yet (the umbracoMigration table only has "7.3.0"). The upgrade installer then pops up again so that it can make sure everything is actually properly upgraded to the latest version.
Now.. that was a long introduction before we get to the actual problem: the upgrade installer will detect that your database does not have the table and should create it for you. Seems like that hasn't happened yet.
Did you actually see the upgrade installer and did you run through it? Did you have any other errors in the installer that might have prevented the database from being upgraded properly?
One other things: you should never ever clear the appSetting umbracoConfigurationStatus in your web.config and also don't touch the connection string in your web.config before you upgrade. If you modified either one of those before you attempted to upgrade Umbraco then that might be the problem. Make sure to restore the backup of your database (that you hopefully made) and have umbracoConfigurationStatus set to 6.1.5 and have your connection string pointing to the 6.1.5 version of the database and try again.
That was the reason for the error. I had to set it to 6.1.5. After that change the installation succeeded.
Even if I'm aware about the meaning of this entry I might have changed it mistakenly to 7.3.1 since the line got lost during the merge of the web.config after installation. I remember that I had to add the line and that the connection string was empty. Using my SVN I restored these lines.
2015-11-03 09:52:46,721 [P10040/D2/T16] INFO Umbraco.Core.Persistence.UmbracoDatabase - at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.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.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 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](Func`1 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.Update(String tableName, String primaryKeyName, Object poco, Object primaryKeyValue, IEnumerable`1 columns)
2015-11-03 09:52:46,773 [P10040/D2/T16] ERROR Umbraco.Core.DatabaseContext - Database configuration failed
System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'UniqueID'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.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.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 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](Func`1 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.Update(String tableName, String primaryKeyName, Object poco, Object primaryKeyValue, IEnumerable`1 columns)
at Umbraco.Core.Persistence.Database.Update(Object poco, Object primaryKeyValue, IEnumerable`1 columns)
at Umbraco.Core.Persistence.Database.Update(Object poco)
at Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSixZeroOne.UpdatePropertyTypesAndGroups.UpdatePropertyTypesAndGroupsDo(Database database)
at Umbraco.Core.Persistence.Migrations.Syntax.Execute.Expressions.ExecuteCodeStatementExpression.Process(Database database)
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:19cf22e9-2586-4cd5-99d8-9faebc1f286b
2015-11-03 09:52:46,780 [P10040/D2/T16] 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:
umbracoApp,UCUserSettings,ConciergeLockUnLock,TS_ScheduledTask,cmsMacroPropertyType,UFFieldConditions,cmsTab,UFFieldConditionRules,eks_PageExpiry,eks_BinDeliveryDates,ns_EmailTrackingItems,ns_Newsletters,ns_Subscribers,ns_Subscriptions,ns_Templates,ns_TrackingItems,UFWorkflowsToForms,UFSettings,icUrlTracker,UFPrevalueSources,UFUserSecurity,UFDataSources,UFFormStates,UFPrevalueSourceSettings,umbracoAppTree,UFDataSourceMappings,UFForms,UFWorkflowExecutionStates,UFWorkflows,UFRecordsXml,UFRecords,UFUserFormSecurity,umbracoUserLogins,UFPages,UFRecordFields,UFFieldsets,UFFields,UFFieldSettings,UFPrevalues,UFRecordDataString,UFRecordDataLongString,UFRecordDataInteger,UFRecordDataDateTime,UFRecordDataBit,cmsPropertyTypeGroup,cmsContentType2ContentType,umbracoAccess,umbracoAccessRule,umbracoCacheInstruction,umbracoExternalLogin,umbracoMigration
The following columns were found in the database, but are not in the current schema:
cmsDocument,alias,umbracoApp,sortOrder,umbracoApp,appAlias,umbracoApp,appIcon,umbracoApp,appName,umbracoApp,appInitWithTreeAlias,UCUserSettings,User,UCUserSettings,Key,UCUserSettings,Value,ConciergeLockUnLock,ticketId,ConciergeLockUnLock,nodeId,ConciergeLockUnLock,userId,ConciergeLockUnLock,Datestamp,ConciergeLockUnLock,Status,ConciergeLockUnLock,Comment,cmsContentType,masterContentType,TS_ScheduledTask,ScheduledTaskId,TS_ScheduledTask,ScheduledTaskName,TS_ScheduledTask,NotifyEmailAddress,TS_ScheduledTask,ExecuteEvery,TS_ScheduledTask,ExecuteDays,TS_ScheduledTask,ExecuteHour,TS_ScheduledTask,ExecuteMinute,TS_ScheduledTask,RunTaskAs,TS_ScheduledTask,TaskUrl,TS_ScheduledTask,UseOutputInReport,cmsMacroPropertyType,id,cmsMacroPropertyType,macroPropertyTypeAlias,cmsMacroPropertyType,macroPropertyTypeRenderAssembly,cmsMacroPropertyType,macroPropertyTypeRenderType,cmsMacroPropertyType,macroPropertyTypeBaseType,UFFieldConditions,Id,UFFieldConditions,Field,UFFieldConditions,Enabled,UFFieldConditions,ActionType,UFFieldConditions,LogicType,cmsTab,id,cmsTab,contenttypeNodeId,cmsTab,text,cmsTab,sortorder,UFFieldConditionRules,Id,UFFieldConditionRules,FieldCondition,UFFieldConditionRules,Field,UFFieldConditionRules,Operator,UFFieldConditionRules,Value,cmsTemplate,master,eks_PageExpiry,Id,eks_PageExpiry,doy,umbracoUser,userDefaultPermissions,umbracoUser,defaultToLiveEditing,eks_BinDeliveryDates,Id,eks_BinDeliveryDates,PostCode,eks_BinDeliveryDates,DeliveryDate,ns_EmailTrackingItems,Id,ns_EmailTrackingItems,Newsletter_Id,ns_EmailTrackingItems,SubscriberId,ns_EmailTrackingItems,Name,ns_EmailTrackingItems,Email,ns_EmailTrackingItems,Error,ns_EmailTrackingItems,Status,ns_EmailTrackingItems,SendDate,ns_EmailTrackingItems,CreateDate,ns_EmailTrackingItems,SubscriptionAlias,ns_Newsletters,Id,ns_Newsletters,MessageBody,ns_Newsletters,Name,ns_Newsletters,EmailSubject,ns_Newsletters,SubscriptionAlias,ns_Newsletters,CreatedDate,ns_Newsletters,SentDate,ns_Newsletters,ScheduledSendDate,ns_Newsletters,Status,ns_Newsletters,EmailFrom,ns_Newsletters,SenderName,ns_Newsletters,Template_Id,ns_Subscribers,Id,ns_Subscribers,Name,ns_Subscribers,Email,ns_Subscribers,SubscribeDate,ns_Subscribers,SubscriptionId,ns_Subscribers,Status,ns_Subscribers,ErrorCount,ns_Subscriptions,Id,ns_Subscriptions,Name,ns_Templates,Id,ns_Templates,Name,ns_Templates,Content,cmsPropertyType,tabId,cmsPropertyType,helpText,ns_TrackingItems,Id,ns_TrackingItems,Email,ns_TrackingItems,TrackingType,ns_TrackingItems,NewsletterId,ns_TrackingItems,CreatedDate,ns_TrackingItems,Url,cmsMacroProperty,macroPropertyHidden,cmsMacroProperty,macroPropertyType,UFWorkflowsToForms,Workflow,UFWorkflowsToForms,Form,UFSettings,Id,UFSettings,Key,UFSettings,Value,icUrlTracker,Id,icUrlTracker,OldUrl,icUrlTracker,OldUrlQueryString,icUrlTracker,OldRegex,icUrlTracker,RedirectRootNodeId,icUrlTracker,RedirectNodeId,icUrlTracker,RedirectUrl,icUrlTracker,RedirectHttpCode,icUrlTracker,RedirectPassThroughQueryString,icUrlTracker,Notes,icUrlTracker,Is404,icUrlTracker,Referrer,icUrlTracker,Inserted,UFPrevalueSources,Id,UFPrevalueSources,Name,UFPrevalueSources,Type,UFUserSecurity,User,UFUserSecurity,ManageDataSources,UFUserSecurity,ManagePreValueSources,UFUserSecurity,ManageWorkflows,UFUserSecurity,ManageForms,UFDataSources,Id,UFDataSources,Type,UFDataSources,Name,UFFormStates,State,UFPrevalueSourceSettings,PrevalueProvider,UFPrevalueSourceSettings,Key,UFPrevalueSourceSettings,Value,umbracoAppTree,treeSilent,umbracoAppTree,treeInitialize,umbracoAppTree,treeSortOrder,umbracoAppTree,appAlias,umbracoAppTree,treeAlias,umbracoAppTree,treeTitle,umbracoAppTree,treeIconClosed,umbracoAppTree,treeIconOpen,umbracoAppTree,treeHandlerAssembly,umbracoAppTree,treeHandlerType,umbracoAppTree,action,UFDataSourceMappings,DataSource,UFDataSourceMappings,DataSourceField,UFDataSourceMappings,Form,UFDataSourceMappings,PrevalueTable,UFDataSourceMappings,PrevalueKeyField,UFDataSourceMappings,PrevalueValueField,UFDataSourceMappings,DataType,UFDataSourceMappings,DefaultValue,UFForms,Id,UFForms,Name,UFForms,Created,UFForms,ManualApproval,UFForms,GotoPageOnSubmit,UFForms,MessageOnSubmit,UFForms,DataSource,UFForms,ShowValidationSummary,UFForms,HideFieldValidation,UFForms,RequiredErrorMessage,UFForms,InvalidErrorMessage,UFForms,FieldIndicationType,UFForms,Indicator,UFForms,Archived,UFForms,StoreRecordsLocally,UFForms,DisableDefaultStylesheet,UFForms,Entries,UFForms,Views,cmsDataType,controlId,UFWorkflowExecutionStates,Workflow,UFWorkflowExecutionStates,State,UFWorkflowExecutionStates,Form,UFWorkflows,Id,UFWorkflows,Name,UFWorkflows,Type,UFWorkflows,SortOrder,UFWorkflows,Active,UFWorkflows,Form,UFWorkflows,ExecutesOn,UFRecordsXml,id,UFRecordsXml,Form,UFRecordsXml,xml,UFRecordsXml,created,UFRecordsXml,Page,UFRecords,Id,UFRecords,Form,UFRecords,Created,UFRecords,Updated,UFRecords,State,UFRecords,currentPage,UFRecords,umbracoPageId,UFRecords,IP,UFRecords,MemberKey,UFUserFormSecurity,User,UFUserFormSecurity,Form,UFUserFormSecurity,HasAccess,UFUserFormSecurity,SecurityType,UFUserFormSecurity,AllowInEditor,umbracoUserLogins,contextID,umbracoUserLogins,userID,umbracoUserLogins,timeout,UFPages,Id,UFPages,Form,UFPages,SortOrder,UFPages,Caption,UFRecordFields,Key,UFRecordFields,Field,UFRecordFields,Record,UFRecordFields,DataType,UFFieldsets,Id,UFFieldsets,Page,UFFieldsets,SortOrder,UFFieldsets,Caption,UFFields,Id,UFFields,Fieldset,UFFields,Fieldtype,UFFields,PreValueProvider,UFFields,RegEx,UFFields,Mandatory,UFFields,SortOrder,UFFields,Caption,UFFields,DataSourceField,UFFields,ToolTip,UFFields,DefaultValue,UFFields,RequiredErrorMessage,UFFields,InvalidErrorMessage,UFFieldSettings,Field,UFFieldSettings,Key,UFFieldSettings,Value,UFPrevalues,Id,UFPrevalues,Field,UFPrevalues,Value,UFPrevalues,SortOrder,UFRecordDataString,Key,UFRecordDataString,Value,UFRecordDataLongString,Key,UFRecordDataLongString,Value,UFRecordDataInteger,Key,UFRecordDataInteger,Value,UFRecordDataDateTime,Key,UFRecordDataDateTime,Value,UFRecordDataBit,Key,UFRecordDataBit,Value,cmsContentType,isContainer,cmsContentType,allowAtRoot,cmsDataType,propertyEditorAlias,cmsMacroProperty,editorAlias,cmsPropertyTypeGroup,id,cmsPropertyTypeGroup,parentGroupId,cmsPropertyTypeGroup,contenttypeNodeId,cmsPropertyTypeGroup,text,cmsPropertyTypeGroup,sortorder,cmsPropertyType,propertyTypeGroupId,cmsPropertyType,UniqueID,cmsTagRelationship,propertyTypeId,umbracoUser,securityStampToken,umbracoUser,failedLoginAttempts,umbracoUser,lastLockoutDate,umbracoUser,lastPasswordChangeDate,umbracoUser,lastLoginDate,cmsContentType2ContentType,parentContentTypeId,cmsContentType2ContentType,childContentTypeId,cmsContentTypeAllowedContentType,SortOrder,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_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_EmailTrackingItemNewsletter1,FK_SubscribeListSubscriber1,FK_UFDataSourceMappings_UFDataSources,FK_UFDataSourceMappings_UFForms,FK_UFField_UFFieldsets,FK_UFFieldConditionRules_UFFieldConditions,FK_UFFieldConditionRules_UFFields,FK_UFFieldConditions_UFFields,FK_UFFieldsets_UFPages,FK_UFFieldSettings_UFFields,FK_UFForms_UFDataSources,FK_UFPages_UFForms,FK_UFPrevalues_UFFields,FK_UFPrevalueSettings_UFPrevalueProviders,FK_UFRecordDataBit_UFRecordFields,FK_UFRecordDataDateTime_UFRecordFields,FK_UFRecordDataInteger_UFRecordFields,FK_UFRecordDataLongString_UFRecordFields,FK_UFRecordDataString_UFRecordFields,FK_UFRecordFields_UFFields,FK_UFRecordFields_UFRecords,FK_UFRecords_UFForms,FK_UFRecordsXml_UFForms,FK_UFUserFormSecurity_UFForms,FK_UFWorkflowExecutionStates_UFFormStates,FK_UFWorkflows_UFForms,FK_umbracoDomains_umbracoNode,FK_umbracoMacroProperty_umbracoMacroPropertyType,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_cmsContent_cmsContentType_nodeId,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_cmsContentType_nodeId,FK_cmsMemberType_umbracoNode_id,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_cmsPropertyTypeGroup_id,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_cmsTags_cmsTags,FK_cmsTagRelationship_cmsContent,FK_cmsTagRelationship_cmsTags_id,FK_cmsTagRelationship_cmsPropertyType,FK_umbracoUser_umbracoUserType_id,FK_cmsTask_cmsTaskType_id,FK_cmsTask_umbracoNode_id,FK_cmsContentType2ContentType_umbracoNode_parent,FK_cmsContentType2ContentType_umbracoNode_child,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__cmsConte__3213E83F3B75D760,PK__ns_Email__3214EC071D7B6025,PK__ns_Newsl__3214EC07214BF109,PK__ns_Subsc__3214EC07251C81ED,PK__ns_Subsc__3214EC0728ED12D1,PK__ns_Templ__3214EC072CBDA3B5,PK__ns_Track__3214EC07308E3499,PK_cmsTab,PK_ConciergeLockUnLock,PK_domains,PK_eks_BinDeliveryDates,PK_eks_PageExpiry,PK_icUrlTracker,PK_language,PK_macro,PK_macroProperty,PK_macroPropertyType,PK_templates,PK_TS_ScheduledTask,PK_UCUserSettings,PK_UFDataSourceMappings,PK_UFDataSources,PK_UFField,PK_UFFieldConditionRules,PK_UFFieldConditions,PK_UFFieldsets,PK_UFForms,PK_UFFormStates,PK_UFPages,PK_UFPrevalueProviders,PK_UFPrevalues,PK_UFPrevalueSettings,PK_UFRecordDataBit,PK_UFRecordDataDateTime,PK_UFRecordDataInteger,PK_UFRecordDataLongString,PK_UFRecordDataString,PK_UFRecordFields,PK_UFRecords,PK_UFRecordsXml,PK_UFSettings,PK_UFUserFormSecurity,PK_UFUserSecurity,PK_UFWorkflowExecutionStates,PK_UFWorkflows,PK_UFWorkflowsToForms,PK_umbracoApp,PK_umbracoAppTree,PK_userType,PK_cmsTemplate,PK_cmsContentVersion,PK_umbracoLanguage,PK_umbracoDomains,PK_cmsMacro,PK_cmsMacroProperty,PK_cmsPropertyTypeGroup,PK_umbracoUserType,PK_cmsContentType2ContentType,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_cmsTaskType,IX_cmsTemplate,NCI_EmailTrackingItems_Email,NCI_TrackingItems_Email,IX_umbracoLanguage,IX_umbracoUser,umbracoUserLogins_Index,IX_umbracoNodeTrashed,IX_umbracoNodeUniqueID,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_cmsMacroPropertyAlias,IX_cmsMacroProperty_Alias,IX_cmsPropertyTypeUniqueID,IX_cmsTags,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:
cmsTags_cmsTagRelationship,umbracoNode_cmsTagRelationship
I am getting similar error but i am trying to upgrade from 4.11.8 to 7.3.1
I have merged the web.config file and umbracoConfigurationStatus is 4.11.8
It looks like issue is related miniprofiler, anyone please help me out to fix this issue
Other than that we haven't been able to reproduce this, maybe Tom has found the problem already, you can ask him here: http://issues.umbraco.org/issue/U4-7220
Hi,
i got the same error after upgrading locally, and releasing the web.config on my production server. The problem was solved when i removed the value from umbracoConfigurationStatus in appsettings. It shouldn't of course be there in the first place.
Just came across this error when upgrading an older version of Umrbaco and thought this might help..
The database upgraded with schema from a user which was not db_owner.
so the new tables looked like this:
umbraco_webuser.umbracoMigration
rather than
dbo.umbracoMigration
I ran this SQL on the tables with incorrect schema and restarted my site and now works fine:
ALTER SCHEMA dbo TRANSFER umbraco_webuser.umbracoMigration;
Upgrade 6.1.5->7.3.1 fails: Invalid Object 'umbracoMigration'
Hi altogether,
I'm stuck in an upgrade from 6.1.5 to 7.3.1. Seems, as if the upgrade procedure relies on a database object 'umbracoMigration' which doesn't exist in the database.
This is the text in the umbracoTraceLog file:
immediately after the error another message appears:
The error suggests, that there is an object 'umbracoMigration' which shouldn't be there, because it's not part of the Schema. This seems to be a contradictionary message to the former error message. And I can't see that object in the database.
Does anybody have any insight in this matter? What is 'umbracoMigration' for?
Thanks a lot in advance.
-Mirko
The
umbracoMigration
table is a new table that stores which "migrations" have run. Currently it will only store the installed version of Umbraco so we can detect if an upgrade is necessary. This table was introduced in v7.3.0. So if you've upgraded your site to 7.3.1 and the upgrade installer ran then it will add "7.3.1" into a new row. Then when you deploy the new files to your next environment (your staging site or your live site for example) it will look in the database on that environment and see that the upgrade hasn't completed there yet (theumbracoMigration
table only has "7.3.0"). The upgrade installer then pops up again so that it can make sure everything is actually properly upgraded to the latest version.Now.. that was a long introduction before we get to the actual problem: the upgrade installer will detect that your database does not have the table and should create it for you. Seems like that hasn't happened yet.
Did you actually see the upgrade installer and did you run through it? Did you have any other errors in the installer that might have prevented the database from being upgraded properly?
One other things: you should never ever clear the appSetting
umbracoConfigurationStatus
in your web.config and also don't touch the connection string in your web.config before you upgrade. If you modified either one of those before you attempted to upgrade Umbraco then that might be the problem. Make sure to restore the backup of your database (that you hopefully made) and haveumbracoConfigurationStatus
set to 6.1.5 and have your connection string pointing to the 6.1.5 version of the database and try again.Sebastiaan, thanks for your Input. Your answer made it possible to fix the error. Somehow the UmbracoConfigurationStatus was at 7.3.1:
That was the reason for the error. I had to set it to 6.1.5. After that change the installation succeeded.
Even if I'm aware about the meaning of this entry I might have changed it mistakenly to 7.3.1 since the line got lost during the merge of the web.config after installation. I remember that I had to add the line and that the connection string was empty. Using my SVN I restored these lines.
Making a long answer short: It works now!
Thanks a lot for answering.
I am getting similar error but i am trying to upgrade from 4.11.8 to 7.3.1
I have merged the web.config file and umbracoConfigurationStatus is 4.11.8
It looks like issue is related miniprofiler, anyone please help me out to fix this issue
Thanks, Lokesh
The MiniProfiler is not the problem, it's just used to run all our queries through.
Do you use uSiteBuilder? Maybe that is the problem, see: http://issues.umbraco.org/issue/U4-7100
Other than that we haven't been able to reproduce this, maybe Tom has found the problem already, you can ask him here: http://issues.umbraco.org/issue/U4-7220
Thanks for your quick response, i am not using uSiteBuilder
I will ask Tom
Lokesh
I managed to fix this by upgrading database to 7.2.8 and then upgrading to 7.3.1. And also need to delete duplicate rows from tables
Hi, i got the same error after upgrading locally, and releasing the web.config on my production server. The problem was solved when i removed the value from umbracoConfigurationStatus in appsettings. It shouldn't of course be there in the first place.
Thanks for giving me directions.
I had the same error noted above. I am trying to upgrade from 6.1.6 to version 7.4.3. The umbracoConfigurationStatus value=“7.4.3”
I changed back to old version: 6.1.6
Restarted the IIS
Now I'm seeing 500 Internal Error.
Where as I had the upgrade installer before changing this back to the old version #.
I'ver tried to change umbracoConfigurationStaus back to 7.4.3 to at least see the upgrade installer again.
Nothing but 500 Internal Error.
I'm using Chrome, doing a hard restart....nothing. I changed the version # in the ~/Config/ClientDependency.config
Restarted IIS
Still 500 Internal Error
Any help would be greatly appreciated!!!
Just came across this error when upgrading an older version of Umrbaco and thought this might help..
The database upgraded with schema from a user which was not db_owner.
so the new tables looked like this: umbraco_webuser.umbracoMigration rather than dbo.umbracoMigration I ran this SQL on the tables with incorrect schema and restarted my site and now works fine:
is working on a reply...