1.6 all! usb devices shows corrupt database with p4 and engine prime! :(

Likely your databases were a bit funky before the 1.6 update - 1.5 ignored some db errors and allowed you to continue using it.

Grab all the .db files and a copy of the sqlite binary then run the following command against the .db files to find the corrupt one(s):

sqlite3 dbname.db “PRAGMA integrity_check”

This checks the sqlite database for errors and spits any out on screen - make note of the files that spit out errors and run the following against them:

sqlite3 dbname.db “.dump” | sqlite3 dbname.new.db

After that, make sure to backup the “corrupt” ones somewhere just in case then rename the *.new.db files to just *.db and transfer back to your library/media.

Engine Prime - Fixing Corrupt Databases.pdf (690.9 KB)

9 Likes