Library is large, close to 6400 e-books (I am at 6271 post problem).
I use Box, although due to the way it works I may end up having to switch to Dropbox (box does a popup for downloads that my Kindle doesn't accept, so getting books to my Kindle Keyboard 'on the go' is not possible without logging into my computer remotely and using 'send to kindle'. I hear that Dropbox does not do things this way, but have yet to test.)
I have completed step 1 that BetterRed suggests (use Library Maintenance->Restore database - it will build a fresh metadata.db from the metadata.opf files in the book folders). It has resulted in some 'errors', but looking closely at them they are all the same error, just with many different books.
Quote:
Traceback (most recent call last):
File "site-packages\calibre\db\restore.py", line 253, in restore_books
File "site-packages\calibre\db\cache.py", line 57, in call_func_with_lock
File "site-packages\calibre\db\cache.py", line 1779, in restore_book
File "site-packages\calibre\db\cache.py", line 1383, in create_book_entry
File "site-packages\calibre\db\backend.py", line 287, in execute
File "c:\cygwin\home\kovid\sw\build\apsw-3.7.14.1-r1\src\cursor.c", line 231, in resetcursor
ConstraintError: ConstraintError: PRIMARY KEY must be unique
|
I've copied the 'list' to clipboard and saved it, and I figure I'll have to go through the multitude of books one by one, but do I have to? And at what point should I move to Step 2 that BetterRed suggests?
EDIT #1 - TONS of errors, but TBH, many/most of these errors were probably there to begin with.
EDIT #2 - The PRIMAY KEY is the # at the end of the folder name, isn't it? That's what I'm seeing. Duplicate folders, 'same book' although they're in different folders.
Example: Bob Builds Roads (666)
Bob Builds THE Roads (666)
Same book (made up), same 'KEY', but different folders thus the errors, right?
Naloomi