I turned off the automatic syncing a while ago when I found it messed with the library. So it no longer runs on startup. My main library also, was not in the syncing folder. (Hey, I learned my lesson after having to rebuild my library after using Google Drive)
I got a "corrupt file" error. So I moved all the files to a new location where I had set up an empty library. I then turned off wifi and virus protection and ran the rebuild. 24+ hours later, I have the majority of my books and data back. Well, the books will always be there, it was the wonderful metadata that I really wanted.
Although it rebuild the majority of the library, there were some errors that appear to all be the same:
Failed to restore the books in the following folders:
F:\My documents\Calibre fanfic\comp fanfics -b\Vixen1836\The Beauty and The Geek (1) 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 1979, in restore_book
File "site-packages\calibre\db\cache.py", line 1487, 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
So I am guessing somehow they got the same id as another book in the library. It isn't a lot, so I can manually re-add and fix.
I then ran a Library Check and found a lot more extra books and authors. Some may be duplicates that don't matter. Unfortunately, they can't be automatically fixed
So the rest is manual I guess. I copied everything to a notepad file so I have all the info.
I have a backup library that was last updated about a month ago. Is there anyway to compare libraries?
Thanks for all your help. This is such a great program!