View Single Post
Old 06-11-2017, 03:01 AM   #1
Terisa de morgan
Grand Sorcerer
Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.
 
Terisa de morgan's Avatar
 
Posts: 6,637
Karma: 12595249
Join Date: Jun 2009
Location: Madrid, Spain
Device: Kobo Clara/Aura One/Forma,XiaoMI 5, iPad, Huawei MediaPad, YotaPhone 2
Problem with "," in series

Hi,

I'm trying to store in calibre a book which series name includes a ",". It isn't possible, however, because calibre raises an error:

Spoiler:
calibre, version 2.99.12
ERROR: Excepción no considerada: <b>ConstraintError</b>:ConstraintError: UNIQUE constraint failed: series.name

calibre 2.99.12 [64bit] embedded-python: True is64bit: True
Windows-10-10.0.10240-SP0 Windows ('64bit', 'WindowsPE')
('Windows', '10', '10.0.10240')
Python 2.7.12+
Windows: ('10', '10.0.10240', 'SP0', u'Multiprocessor Free')
Successfully initialized third party plugins: DeDRM (6, 5, 2) && Search The Internet (1, 7, 6) && Generate Cover (1, 5, 21) && KoboTouchExtended (2, 8, 2) && Import List (1, 1, 5) && Barnes & Noble (1, 2, 14) && Owned Books Goodreads (0, 0, 4) && Overdrive Link (2, 13, 0) && Goodreads (1, 1, 12) && Consolidate All Library Metadata (2, 0, 29) && Annotations (1, 4, 11) && Save Composite Custom Columns (1, 1, 0) && SmartEject (2, 0, 6) && Reading List (1, 6, 6) && EpubSplit (2, 2, 0) && Favourites Menu (1, 0, 4) && My Tools (0, 0, 19) && View Manager (1, 4, 1) && Edit Columns (0, 0, 1) && Fantastic Fiction (1, 1, 6) && Goodreads Sync (1, 10, 8) && GetFileName (0, 0, 13) && Modify ePub (1, 4, 3) && Count Pages (1, 7, 3) && Ex Libris (1, 0, 20) && EpubMerge (2, 1, 0) && Extract ISBN (1, 4, 4) && Quality Check (1, 9, 11) && Diaps Editing Toolbag (0, 3, 4) && Find Duplicates (1, 6, 2) && Kobo Utilities (2, 5, 4) && Overdrive Link* (2, 13, 0)
Traceback (most recent call last):
File "site-packages\calibre\gui2\metadata\single.py", line 583, in accept
File "site-packages\calibre\gui2\metadata\single.py", line 558, in apply_changes
File "site-packages\calibre\gui2\metadata\basic_widgets.py", line 635, in commit
File "site-packages\calibre\db\legacy.py", line 810, in func
File "site-packages\calibre\db\cache.py", line 62, in call_func_with_lock
File "site-packages\calibre\db\cache.py", line 1088, in set_field
File "site-packages\calibre\db\write.py", line 544, in set_books
File "site-packages\calibre\db\write.py", line 317, in many_one
File "site-packages\calibre\db\write.py", line 271, in get_db_id
File "site-packages\calibre\db\backend.py", line 842, in execute
File "c:\t\t\apsw-j6gj96\apsw-3.13.0-r1\src\cursor.c", line 236, in resetcursor
ConstraintError: ConstraintError: UNIQUE constraint failed: series.name


I'll remove the "," but I only wanted to report it here because it can happen to more people.
Terisa de morgan is offline   Reply With Quote