bannerBaka-UpdatesManga
Manga Poll
Did you dress up for Halloween this year?
Yes
No
 
mascot
Manga is the Japanese equivalent of comics
with a unique style and following. Join the revolution! Read some manga today!

RSS Feed

Can't add an alternate series title with an apostrophe. Probably issue with escaping.

You must be registered to post!
From User
Message Body
Member


9 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 passed 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.


user avatar
Site Admin


9 months ago
Posts: 10944

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

Member


9 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.


... Last edited by blathers16 9 months ago
user avatar
Site Admin


9 months ago
Posts: 10944

It already has the name "The Barbarian's Bride (Kotoba Noriaki)". That's how we deal with duplicate titles


________________

A just ruler amongst tyrants

Post #808900 - Reply To (#808807) by lambchopsil
Post #808900 - Reply To (#808807) by lambchopsil
Member


8 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.


You must be registered to post!