Quote:
Originally Posted by Naloomi
Oh Yes. I can confirm that they happened during the "Restore Database" task. The restore finished, and then it allowed me to copy the list to clipboard. At a guess, I'd say that the 'multitude' is several hundred different books. I've counted up to 100 so far, and I'm not 25% of the way through the list of books with the same error.
As I mentioned in Edit #2, it seems to be because the PRIMARY KEY. If I'm right, the PRIMARY KEY in the database is that # that follows book title. And a spot check has confirmed that each time that I have checked the books with the error they have a 'duplicate' folder with the same # after the folder name.
I just did a search (8279, the Ruth Plumly Thompson book, is Yankee in Oz) for the book referenced with # 8279. I found it, as a PDF, in a different directory (Unknown Author). When I open the directory, that folder has the Tag # of 8279. Lets confirm this further.
L. Frank Baum\The Scarecrow of Oz (8296) (This one has the error).
Calibre Library\Unknown\Oz 9. The Scarecrow of Oz (8296)
Eloise Jarvis McGraw\Merry Go Round In Oz (8277) (Has the error)
Calibre Library\Unknown\Oz 40. Merry Go Round In Oz (8277)
Ugh. So it appears I have duplicates that were never found in my 'find duplicate' purge months ago.
BetterRed, thank you for all your help so far on this.
Naloomi
|
@
Naloomi - This is what I'd do
Move the
\Calibre Library\Unknown\ folder out of the
\Calibre Library\ folder with a file manager (Windows Explorer, Finder, Nautilus, whatever) and then rerun the database restore.
If you still get errors then run the
Library Maintenance->Check Library function, the second phase will tell you of discrepancies, you can save the results to the clipboard. That should get you a place where you can resolve the discrepancies and hopefully end up with a clean library.
If it looks beyond repair - then you'll have to add all the books into a fresh library as suggested by Adoby & Kovid.
-------
What operating system are you using, and how long have you been using calibre ?
This is Windows only - I have a memory cell telling me that one
could get a duplicate book number on a folder if you changed the author or title of a book whilst you had a format file open in a program that locked the file. The programs I know of that lock the files are Word for DOC, RTF, DOCX etc files, also XChange & Nitro for PDF files. But Kovid fixed that some time ago - early last year or maybe 2012. Does that ring any bells? I stress this is a Windows issue, Linux and OS/X don't provide any file locking mechanism.
Once you get the library back together I suggest you run the Check Library function now and again - I do it weekly, doesn't take long, just ran it on my 7482 'book' media library in < 2mins. I don't have a super fast computer.
BR