Adding Books duplicates ID's

Talung · 02-10-2009, 05:43 PM

Hi There,

Is anybody else experiencing this problem? At first I thought it was the sync between linux and windows causing the issue, but it is now happening while using linux exclusively.

The issue is that it is duplicating the calibre ID's.

Eg.
/media/backup/eBooks/calibre/Margaret Weis/Love and War (1626)
/media/backup/eBooks/calibre/John Norman/Tarnsman of Gor (1626)

I deleted the Tarnman book, and then added a new book and this is what happening.

To find these duplicates I use this:

Code:

find /media/backup/eBooks/calibre/ -iname "*(*)" | awk '{print $NF}' | sort | uniq -d

Followed by this:

Code:

find /media/backup/eBooks/calibre/ -iname "*(1626)" -exec rm -R '{}' ';'

This seems to be happening quite a lot lately. When it does, all formats disappear from the book, and there is just the metadata remaining. Since re-adding the formats does not work, I then delete the book and readd it. It then conflicts with another book.

Anybody have any idea what is going on?

kovidgoyal · 02-10-2009, 06:30 PM

This is most likely a legacy effect from your windows->linux syncing days. I suggest the following:

upgrade to latest release
select all books, click save to disk
then remove (delete/rename) your library folder and restart calibre
Use the add to library recursively on the folder you previously saved to

Talung · 02-10-2009, 06:51 PM

Thanks,

I was trying to avoid that as I have all the ISBN's and cover images, authors, series etc. all filled in already.

Currently coverting everything to epub, once that is done I will try the import of just epubs on a new database.

Is there any tool to check the metadata.db for errors or other such stuff?

kovidgoyal · 02-10-2009, 07:10 PM

The procedure I described will preserve your metadata/covers etc (with the latest calibre).

No there isn't sucha tool at the moment.

Talung · 02-10-2009, 07:14 PM

Thanks Kovid,

I will give it a try that way.

02-10-2009, 05:43 PM	#1
Talung Member Posts: 15 Karma: 10 Join Date: Feb 2009 Device: PRS-505	Adding Books duplicates ID's Hi There, Is anybody else experiencing this problem? At first I thought it was the sync between linux and windows causing the issue, but it is now happening while using linux exclusively. The issue is that it is duplicating the calibre ID's. Eg. /media/backup/eBooks/calibre/Margaret Weis/Love and War (1626) /media/backup/eBooks/calibre/John Norman/Tarnsman of Gor (1626) I deleted the Tarnman book, and then added a new book and this is what happening. To find these duplicates I use this: Code: find /media/backup/eBooks/calibre/ -iname "()" \| awk '{print $NF}' \| sort \| uniq -d Followed by this: Code: find /media/backup/eBooks/calibre/ -iname "*(1626)" -exec rm -R '{}' ';' This seems to be happening quite a lot lately. When it does, all formats disappear from the book, and there is just the metadata remaining. Since re-adding the formats does not work, I then delete the book and readd it. It then conflicts with another book. Anybody have any idea what is going on?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Duplicates ! and adding new books to library	anickson	Calibre	4	10-11-2010 03:48 PM
ADE - Gerätebeschränkung bei Adobe ID's	Esperanza	Software	8	08-16-2010 04:16 AM
Adding books without a copy	Sanderfox	Calibre	5	12-02-2009 02:32 PM
Help with adding books please	stustaff	Calibre	12	10-27-2009 02:30 PM
Two Adobe ID's, and I forgot which one I authorized my Reader with!	curtw	Sony Reader	2	07-08-2009 09:19 PM

02-10-2009, 06:30 PM	#2
kovidgoyal creator of calibre Posts: 45,169 Karma: 27110894 Join Date: Oct 2006 Location: Mumbai, India Device: Various	This is most likely a legacy effect from your windows->linux syncing days. I suggest the following: upgrade to latest release select all books, click save to disk then remove (delete/rename) your library folder and restart calibre Use the add to library recursively on the folder you previously saved to

02-10-2009, 06:51 PM	#3
Talung Member Posts: 15 Karma: 10 Join Date: Feb 2009 Device: PRS-505	Thanks, I was trying to avoid that as I have all the ISBN's and cover images, authors, series etc. all filled in already. Currently coverting everything to epub, once that is done I will try the import of just epubs on a new database. Is there any tool to check the metadata.db for errors or other such stuff?

02-10-2009, 07:10 PM	#4
kovidgoyal creator of calibre Posts: 45,169 Karma: 27110894 Join Date: Oct 2006 Location: Mumbai, India Device: Various	The procedure I described will preserve your metadata/covers etc (with the latest calibre). No there isn't sucha tool at the moment.

02-10-2009, 07:14 PM	#5
Talung Member Posts: 15 Karma: 10 Join Date: Feb 2009 Device: PRS-505	Thanks Kovid, I will give it a try that way.