Copied to clipboard

Flag this post as spam?

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


  • Trev 2 posts 94 karma points
    Nov 11, 2023 @ 10:08
    Trev
    0

    Upgrade from 10.7.0 to 11.0.0 unable to happen

    Hi,

    I've just upgraded the nuget packages for my U10.7 to U11.0, fixed up some compilation issues, and gone to run the site.

    I'm presented with (as expected) the upgrade screen, stating:

    Detected current version (ef93f398), which needs to be upgraded to 11.0.0 (3f5d492a)

    If I 'View report' I'm taken to https://our.umbraco.com/download/releases/compare?from=11.0.0&to=11.0.0&notes=1 with from & to being the same value?

    If I proceed anyway (as I know there is a DB update needed) then it errors with

    The migration plan does not support migrating from state "{EF93F398-1385-4F07-808A-D3C518984442}"

    Checking my logs, the only thing that looks to be of interest is

    The following constraints (Primary Keys, Foreign Keys and Indexes) were found in the database, but are not in the current schema: PKumbracoContentVersionCleanupPolicy. The following indexes were found in the database, but are not in the current schema: IXumbracoExternalLogin_userOrMemberKey

    In umbracoKeyValue, the row for the version is at

    > Umbraco.Core.Upgrader.State+Umbraco.Core|{EF93F398-1385-4F07-808A-D3C518984442}|2023-11-10 17:27:44.383

    Where I updated to 10.7.0 last night with no issue

  • Owain Jones 57 posts 387 karma points MVP 4x c-trib
    Nov 11, 2023 @ 19:41
    Owain Jones
    0

    Hi Trev,

    How odd, looking at the migration plan in the Umbraco source, I can see that ef93f398 is 10.7.0, but 3f5d492a seems to be 10.4.0 🤔

    Here's the source code: https://github.com/umbraco/Umbraco-CMS/blob/e5c8627abf7984f6939d17105f581304dcdf4553/src/Umbraco.Infrastructure/Migrations/Upgrade/UmbracoPlan.cs#L67

    I'm not sure why it would be trying to downgrade to 10.4.0, especially when it is claiming that it is trying to upgrade to 11.0.0 (but the GUID displayed doesn't match that, v11.0.0's upgrade GUID starts with FFB6B9B0).

    Also, the primary key umbracoContentVersionCleanupPolicy was added in 10.5.0 (you can see it listed here under bugfixes: https://our.umbraco.com/download/releases/1050), so that error makes sense in the context of it trying to downgrade to 10.4.0, as that was not present in the 10.4.0 schema.

    So it seems like something has gone wrong with your 11.0.0 NuGet install, you might have a reference to 10.4.0 somewhere.

    Therefore, I would suggest:

    1. Rolling back your v11 upgrade in your source code.
    2. Re-installing the v11 NuGet packages. (Make sure to update any 3rd party packages too).
    3. Point to a blank database and run.
    4. If it installs and gives you a fresh v11 site, then point it at your actual database and try the upgrade again. (be sure to backup your database before attempting the upgrade).
  • Trev 2 posts 94 karma points
    Nov 12, 2023 @ 08:24
    Trev
    102

    Thanks Owain,

    A fresh install worked fine, so decied to see what would happen if I just tricked the db into thinking it was back on 10.3, and make it run everything in again, by running:

    update  [dbo].[umbracoKeyValue] set [value]='{56833770-3B7E-4FD5-A3B6-3416A26A7A3F}'
      where value = '{EF93F398-1385-4F07-808A-D3C518984442}';
    

    And that seems to have allowed me to progress

  • Daniel 18 posts 108 karma points
    23 days ago
    Daniel
    0

    Hi Trev & Owain

    I think I have a similar problem, I reported here: https://our.umbraco.com/forum/using-umbraco-and-getting-started/113921-issue-upgrading-the-database-when-upgrading-umbraco-from-12-to-13

    However this is from version 12.1.1 to 13.2.2 I don't get anything from the logs, but when i click "view report" it shows an upgrade from 13.0.0 to 13.2.2 which is wrong.

    However I have an issue in finding the GUID for my version [12.1.1][1] https://github.com/umbraco/Umbraco-CMS/blob/release-12.1.2/src/Umbraco.Infrastructure/Migrations/Upgrade/UmbracoPlan.cs

    Looking at the properties of the dll it suggest that it starts with "0230b25", but I'm not sure.

    Where should I look for the GUID for 12.1.1?

  • Owain Jones 57 posts 387 karma points MVP 4x c-trib
    22 days ago
    Owain Jones
    0

    Hi Daniel I just replied to the other thread with info on how to enable debug logging, I've looked through the upgrade plans of v8 to v14 but I couldn't find that GUID anywhere there... so I have no idea what that could be from.

    Hopefully something useful shows up in the debug log 🤞

Please Sign in or register to post replies

Write your reply to:

Draft