Duplicate Problem - Extra books on file system but not in Calibre

spedinfargo · 12-13-2013, 04:59 PM

OK - I have an interesting one. About 90% of my books are duplicated on the File System but aren't duplicated in my Calibre library. The duplicates look like they originated in calibre. I think it may have happened when I did a mass update of metadata on almost my entire library.

For instance I have these two files:

D:\CalibreNewLibrary\Neal Stephenson\Snow Crash (197)\Snow Crash - Neal Stephenson.epub
D:\CalibreNewLibrary\Neal Stephenson\Snow Crash (12741)\Snow Crash - Neal Stephenson.epub

But only the (197) one is in my library.

I saw the tip to do a "move library" which was supposed to just move the folders and books that were actually in the library. However, when I do this it still brings along the duplicates to the new folder structure.

Find Duplicates plug-in doesn't seem to do anything since technically there are no duplicates in the library.

Any ideas on getting rid of these extra files and folders?

Thanks!

theducks · 12-13-2013, 05:34 PM

Quote:

Originally Posted by spedinfargo

OK - I have an interesting one. About 90% of my books are duplicated on the File System but aren't duplicated in my Calibre library. The duplicates look like they originated in calibre. I think it may have happened when I did a mass update of metadata on almost my entire library.

For instance I have these two files:

D:\CalibreNewLibrary\Neal Stephenson\Snow Crash (197)\Snow Crash - Neal Stephenson.epub
D:\CalibreNewLibrary\Neal Stephenson\Snow Crash (12741)\Snow Crash - Neal Stephenson.epub

But only the (197) one is in my library.

I saw the tip to do a "move library" which was supposed to just move the folders and books that were actually in the library. However, when I do this it still brings along the duplicates to the new folder structure.

Find Duplicates plug-in doesn't seem to do anything since technically there are no duplicates in the library.

Any ideas on getting rid of these extra files and folders?

Thanks!

This condition implies the Metadata.db and folder contents are out of sync.
Reasons can include:
Cloud trying to synch 2 different Libraries.

User (copying) combining Libraries using the OS (it don't work that way. Use Calibre to 'Copy to Library')
User restored the wrong (or OLDER) metadata.db

BetterRed · 12-13-2013, 06:41 PM

Have you run the 2nd phase of Library Maintenance->Check Library ?

I think Find Duplicates only finds books that are in the library - i.e. those that have a row in the books table of metadata.db.

BR

spedinfargo · 12-14-2013, 02:45 PM

Hey guys - the library maintenance thing worked. It went through and looked at all subfolders and allowed me to delete the dupes. Thanks!

12-13-2013, 04:59 PM	#1
spedinfargo Groupie Posts: 155 Karma: 106422 Join Date: Nov 2010 Device: none	Duplicate Problem - Extra books on file system but not in Calibre OK - I have an interesting one. About 90% of my books are duplicated on the File System but aren't duplicated in my Calibre library. The duplicates look like they originated in calibre. I think it may have happened when I did a mass update of metadata on almost my entire library. For instance I have these two files: D:\CalibreNewLibrary\Neal Stephenson\Snow Crash (197)\Snow Crash - Neal Stephenson.epub D:\CalibreNewLibrary\Neal Stephenson\Snow Crash (12741)\Snow Crash - Neal Stephenson.epub But only the (197) one is in my library. I saw the tip to do a "move library" which was supposed to just move the folders and books that were actually in the library. However, when I do this it still brings along the duplicates to the new folder structure. Find Duplicates plug-in doesn't seem to do anything since technically there are no duplicates in the library. Any ideas on getting rid of these extra files and folders? Thanks!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Where does the Kobo app store the books on the file system?	diddy	Kobo Reader	8	01-23-2012 04:27 PM
iPad calibre + iPad = books duplicate to iTunes	Ivy	Apple Devices	5	06-07-2011 06:11 PM
Calibre extra unwanted carriage returns in PCB file conversion	gragradownunder	Conversion	0	05-12-2011 06:57 AM
PDB file problem with Calibre :(	Katdragon	Calibre	0	06-14-2010 08:16 AM
how to clean more disk space in root file system to upgrade system	chinaet	iRex	1	12-18-2006 03:54 PM

12-13-2013, 06:41 PM	#3
BetterRed null operator (he/him) Posts: 20,565 Karma: 26954694 Join Date: Mar 2012 Location: Sydney Australia Device: none	Have you run the 2nd phase of Library Maintenance->Check Library ? I think Find Duplicates only finds books that are in the library - i.e. those that have a row in the books table of metadata.db. BR

12-14-2013, 02:45 PM	#4
spedinfargo Groupie Posts: 155 Karma: 106422 Join Date: Nov 2010 Device: none	Hey guys - the library maintenance thing worked. It went through and looked at all subfolders and allowed me to delete the dupes. Thanks!

Advert