Thread: Guide to Collections Management with calibre (Touch / Glo / Mini /Aura)
View Single Post
Old 10-11-2017, 10:55 PM   #511
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 24,905
Karma: 47303824
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
Quote:
Originally Posted by vjjustin View Post
A quick question; is there any way to delete all the collections ONLY in Kobo? I know we can delete collections individually from kobo by long pressing each collection, but is there anyway to do it for all at once either through device or through calibre?

I have automatic collection management enabled in calibre but was trying some automatic folder management while sending books to kobo. So, now I have many collections with wrong book count. This is not getting fixed during regular calibre connect.

The only way I know to fix this is to delete all the collections in kobo and next time when I connect calibre/metadata will create all collections for me with correct book count, this has worked in the past. But I have around 100 collections and it will take a lot of time.
The count shown in the collections list is done when the collections list is built. If you are seeing anything other than the correct number of books, it means that some data in the database are inconsistent and that means something bad happened. My first thought, as compurandom suggested, is a corrupt database. You can check that with any SQLite database management tool, or my Kobo Utilities plugin in calibre. If it is corrupt, you will need to restore a backup or sign out of the Kobo account on the device and let it create a new database.

If the database isn't corrupt, but the data is inconsistent, you will probably need to use some SQL to fix things. The driver in calibre will maintain the collections, but it only makes changes for books that are in the calibre library and matched to books on the device. If the count for a collection is wrong, that means there is an entry in the database that points to a book not actually on the device. The collection management code in the driver won't do anything in this situation.

The simplest solution is to sign out of the Kobo account and back in. This will rebuild the database, download any synced books and collections, and import the sideloaded books. The next time you connect to calibre it will rebuild the collections.

The next way is using SQL as mentioned above. I'll help if you need it, but if your response to my suggestion is "Use what?", then don't try it.

Having said all that, have you restarted the device? That might fix it as it means the database is reread.
davidfor is offline