Strange Error: ConstrainError won't let me put Authors in

[cgrapski]

I am getting the strangest errors today - never happened before.

First I thought it was one thing - I get a constraint error trying to use "D. K. Publishing" as the Author Name. That was odd enough. And annoying.

Then I got a similar error - for a tag - for the tag "sex." That was not permitted.

Now I get the author name error - for "Mike Smith."

What in the world is going on? This is on 5.39

[cgrapski]

UPDATE:

It only gets worse and more puzzling and frustrating.

Now I am getting this one:

apsw.ConstraintError: ConstraintError: Foreign key violation: authors is still referenced

I have no idea what it is referring to - or what to change to get the entry to submit. It's not the tags now, nor the author. And there are no foreign characters - so I have no idea what this is doing.

[cgrapski]

And now this is happening on multiple books - after I download the metadata.

[cgrapski]

Now it is happening with every single book!!!

But if I cancel - and it says it will lose all the data - it retains the downloaded author. But nothing else.

If I then re-download the metadata a second time - it accepts it all.

[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

[theducks]

IIRC there was a plugin that screened for 'naughty' (PG) words. It may be failing the new Python.
What PI do you have installed?
There is a RESTART option on Preferences to start Calibre wit all PI disabled (for basic testing)

[PeterT]

Try performing Library Maintenance to validate your library.

Sent from my Pixel 4a using Tapatalk

[BetterRed]

Originally Posted by theducks

IIRC there was a plugin that screened for 'naughty' (PG) words. It may be failing the new Python.
What PI do you have installed?

Looks like just about every PI there is.

Originally Posted by theducks

There is a RESTART option on Preferences to start Calibre wit all PI disabled (for basic testing)

↑ ↑ ↑ ✔

Ctrl+Alt+Shift+R

BR

[DNSB]

Originally Posted by BetterRed

Looks like just about every PI there is.

Language Cleaner does not seem to be in the list and as far as I recall, it only worked on the content of books that were being converted to epub. I played with it once and just not my cuppa.

[cgrapski]

Tried that too. But what worked - was restarting whole computer. Restarting the program itself wouldn't do it.