MySQL Error... - Printable Version

MySQL 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)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: MySQL Error... (/showthread.php?tid=233445)

MySQL Error... - Unknown123 - 01.03.2011

Pawn Code:

pawn Код:

stock SavePlayerAccount(playerid)
{
    new queue[184];
    format(queue, sizeof(queue), "UPDATE `Players` SET AdminLevel= '%d', Score= '%d', Money= '%d', BankMoney= '%d', Kills= '%d', Deaths= '%d', Army= '%d', Swat= '%d', RobRank= '%d', TazerRank= '%d' WHERE Username= '%s'",
    PlayerData[playerid][AdminLevel], GetPlayerScore(playerid), GetPlayerMoney(playerid), PlayerData[playerid][BankMoney],
    PlayerData[playerid][Kills], PlayerData[playerid][Deaths], PlayerData[playerid][Army], PlayerData[playerid][Swat],
    PlayerData[playerid][RobRank], PlayerData[playerid][TazerRank], PlayerName(playerid));
    mysql_query(queue);
    return 1;
}

Error:

Код:

Error (0): Failed to exeute query. 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 ''Unkn' at line 1.

pawn Код:

use near ''Unkn' at line 1. //Look, It dont get my full name (Unknown123)

Re: MySQL Error... - Bumbis - 01.03.2011

maybe the string lenght is too short.

Re: MySQL Error... - Hiddos - 01.03.2011

Quote:

Originally Posted by silvis123

maybe the string lenght is too short.

Yep, it's way too short. The 'unformatted' string itself IS 184 characters/cells, so it will not fit when you try to format it lol.

Re: MySQL Error... - Unknown123 - 01.03.2011

Quote:

Originally Posted by silvis123

maybe the string lenght is too short.

Indeed xD I changed it to

pawn Код:

new queue[256];

And now it works

-Thanks