MySQL syntax error - Printable Version

MySQL syntax 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 syntax error (/showthread.php?tid=530840)

MySQL syntax error - alanhutch - 09.08.2014

Hi all.

I get these codes with my new MySQL script.

Код:

C:\Users\Nicolas\Downloads\samp03z_svr_R1_win32\gamemodes\PLRPbene.pwn(28951) : error 076: syntax error in the expression, or invalid function call
C:\Users\Nicolas\Downloads\samp03z_svr_R1_win32\gamemodes\PLRPbene.pwn(28953) : error 047: array sizes do not match, or destination array is too small
C:\Users\Nicolas\Downloads\samp03z_svr_R1_win32\gamemodes\PLRPbene.pwn(28955) : error 076: syntax error in the expression, or invalid function call
C:\Users\Nicolas\Downloads\samp03z_svr_R1_win32\gamemodes\PLRPbene.pwn(28957) : error 047: array sizes do not match, or destination array is too small
C:\Users\Nicolas\Downloads\samp03z_svr_R1_win32\gamemodes\PLRPbene.pwn(28959) : error 076: syntax error in the expression, or invalid function call
C:\Users\Nicolas\Downloads\samp03z_svr_R1_win32\gamemodes\PLRPbene.pwn(28961) : error 047: array sizes do not match, or destination array is too small

Here's the lines of the errors.

pawn Код:

new stringnome1[256];
    format(stringnome1,sizeof(stringnome1),"SELECT `nomepersonaggio1` FROM `users` WHERE `username` = `%e`",PlayerName);
    mysql_query(stringnome1);
    PlayerInfo[playerid][pNomePersonaggio1] = stringnome1;
    new stringnome2[256];
    format(stringnome2,sizeof(stringnome2),"SELECT `nomepersonaggio2` FROM `users` WHERE `username` = `%e`",PlayerName);
    mysql_query(stringnome2);
    PlayerInfo[playerid][pNomePersonaggio2] = stringnome2;
    new stringnome3[256];
    format(stringnome3,sizeof(stringnome3),"SELECT `nomepersonaggio3` FROM `users` WHERE `username` = `%e`",PlayerName);
    mysql_query(stringnome3);
    PlayerInfo[playerid][pNomePersonaggio3] = stringnome3;

Can you help me? Thanks

Re: MySQL syntax error - SanAndreasMP - 09.08.2014

If your plugin is outdated, Upgrade your plugin to Mysql R7.

and replace mysql_query with mysql_function_query

Usage of mysql_function_query :

Код:

 mysql_function_query( connectionHandle,query[],bool:cache,callback[], format[],{Float,_}:... )

And use mysql_format instead of format(....);

Usage of Mysql_format

Код:

 mysql_format(connectionHandle, output[], format[],{Float,_}:...)

Hope i helped.

Re: MySQL syntax error - [D]ry[D]esert - 09.08.2014

Not sure but i think this will work:

pawn Код:

format(PlayerInfo[playerid][pNomePersonaggio1],sizeof(PlayerInfo[playerid][pNomePersonaggio1]),"SELECT `nomepersonaggio1` FROM `users` WHERE `username` = `%e`",PlayerName);
    mysql_query(PlayerInfo[playerid][pNomePersonaggio1]);
    format(PlayerInfo[playerid][pNomePersonaggio2],sizeof(PlayerInfo[playerid][pNomePersonaggio2]),"SELECT `nomepersonaggio2` FROM `users` WHERE `username` = `%e`",PlayerName);
    mysql_query(PlayerInfo[playerid][pNomePersonaggio2]);
    format(PlayerInfo[playerid][pNomePersonaggio3],sizeof(PlayerInfo[playerid][pNomePersonaggio3]),"SELECT `nomepersonaggio3` FROM `users` WHERE `username` = `%e`",PlayerName);
    mysql_query(PlayerInfo[playerid][pNomePersonaggio3]);

Re: MySQL syntax error - alanhutch - 09.08.2014

Quote:

Originally Posted by [D]ry[D]esert

Not sure but i think this will work:

pawn Код:

format(PlayerInfo[playerid][pNomePersonaggio1],sizeof(PlayerInfo[playerid][pNomePersonaggio1]),"SELECT `nomepersonaggio1` FROM `users` WHERE `username` = `%e`",PlayerName);
    mysql_query(PlayerInfo[playerid][pNomePersonaggio1]);
    format(PlayerInfo[playerid][pNomePersonaggio2],sizeof(PlayerInfo[playerid][pNomePersonaggio2]),"SELECT `nomepersonaggio2` FROM `users` WHERE `username` = `%e`",PlayerName);
    mysql_query(PlayerInfo[playerid][pNomePersonaggio2]);
    format(PlayerInfo[playerid][pNomePersonaggio3],sizeof(PlayerInfo[playerid][pNomePersonaggio3]),"SELECT `nomepersonaggio3` FROM `users` WHERE `username` = `%e`",PlayerName);
    mysql_query(PlayerInfo[playerid][pNomePersonaggio3]);

That gives me:

Код:

C:\Users\Nicolas\Downloads\samp03z_svr_R1_win32\gamemodes\PLRPbene.pwn(28964) : error 001: expected token: "]", but found "-identifier-"
C:\Users\Nicolas\Downloads\samp03z_svr_R1_win32\gamemodes\PLRPbene.pwn(28964) : warning 215: expression has no effect
C:\Users\Nicolas\Downloads\samp03z_svr_R1_win32\gamemodes\PLRPbene.pwn(28964) : error 001: expected token: ";", but found "]"
C:\Users\Nicolas\Downloads\samp03z_svr_R1_win32\gamemodes\PLRPbene.pwn(28964) : error 029: invalid expression, assumed zero
C:\Users\Nicolas\Downloads\samp03z_svr_R1_win32\gamemodes\PLRPbene.pwn(28964) : fatal error 107: too many error messages on one line

Re: MySQL syntax error - alanhutch - 09.08.2014

Resolved!

pawn Код:

PlayerInfo[playerid][pNomePersonaggio3] = stringnome3[123];