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)
+--- Thread: MySQL ERROR (/showthread.php?tid=394198)

MySQL ERROR - SanCio - 21.11.2012

Hi , i have problem with mySQL save.

CODE :

Код:

 format ( query , sizeof ( query ) , "UPDATE `login` SET `IP`='%s' WHERE ( `Vardas`='%s' )" , GetPlayerIpEx ( playerid ) , GetPlayerNameEx ( playerid ) )  ;
	 mysql_query ( query ) ;
	 format ( query , sizeof ( query ) , "UPDATE `login` SET `Valanda`='%i' , `Minute`='%i' , `Secunde`='%i' , `Metas`='%i` , `Menesis`='%i' , `Diena`='%i'  WHERE ( `Vardas`='%s' )" , val , mins , sec , year , month , day , GetPlayerNameEx ( playerid ) ) ;
	 mysql_query ( query )  ;

ERROR :

Код:

[Wed Nov 21 18:31:50 2012] Function: mysql_query executed: "UPDATE `login` SET `Valanda`='18' , `Minute`='31' , `Secunde`='50' , `Metas`='2012` , `Menesis`='11' , `Diena`='21'  WHERE ( `Vardas`='Sasha_Hriundel' )" with result: "1".
[Wed Nov 21 18:31:50 2012] 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 '11' , `Diena`='21'  WHERE ( `Vardas`='Sasha_Hriundel' )' at line 1.

Thanks for help

Re: MySQL ERROR - CmZxC - 21.11.2012

try removing ' when its %i, i dont think they need those.

Re: MySQL ERROR - SanCio - 21.11.2012

Don't work

Re: MySQL ERROR - SanCio - 21.11.2012

HELP ! Please .

Re: MySQL ERROR - SanCio - 22.11.2012

UP! Please help!

AW: MySQL ERROR - Skimmer - 22.11.2012

Is login your table name? If not change it please.
Try this.

pawn Код:

format(query, sizeof(query), "UPDATE login SET IP = '%s' WHERE Vardas = '%s'" , GetPlayerIpEx ( playerid ) , GetPlayerNameEx ( playerid ) )  ;
mysql_query(query);
format(query, sizeof(query) , "UPDATE login SET Valanda = '%d', Minute = '%d', Secunde = '%d', Metas = '%d , Menesis = '%d', Diena = '%d' WHERE Vardas = '%s'" , val , mins , sec , year , month , day , GetPlayerNameEx ( playerid ) ) ;
mysql_query(query);

Re: MySQL ERROR - SanCio - 22.11.2012

THANKS WORK!