mysql error #1064 - Printable Version

mysql 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 error #1064 (/showthread.php?tid=641132)

mysql error #1064 - MatthewRoss - 11.09.2017

hi, i have a problem with my mysql log, error:

PHP код:



[ERROR] CMySQLQuery::Execute[UploadPlayerAccountNumber] - (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 'VA' at line 1

in .pwn

PHP код:



forward UploadPlayerAccountNumber(playerid);

public UploadPlayerAccountNumber(playerid) pInfo[playerid][pID] = cache_insert_id(mysql_connect_id);

public calls when player register account:

PHP код:



stock CreateNewAccount(playerid, password[])

{

    new query_string[66+MAX_PLAYER_NAME-4+30];

    format(query_string, sizeof(query_string), "INSERT INTO `accounts` (`player_name`, `password`, `VIP`, `Mute`, `admin`, `Warns`, `Kills`, `Deaths`, `Banned`) VALUES ('%s', '%s', '%d', '%d', '%d', '%d', '%d', '%d', '%d')",

    pInfo[playerid][pName],

    password,

    pInfo[playerid][pVIP],

    pInfo[playerid][pMute],

    pInfo[playerid][pAdmin],

    pInfo[playerid][pWarns],

    pInfo[playerid][pKills],

    pInfo[playerid][pDeaths],

    pInfo[playerid][pBanned]);

    mysql_function_query(mysql_connect_id, query_string, true, "UploadPlayerAccountNumber", "i", playerid);


    player_is_authorized{playerid} = 1;

    SpawnPlayer(playerid);

    return 1;

}

thanks!

Re: mysql error #1064 - Vince - 11.09.2017

Query string way too short.

Re: mysql error #1064 - MatthewRoss - 11.09.2017

Quote:

Originally Posted by Vince

Query string way too short.

work, thanks!