Almost Everyday there are new versions

You can actually rollback the version embedded in your current data file by using the command line, if you’re game.

First you need to find the current embedded schema version of your data file. This post Database versioning - #3 by d3mad explains how to find the schema version.

The output displays as a 6 hex number. For example, a data file last opened with 21.5.34 will show a schema of x’08A102’. The middle byte is A1, which is the schema version 0xA1 = 161, so 21.5.33 would be x’08A002’ (0xA0 = 160) and 21.5.32 would be x’089F02’ (0x9F = 159).

To rollback the schema version of your file, run the following command in a terminal (you must have sqlite3 installed and your data file should be backed-up):

sqlite3 “$file” “UPDATE Objects SET Content = x’089f02’ Where Key = ‘a9a71e47-82b3-49db-8aec-898adb460a80’”

Where $file is the name/location of the data file and the ‘Content’ being SET is the schema version you want to rollback to.

Remember, back up your data file first.

1 Like