Thread: Aura HD Changes in Kobo Desktop 3.17
View Single Post
Old 08-29-2015, 10:00 PM   #15
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 DNSB View Post
I've had databases that according to the my utilities collection (SQLite Expert Personal, DB Browser for SQLite, SQLite Studio, etc. ... what can I say? I can't resist utilities) had no issues but my Kobo ereader disagreed. Looking at the contents of the database, in several cases there were issues with the contents of several tables, as you said, inconsistent data.
Yes, corrupt/inconsistent data versus corrupt database. In this case, I am pretty sure it is the database. Losing data when powering off and on is pretty good indicator.
Quote:
I've tried several utilities to re-index, clean up and/or "repair" databases but none that gave me results that I was happy with. For the most part, I found that it was simply easier to revert back to the factory database, restore a database backup and then resync/reprocess my ebooks.
I agree. It's rarely worth the trouble of trying to fix if there is a recent backup.
Quote:
Using davidfor's Kobo Utilities with Calibre to backup the database on connect is my current preference to minimize the amount of ebooks that need to be reprocessed.
I know that MacEachaidh is not a calibre user, so that won't help. With this sort of problem, if I want to experiment, I take a full copy of the user partition first. Then, if it doesn't work, or I want to get back to the previous state, I simply copy this back. It takes some time, but it works.
davidfor is offline   Reply With Quote