MySQL Syntax error - wtf? - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL Syntax error - wtf? (/showthread.php?tid=366398)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL Syntax error - wtf? (/showthread.php?tid=366398)
MySQL Syntax error - wtf? - fordawinzz - 06.08.2012
Code:
CMySQLHandler::Query(UPDATE `players` SET Password='e123456s',Level=1,Admin=6,Cash=5000,Kills=0,Deaths=0,Age=69,Spawn=1,Tutorial=1,Skin=192,Accent='None',Mute=0,HouseKey=0,Materials=0,Weed=0,Cocaine=0,Experience=0,Group=0,GroupRank=0 WHERE id=6) - An error has occured. (Error ID: 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 'Group=0,GroupRank=0 WHERE id=6' at line 1)
Re: MySQL Syntax error - wtf? - ReneG - 06.08.2012
MySQL for sa-mp is very inconsistent with queries' requirements.
Maybe try
pawn Code:
WHERE `id` = 6
Re: MySQL Syntax error - wtf? - fordawinzz - 06.08.2012
Nah, fixed it. I was using the same field in another table.
