Thread: Calibre 2.7 Unable to open Database file
View Single Post
Old 10-31-2016, 09:49 PM   #7
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 Gordo29 View Post
Thanks for the replies. OK, seems as if the drive letter problem must be coincidental and unrelated to the "unable to open database" error. So, what to do to rectify the database error. Is it the database on the Kobo or on the PC? I tried connecting to my W8 (dual boot system) and had the same problem so my guess is on the device? I have Calibre on my laptop so I'll try that too and see if I have the same problem.
The database being referred to in the error is on the device. The file it is in is "KoboReader.sqlite" in the directory ".kobo". As it fails under the two OSes on the same machine, either the database is corrupt, or there is something wrong with the USB port being used. If you get the same on the laptop, then it is the database.

You can check the database using the Kobo Utilities plugin or an SQLite database management tool. I suspect the plugin won't work as it uses the KoboTouch driver to open the database. You will probably see an error in the same line.

If it is the database, the device can keep working for a while. It is using in-memory structure read from the database. But, it will have problems saving any changes. If you restart the device, it will read the old and corrupt version of the database and you lose any changes that should have been made. The solution is to restore a recent backup if you have one, or sign out of the Kobo account on the device. This will generate a new database and reload any sideloaded books. Unfortunately, you will lose the reading status of any sideloaded books.
davidfor is offline   Reply With Quote