First time updating stories after installing calibre 1.0 64-bit standard install on Windows 7 Pro x64.
First off, I noticed that the FFDL plugin seems to have stopped calling Reading List to update my reading lists (I have FFDL set to add new/updated stories to a "Send to Phone" reading list) or custom column metadata-- word count, two other boolean columns for "synced to device" and "(marked as) read" are not being updated.
Lastly, got this error message trying to update an anthology epub, with the series link being
http://archiveofourown.org/series/40129.
Code:
calibre, version 1.0.0
ERROR: Unhandled exception: <b>ConstraintError</b>:ConstraintError: columns book, tag are not unique
calibre 1.0 [64bit] isfrozen: True is64bit: True
Windows-7-6.1.7601-SP1 Windows ('64bit', 'WindowsPE')
('Windows', '7', '6.1.7601')
Python 2.7.4
Windows: ('7', '6.1.7601', 'SP1', 'Multiprocessor Free')
Traceback (most recent call last):
File "site-packages\calibre\gui2\proceed.py", line 118, in do_ask_question
File "calibre_plugins.fanfictiondownloader_plugin.ffdl_plugin", line 1296, in do_download_merge_update
File "calibre_plugins.fanfictiondownloader_plugin.ffdl_plugin", line 1111, in update_books_loop
File "calibre_plugins.fanfictiondownloader_plugin.ffdl_plugin", line 1412, in update_metadata
File "site-packages\calibre\db\legacy.py", line 458, in set_metadata
File "site-packages\calibre\db\cache.py", line 55, in ans
File "site-packages\calibre\db\cache.py", line 1137, in set_metadata
File "site-packages\calibre\db\cache.py", line 1105, in protected_set_field
File "site-packages\calibre\db\cache.py", line 1085, in set_field
File "site-packages\calibre\db\cache.py", line 906, in set_field
File "site-packages\calibre\db\write.py", line 502, in set_books
File "site-packages\calibre\db\write.py", line 415, in many_many
File "site-packages\calibre\db\backend.py", line 291, in executemany
File "c:\cygwin\home\kovid\sw\build\apsw-3.7.14.1-r1\src\cursor.c", line 231, in resetcursor
ConstraintError: ConstraintError: columns book, tag are not unique
I restarted calibre in debug mode, and proceeded to try again on the same series URL as above, as well as creating three new anthologies from Archive of Our Own series URLs: one series has only one story in it (
http://archiveofourown.org/series/54548), the other has multiple stories (
http://archiveofourown.org/series/37060).
I have also tried making an anthology manually from FF.Net URLs, as well as update several other existing anthologies. In all instances I consistently get the ConstraintError message. Output from all that is enclosed below in the attachment. All this is from the currently latest released version of the FFDL plugin.
Let me know if you need anything else or if you need me to use your new debugging plugin and repeat the tests as well yeah? Thanks.