Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Readers > Kobo Reader

Notices

Reply
 
Thread Tools Search this Thread
Old 07-12-2013, 11:58 PM   #1
GeoffR
Wizard
GeoffR ought to be getting tired of karma fortunes by now.GeoffR ought to be getting tired of karma fortunes by now.GeoffR ought to be getting tired of karma fortunes by now.GeoffR ought to be getting tired of karma fortunes by now.GeoffR ought to be getting tired of karma fortunes by now.GeoffR ought to be getting tired of karma fortunes by now.GeoffR ought to be getting tired of karma fortunes by now.GeoffR ought to be getting tired of karma fortunes by now.GeoffR ought to be getting tired of karma fortunes by now.GeoffR ought to be getting tired of karma fortunes by now.GeoffR ought to be getting tired of karma fortunes by now.
 
GeoffR's Avatar
 
Posts: 1,666
Karma: 3275002
Join Date: Nov 2012
Location: New Zealand
Device: Kobo Glo
File size info on book details page

I have had the occasional problem with kepub books downloaded from Kobo displaying the wrong file size in the library listing and/or on the book's details page. I haven't seen anyone else posting about this problem, but I thought I'd describe what I have learned in case it will be useful.

The file size is displayed in two places: in the book's library listing (alongside the reading status and file type), and on the book's details page (accessed by a long press on the library listing, or the menu to the right of the book's listing). It is also used to calculate how much space will be saved when archiving books.

The file size is stored in the book's ___FileSize field of the content table in the database. There seem to be two options:

If ___FileSize=0 then the the file size is not displayed at all on the details page, but the correct size is still displayed in the library listing. I think in this case it must be read directly from the filesystem, unless it is stored somewhere else in the database I don't know about.

If ___FileSize>0 then that value (in bytes) is displayed in both the library listing and on the details page, even if it is incorrect. It is also used to calculate how much space is saved by archiving the book, even if incorrect.

So the ideal situation would be to always sfore the correct size in ___FileSize. The second best alternative would be to store zero in ___FileSize. Having the wrong nonzero value in ___FileSize is always a bad thing.

However I have found that while all the file sizes for sideloaded books are correct, some of the books I download directly from Kobo have the incorrect file size set. I thought at first this was a firmware bug because it seemed to start hapenning after upgrading to firmware 2.4.0, but it doesn't happen for every book, so it could be that the file size is loaded from an incorrect value stored on the Kobo server. It also seems to happen only when I buy a book that is already "known" to my device, either by way of a recommendation, or because the books is on my wishlist, so it could be that the size of the recommendation is being displayed instead of the size of the whole book. However it doesn't always happen even in those cases.

I've also noticed that while all sideloaded books have the correct value set in ___FileSize, (and so display the correct file size in both locations) many books downloaded from Kobo set ___FileSIze to zero, and so do not display the file size at all on the book's details page.

What I have been doing to fix the problem is manually setting ___FileSize to the correct value, with a command (this is for the book "The Sky Road" by Ken Macleod, Tor edition) like:
Code:
UPDATE content SET ___FileSize=472414 WHERE BookID IS NULL AND IsDownloaded='true' AND Title='The Sky Road';
I'd be interested to hear if anyone else has come across this problem. An easy way to check could be to sort your library in file size order and look at the books with the smallest filesize (when the size is incorrect is always seems to be far too small rather than too large). Look for any book that seems suspiciously small (if the file size says 1KB or 2KB then it is probably wrong).

Last edited by GeoffR; 07-13-2013 at 12:43 AM. Reason: spelling
GeoffR is offline   Reply With Quote
Old 07-14-2013, 08:26 PM   #2
moffattm
Addict
moffattm ought to be getting tired of karma fortunes by now.moffattm ought to be getting tired of karma fortunes by now.moffattm ought to be getting tired of karma fortunes by now.moffattm ought to be getting tired of karma fortunes by now.moffattm ought to be getting tired of karma fortunes by now.moffattm ought to be getting tired of karma fortunes by now.moffattm ought to be getting tired of karma fortunes by now.moffattm ought to be getting tired of karma fortunes by now.moffattm ought to be getting tired of karma fortunes by now.moffattm ought to be getting tired of karma fortunes by now.moffattm ought to be getting tired of karma fortunes by now.
 
moffattm's Avatar
 
Posts: 333
Karma: 1440670
Join Date: Jul 2010
Location: Auckland, New Zealand
Device: Kobo Original, Kobo Glo
I think I've seen this problem when I've downloaded previews of books from Kobo and then gone ahead and bought the book. It's like the e-reader doesn't remove the preview record from the database but just updates it and the old file size of the preview is kept.
moffattm is offline   Reply With Quote
Old 02-28-2014, 03:00 AM   #3
GeoffR
Wizard
GeoffR ought to be getting tired of karma fortunes by now.GeoffR ought to be getting tired of karma fortunes by now.GeoffR ought to be getting tired of karma fortunes by now.GeoffR ought to be getting tired of karma fortunes by now.GeoffR ought to be getting tired of karma fortunes by now.GeoffR ought to be getting tired of karma fortunes by now.GeoffR ought to be getting tired of karma fortunes by now.GeoffR ought to be getting tired of karma fortunes by now.GeoffR ought to be getting tired of karma fortunes by now.GeoffR ought to be getting tired of karma fortunes by now.GeoffR ought to be getting tired of karma fortunes by now.
 
GeoffR's Avatar
 
Posts: 1,666
Karma: 3275002
Join Date: Nov 2012
Location: New Zealand
Device: Kobo Glo
Just updating to note that the problem seems to be fixed in the current firmware (assuming it was a firmware issue). The last time I had a book with the wrong file size was with firmware 2.8.1.
GeoffR is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Populating 'details' info for Kindle index? veezh Recipes 14 10-12-2012 08:40 AM
Changing font size in Book Details Comments BookJunkieLI Library Management 5 02-13-2012 10:42 AM
Info(prcgen): No page map found in the book Xabache Kindle Formats 2 07-08-2011 10:25 PM
Book (file) size irenas Astak EZReader 15 04-15-2010 04:21 PM
Book Details - Size of Font adrian1944 Calibre 1 02-18-2010 07:12 PM


All times are GMT -4. The time now is 07:53 AM.


MobileRead.com is a privately owned, operated and funded community.