Can't add an alternate series title with an apostrophe. Probably issue with escaping. 3m2d4v
4 months ago
Posts: 3
If I try to add an alternate title with an apostrophe, it will partially fail the update and not add that title. I have tried several escape sequences (/,',%27,'), and they will allow the post to succeed. However, they will appear in literal form in the updated title. I believe this is likely an issue with how you are escaping strings being ed to and from the database. I have some programming experience and would be willing to suggest a solution if you share some information with me. I would probably need to know what tech stack you are using, including the frontend, backend, database, and DB connection library. There is most likely a library function that can be used for this purpose. 2u162

4 months ago
Posts: 10876
From the logs, I can see that you're trying to modify the series Hime Kishi wa Barbaroi no Yome and add the name "The Barbarian's Bride"
The reason why it's failing is because that title is already on Shakunetsu no Kuni no Koibito
A just ruler amongst tyrants
4 months ago
Posts: 3
What would you suggest for a solution, as that is one of the official English names? I would posit that series names, particularly alternate names shouldn't need to be unique, but that's probably a pretty big change to the DB schema if you made either of those an table ID.

4 months ago
Posts: 10876
It already has the name "The Barbarian's Bride (Kotoba Noriaki)". That's how we deal with duplicate titles
A just ruler amongst tyrants
4 months ago
Posts: 3
OK, I will do that in the future. I don't think that was there when I tried to edit it. Is there any way the error message could be improved in the future? It didn't inform me of a duplicate title; it just said the update partially succeeded. It's probably not the highest priority, but maybe it's something to add to the backlog.