You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
If any of the unique DB attributes has a punctuation symbol AND there's another book in the DB with the same attribute WITHOUT punctuation symbol, you get the error:
upload a book with author name José Luis Corral (it works)
upload a book with author name Jose Luis Corral (it works)
upload a book with author name José Luis Corral (it fails)
Internal error is:
[2024-09-04 17:28:27,960] ERROR {cps.editbooks:304} Database error: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely)
(sqlite3.IntegrityError) UNIQUE constraint failed: authors.name
[SQL: UPDATE authors SET name=?, sort=? WHERE authors.id = ?]
[parameters: ('José Luis Corral', 'Corral, José Luis', 3373)]
(Background on this error at: https://sqlalche.me/e/20/gkpj)
Tested in commit from: 9/26/24, 7:46 PM
The text was updated successfully, but these errors were encountered:
It's a regression/case (probably) of bug fixed in #3058
aserrallerios
changed the title
Cannot upload a book with punctuations symbols in unique attribute
Cannot upload books with punctuation in unique attributes
Oct 2, 2024
If any of the unique DB attributes has a punctuation symbol AND there's another book in the DB with the same attribute WITHOUT punctuation symbol, you get the error:
To reproduce:
Internal error is:
Tested in commit from: 9/26/24, 7:46 PM
The text was updated successfully, but these errors were encountered: