Adventure Game Studio

AGS Development => Site & Forum Reports => Topic started by: Ubel on Wed 13/03/2013 12:48:23

Title: MySQL error in a Games page comment
Post by: Ubel on Wed 13/03/2013 12:48:23
I was voting for this game (http://www.adventuregamestudio.co.uk/site/games/game/1650/) 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?
Title: Re: MySQL error in a Games page comment
Post by: AGA on Wed 13/03/2013 13:56:03
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!