Copied to clipboard

Flag this post as spam?

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


  • cheryl carpenter 13 posts 91 karma points
    Aug 08, 2019 @ 15:41
    cheryl carpenter
    0

    Need to downgrade 8.1.1 to 8.0.2 database error

    I upgraded to 8.1.1, let it update my database, now i need to revert to 8.0.2 because it is bad. I got my VS projects running and happy, but when it connects it wants to upgrade my database, and gets the following error.

    The database failed to upgrade. ERROR: The database configuration failed with the following message: Unknown state "{5B1E0D93-F5A3-449B-84BA-65366B84E2D4}". Please check log file for additional information (can be found in '/App_Data/Logs/UmbracoTraceLog.txt')

    Which is nifty because the new trace logs are not helpful.

    Can anyone tell me how to get my database downgraded to 8.0.2??

  • Steve Megson 151 posts 1024 karma points MVP c-trib
    Aug 08, 2019 @ 18:36
    Steve Megson
    100

    I don't think that 8.1.1 would have changed anything in the database that would cause a problem for 8.0.2. So in theory you just need to lie to 8.0.2 about the last upgrade that was done to the database, so that it no longer thinks it needs to "upgrade" your database to 8.0.2.

    In the umbracoKeyValue table, you'll see the offending value {5B1E0D93-F5A3-449B-84BA-65366B84E2D4} in the value column. A database from 8.0.2 would have the value {80C0A0CB-0DD5-4573-B000-C4B7C313C70D} here.

  • cheryl carpenter 13 posts 91 karma points
    Aug 08, 2019 @ 19:14
    cheryl carpenter
    0

    Thank you so much. It is hard to find this info as a lay person. I'm not supposed to even have database access so things that seem obvious to .NET people are not obvious to us. I happen to have SQL MGT Studio with dev connection, and googled 'how to edit a value in a table". :) Thanks again.

Please Sign in or register to post replies

Write your reply to:

Draft