|
I got an unwelcome New Year's Eve present: sudden shelf duplication. I'd had the problem before and thought I'd successfully gotten rid of it, but my Glo decided to sync as the ball dropped.
Luckily, I had a backup copy of the database from mid-November, so I didn't lose all my collection data. (Almost all of my books are sideloaded.) I did have to pull up my trusty SQLite editor and work some magic with it* to make all of the shelves go away, and then it was just a matter of restoring the old database and filling in the missing data. Since then, I'm making a point of doing manual backups about once a week.
* The shelf table is easy to find, and editing all the entries to give each shelf a unique name is common sense. The key, though, was setting the "needs to be synced" flag on every last shelf. That way, I could sync the device to change the names in the cloud, then delete the shelves and resync to remove the shelves from the cloud. That made all the shelves go away everywhere, except in the uncorrupted backup database...which I also made sure had all shelves set to be synced. Presto, semi-instant restoration!
|