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??
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.
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.
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??
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.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.
is working on a reply...