MySQL Error
#1

Can someone help me I get this everytime I /savedata:
Код:
 errorid: 1064 | 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 ''Go', businessOwner = 'NPC_STATE', businessPrice = '0', businessVault = '905', b' at line 1 | resultid: -1 | extraid: -1 | callback: NULL | query: UPDATE businesses SET businessExteriorX = '-2478.732910', businessExteriorY = '2318.402099', businessExteriorZ = '4.984375', businessInteriorX = '-27.037883', businessInteriorY = '-57.808139', businessInteriorZ = '1003.546875', businessInterior = '6', businessType = '1', businessName = '24/7 Stop'n'Go', businessOwner = 'NPC_STATE', businessPrice = '0', businessVault = '905', businessLock = '0', businessMiscX = '0.000000', businessMiscY = '0.000000', businessMiscZ = '0.000000' WHERE businessID = '3'
Reply
#2

pawn Код:
UPDATE businesses SET
businessExteriorX = "-2478.732910",
businessExteriorY = "2318.402099",
businessExteriorZ = "4.984375",
businessInteriorX = "-27.037883",
businessInteriorY = "-57.808139",
businessInteriorZ = "1003.546875",
businessInterior = "6",
businessType = "1",
businessName = "24/7 Stop'n'Go",
businessOwner = "NPC_STATE",
businessPrice = "0",
businessVault = "905",
businessLock = "0",
businessMiscX = "0.000000",
businessMiscY = "0.000000",
businessMiscZ = "0.000000"
WHERE businessID = "3"
You had
pawn Код:
...
businessName = '24/7 Stop'n'Go',
...
You used ' ' to determinate the field value, but you also used those quotes inside the string
It should be: "24/7 Stop'n'Go"
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)