Quote:
Originally Posted by davidfor
If you want to clean-up the shelves by directly editing the database, you can. But, as it is a dangerous thing to do, I will simply state the changes needed. If you understand them and want to risk it, go ahead. If you don't understand them, I recommend not attempting to do it.
The database on the device is an SQLite database. It is in ".kobo\KoboReader.sqlite". The shelves are stored in the "Shelf" table in the database. The columns to look at are "Name" and "_IsDeleted" and possibly one of the timestamps. Just deleting these rows is not enough. The next sync to Kobo will probably bring them back.
If you change "_IsDeleted" to "true" for all rows in the table, the shelves will be deleted from the device and the server at the next sync.
You can selectively change "_IsDeleted" to "true" for just the extra shelves. When I did this, I changed it for all duplicated shelves the except the one with oldest "CreationDate".
|
After backing-up of course, I went all out this morning, and deleted the full lines for all duplicated / triplicated active shelves (keeping the most recent), and all the obsolete shelves which were not even visible on the kobos. It worked fine, but I decided a while back not to sync with kobo when not absolutely necessary. When I had to, after I last had to do a factory reset, I started with eliminating from kobo desktop the very few books I'd bought from kobo (from the computer, to the computer, anyway), and I didn't notice kobocreated shelves in the database.