MySQL error in a Games page comment

Started by Ubel, Wed 13/03/2013 12:48:23

Previous topic - Next topic

Ubel

I was voting for this game in the game database and got this error message. I suppose my vote was still recorded because I am unable to vote again but my heartfelt and long comment was lost forever. :(

QuoteThank you, your votes have been recorded!
Couldn't connect to database: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 't put a ";-)" smiley face in dialogue, it just looks silly and breaks the immers' at line 1

Maybe has something to do with the semicolon? I'd imagine there's parsing for the quotation mark, right?

AGA

Apparently I forgot to escape the comment string, so certain programming-y characters would have broken it.  They're escaped now, so it should work in future.  Sorry!

SMF spam blocked by CleanTalk