MobileRead Forums - View Single Post

Stinger · 06-20-2010, 05:39 PM

So I think I've figured out the reason behind the TOC on the Kobo displaying redundant and/or invalid entries even though the epub TOC is fine and doesn't show any trace of these entries on other viewers/editors/devices.

I'm pretty sure it's tied in to the fact that the Kobo doesn't clean up when you delete a regular epub file from the device (leaves behind those residual image files, and also leaves behind ghost entries in the SQLite dbase).

When you delete the epub file from the Kobo, it apparantly leaves behind the TOC it cached in the SQLite dbase. If you re-send that same file to the Kobo, when it reprocesses, it seems to just add to those old entries.

I wiped my SQLite database just now, and reloaded a bunch of my books. I noticed that the TOC in those files is displayed perfectly fine now, with no redundant or old/invalid entries. Before the SQLite wipe, I know for a fact that these exact same epubs were showing a garbage TOC of 100+ items (caused by me playing with formatting and deleting and resending the epub to the Kobo multiple times).

I know people have asked about this a few times here, so at least we know the cause now (and a dirty solution).

06-20-2010, 05:39 PM	#1
Stinger Asha'man Posts: 335 Karma: 844 Join Date: May 2010 Location: Canada Device: Kobo	Redundant/Invalid TOC entries So I think I've figured out the reason behind the TOC on the Kobo displaying redundant and/or invalid entries even though the epub TOC is fine and doesn't show any trace of these entries on other viewers/editors/devices. I'm pretty sure it's tied in to the fact that the Kobo doesn't clean up when you delete a regular epub file from the device (leaves behind those residual image files, and also leaves behind ghost entries in the SQLite dbase). When you delete the epub file from the Kobo, it apparantly leaves behind the TOC it cached in the SQLite dbase. If you re-send that same file to the Kobo, when it reprocesses, it seems to just add to those old entries. I wiped my SQLite database just now, and reloaded a bunch of my books. I noticed that the TOC in those files is displayed perfectly fine now, with no redundant or old/invalid entries. Before the SQLite wipe, I know for a fact that these exact same epubs were showing a garbage TOC of 100+ items (caused by me playing with formatting and deleting and resending the epub to the Kobo multiple times). I know people have asked about this a few times here, so at least we know the cause now (and a dirty solution).