Mysql errors
#4

Thanks everyone, i'm just new to Mysql.
and i got 1 more error on OnPlayerDisconnect


Код:
   	new query[540]; //query[128] is for formatting our query and Float:pos[3] is for getting and saving player's position
	mysql_format(mysql, query, sizeof(query), "UPDATE `Players` SET ,`MysqlID`='0'",\
	PlayerInfo[playerid][MysqlID]);
Код:
[07:32:26] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `Players` SET ,`MysqlID`='0'", callback: "(null)", format: "(null)"
[07:32:26] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[07:32:26] [ERROR] CMySQLQuery::Execute[] - (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 '`MysqlID`='0'' at line 1
[07:32:26] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
Reply


Messages In This Thread
Mysql errors - by DerickClark - 17.10.2015, 14:04
Re: Mysql errors - by karemmahmed22 - 17.10.2015, 14:15
Re: Mysql errors - by iggy1 - 17.10.2015, 14:16
Re: Mysql errors - by DerickClark - 17.10.2015, 14:25
Re: Mysql errors - by karemmahmed22 - 17.10.2015, 14:33
Re: Mysql errors - by DerickClark - 17.10.2015, 15:00

Forum Jump:


Users browsing this thread: 1 Guest(s)