Quote:
Originally Posted by Josieb1
I've got the duplicated shelves problem back on my Kobo Aura H20 as a result 3.12. I mistakenly left the wifi on
I can't remember how to fix it, can anyone enlighten me, shelves are impossible now I've got 260 instead of three pages. 
|
The last time this happened to me, I did two things to fix it.
0. If you have a recent backup of the database, restore it; problem solved. If not, smack yourself gently on the face with a red snapper.
1. Use an SQLite utility to go to the database table (make a backup first!) that has all the shelves, mark everything "false" in the "_IsSynced" column, and mark everything "true" in the "_IsDeleted" and "_IsVisible" columns. (You can do that with one statement for each column, but the syntax eludes me at the moment.) Then go through and find the shelves you want to keep, marking them "false" in the "_IsDeleted" field. Make another backup, then disconnect the reader and see if the shelf list matches what you want. If it doesn't, try again until it does. Sync the reader to send the changes up to the cloud, and make sure nothing changed on the reader in the process. If you're good, delete the two backup databases and make a fresh backup of the "blessed by sync" version.
2. Make periodic backups, at least of the database. How periodic? Only you can answer that, but "after significantly changing the contents of the reader" is a good time. Note that with the Kobo, this means
after letting it scan newly-added books, so the database is up to date and won't have to start by adding several entries. Yes, you'll have to reconnect the device to the computer. Small price to pay.