Problem with "," in series

[Terisa de morgan]

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.

[chaley]

It works fine for me. I tried Edit Metadata (Single), editing in the spreadsheet, and editing in the tag browser.

My concern is that there is something wrong with your database. The constraint failure says that the series name is already in the database, but calibre isn't finding it when it checks. That implies that there is something strange, perhaps an odd character encoding or leading/trailing spaces, that prevents calibre from finding the series name in its in memory cache but doesn't prevent sqlite from finding it when it does a constrain check on the actual database.

I note that you have installed CALM. Does it fail on a non-CALM database? Does it fail on a new library?

[Terisa de morgan]

Originally Posted by chaley

It works fine for me. I tried Edit Metadata (Single), editing in the spreadsheet, and editing in the tag browser.

It was in Edit Metadata (Single), so it should work.

Originally Posted by chaley

My concern is that there is something wrong with your database. The constraint failure says that the series name is already in the database, but calibre isn't finding it when it checks. That implies that there is something strange, perhaps an odd character encoding or leading/trailing spaces, that prevents calibre from finding the series name in its in memory cache but doesn't prevent sqlite from finding it when it does a constrain check on the actual database.

I have to check another idea related with it.

Originally Posted by chaley

I note that you have installed CALM. Does it fail on a non-CALM database? Does it fail on a new library?

If by non-CALM you mean one that is not included in the plugin, I don't know. If you mean in a database created by CALM, this isn't. And new, I see I have the comma in another library. Blame my alarm to lack of sleep. I have to check you ideas and some more.

[Terisa de morgan]

It was something more strange: the book was there but it didn't appear at the library, so my guess is that the series wasn't found either. After restart the library, the book has appeared and all has worked.

[chaley]

Originally Posted by Terisa de morgan

It was something more strange: the book was there but it didn't appear at the library, so my guess is that the series wasn't found either. After restart the library, the book has appeared and all has worked.

Was the book added using the command line, auto-add, or some other non-GUI way while the GUI was running? If so then it is possible that the GUI wasn't fully refreshed, although I would be surprised if Kovid didn't test these cases.

[Terisa de morgan]

Originally Posted by chaley

Was the book added using the command line, auto-add, or some other non-GUI way while the GUI was running? If so then it is possible that the GUI wasn't fully refreshed, although I would be surprised if Kovid didn't test these cases.

It was moved from a library (which at that moment was open at the content server) to another one, and later a I switched to the destination library, where the problem appeared.

[kovidgoyal]

What exactly were the steps you used?

1) Start calibre
2) open content server and browse the library currently showing in calibre
3) move books from library to another library in calibre
4) switch to library to which you moved book
5) the newly moved book is not visible?

Is that right?

[Terisa de morgan]

Steps are:

1. Start calibre in library A
2. Start content server
3. Browse library B in content server
4. Switch calibre gui to library B
5. Copy book from library B to library A
6. Switch the gui to library A

Anyway, perhaps I did something wrong, I don't know.

[kovidgoyal]

With those steps the copied book shows up in library A for me when I switch back to it.

Does it happen again for you if you try the steps yourself?

[Terisa de morgan]

I'll check it and I'll be back to you.