kwong
01-10-2008, 08:41 AM
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
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