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


  • Tom C 87 posts 222 karma points
    Feb 04, 2020 @ 19:37
    Tom C
    0

    Umbraco 7.15.3 to 8.5 upgrade problem; missing or duplicate 'current' content versions.

    Using Umbraco And Getting Started
    Umbraco 8

    I've been working through trying to do the upgrade; sorted about 5 problems so far with the help of forum messages and github, but now got to one im stuck on.

    The database failed to upgrade. ERROR: The database configuration failed with the following message: Migration failed: missing or duplicate 'current' content versions.

    the only page i can find searching for this error is; https://github.com/umbraco/Umbraco-CMS/issues/5831 However the two queries suggested to check on there return 0 results for me. Is there anything else I could check?

    Thanks for any help!

    Copy Link
  • Steve Megson 151 posts 1022 karma points MVP c-trib
    Feb 05, 2020 @ 10:34
    Steve Megson
    100

    The two queries in that issue cover the causes of duplicate current versions, but not missing current versions.

    This will list all versions for any nodes which have no 'newest' version:

    select * from cmsdocument
where nodeid not in (select nodeid from cmsdocument where newest=1)

    Hopefully it will be obvious which versionId should be marked as newest for each nodeId, and you can manually update the newest column.

    Copy Link
  • Tom C 87 posts 222 karma points
    Feb 06, 2020 @ 18:12
    Tom C
    0

    Thanks Steve!

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft