View Single Post
Old 12-01-2024, 10:50 AM   #9
Georgie W
Connoisseur
Georgie W began at the beginning.
 
Georgie W's Avatar
 
Posts: 96
Karma: 10
Join Date: Jan 2014
Location: Scotland
Device: KT4 5.13.6
Quote:
Originally Posted by BetterRed View Post
Install this program ==>> DB Browser for SQLite

Start it and Open the library metadata.db file in the library folder, go into the Browse data tab, load the books table, and have a look at the has_cover column.
Ooh, that was interesting. But sadly, every single book has a 1 in the cover column, viz:-Click image for larger version

Name:	Capture.JPG
Views:	245
Size:	37.6 KB
ID:	212302 for the two Ackroyds. Only a handful of books have 0s and they are all ones where I knew already there was no cover.

I think I'll have to go back and bulk download the covers again, and checking each one bfore I OK it. Bother—because your thoughtful suggestion was definitely worth checking out. Thank you.

Looking at the dates of the affected books, something seems to have happened on 19th Nov to break the connection between Calibre & the stored jpgs. I really can't think what, as I have the soul of a grey, wizened accountant, and am meticulous in my databases. Perhaps it's a sign of the beginning of the end of days, in which case I'll drink the decent gin I've been saving...
Georgie W is offline   Reply With Quote