PRS-T1 How to refresh books.db?

bremler · 04-29-2015, 12:16 PM

Is there a way to refresh the books.db everytime I add a new cover to a book, so that it updates the thumbnail?

I've been doing it the hard way: deleting the books.db and waiting ages for everything to rebuild. This also deletes all my collections.

I have SQlitespy if that helps, just a command, or something that would refresh the database without having to delete it, to reflect new book covers. Thanks in advance.

MickiTee · 05-01-2015, 04:39 PM

You're looking in the wrong place to do this. I think this can be done directly on the reader without touching the books.db database.

In Explorer locate the 'database' folder on the T1 and then open the 'cache' folder, followed by the 'books' folder. In there you will see a folder for each book on the reader. The folder name equates to the '_id' field in the books table in the db. The numbered folders contain yet another folder called 'thumbnail' which in turn has a copy of the cover jpg/png in it.

I haven't tried this, but I can see no reason why you can't either delete the existing graphic thereby forcing the reader to add it again or copy your new cover file into the relevant book's folder.

You should take a backup of everything on your reader before you try this, so that you can restore things if my suggestion doesn't work.

And the same procedure will apply to a microSD card if you've got one installed.

Hope this helps.

bremler · 05-02-2015, 01:38 AM

Thanks for the tip. I tried it...deleted the main_thumbnail.jpg from the cache folder, restarted the T1.....except it didn't generate a new thumbnail image from the new cover of the epub - on the screen it shows a generic picture of a book in place of the thumbnail.

I worked around by creating my own thumbnail and putting it in the thumbnail folder, renaming it to main_thumbnail.jpg.

It seems that the T1 won't automatically generate a new thumbnail for an edited cover unless you delete the books.db file, forcing it to rebuild everything and losing your collections in the process.

So I conclude I've got to do it manually which is just one extra step.

Ghitulescu · 05-04-2015, 04:00 AM

No need to delete the .DB file.
Just delete the book (using the Sony) and add it again.

bla · 06-09-2015, 02:59 PM

Powering off/on or using a soft reset should refresh the DB

04-29-2015, 12:16 PM	#1
bremler Enthusiast Posts: 41 Karma: 10 Join Date: Mar 2008 Device: Sony PRS-T1	How to refresh books.db? Is there a way to refresh the books.db everytime I add a new cover to a book, so that it updates the thumbnail? I've been doing it the hard way: deleting the books.db and waiting ages for everything to rebuild. This also deletes all my collections. I have SQlitespy if that helps, just a command, or something that would refresh the database without having to delete it, to reflect new book covers. Thanks in advance.

05-02-2015, 01:38 AM	#3
bremler Enthusiast Posts: 41 Karma: 10 Join Date: Mar 2008 Device: Sony PRS-T1	Thanks for the tip. I tried it...deleted the main_thumbnail.jpg from the cache folder, restarted the T1.....except it didn't generate a new thumbnail image from the new cover of the epub - on the screen it shows a generic picture of a book in place of the thumbnail. I worked around by creating my own thumbnail and putting it in the thumbnail folder, renaming it to main_thumbnail.jpg. It seems that the T1 won't automatically generate a new thumbnail for an edited cover unless you delete the books.db file, forcing it to rebuild everything and losing your collections in the process. So I conclude I've got to do it manually which is just one extra step. Last edited by bremler; 05-02-2015 at 01:44 AM.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
no refresh on M92	laurevieu	Onyx Boox	4	06-05-2012 05:46 AM
Does clicking 'refresh' sell more books?	John Carroll	Writers' Corner	5	12-10-2010 08:23 PM
What Does Everyone think of the K3 refresh	Scarpad	Amazon Kindle	6	08-29-2010 10:00 PM
After refresh	maxhyl	iRex	1	11-23-2008 03:50 AM
Best refresh on eInk	Hatgirl	Which one should I buy?	22	10-14-2008 12:11 AM

05-01-2015, 04:39 PM	#2
MickiTee Guru Posts: 860 Karma: 4097942 Join Date: Jun 2012 Location: London, UK Device: Sony PRS-505, Pocketbook TL3, TL4, TL5	You're looking in the wrong place to do this. I think this can be done directly on the reader without touching the books.db database. In Explorer locate the 'database' folder on the T1 and then open the 'cache' folder, followed by the 'books' folder. In there you will see a folder for each book on the reader. The folder name equates to the '_id' field in the books table in the db. The numbered folders contain yet another folder called 'thumbnail' which in turn has a copy of the cover jpg/png in it. I haven't tried this, but I can see no reason why you can't either delete the existing graphic thereby forcing the reader to add it again or copy your new cover file into the relevant book's folder. You should take a backup of everything on your reader before you try this, so that you can restore things if my suggestion doesn't work. And the same procedure will apply to a microSD card if you've got one installed. Hope this helps.

05-04-2015, 04:00 AM	#4
Ghitulescu Fanatic Posts: 563 Karma: 403106 Join Date: Aug 2014 Device: PRS-T1	No need to delete the .DB file. Just delete the book (using the Sony) and add it again.

06-09-2015, 02:59 PM	#5
bla E bookworm Posts: 358 Karma: 2013666 Join Date: Jul 2010 Location: Ontario, Canada Device: Sony PRS T1,Android Tablet, I phone	Powering off/on or using a soft reset should refresh the DB

Advert

Advert