Malformed database and saving Kobo stats

blar · 05-22-2021, 04:44 PM

A family member of mine has a Kobo Nia which I help her manage with Calibre. Recently, she plugged it in and received this error:

Code:

calibre, version 5.18.0
ERROR: Error: Error communicating with device

CorruptError: database disk image is malformed

Traceback (most recent call last):
  File "calibre\gui2\device.py", line 89, in run
  File "calibre\gui2\device.py", line 515, in _books
  File "calibre\devices\kobo\driver.py", line 1875, in books
  File "calibre\devices\kobo\driver.py", line 2967, in get_bookshelflist
apsw.CorruptError: CorruptError: database disk image is malformed

No idea what's been done since the last time I checked it or how this happened.

Upon searching, it seems like she has to log out and back in to set the device up again... but I would like some way to avoid her losing her reading time stats, saved dictionary words, annotations, and bookmarks. Everything is sideloaded, by the way. Is there a way I can fix this for her? I really hope so; she's become invested in stuff like hours read and likes her annotations.

The ereader itself seems just fine, other than the inability to remove collections from within the device interface (long press and delete does nothing).

davidfor · 05-23-2021, 12:44 AM

Probably not. Sometimes with a corrupt database, you can do a compress and that will fix it. For that to work, it usually means that an index was corrupt, or the freespace was not allocated properly. If you have my Kobo Utilities plugin installed, it has functions to check the database and compress it. But, I don't think this will be the case here.

It might work to open the database with SQLite directly and export the data from some of the tables. The error is reading the collections table. Maybe the others are OK. There might be tools out there to fix the database, but, I've never really looked.

If the books are sideloaded epubs, any annotations will be on the disk as well as in the database. That is under "Digital Editions/Annotations". These will be reread when the book is opened again.

Otherwise, unless there is a backup of the database, you will lose everything. Again, my Kobo Utilities plugin can backup the database, and store reading status to restore later. But, that needs to be done while the database is good. The plugin also has function to mark books as read.

05-22-2021, 04:44 PM	#1
blar Junior Member Posts: 9 Karma: 10 Join Date: May 2021 Device: Kobo Clara HD	Malformed database and saving Kobo stats A family member of mine has a Kobo Nia which I help her manage with Calibre. Recently, she plugged it in and received this error: Code: calibre, version 5.18.0 ERROR: Error: Error communicating with device CorruptError: database disk image is malformed Traceback (most recent call last): File "calibre\gui2\device.py", line 89, in run File "calibre\gui2\device.py", line 515, in _books File "calibre\devices\kobo\driver.py", line 1875, in books File "calibre\devices\kobo\driver.py", line 2967, in get_bookshelflist apsw.CorruptError: CorruptError: database disk image is malformed No idea what's been done since the last time I checked it or how this happened. Upon searching, it seems like she has to log out and back in to set the device up again... but I would like some way to avoid her losing her reading time stats, saved dictionary words, annotations, and bookmarks. Everything is sideloaded, by the way. Is there a way I can fix this for her? I really hope so; she's become invested in stuff like hours read and likes her annotations. The ereader itself seems just fine, other than the inability to remove collections from within the device interface (long press and delete does nothing).

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Error in Kobo Glo: database disk image is malformed	Carpidor	Devices	2	08-07-2015 07:17 AM
Calibre + Kobo Touch error message : database disk image is malformed	Bernard75	Devices	1	04-07-2012 03:46 PM
Kobo error: database disk image is malformed	RSaunders	Devices	7	07-28-2011 09:52 PM
Error communicating with device(Kobo Wireless)/database disk image is malformed	cotej1977	Devices	2	04-26-2011 09:34 PM
help: 'malformed database' with kobo	prairiegal	Devices	2	03-10-2011 09:50 PM

05-23-2021, 12:44 AM	#2
davidfor Grand Sorcerer Posts: 24,905 Karma: 47303824 Join Date: Jul 2011 Location: Sydney, Australia Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos	Probably not. Sometimes with a corrupt database, you can do a compress and that will fix it. For that to work, it usually means that an index was corrupt, or the freespace was not allocated properly. If you have my Kobo Utilities plugin installed, it has functions to check the database and compress it. But, I don't think this will be the case here. It might work to open the database with SQLite directly and export the data from some of the tables. The error is reading the collections table. Maybe the others are OK. There might be tools out there to fix the database, but, I've never really looked. If the books are sideloaded epubs, any annotations will be on the disk as well as in the database. That is under "Digital Editions/Annotations". These will be reread when the book is opened again. Otherwise, unless there is a backup of the database, you will lose everything. Again, my Kobo Utilities plugin can backup the database, and store reading status to restore later. But, that needs to be done while the database is good. The plugin also has function to mark books as read.

Advert