Incomplete Library Listing

SteveK · 07-06-2013, 10:34 AM

I have what may be a major Calibre problem. Last night, I downloaded SugarSynch and "merged" it with Calibre. Now, when I go into Calibre and sort by date order, the latest date it shows is 11 Oct 2011. No books added after this date are shown, and obviously I have added many titles since October 2011. When I go into the directory where my Calibre books are stored, recently added titles are shown. The SugarSynch program indicated that no files would be deleted from the computer, and the files do appear to be present, but for some reason are not listed in Calibre.

I deleted SugarSynch since it seems to be what caused the problem, but I don't know how to fix Calibre so that it shows my complete library. Is there a way I can "repair" the database, such as by re-importing the directory into Calibre?

Perhaps this problem isn't due to my experiment with SugarSynch, but that certainly appears to be the cause since everything was fine until I installed SugarSynch.

Thanks in advance for any information you may provide.

SteveK

Adoby · 07-06-2013, 11:00 AM

Start by making a backup of the calibre library, that way you can keep trying different things.

The easiest could be to do as you suggest, create a new empty calibre library and add the books from the old, assuming they are there and there are opf-files with metadata in the folders.

Move or rename the calibre library. Then start calibre. A new empty library will be created.

Add the books in the old calibre library. Choose the second method, add books in subdirectories, assume that multiple books in the same folder is the same book in different formats.

After a while you have hopefully a new working and up to date calibre library.

When you experiment with networked and mirrored folders it is a good idea to make sure you have a backup, if something goes wrong. It is NOT recommended to use networked folders for the calibre library, bad things can happen. Test carefully, and make sure not to update or mirror the calibre library while you have calibre running.

chaley · 07-06-2013, 12:28 PM

You could also try a "Restore Database" (library -> library maintenance -> restore database). Make a backup first.

SteveK · 07-06-2013, 04:50 PM

Chaley - Restoring the database seems to have done the trick! After making a backup, I restored the database, and it now appears to contain all titles, including recently added titles. Thanks!

Adoby - I can obviously vouch for the wisdom of your warning - I won't do that again! Since my library exceeded the free limits of SugarSync, it appears that any file not merged with SugarSync was somehow deleted from the Calibre database, even though the files themselves were still there. Fortunately, the restore database function appears to have worked its magic.

Thanks for the help!
SteveK

07-06-2013, 10:34 AM	#1
SteveK Addict Posts: 272 Karma: 1017902 Join Date: Nov 2008 Device: Kindle PW, PW2, Kindle3, Kobo Glo, tablets, phone	Incomplete Library Listing I have what may be a major Calibre problem. Last night, I downloaded SugarSynch and "merged" it with Calibre. Now, when I go into Calibre and sort by date order, the latest date it shows is 11 Oct 2011. No books added after this date are shown, and obviously I have added many titles since October 2011. When I go into the directory where my Calibre books are stored, recently added titles are shown. The SugarSynch program indicated that no files would be deleted from the computer, and the files do appear to be present, but for some reason are not listed in Calibre. I deleted SugarSynch since it seems to be what caused the problem, but I don't know how to fix Calibre so that it shows my complete library. Is there a way I can "repair" the database, such as by re-importing the directory into Calibre? Perhaps this problem isn't due to my experiment with SugarSynch, but that certainly appears to be the cause since everything was fine until I installed SugarSynch. Thanks in advance for any information you may provide. SteveK

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
[Old Thread] Library listing	richreads	Calibre	15	09-22-2011 03:42 PM
The Incomplete Me	stevensavile	Self-Promotions by Authors and Publishers	0	04-23-2011 06:03 AM
Library listing in Menu	Lizard1	Calibre	1	10-10-2010 08:11 PM
Need help with library listing	geko	Calibre	2	06-29-2010 03:10 PM
Listing books in Library	anselmo	Calibre	2	01-14-2010 09:03 AM

07-06-2013, 11:00 AM	#2
Adoby Handy Elephant Posts: 1,737 Karma: 26785684 Join Date: Dec 2009 Location: Southern Sweden, far out in the quiet woods Device: Samsung Galaxy Tab S8 Ultra	Start by making a backup of the calibre library, that way you can keep trying different things. The easiest could be to do as you suggest, create a new empty calibre library and add the books from the old, assuming they are there and there are opf-files with metadata in the folders. Move or rename the calibre library. Then start calibre. A new empty library will be created. Add the books in the old calibre library. Choose the second method, add books in subdirectories, assume that multiple books in the same folder is the same book in different formats. After a while you have hopefully a new working and up to date calibre library. When you experiment with networked and mirrored folders it is a good idea to make sure you have a backup, if something goes wrong. It is NOT recommended to use networked folders for the calibre library, bad things can happen. Test carefully, and make sure not to update or mirror the calibre library while you have calibre running.

07-06-2013, 12:28 PM	#3
chaley Grand Sorcerer Posts: 12,374 Karma: 8012652 Join Date: Jan 2010 Location: Notts, England Device: Kobo Libra 2	You could also try a "Restore Database" (library -> library maintenance -> restore database). Make a backup first.

07-06-2013, 04:50 PM	#4
SteveK Addict Posts: 272 Karma: 1017902 Join Date: Nov 2008 Device: Kindle PW, PW2, Kindle3, Kobo Glo, tablets, phone	Chaley - Restoring the database seems to have done the trick! After making a backup, I restored the database, and it now appears to contain all titles, including recently added titles. Thanks! Adoby - I can obviously vouch for the wisdom of your warning - I won't do that again! Since my library exceeded the free limits of SugarSync, it appears that any file not merged with SugarSync was somehow deleted from the Calibre database, even though the files themselves were still there. Fortunately, the restore database function appears to have worked its magic. Thanks for the help! SteveK

Advert