View Full Version : mySQL query error

10 Jan 2008, 09:41
After heaving some birth difficulties , The arcade is up and running for almost a month with great sucsses.

since yesterday when trying to enter the arcade we are getting the following error.

i understand it's something to do with the ' in the user name.

1. how do i fix these problem permanently ?
2. i can change the user name to another one without all the ' , would that do the trick ?
3. right now no one can enter the arcade.:(

mySQL query error: INSERT INTO pmtext (fromuserid, fromusername, title, message, touserarray, iconid, dateline, showsignature, allowsmilie) VALUES ('39', 'פיצ'יצ'י', 'Tournament Information', 'Hello פיצ\'יצ\'י,

please remember to make your game in the Tetris-Tournament

Click here (\'http://xxx.forums/arcade.php?do=viewtourney&tid=11\') to view this tournament.', 'a:1:{i:0;s:2:\"39\";}', 0, 1199959611, 0, 0)

mySQL error: 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 'יצ'י', 'Tournament Information', 'Hello פיצ\'יצ\'י,

please remember to make you' at line 1
mySQL error code:
Date: Thursday 10th of January 2008 12:06:51 PM