Error with calibre connection

Carmelocotonto · 12-18-2020, 06:04 AM

Hi, this question is for Davidfor and his plugins. When I connect my kobo Clara with last soft and calibre 4.23 all is ok except the following error:

ConstraintError: UNIQUE constraint failed: Shelf.Id

Traceback (most recent call last):
File "site-packages\calibre\gui2\device.py", line 90, in run
File "site-packages\calibre\gui2\device.py", line 543, in _sync_booklists
File "site-packages\calibre\devices\kobo\driver.py", line 970, in sync_booklists
File "site-packages\calibre\devices\kobo\driver.py", line 2455, in update_device_database_collections
File "site-packages\calibre\devices\kobo\driver.py", line 3034, in check_for_bookshelf
File "c:\t\t\apsw-w7591s5i\src\cursor.c", line 236, in resetcursor
ConstraintError: ConstraintError: UNIQUE constraint failed: Shelf.Id

And I don't know why. Please, can you help me?
I have installed kobo utilities, etc...
Thanks

Edit: I have encountered the error; I was trying to create collections that were already created

davidfor · 12-20-2020, 07:52 AM

That's an interesting error. I've been trying to reproduce it and can't. I think it has something to do with the case of the collection names, but, can't come up with combination of changes that would trigger it. Have you change a one of the values somehow?

Alternatively, it could be a corrupt index on the Shelf table in the database. In that case, compressing the database would probably fix it. My Kobo Utilities plugin can do this.

12-18-2020, 06:04 AM	#1
Carmelocotonto Connoisseur Posts: 93 Karma: 12 Join Date: Nov 2018 Location: Salamanca Device: kobo Clara HD, Onyxboox C67	Error with calibre connection (fixed up) 8)) Hi, this question is for Davidfor and his plugins. When I connect my kobo Clara with last soft and calibre 4.23 all is ok except the following error: ConstraintError: UNIQUE constraint failed: Shelf.Id Traceback (most recent call last): File "site-packages\calibre\gui2\device.py", line 90, in run File "site-packages\calibre\gui2\device.py", line 543, in _sync_booklists File "site-packages\calibre\devices\kobo\driver.py", line 970, in sync_booklists File "site-packages\calibre\devices\kobo\driver.py", line 2455, in update_device_database_collections File "site-packages\calibre\devices\kobo\driver.py", line 3034, in check_for_bookshelf File "c:\t\t\apsw-w7591s5i\src\cursor.c", line 236, in resetcursor ConstraintError: ConstraintError: UNIQUE constraint failed: Shelf.Id And I don't know why. Please, can you help me? I have installed kobo utilities, etc... Thanks Edit: I have encountered the error; I was trying to create collections that were already created Last edited by Carmelocotonto; 12-18-2020 at 06:13 AM.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
General Connection Error on any wireless device connection"Send to device" (Android)	Cris B	Calibre Companion	0	03-21-2020 09:20 PM
Calibre Hudl 2: calibre, version 3.2.1 ERROR: Error: Error communicating with device	elfed	Devices	4	07-21-2017 05:33 AM
Connection Error	sberry	Devices	4	10-09-2012 01:24 AM
7.56: error on device connection	jesscat	Calibre	13	04-17-2011 06:19 PM
Calibre connection error	Krathor	Calibre	8	01-26-2011 04:45 AM

12-20-2020, 07:52 AM	#2
davidfor Grand Sorcerer Posts: 24,906 Karma: 47303748 Join Date: Jul 2011 Location: Sydney, Australia Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos	That's an interesting error. I've been trying to reproduce it and can't. I think it has something to do with the case of the collection names, but, can't come up with combination of changes that would trigger it. Have you change a one of the values somehow? Alternatively, it could be a corrupt index on the Shelf table in the database. In that case, compressing the database would probably fix it. My Kobo Utilities plugin can do this.

Advert