PDA

View Full Version : Data-base error in IbProarcade


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.

kh99
02-25-2013, 04:57 PM
You should ask questions about mods in the mod thread (or the subforum, in the case of ibproarcade).

That said, I'm guessing the issue is that the game name has ' (an apostrophe) in it. You should post in and/or search the ibproarcade forum because someone might have found this already, and if not they may want to know so it can be fixed in a later release.