View Single Post
Old 07-22-2012, 12:33 PM   #10
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 31,094
Karma: 60358908
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
Quote:
Originally Posted by Murphy View Post
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.
I think that means there is already a book with the same ID (the numbers in paren)

Do you dual boot Linux<->Windows? You can end up with a entry with a different case mix that you can NOT see in (case insensitive) windows.
theducks is offline   Reply With Quote