An error pops up when I try to add metadata of thousands of fb2 books from files

gecemavisi · 12-01-2020, 12:00 AM

calibre, version 5.6.0
HATA: Başarısız: ConstraintError: UNIQUE constraint failed: publishers.name

Traceback (most recent call last):
File "calibre\gui2\dialogs\metadata_bulk.py", line 171, in do_it
File "calibre\gui2\dialogs\metadata_bulk.py", line 225, in do_all
File "calibre\gui2\dialogs\metadata_bulk.py", line 207, in read_file_metadata
File "calibre\db\cache.py", line 72, in call_func_with_lock
File "calibre\db\cache.py", line 1409, in set_metadata
File "calibre\db\cache.py", line 1371, in protected_set_field
File "calibre\db\cache.py", line 1349, in set_field
File "calibre\db\cache.py", line 1169, in set_field
File "calibre\db\write.py", line 543, in set_books
File "calibre\db\write.py", line 317, in many_one
File "calibre\db\write.py", line 271, in get_db_id
File "calibre\db\backend.py", line 920, in execute
apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: publishers.name

kovidgoyal · 12-01-2020, 04:49 AM

That's an interesting error, it indicates a corrupted database. Try running the check library tool (click calibre button on tool bar and select library meintenance)

12-01-2020, 12:00 AM	#1
gecemavisi Junior Member Posts: 2 Karma: 10 Join Date: Nov 2020 Device: Galaxy Note 10.4	An error pops up when I try to add metadata of thousands of fb2 books from files calibre, version 5.6.0 HATA: Başarısız: ConstraintError: UNIQUE constraint failed: publishers.name Traceback (most recent call last): File "calibre\gui2\dialogs\metadata_bulk.py", line 171, in do_it File "calibre\gui2\dialogs\metadata_bulk.py", line 225, in do_all File "calibre\gui2\dialogs\metadata_bulk.py", line 207, in read_file_metadata File "calibre\db\cache.py", line 72, in call_func_with_lock File "calibre\db\cache.py", line 1409, in set_metadata File "calibre\db\cache.py", line 1371, in protected_set_field File "calibre\db\cache.py", line 1349, in set_field File "calibre\db\cache.py", line 1169, in set_field File "calibre\db\write.py", line 543, in set_books File "calibre\db\write.py", line 317, in many_one File "calibre\db\write.py", line 271, in get_db_id File "calibre\db\backend.py", line 920, in execute apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: publishers.name

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
calibre - Not using existing metadata from *.opf files when Add books	rolandt99	Library Management	19	06-15-2020 04:43 PM
Add files to selected book records from clipboard - error	BetterRed	Library Management	2	08-20-2019 06:29 PM
New Plugin to add metadata to Audio & Video Files	woodr2011	Plugins	3	09-27-2015 06:44 PM
[Error] Metadata in FB2	simonbcn	Calibre	4	08-30-2009 05:01 PM
[Error] Metadata "sequence" tag from FB2	simonbcn	Calibre	0	08-30-2009 12:20 PM

12-01-2020, 04:49 AM	#2
kovidgoyal creator of calibre Posts: 45,349 Karma: 27182818 Join Date: Oct 2006 Location: Mumbai, India Device: Various	That's an interesting error, it indicates a corrupted database. Try running the check library tool (click calibre button on tool bar and select library meintenance)

Advert