+- Forerunner Gaming (https://forerunnergaming.org/forums)
+-- Forum: Server Discussion (https://forerunnergaming.org/forums/forumdisplay.php?fid=19)
+--- Forum: Bug Reports (https://forerunnergaming.org/forums/forumdisplay.php?fid=25)
+---- Forum: Resolved (https://forerunnergaming.org/forums/forumdisplay.php?fid=42)
+---- Thread: Error when trying to put on the marketplace on forums (/showthread.php?tid=1470)
Error when trying to put on the marketplace on forums - Excel - 06-07-2015
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1064 - 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 's Surplus","UID":"1923695746","Type":1,"class":"weapon_ttt_sg552","NameColor":{"' at line 1
Query:
INSERT INTO market_queue VALUES('', 17668, 'STEAM_0:0:21815045', NULL, '{"BID":"Shank's Surplus","UID":"1923695746","Type":1,"class":"weapon_ttt_sg552","NameColor":{"r":22,"b":233,"a":255,"g":80},"stats":{"Clip":1,"Mobility":1,"Recoil":1,"Accuracy":1,"Damage":0.774,"Firerate":0.864},"vars":{"BaseClass":[]},"Icon":"IconFromWorldModel","PrintName":"Shank's Surplus","NameIsPrefix":true,"DisplayStats":true,"traits":{"1":{"Name":"ExtraDamageToGalils","stats":{"Damage":0.08}}}}', 'STEAM_0:0:84438953', 1)
tryed it 3-4 times and got this error all the times
RE: Error when trying to put on the marketplace on forums - Terran - 06-07-2015
It happens sometime, just something that goes on with the browser marketplace. Not sure what causes it, but it goes away.
RE: Error when trying to put on the marketplace on forums - Brassx - 06-07-2015
(06-07-2015, 04:41 PM)Excel Wrote: MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1064 - 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 's Surplus","UID":"1923695746","Type":1,"class":"weapon_ttt_sg552","NameColor":{"' at line 1
Query:
INSERT INTO market_queue VALUES('', 17668, 'STEAM_0:0:21815045', NULL, '{"BID":"Shank's Surplus","UID":"1923695746","Type":1,"class":"weapon_ttt_sg552","NameColor":{"r":22,"b":233,"a":255,"g":80},"stats":{"Clip":1,"Mobility":1,"Recoil":1,"Accuracy":1,"Damage":0.774,"Firerate":0.864},"vars":{"BaseClass":[]},"Icon":"IconFromWorldModel","PrintName":"Shank's Surplus","NameIsPrefix":true,"DisplayStats":true,"traits":{"1":{"Name":"ExtraDamageToGalils","stats":{"Damage":0.08}}}}', 'STEAM_0:0:84438953', 1)
tryed it 3-4 times and got this error all the times
I see the issue. I will fix it. It's the " ' " in Shank's.
Should be fixed now. I missed escaping the encoded item in a few spots.(Makes ' and other characters that break strings/mysql work properly)