View Single Post
Old 12-01-2024, 12:08 AM   #8
BetterRed
null operator (he/him)
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 21,742
Karma: 30237526
Join Date: Mar 2012
Location: Sydney Australia
Device: none
Quote:
Originally Posted by Georgie W View Post
Yes, that worked—thank you. And yes, a bulk refresh would be needed (just not practicable to do this one at a time).

Any theories about what might have caused the original disconnect, and how to stop it happening again?
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, viz:

Click image for larger version

Name:	Screenshot 2024-12-01 155052.jpg
Views:	239
Size:	610.1 KB
ID:	212296

Do the '1's and '0's match the presence/absence of the cover display?

If they do then we're on the way to a solution.

Exit DB Browser.
Copy the library metadata.db file somewhere safe.
Now open the metadata.db file with DB Browser
Change the has_cover cell (F2 will open a cell for Edit) for one of the recalcitrant books.
Execute File->Write changes option
Close DB Browser
Start calibre

Can you see the cover?

If you can then… hopefully you can work out the rest.

I have no idea why it happened, or how to stop it happening again… I'll leave the speculating to others.

BR
BetterRed is online now   Reply With Quote