Error adding new books to Calibre

[enguerrand]

Hello,

I started getting error messages whenever I try adding any new book to Calibre:

calibre, version 1.20.0
WARNING: Failed to read metadata: Failed to read metadata from the following:

Erwin Panofsky-Meaning in the Visual Arts.pdf
Traceback (most recent call last):
File "site-packages\calibre\gui2\add.py", line 136, in start
File "site-packages\calibre\gui2\add.py", line 225, in add
File "site-packages\calibre\db\legacy.py", line 211, in create_book_entry
File "site-packages\calibre\db\cache.py", line 57, in call_func_with_lock
File "site-packages\calibre\db\cache.py", line 1379, in create_book_entry
File "site-packages\calibre\db\cache.py", line 1153, in set_metadata
File "site-packages\calibre\db\cache.py", line 1140, in set_field
File "site-packages\calibre\db\cache.py", line 961, in set_field
File "site-packages\calibre\db\write.py", line 513, in set_books
File "site-packages\calibre\db\write.py", line 437, in many_many
File "site-packages\calibre\db\backend.py", line 291, in executemany
File "c:\cygwin\home\kovid\sw\build\apsw-3.7.17-r1\src\cursor.c", line 231, in resetcursor
ConstraintError: ConstraintError: Foreign key violation: authors is still referenced

Before this happened, I had my system (Windows 7 32-bit) crash twice for no clear reason. I don't know if this affected Calibre's functioning. It did not seem to affect any other software.

Can someone help me with this please?

[Terisa de morgan]

Check you database integrity, it looks like something is not OK there.

[enguerrand]

Calibre finds no errors in the database (if you mean Library Maintenance/Check Library options - or is it something else?)

[theducks]

Originally Posted by enguerrand

Hello,

I started getting error messages whenever I try adding any new book to Calibre:

calibre, version 1.20.0
WARNING: Failed to read metadata: Failed to read metadata from the following:

Erwin Panofsky-Meaning in the Visual Arts.pdf
Traceback (most recent call last):
File "site-packages\calibre\gui2\add.py", line 136, in start
File "site-packages\calibre\gui2\add.py", line 225, in add
File "site-packages\calibre\db\legacy.py", line 211, in create_book_entry
File "site-packages\calibre\db\cache.py", line 57, in call_func_with_lock
File "site-packages\calibre\db\cache.py", line 1379, in create_book_entry
File "site-packages\calibre\db\cache.py", line 1153, in set_metadata
File "site-packages\calibre\db\cache.py", line 1140, in set_field
File "site-packages\calibre\db\cache.py", line 961, in set_field
File "site-packages\calibre\db\write.py", line 513, in set_books
File "site-packages\calibre\db\write.py", line 437, in many_many
File "site-packages\calibre\db\backend.py", line 291, in executemany
File "c:\cygwin\home\kovid\sw\build\apsw-3.7.17-r1\src\cursor.c", line 231, in resetcursor
ConstraintError: ConstraintError: Foreign key violation: authors is still referenced

Before this happened, I had my system (Windows 7 32-bit) crash twice for no clear reason. I don't know if this affected Calibre's functioning. It did not seem to affect any other software.

Can someone help me with this please?

Not all PDF's play nice
You need to (temporarily) disable the PDF metadata reader

Preferenceslugins: Metadata READER: Read metadata from PDF files: (click the enable/disable button to get it in the desired state)
Apply

When the book has been added, you can restore the setting

[enguerrand]

The pdf file was just an example, unfortunately. I get the same error with epub, mobi, azw3 - any format and any book I've tried.

calibre, version 1.20.0
WARNING: Failed to read metadata: Failed to read metadata from the following:

Under My Skin - Doris Lessing.epub
Traceback (most recent call last):
File "site-packages\calibre\gui2\add.py", line 136, in start
File "site-packages\calibre\gui2\add.py", line 225, in add
File "site-packages\calibre\db\legacy.py", line 211, in create_book_entry
File "site-packages\calibre\db\cache.py", line 57, in call_func_with_lock
File "site-packages\calibre\db\cache.py", line 1379, in create_book_entry
File "site-packages\calibre\db\cache.py", line 1153, in set_metadata
File "site-packages\calibre\db\cache.py", line 1140, in set_field
File "site-packages\calibre\db\cache.py", line 961, in set_field
File "site-packages\calibre\db\write.py", line 513, in set_books
File "site-packages\calibre\db\write.py", line 437, in many_many
File "site-packages\calibre\db\backend.py", line 291, in executemany
File "c:\cygwin\home\kovid\sw\build\apsw-3.7.17-r1\src\cursor.c", line 231, in resetcursor
ConstraintError: ConstraintError: Foreign key violation: authors is still referenced

[theducks]

What OS (the c:\ makes me think some version of Windows)

[enguerrand]

Windows 7 32-bit

[theducks]

Originally Posted by enguerrand

Windows 7 32-bit

Thanks,
I think Kovid will have to weigh in on this one.

Those EPUB do not have DRM?

(you did try disabling or updating those tools? )

[enguerrand]

Yes, I did try to disable the PDF metadata reader, but the error message is still the same. As for updating, I seem to have the latest version of Calibre installed.

The files have no DRM protection - and I've tried dozens of files, believe me.

Also, I have been using Calibre for years on this PC, without a glitch until this.

[BetterRed]

Originally Posted by Terisa de morgan

Check you database integrity, it looks like something is not OK there.

Have you tried adding a book to a different library - eg a fresh one with same structure as existing library?

BR

[kovidgoyal]

It looks like the database has been corrupted. You can try rebuilding the database by right clicking the library menu and choosing Library Maintenance->Restore database.