Hi there Guest,  
Sign in here: Login through Steam



  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
 
Error when trying to put on the marketplace on forums

#1
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
Find

#2
It happens sometime, just something that goes on with the browser marketplace. Not sure what causes it, but it goes away.
Image
Find

#3
(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)
Find



Forum Jump:


Users browsing this thread:
1 Guest(s)