MySQL Syntax error - wtf?
#1

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)
Wtf is wrong there?
Reply
#2

MySQL for sa-mp is very inconsistent with queries' requirements.

Maybe try
pawn Code:
WHERE `id` = 6
Maybe you made a typo in the column names?
Reply
#3

Nah, fixed it. I was using the same field in another table.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)