[toscanot]

Tried on two different machines to upload a new book to Calibre library. Both times on both machines got the same message.

calibre, version 1.14.0
ERROR: Unhandled exception: <b>ConstraintError</b>:ConstraintError: Foreign key violation: authors is still referenced

calibre 1.14 isfrozen: True is64bit: False
Windows-8-6.2.9200 Windows ('32bit', 'WindowsPE')
32bit process running on 64bit windows
('Windows', '8', '6.2.9200')
Python 2.7.5
Windows: ('8', '6.2.9200', '', 'Multiprocessor Free')
Traceback (most recent call last):
File "site-packages\calibre\gui2\add.py", line 41, in add_one
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

Please let me know what I need to do. I have my books sorted specifically and do not wish to recreate the wheel.

Many thanks.

T