Sign in Register
Go to solution
Copied to clipboard

Flag this post as spam?

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


  • Fredrik Stolpe 10 posts 103 karma points
    Dec 12, 2022 @ 11:56
    Fredrik Stolpe
    0

    Database failed to upgrade 8.18.5 -> 9.0.0

    Hello

    I have a website from an Umbraco site that is the latest 8 version, 8.18.5.

    I have create a project with version 9.0.0.

    When I start the site pointing to that database I get the following error:

    The database failed to upgrade. ERROR: The database configuration failed with the following message: The migration plan does not support migrating from state {03482BB0-CF13-475C-845E-ECB8319DBE3C}

    Does anyone have a clue?

    Regards Fredrik

    Copy Link
  • Lindow 154 posts 1301 karma points
    Dec 12, 2022 @ 12:20
    Lindow
    0

    Hey Fredrik

    The umbracoKeyValue table has an incorrect value in it https://github.com/umbraco/Umbraco-CMS/blob/46414f2c646d9a04e2d3614876a7a311cba8653a/src/Umbraco.Infrastructure/Migrations/Upgrade/UmbracoPlan.cs#L252

    You might want to look into https://our.umbraco.com/forum/umbraco-9/107301-migrating-umbraco-8-to-9 and https://our.umbraco.com/documentation/Umbraco-Cloud/Upgrades/Migrating-from-8-to-10/

    Copy Link
  • Cedeste 37 posts 129 karma points
    May 31, 2023 @ 16:18
    Cedeste
    0

    Do you happen to have the keyvalue for 11.1 to 11.2? Logs show it fails at the keyvalue every time.

    Copy Link
  • Fredrik Stolpe 10 posts 103 karma points
    Dec 12, 2022 @ 13:46
    Fredrik Stolpe
    0

    Hello

    Thanks. Still I don't know why it has an incorrect value and what I should do to upgrade. I have not altered the database or done anything special.

    I tried with a clean restore of the database and did according to the second link; to first boot up and install a new database, and then I changed to the version 8 database. But I still get the same error.

    In the installation wizard it says "Detected current version (03482bb0), which needs to be upgraded to 9.0.0 (5e02f241)." Seems a bit fishy. Though I cannot understand why...

    Regards Fredrik

    Copy Link
  • Lindow 154 posts 1301 karma points
    Dec 12, 2022 @ 13:49
    Lindow
    0

    Hey again

    Try https://docs.umbraco.com/v/10.x-lts/umbraco-cms/fundamentals/setup/upgrading#run-an-unattended-upgrade

    Copy Link
  • Fredrik Stolpe 10 posts 103 karma points
    Dec 12, 2022 @ 14:08
    Fredrik Stolpe
    0

    When looking at UpgradePlan source file i see the guid I have seems to be added in version 9.3.1.

    https://github.com/umbraco/Umbraco-CMS/commit/3a269ed3293c8e22bd9a546f424402c0a491964f

    I will try to upgrade the project to 9.3.1 and see if that works better.

    Copy Link
  • Fredrik Stolpe 10 posts 103 karma points
    Dec 12, 2022 @ 14:19
    Fredrik Stolpe
    101

    It worked!

    So, anyone trying to upgrade from version 8.18.5 to 9 -> make sure to upgrade to at least 9.3.1 instead of 9.0.0. Maybe this should be mentioned in the official guides...

    Regards Fredrik

    Copy Link
  • Punit Sharma 27 posts 96 karma points
    Oct 06, 2023 @ 10:50
    Punit Sharma
    0

    Database configuration failed.

    Hello Any one can help me on this error.

    {"@t":"2023-10-05T11:11:01.4543898Z","@mt":"Database configuration failed","@l":"Error","@x":"System.InvalidCastException: Invalid cast from 'System.DateTime' to 'System.ValueTuple2[[System.Nullable1[[System.DateTime, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]], mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[System.Nullable`1[[System.DateTime, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]], mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]'.\r\n at System.Convert.DefaultToType(IConvertible value, Type targetType, IFormatProvider provider)\r\n at System.DateTime.System.IConvertible.ToType(Type type, IFormatProvider provider)\r\n at System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider)\r\n at NPoco.Database.Dictionary[TKey,TValue](String sql, Object[] args)\r\n at NPoco.Database.Dictionary[TKey,TValue](Sql Sql)\r\n at Umbraco.Core.Migrations.Upgrade.V800.TablesForScheduledPublishing.Migrate() in d:\a\1\s\src\Umbraco.Core\Migrations\Upgrade\V800\TablesForScheduledPublishing.cs:line 17\r\n at Umbraco.Core.Migrations.MigrationBase.Umbraco.Core.Migrations.IMigration.Migrate() in d:\a\1\s\src\Umbraco.Core\Migrations\MigrationBase.cs:line 73\r\n at Umbraco.Core.Migrations.MigrationPlan.Execute(IScope scope, String fromState, IMigrationBuilder migrationBuilder, ILogger logger) in d:\a\1\s\src\Umbraco.Core\Migrations\MigrationPlan.cs:line 309\r\n at Umbraco.Core.Migrations.Upgrade.Upgrader.Execute(IScopeProvider scopeProvider, IMigrationBuilder migrationBuilder, IKeyValueService keyValueService, ILogger logger) in d:\a\1\s\src\Umbraco.Core\Migrations\Upgrade\Upgrader.cs:line 67\r\n at Umbraco.Core.Migrations.Install.DatabaseBuilder.UpgradeSchemaAndData(MigrationPlan plan) in d:\a\1\s\src\Umbraco.Core\Migrations\Install\DatabaseBuilder.cs:line 498","SourceContext":"Umbraco.Core.Migrations.Install.DatabaseBuilder","ProcessId":19460,"ProcessName":"iisexpress","ThreadId":7,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"WEBDEV-2","Log4NetLevel":"ERROR","HttpRequestNumber":12,"HttpRequestId":"79dab6d4-49f9-4221-bb48-bdaba2f34bbf"}

    Copy Link
  • Christopher Pascual 27 posts 275 karma points
    Jun 11, 2024 @ 10:47
    Christopher Pascual
    0

    Sorry for necroing this thread, but this post is a top google search result

    In case someone needs the Umbraco.Core.Upgrader.State+Umbraco.Core key for v13+

    {985AF2BA-69D3-4DBA-95E0-AD3FA7459FA7}

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft