View Single Post
Old 08-20-2015, 12:08 PM   #20
BranMakMorn
Enthusiast
BranMakMorn began at the beginning.
 
Posts: 30
Karma: 10
Join Date: Jan 2010
Device: none
OK so:

1) I moved the Calibre Library out of Google Drive, and it is now in the OneDrive folder, but I paused the sync immediately, to make sure I could fix the library via Calibre first, and sync later;

2) I reinstalled Calibre, and told it to look for a previously existing library in the new directory;

3) I did a "restore database", which took ages, but gave me back several errors. I give an example here

calibre, version 2.35.0
WARNING: Success: Restoring the database succeeded with some warnings. Click "Show details" to see the details. The old database was saved as: C:\Users\XXXXX\OneDrive\Documents\Calibre Library\metadata_pre_restore.db

Failed to restore the books in the following folders:
C:\Users\XXXXX\OneDrive\Documents\Calibre Library\Jack Doe\Your Computer Sucks (271) with error:
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 1985, in restore_book
File "site-packages\calibre\db\cache.py", line 1493, in create_book_entry
File "site-packages\calibre\db\backend.py", line 804, in execute
File "c:\cygwin64\home\kovid\sw\build\apsw-3.8.2-r1\src\cursor.c", line 231, in resetcursor
ConstraintError: ConstraintError: UNIQUE constraint failed: books.id




There is a long list of books with this same error.If I look for them, they are on the database and the majority opens just fine. While in other cases it tells me that I have "no available formats" Why?

Also, I now have also 6 books with "no available formats" AND with no "size" in the relevant column (makes them easy to spot), but opening the path shows that I actually have 2 PDFs, but anyway, I guess I can re-add them manually, it is only 6 after all.

What's going on? Should I do something differently? Would it be a good idea to reinstall again but this time delete all the previous metadata file from the Calibre library?
BranMakMorn is offline   Reply With Quote