[cgrapski]

Now its back to doing this for tags. I literally tried to add the following tags to a book already with downloaded metadata.

The added Tag is "Cats" - earlier it did this with "Sex" - I changed it to something else (even though it was a guide to the Kama Sutra - and that worked. This time - nothing I put into the tag form will work. Not even "Cats."

"calibre, version 5.39.0
ERROR: Unhandled exception: <b>ConstraintError</b>:ConstraintError: UNIQUE constraint failed: tags.name

calibre 5.39 [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, 47, 0) && DeDRM (7, 2, 1) && Package KFX (from KFX Input) (1, 47, 0) && APNX Generator (1, 1, 0) && Action Chains (1, 16, 3) && Amazon.com Multiple Countries (1, 0, 0) && Annotations (1, 16, 0) && Audit Log (1, 0, 16) && Author Book Count (2, 2, 2) && Author Book Count Hierarchy (1, 2, 3) && Barnes & Noble (1, 2, 16) && Calibre Power Search Plugin (2, 1, 1) && CalibreSpy (1, 0, 84) && Clean Metadata (0, 0, 6) && Clipboard Search (1, 3, 1) && Comments Cleaner (1, 6, 2) && Consolidate All Library Metadata (2, 0, 40) && Copy Cover To Device (2, 0, 4) && Count Pages (1, 11, 2) && DOC Input (1, 0, 1) && Derive_Genres (1, 1, 5) && Diaps Editing Toolbag (0, 3, 7) && Drop Search Results (1, 0, 11) && Entities Manager (1, 0, 15) && EpubMerge (2, 12, 0) && EpubSplit (3, 2, 0) && Extract ISBN (1, 5, 0) && Favourites Menu (1, 1, 0) && Find Duplicates (1, 9, 4) && Generate Cover (2, 1, 0) && GetFileName (0, 1, 1) && Goodreads (1, 5, 3) && Goodreads More Tags (1, 2, 1) && Goodreads Sync (1, 15, 1) && Import List (1, 8, 2) && Job Spy (1, 0, 190) && KFX metadata reader (from KFX Input) (1, 47, 0) && KFX Input (1, 47, 0) && Kindle Collections (1, 7, 29) && Kindle hi-res covers (0, 5, 0) && KindleUnpack - The Plugin (0, 83, 1) && Library Codes (1, 0, 50) && Library Splitter (1, 0, 4) && LibraryThing Match (0, 2, 0) && Manage Series (1, 3, 0) && Media File Importer (1, 0, 24) && Modify ePub (1, 7, 0) && MultiColumnSearch (1, 0, 87) && Open With (1, 7, 0) && Overdrive Link (2, 50, 0) && Prettify Cover (1, 5, 0) && Prince PDF (1, 5, 0) && Quality Check (1, 12, 0) && Quick Preferences (1, 5, 0) && Reading List (1, 8, 0) && Reformat plugin (2, 4, 0) && Resize Cover (1, 1, 0) && Save Composite Custom Columns (1, 1, 1) && Save To Format (0, 0, 6) && Save Virtual Libraries To Column (2, 0, 1) && Save Virtual Libraries To Column GUI (2, 3, 0) && Scroll Book Details (1, 0, 0) && Search The Internet (1, 8, 1) && SmartEject (2, 4, 0) && User Category (1, 5, 5) && View Manager (1, 7, 0) && Walk Search History (1, 3, 2) && Wiki Reader (2, 2, 1) && Wikidata (2, 0, 0) && Wikidata gui (2, 0, 0) && WordDumb (3, 18, 2) && X-Ray Creator (3, 2, 1) && Zotero Metadata Importer (1, 0, 70)
Traceback (most recent call last):
File "calibre\gui2\metadata\single.py", line 626, in accept
File "calibre\gui2\metadata\single.py", line 607, in apply_changes
File "calibre\gui2\metadata\basic_widgets.py", line 1464, in commit
File "calibre\db\legacy.py", line 573, in set_tags
File "calibre\db\cache.py", line 1239, in set_field
File "calibre\db\write.py", line 565, in set_books
File "calibre\db\write.py", line 421, in many_many
File "calibre\db\write.py", line 288, in get_db_id
File "calibre\db\backend.py", line 935, in execute
apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: tags.name