justicechick
02-25-2013, 05:32 AM
Im having an issue with a game that I installed. It is swingping and the game plays fine but its when I go to save the score I get the following database error!(this is the only game which does this)
Database error in vBulletin 4.2.0:
Invalid SQL:
INSERT INTO vsa_chatbox
(userid, userip, message, dateline, textprop)
VALUES ('1', '66.87.2.112', 'Babygirl set a new high score of 44.46 in comarcade[/COLOR].php?do=play&gameid=526]Yeti Sports - Swing 'n Ping', 1361435095, '');
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 'n Ping[/siteurl]', 1361435095, '')' at line 3
Error Number : 1064
Request Date : Thursday, February 21st 2013 @ 02:24:55 AM
Error Date : Thursday, February 21st 2013 @ 02:24:55 AM
Script : http://theflirtingretreat.com/index.php?autocom=arcade&do=savescore
Referrer : http://theflirtingretreat.com/arcade.php?&act=Arcade&do=play&gameid=526
IP Address : 66.87.2.112
Username : Babygirl
Classname : vB_Database
MySQL Version : 5.1.63-cll
Can anyone tell me what I might need to do to fix this? Does it have something to do with the part that I have highlighted in red and underlined? If you click on that link as it is you get and error, however if I manually type the link in and place a / between the com and arcade portion then it takes you to the correct page.
Database error in vBulletin 4.2.0:
Invalid SQL:
INSERT INTO vsa_chatbox
(userid, userip, message, dateline, textprop)
VALUES ('1', '66.87.2.112', 'Babygirl set a new high score of 44.46 in comarcade[/COLOR].php?do=play&gameid=526]Yeti Sports - Swing 'n Ping', 1361435095, '');
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 'n Ping[/siteurl]', 1361435095, '')' at line 3
Error Number : 1064
Request Date : Thursday, February 21st 2013 @ 02:24:55 AM
Error Date : Thursday, February 21st 2013 @ 02:24:55 AM
Script : http://theflirtingretreat.com/index.php?autocom=arcade&do=savescore
Referrer : http://theflirtingretreat.com/arcade.php?&act=Arcade&do=play&gameid=526
IP Address : 66.87.2.112
Username : Babygirl
Classname : vB_Database
MySQL Version : 5.1.63-cll
Can anyone tell me what I might need to do to fix this? Does it have something to do with the part that I have highlighted in red and underlined? If you click on that link as it is you get and error, however if I manually type the link in and place a / between the com and arcade portion then it takes you to the correct page.