View Single Post
Old 07-22-2012, 12:13 PM   #9
Murphy
Member
Murphy began at the beginning.
 
Posts: 18
Karma: 10
Join Date: Jan 2008
Device: Kobo Touch
PeterT - Thank you for quick reply.
I have checked that my computer can see Kobo - yes it can.
I checked that Kobo device interface plugin was enabled - it wasn't, I enabled it and made no difference. - How did it get switched off?
However, while I was looking for things to try I think I have found something. I clicked on Library and moved my library to a new location. This restored the Calibre database and in the process found some problems - namely 'Primary Key must be unique'.
Anyway, that is what I think I did! I know, I should have noted all the steps down as I did them...
Here is the log

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

Failed to restore the books in the following folders:
C:\Users\Anna\Calibre Library\Liz Flaherty\Because of Joe (1809) with error:
Traceback (most recent call last):
File "site-packages\calibre\library\restore.py", line 245, in restore_books
File "site-packages\calibre\library\restore.py", line 259, in restore_book
File "site-packages\calibre\library\database2.py", line 3319, in create_book_entry
File "site-packages\calibre\library\sqlite.py", line 313, in run
IntegrityError: PRIMARY KEY must be unique

C:\Users\Anna\Calibre Library\Men Of Courage\Foster, Lori & Kauffman, Donna & Shalvis (3537) with error:
Traceback (most recent call last):
File "site-packages\calibre\library\restore.py", line 245, in restore_books
File "site-packages\calibre\library\restore.py", line 259, in restore_book
File "site-packages\calibre\library\database2.py", line 3319, in create_book_entry
File "site-packages\calibre\library\sqlite.py", line 313, in run
IntegrityError: PRIMARY KEY must be unique

C:\Users\Anna\Calibre Library\William Maltese_ AM Riley_ Lex Valentine\Love Me Dead (4730) with error:
Traceback (most recent call last):
File "site-packages\calibre\library\restore.py", line 245, in restore_books
File "site-packages\calibre\library\restore.py", line 259, in restore_book
File "site-packages\calibre\library\database2.py", line 3319, in create_book_entry
File "site-packages\calibre\library\sqlite.py", line 313, in run
IntegrityError: PRIMARY KEY must be unique

All 3 books have been in my library for some time, so can't see why they might be causing the problem. And this may be totally unrelated. I think some books may have gone astray during the restore, but as I have nearly 4000 it won't be easy to check this.

Sorry I did not post the debug log for My device is not detected but for whatever reason it is now working again. Hope it continues to do so.
Murphy is offline   Reply With Quote