View Single Post
Old 01-11-2021, 04:15 PM   #843
genoasalami
Connoisseur
genoasalami began at the beginning.
 
Posts: 53
Karma: 20
Join Date: Apr 2017
Device: KK3G, PW, Voyage, Oasis, Aura One, Forma
Hoping you can help with this error. I am trying to create a custom column for the annotations because I don't want them showing up in all my book descriptions, which is happening right now because of use of the default "comments" column. Following the directions in the help file produces the below error.

Code:
calibre, version 5.9.0
ERROR: Unhandled exception: <b>ConstraintError</b>:ConstraintError: UNIQUE constraint failed: custom_columns.label

calibre 5.9 [64bit]  embedded-python: True is64bit: True
Windows-10-10.0.19041 Windows ('64bit', 'WindowsPE')
('Windows', '10', '10.0.19041')
Python 3.8.5
Windows: ('10', '10.0.19041', '', 'Multiprocessor Free')
Interface language: None
Successfully initialized third party plugins: Gather KFX-ZIP (from KFX Input) (1, 36, 0) && DeDRM (7, 0, 3) && Package KFX (from KFX Input) (1, 36, 0) && Annotations (1, 14, 0) && Find Duplicates (1, 8, 3) && KFX metadata reader (from KFX Input) (1, 36, 0) && KFX Input (1, 36, 0) && KePub Input (3, 4, 3) && KePub Metadata Reader (3, 4, 3) && KePub Output (3, 4, 3) && Kobo Books (1, 8, 0)
Traceback (most recent call last):
  File "C:\Users\genoasalami\AppData\Roaming\calibre\plugins\annotations_resources\dialogs\cc_wizard.py", line 160, in dispatch_button_click
  File "C:\Users\genoasalami\AppData\Roaming\calibre\plugins\annotations_resources\dialogs\cc_wizard.py", line 100, in custom_column_add
  File "calibre\db\legacy.py", line 808, in create_custom_column
  File "calibre\db\cache.py", line 72, in call_func_with_lock
  File "calibre\db\cache.py", line 2014, in create_custom_column
  File "calibre\db\backend.py", line 993, in create_custom_column
  File "calibre\db\backend.py", line 920, in execute
apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: custom_columns.label




Thanks!
genoasalami is offline   Reply With Quote