View Single Post
Old 09-20-2015, 10:59 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 Mrs_Often View Post
My super sexy husband fixed my database

Apparently Macs have a built in sqlite command line tool and husband was able to dump database to a text file and recreate it from there
If he did a check on the database and kept the list of errors, I'd be interested in seeing them. I have fixed databases in the past, but with very limited type of errors.
Quote:
He also found a couple of culprit books... No idea if I'm able to sign out now, but I don't really want to try

So now I can get to puzzling on why some book covers aren't showing. Any idea on whether I need to delete a book with Calibre before re-sending it to the device if I made any changes with Sigil? Edit: apparently not, same thing I tried before worked perfectly this time now the database doesn't have its knickers in a twist
It really depends on when the cover didn't show up. If it never did, then it probably means the driver couldn't identify the cover and set the property when the book was sent. If it disappeared after a while, I don't know. There is a discussion on this in the extended driver thread with no conclusion. I did have some problems with firmware 3.16.10 and 3.17.0 that meant the stored cover image file was empty. In these cases, the cover was not displayed after I restarted the device. Removing the files and restarting the device generated correct covers. I think I have seen disappearing covers with 3.17.3, but haven't had one since the discussion started.
Quote:
Also still interested to know about question 3, for future reference or for when I'd like to cheat my statistics...
I can't help with getting the reading stats back after a factory reset. Some will come back from the Kobo server if syncs happen, but not all. For marking the books as read, just select the books you have read in your calibre library and update the device using the mentioned Kobo Utilities plugin. Of course, that needs an indication in the library. I put all the read books in a reading list. And in the past, I had a Yes/No column that I set to yes when I read the book. Of course, nowadays I let the utilities plugin do all the hard work.

The "Store/Restore current bookmark" will store the current reading status of the books on the device in the calibre library. After a factory reset or logout/in, you can restore the status. The status includes the actual reading position, percent read, when you last read it and the rating (though this isn't in the latest firmware for sideloaded books). The store can be automated so that it happens each time the device is seen by calibre.

Another thing you can do is backup the database. Then, if it gets corrupted, you restore the last good copy and you don't lose as much history. The utilities plugin can automate this as well.
davidfor is offline   Reply With Quote