MySQL Query Error 1064. - Printable Version

MySQL Query Error 1064. - 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 Query Error 1064. (/showthread.php?tid=550167)

MySQL Query Error 1064. - gtasarules14 - 11.12.2014

Hi everyone, I am having a problem with a Quert in MySQL.

Error.
23:56:11] [DEBUG] mysql_format - connection: 1, len: 128, format: "UPDATE `users` SET `Admin` =`%d`, `Money`=`%d`, WHERE `ID`=`%d`"
[23:56:11] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `users` SET `Admin` =`0`, `Money`=`0`, WHERE `ID`=`0`", callback: "(null)", format: "(null)"
[23:56:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[23:56:11] [ERROR] CMySQLQuery::Execute[] - (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 'WHERE `ID`=`0`' at line 1
[23:56:11] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[23:56:11] [DEBUG] Calling callback "OnQueryError"..

Code for where the error is.

pawn Код:

public OnPlayerDisconnect(playerid, reason)
{
    new query[128];
    mysql_format(mysql, query, sizeof(query), "UPDATE `users` SET `Admin` =%d, `Money`=%d, WHERE `ID`=%d",pInfo[playerid][Admin], pInfo[playerid][Money],pInfo[playerid][ID]);
    mysql_tquery(mysql, query, "", "");
    return 1;
}

Any ideas? Thanks!

Re: MySQL Query Error 1064. - Raweresh - 11.12.2014

Change:

Код:

mysql_format(mysql, query, sizeof(query), "UPDATE `users` SET `Admin` =%d, `Money`=%d, WHERE `ID`=%d",pInfo[playerid][Admin], pInfo[playerid][Money],pInfo[playerid][ID]);

To:

Код:

mysql_format(mysql, query, sizeof(query), "UPDATE `users` SET `Admin` ='%d', `Money`='%d', WHERE `ID`='%d'",pInfo[playerid][Admin], pInfo[playerid][Money],pInfo[playerid][ID]);

Re: MySQL Query Error 1064. - JeaSon - 11.12.2014

i think the problem is ", " Money=%d, here this coma you dont have to put that

put this

pawn Код:

mysql_format(mysql, query, sizeof(query), "UPDATE `users` SET `Admin` =%d, `Money`=%d WHERE `ID`=%d",pInfo[playerid][Admin], pInfo[playerid][Money],pInfo[playerid][ID]);

Re: MySQL Query Error 1064. - Vince - 11.12.2014

Get rid of the stupid backticks altogether. I wonder where everyone gets that stuff. You only use them in case your column name is an SQL keyword, in which case you should seriously consider renaming that column.

Re: MySQL Query Error 1064. - gtasarules14 - 11.12.2014

Quote:

Originally Posted by Namer

i think the problem is ", " Money=%d, here this coma you dont have to put that

put this

pawn Код:

mysql_format(mysql, query, sizeof(query), "UPDATE `users` SET `Admin` =%d, `Money`=%d WHERE `ID`=%d",pInfo[playerid][Admin], pInfo[playerid][Money],pInfo[playerid][ID]);

Thank you, this worked like a charm!