MobileRead Forums - View Single Post

PeterT · 03-20-2025, 12:51 AM

I'm officially going crazy. I decided to move from reading a LIBRARY book fufilled by the Kobo store to trying a side-loaded ePub. Simpler right?

Well I open the book, head to a random page (Chapter 10, and a few page turns). Return to the Kobo home screen and as expected, the book is now the first book on the home display. Reopening the book returns to the correct page.

Now I connect the USB cable, eject the device from Chrome, (note calibre was NOT connected). The Kobo does NOT go through its importing content stage and as expected, my book is still the first book on the home screen, and opening it heads to the correct page.

Now reconnect the USB cable and connect to folder as a Libra Colour. No books added / deleted. Ehect from calibre; disconnect from chromebook. This time the Kobo goes through it's importing content screen and my book is no longer the first book on the home screen. Now it just struck that metadata management is set to automatic; so let me disable that and try one more time.

Additionally I've tried making copies of the KoboReader sqlite database at various points and done a sqldiff on the various copies; no differences found

-----

OK. Opened "Promises Greater than Darkness" as an ePub. Moved to Chapter 3 - Page 6 of 7" and set a bookmark.

Stayed in book and connected to ChromeBook, copied the database as "01-Promises.sqlite".

Connected calibre and then copied the /tmp database to "02-temp.sqlite".

01 and 02 are identical.

Eject device from calibre and took another copy of the database from the Kobo "03-after-eject.sqlite".

All db's are still identical.

Ejected device from chromebook and removed USB cable.

Get an IMPORTING CONTENT message; Promises is no longer listed on the home screen. In the My eBooks screen, the book shows as UNREAD and opens to the start. BUT the bookmark is still present.

------

Unfortunately my detailed knowledge of the database schema is minor; this is where the knowledge of @davidfor would be invaluable.

I do know that the Kobo Utilities can retrieve reading location; this is done from the CONTENT table. (This testing on Promises was done WITHOUT Utilities installed).

03-20-2025, 12:51 AM	#290
PeterT Grand Sorcerer Posts: 13,564 Karma: 79436716 Join Date: Nov 2007 Location: Toronto Device: Libra H2O, Libra Colour	I'm officially going crazy. I decided to move from reading a LIBRARY book fufilled by the Kobo store to trying a side-loaded ePub. Simpler right? Well I open the book, head to a random page (Chapter 10, and a few page turns). Return to the Kobo home screen and as expected, the book is now the first book on the home display. Reopening the book returns to the correct page. Now I connect the USB cable, eject the device from Chrome, (note calibre was NOT connected). The Kobo does NOT go through its importing content stage and as expected, my book is still the first book on the home screen, and opening it heads to the correct page. Now reconnect the USB cable and connect to folder as a Libra Colour. No books added / deleted. Ehect from calibre; disconnect from chromebook. This time the Kobo goes through it's importing content screen and my book is no longer the first book on the home screen. Now it just struck that metadata management is set to automatic; so let me disable that and try one more time. Additionally I've tried making copies of the KoboReader sqlite database at various points and done a sqldiff on the various copies; no differences found ----- OK. Opened "Promises Greater than Darkness" as an ePub. Moved to Chapter 3 - Page 6 of 7" and set a bookmark. Stayed in book and connected to ChromeBook, copied the database as "01-Promises.sqlite". Connected calibre and then copied the /tmp database to "02-temp.sqlite". 01 and 02 are identical. Eject device from calibre and took another copy of the database from the Kobo "03-after-eject.sqlite". All db's are still identical. Ejected device from chromebook and removed USB cable. Get an IMPORTING CONTENT message; Promises is no longer listed on the home screen. In the My eBooks screen, the book shows as UNREAD and opens to the start. BUT the bookmark is still present. ------ Unfortunately my detailed knowledge of the database schema is minor; this is where the knowledge of @davidfor would be invaluable. I do know that the Kobo Utilities can retrieve reading location; this is done from the CONTENT table. (This testing on Promises was done WITHOUT Utilities installed).