SA-MP Forums Archive
MySQL Update query error - 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 Update query error (/showthread.php?tid=472835)


MySQL Update query error - Keyhead - 31.10.2013

I get an error in my MySQL log when it tries to update a players data. Anyone know why?

pawn Код:
stock UpdatePlayerData(playerid)
{
    if(Player[playerid][IsLoggedIn] == false)
        return 0;

    new query[256];
    mysql_format(SQL, query, sizeof(query), "UPDATE `players` SET `money` = '%d' `level` = '%d' `deaths` = '%d' `admin` = '%d' WHERE `id` = '%d' LIMIT 1", Player[playerid][Money], Player[playerid][Level],Player[playerid][Deaths],Player[playerid][Admin], Player[playerid][ID]);
    mysql_tquery(SQL, query, "", "");
    return 1;
}


Re: MySQL Update query error - iJumbo - 31.10.2013

You missed some comma
Код:
UPDATE `players` SET `money` = '%d', `level` = '%d', `deaths` = '%d', `admin` = '%d' WHERE `id` = '%d' LIMIT 1


Re: MySQL Update query error - Keyhead - 31.10.2013

I have no idea how I could be so stupid. I'm ashamed. Thanks. I'll REP you.

Re: MySQL Update query error - iJumbo - 31.10.2013

Also the MySql error will help you fix this things. Take a look at that before post here