Copied to clipboard

Flag this post as spam?

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


  • mmaty 113 posts 286 karma points
    Nov 01, 2015 @ 14:49
    mmaty
    1

    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:

     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?

    Thanks a lot in advance.

    -Mirko

  • Sebastiaan Janssen 5060 posts 15522 karma points MVP admin hq
    Nov 02, 2015 @ 14:50
    Sebastiaan Janssen
    5

    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.

  • mmaty 113 posts 286 karma points
    Nov 03, 2015 @ 10:49
    mmaty
    4

    Sebastiaan, thanks for your Input. Your answer made it possible to fix the error. Somehow the UmbracoConfigurationStatus was at 7.3.1:

    <add key="umbracoConfigurationStatus" value="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.

  • Lokesh kumar Chippada 44 posts 249 karma points
    Nov 03, 2015 @ 12:21
    Lokesh kumar Chippada
    0
     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

    Thanks, Lokesh

  • Sebastiaan Janssen 5060 posts 15522 karma points MVP admin hq
    Nov 03, 2015 @ 12:34
    Sebastiaan Janssen
    1

    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

  • Lokesh kumar Chippada 44 posts 249 karma points
    Nov 03, 2015 @ 12:39
    Lokesh kumar Chippada
    0

    Thanks for your quick response, i am not using uSiteBuilder

    I will ask Tom

    Lokesh

  • Lokesh kumar Chippada 44 posts 249 karma points
    Nov 03, 2015 @ 16:21
    Lokesh kumar Chippada
    0

    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

  • Anders Brohäll 295 posts 561 karma points c-trib
    Mar 08, 2016 @ 09:08
    Anders Brohäll
    0

    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.

  • Barb Romito 12 posts 74 karma points
    Sep 15, 2016 @ 13:24
    Barb Romito
    0

    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!!!

  • Richard Hamilton 36 posts 158 karma points
    Jul 27, 2020 @ 09:01
    Richard Hamilton
    0

    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; 
    
Please Sign in or register to post replies

Write your reply to:

Draft