Copied to clipboard

Flag this post as spam?

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


  • TheAlbear 2 posts 32 karma points
    Aug 25, 2022 @ 10:37
    TheAlbear
    0

    Upgrading from Umbraco 7.15 to 8 (Detected current version 0.0.0)

    I am trying to upgrade the underlying Umbraco database from 7.15.8 to 8.

    What I have done is spin up a vanilla Umbraco 8, then pointed it to the 7 DB.

    The issue is that when I go running the upgrade see the following method

    Detected current version 0.0.0 (unknown), which needs to be upgraded to 8.
    

    Once run the upgrade I then get the error

    The database failed to upgrade. ERROR: The database configuration failed with the following message: Could not get current version from web.config Umbraco.Core.ConfigurationStatus appSetting.

    I have tried setting the value in the web.config, which was blank but it doesn't make any difference.

    <add key="umbracoConfigurationStatus" value="7.15.8" />
    
  • Marc Goodson 2155 posts 14408 karma points MVP 9x c-trib
    Aug 25, 2022 @ 22:37
    Marc Goodson
    100

    Hi TheAlbear

    Try

    <add key="Umbraco.Core.ConfigurationStatus" value="7.15.8" />
    

    In your web.config appsettings, I think it's looking for that 'longer' specific name of the setting...

    regards

    Marc

  • TheAlbear 2 posts 32 karma points
    Aug 26, 2022 @ 11:23
    TheAlbear
    0

    Thanks this did sort out the detected issue, but now I am instantly getting another error of

    The database configuration failed with the following message: Unknown state "{init-7.15.8}".

    I have checked the installation and it is 7.15.8.

    Below is a section of the tracelog, any help would be most appreciated

    {"@t":"2022-08-26T11:12:36.5894485Z","@mt":"Starting '{MigrationName}'...","MigrationName":"Umbraco.Core","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":107816,"ProcessName":"iisexpress","ThreadId":5,"AppDomainId":3,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"MACHINE1","Log4NetLevel":"INFO ","HttpRequestNumber":2,"HttpRequestId":"d5331524-2102-4b1b-ac69-36ed71a4c835"} {"@t":"2022-08-26T11:12:36.5898432Z","@mt":"At {OrigState}","OrigState":"{init-7.15.6}","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":107816,"ProcessName":"iisexpress","ThreadId":5,"AppDomainId":3,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"MACHINE1","Log4NetLevel":"INFO ","HttpRequestNumber":2,"HttpRequestId":"d5331524-2102-4b1b-ac69-36ed71a4c835"} {"@t":"2022-08-26T11:12:36.6250585Z","@mt":"Database configuration failed","@l":"Error","@x":"System.Exception: Unknown state \"{init-7.15.6}\".\r\n at Umbraco.Core.Migrations.MigrationPlan.Execute(IScope scope, String fromState, IMigrationBuilder migrationBuilder, ILogger logger)\r\n at Umbraco.Core.Migrations.Upgrade.Upgrader.Execute(IScopeProvider scopeProvider, IMigrationBuilder migrationBuilder, IKeyValueService keyValueService, ILogger logger)\r\n at Umbraco.Core.Migrations.Install.DatabaseBuilder.UpgradeSchemaAndData(MigrationPlan plan)","SourceContext":"Umbraco.Core.Migrations.Install.DatabaseBuilder","ProcessId":107816,"ProcessName":"iisexpress","ThreadId":5,"AppDomainId":3,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"MACHINE1","Log4NetLevel":"ERROR","HttpRequestNumber":2,"HttpRequestId":"d5331524-2102-4b1b-ac69-36ed71a4c835"} {"@t":"2022-08-26T11:12:36.6352616Z","@mt":"The database schema validation produced the following summary: {DbSchemaSummary}","DbSchemaSummary":"The following tables were found in the database, but are not in the current schema:\r\numbracoDomains,umbracoMigration,Redirects,cmsContent,cmsContentVersion,cmsContentXml,cmsDataType,cmsDataTypePreValues,cmsDocument,cmsMedia,cmsPreviewXml,cmsPropertyData,cmsTask,cmsTaskType,MemberExportState,icUrlTracker,umbracoContent,umbracoContentVersion,umbracoMediaVersion,umbracoDocument,umbracoDataType,umbracoDomain,umbracoPropertyData,cmsContentNu,umbracoDocumentVersion,umbracoKeyValue,umbracoContentVersionCultureVariation,umbracoDocumentCultureVariation,umbracoContentSchedule\r\n \r\nThe following columns were found in the database, but are not in the current schema:\r\numbracoDomains,id,umbracoDomains,domainDefaultLanguage,umbracoDomains,domainRootStructureID,umbracoDomains,domainName,umbracoMigration,id,umbracoMigration,name,umbracoMigration,createDate,umbracoMigration,version,Redirects,Id,Redirects,IsRegex,Redirects,OldUrl,Redirects,NewUrl,Redirects,LastUpdated,Redirects,Notes,cmsContent,pk,cmsContent,nodeId,cmsContent,contentType,cmsContentVersion,id,cmsContentVersion,ContentId,cmsContentVersion,VersionId,cmsContentVersion,VersionDate,cmsContentXml,nodeId,cmsContentXml,xml,cmsDataType,pk,cmsDataType,nodeId,cmsDataType,propertyEditorAlias,cmsDataType,dbType,cmsDataTypePreValues,id,cmsDataTypePreValues,datatypeNodeId,cmsDataTypePreValues,value,cmsDataTypePreValues,sortorder,cmsDataTypePreValues,alias,cmsDocument,nodeId,cmsDocument,published,cmsDocument,documentUser,cmsDocument,versionId,cmsDocument,text,cmsDocument,releaseDate,cmsDocument,expireDate,cmsDocument,updateDate,cmsDocument,templateId,cmsDocument,newest,cmsMacro,macroScriptType,cmsMacro,macroScriptAssembly,cmsMacro,macroXSLT,cmsMacro,macroPython,cmsMedia,nodeId,cmsMedia,versionId,cmsMedia,mediaPath,cmsPreviewXml,nodeId,cmsPreviewXml,versionId,cmsPreviewXml,timestamp,cmsPreviewXml,xml,cmsPropertyData,id,cmsPropertyData,contentNodeId,cmsPropertyData,versionId,cmsPropertyData,propertytypeid,cmsPropertyData,dataInt,cmsPropertyData,dataDecimal,cmsPropertyData,dataDate,cmsPropertyData,dataNvarchar,cmsPropertyData,dataNtext,cmsTags,ParentId,cmsTask,closed,cmsTask,id,cmsTask,taskTypeId,cmsTask,nodeId,cmsTask,parentUserId,cmsTask,userId,cmsTask,DateTime,cmsTask,Comment,cmsTaskType,id,cmsTaskType,alias,MemberExportState,Id,MemberExportState,UniqueIdentifier,MemberExportState,Name,MemberExportState,ExportState,MemberExportState,Icon,cmsTemplate,design,icUrlTracker,Id,icUrlTracker,OldUrl,icUrlTracker,OldUrlQueryString,icUrlTracker,OldRegex,icUrlTracker,RedirectRootNodeId,icUrlTracker,RedirectNodeId,icUrlTracker,RedirectUrl,icUrlTracker,RedirectHttpCode,icUrlTracker,RedirectPassThroughQueryString,icUrlTracker,ForceRedirect,icUrlTracker,Notes,icUrlTracker,Is404,icUrlTracker,Referrer,icUrlTracker,Inserted,cmsContentType,isElement,cmsContentType,variations,umbracoContent,nodeId,umbracoContent,contentTypeId,umbracoContentVersion,id,umbracoContentVersion,nodeId,umbracoContentVersion,versionDate,umbracoContentVersion,userId,umbracoContentVersion,current,umbracoContentVersion,text,umbracoMediaVersion,id,umbracoMediaVersion,path,umbracoDocument,nodeId,umbracoDocument,published,umbracoDocument,edited,umbracoDataType,nodeId,umbracoDataType,propertyEditorAlias,umbracoDataType,dbType,umbracoDataType,config,umbracoLanguage,isDefaultVariantLang,umbracoLanguage,mandatory,umbracoLanguage,fallbackLanguageId,umbracoDomain,id,umbracoDomain,domainDefaultLanguage,umbracoDomain,domainRootStructureID,umbracoDomain,domainName,umbracoLog,entityType,umbracoLog,parameters,cmsMacro,macroSource,cmsMacro,macroType,cmsPropertyType,variations,umbracoPropertyData,id,umbracoPropertyData,versionId,umbracoPropertyData,propertyTypeId,umbracoPropertyData,languageId,umbracoPropertyData,segment,umbracoPropertyData,intValue,umbracoPropertyData,decimalValue,umbracoPropertyData,dateValue,umbracoPropertyData,varcharValue,umbracoPropertyData,textValue,cmsTags,languageId,umbracoRedirectUrl,culture,cmsContentNu,nodeId,cmsContentNu,published,cmsContentNu,data,cmsContentNu,rv,umbracoDocumentVersion,id,umbracoDocumentVersion,templateId,umbracoDocumentVersion,published,umbracoKeyValue,key,umbracoKeyValue,value,umbracoKeyValue,updated,umbracoContentVersionCultureVariation,id,umbracoContentVersionCultureVariation,versionId,umbracoContentVersionCultureVariation,languageId,umbracoContentVersionCultureVariation,name,umbracoContentVersionCultureVariation,date,umbracoContentVersionCultureVariation,availableUserId,umbracoDocumentCultureVariation,id,umbracoDocumentCultureVariation,nodeId,umbracoDocumentCultureVariation,languageId,umbracoDocumentCultureVariation,edited,umbracoDocumentCultureVariation,available,umbracoDocumentCultureVariation,published,umbracoDocumentCultureVariation,name,umbracoContentSchedule,id,umbracoContentSchedule,nodeId,umbracoContentSchedule,languageId,umbracoContentSchedule,date,umbracoContentSchedule,action\r\n \r\nThe following constraints (Primary Keys, Foreign Keys and Indexes) were found in the database, but are not in the current schema:\r\nFKcmsContentcmsContentTypenodeId,FKcmsContentumbracoNodeid,FKcmsContentVersioncmsContentnodeId,FKcmsContentXmlcmsContentnodeId,FKcmsDataTypeumbracoNodeid,FKcmsDataTypePreValuescmsDataTypenodeId,FKcmsDocumentcmsContentnodeId,FKcmsDocumentcmsTemplatenodeId,FKcmsDocumentumbracoNodeid,FKcmsMediacmsContentnodeId,FKcmsMediaumbracoNodeid,FKcmsMembercmsContentnodeId,FKcmsMemberumbracoNodeid,FKcmsPreviewXmlcmsContentnodeId,FKcmsPreviewXmlcmsContentVersionVersionId,FKcmsPropertyDatacmsPropertyTypeid,FKcmsPropertyDataumbracoNodeid,FKcmsPropertyTypecmsDataTypenodeId,FKcmsTagscmsTags,FKcmsTaskcmsTaskTypeid,FKcmsTaskumbracoNodeid,FKcmsTaskumbracoUser,FKcmsTaskumbracoUser1,FKumbracoDomainsumbracoNodeid,FKumbracoNodeumbracoUserid,FKumbracoContentumbracoNodeid,FKumbracoContentcmsContentTypeNodeId,FKumbracoContentVersionumbracoContentnodeId,FKumbracoContentVersionumbracoUserid,FKumbracoMediaVersionumbracoContentVersionid,FKumbracoDocumentumbracoContentnodeId,FKumbracoDataTypeumbracoNodeid,FKumbracoLanguageumbracoLanguageid,FKumbracoDomainumbracoNodeid,FKumbracoLogumbracoUserid,FKcmsMemberumbracoContentnodeId,FKcmsPropertyTypeumbracoDataTypenodeId,FKumbracoPropertyDataumbracoContentVersionid,FKumbracoPropertyDatacmsPropertyTypeid,FKumbracoPropertyDataumbracoLanguageid,FKcmsTagsumbracoLanguageid,FKcmsContentNuumbracoContentnodeId,FKumbracoDocumentVersionumbracoContentVersionid,FKumbracoDocumentVersioncmsTemplatenodeId,FKumbracoContentVersionCultureVariationumbracoContentVersionid,FKumbracoContentVersionCultureVariationumbracoLanguageid,FKumbracoContentVersionCultureVariationumbracoUserid,FKumbracoDocumentCultureVariationumbracoNodeid,FKumbracoDocumentCultureVariationumbracoLanguageid,FKumbracoContentScheduleumbracoContentnodeId,FKumbracoContentScheduleumbracoLanguageid,PKcmsContent,PKcmsContentPreviewXml,PKcmsContentVersion,PKcmsContentXml,PKcmsDataType,PKcmsDataTypePreValues,PKcmsDocument,PKcmsMedia,PKcmsPropertyData,PKcmsTask,PKcmsTaskType,PKicUrlTracker,PKMemberExportState,PKRedirects,PKstructure,PKumbracoDomains,PKumbracoMigration,PKumbracoNode,PKumbracoContent,PKumbracoContentVersion,PKumbracoMediaVersion,PKumbracoDocument,PKumbracoDataType,PKumbracoDomain,PKumbracoPropertyData,PKcmsContentNu,PKumbracoDocumentVersion,PKumbracoKeyValue,PKumbracoContentVersionCultureVariation,PKumbracoDocumentCultureVariation,PKumbracoContentSchedule\r\n \r\nThe following indexes were found in the database, but are not in the current schema:\r\nIXcmsContent,IXcmsContentVersionContentId,IXcmsContentVersionVersionId,IXcmsDataTypenodeId,IXcmsDocument,IXcmsDocumentnewest,IXcmsDocumentpublished,IXcmsMedia,IXcmsPropertyData1,IXcmsPropertyData2,IXcmsPropertyData3,nciwicmsTagRelationship9F7ECE3AEF382D3BD48B68431441EFCB,IXcmsTaskTypealias,IXicUrlTracker,IXumbracoMigration,IXumbracoNodeObjectType,IXumbracoNodeParentId,IXumbracoNodePath,IXumbracoNodeTrashed,IXumbracoNodeUniqueID,nciwiumbracoNode6D5D1301EAA27CD2478D5A8423DEEE74,IXumbracoNodeUniqueId,IXumbracoNodeParentId,IXumbracoNodePath,IXumbracoNodeTrashed,IXumbracoNodeObjectType,IXumbracoMediaVersion,IXumbracoDocumentPublished,IXumbracoLanguagefallbackLanguageId,IXumbracoPropertyDataVersionId,IXumbracoPropertyDataPropertyTypeId,IXumbracoPropertyDataLanguageId,IXumbracoPropertyDataSegment,IXcmsTagsLanguageId,IXuserLoginDtolastValidatedUtc,IXumbracoContentVersionCultureVariationVersionId,IXumbracoContentVersionCultureVariationLanguageId,IXumbracoDocumentCultureVariationNodeId,IXumbracoDocumentCultureVariationLanguageId\r\n \r\n","SourceContext":"Umbraco.Core.Migrations.Install.DatabaseBuilder","ProcessId":107816,"ProcessName":"iisexpress","ThreadId":5,"AppDomainId":3,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"MACHINE1","Log4NetLevel":"INFO ","HttpRequestNumber":2,"HttpRequestId":"d5331524-2102-4b1b-ac69-36ed71a4c835"} {"@t":"2022-08-26T11:12:36.6422572Z","@mt":"Installation step {Step} failed.","@l":"Error","@x":"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: Unknown state \"{init-7.15.6}\".\n Please check log file for additional information (can be found in '/AppData/Logs/UmbracoTraceLog.txt')\r\n at Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep.ExecuteAsync(Object model)\r\n --- End of inner exception stack trace ---\r\n at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)\r\n at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)\r\n at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)\r\n at Umbraco.Web.Install.Controllers.InstallApiController.Data/Logs/UmbracoTraceLog.txt')\r\n at Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep.ExecuteAsync(Object model)\r\n --- End of inner exception stack trace ---\r\n at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)\r\n at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)\r\n at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)\r\n at Umbraco.Web.Install.Controllers.InstallApiController.

  • Terence Jee 16 posts 87 karma points
    Sep 21, 2022 @ 07:14
    Terence Jee
    0

    Yea i'm having this same issue as well. I used a vanilla umbraco 8 install and pointed it to an umbraco 7.15.8 database and the migration just won't run.

  • Marc Goodson 2155 posts 14408 karma points MVP 9x c-trib
    Sep 21, 2022 @ 09:45
    Marc Goodson
    0

    Hi Terence

    What error do you get?

    and do you have the ConfigurationStatus set... in your vanilla V8

    and are you able to 'login' to the backoffice, in your vanilla V8 site to trigger the migration?

    (have you run the premigration healthcheck on the V7 site first?)

    regards

    Marc

  • Terence Jee 16 posts 87 karma points
    Sep 21, 2022 @ 15:14
    Terence Jee
    0

    Firstly, thanks so much for the quick reply. Was not expecting turn around this fast. I've actually done a v7 to v8 upgrade before, but this site has a lot of 3rd party packages (which I don't think should be an issue unless they're making database changes). But I can't log into the back office, it just runs attempts to run the upgrade then fails. I check the logs and it's the same error as what's above. So there seems to be an issue when it's trying to run the migration script from v7 to v8.

    I found a work around. I just used a blank database with a vanilla umbraco 8 install. Then I installed this tool on both the umb7 install and the new umb8 install: https://our.umbraco.com/packages/backoffice-extensions/converge/

    Because I have these running locally, i used ngrok to open a hole to port 80/443 so it can be accessed externally and after doing this it was able to copy all the doc types, media items, content, etc to the new umb8 database. But not sure why I was getting these errors in the first place which is why I reached out to see if anyone else had run into this.

Please Sign in or register to post replies

Write your reply to:

Draft