MySQL help
#1

sorry for the inconvenience again :\ but I am getting some errors in MySQL

my problem is

Код:
[21:29:17] [DEBUG] mysql_format - connection: 1, len: 128, format: "UPDATE `Accounts` SET Score=%d, Cash=%d, Level=%d, Kills=%d, Deaths=%d, pMute=%d, Warns=%d  WHERE Name=`%s`"
[21:29:17] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `Accounts` SET Score=0, Cash=0, Level=0, Kills=0, Deaths=", callback: "(null)", format: "(null)"
[21:29:17] [DEBUG] CMySQLQuery::CMySQLQuery() - constructor called
[21:29:17] [DEBUG] mysql_tquery - scheduling query "UPDATE `Accounts` SET Score=0, Cash=0, Level=0, Kills=0, Deaths=0, pMute=0, Warns=0  WHERE Name=`Emperror`"..
[21:29:17] [DEBUG] CMySQLQuery::Execute[()] - starting query execution
[21:29:17] [ERROR] CMySQLQuery::Execute[()] - (error #1054) Unknown column 'Emperror' in 'where clause'
[21:29:17] [DEBUG] CMySQLQuery::Execute[()] - error will be triggered in OnQueryError
[21:29:17] [DEBUG] CMySQLQuery::Execute[()] - data being passed to ProcessCallbacks()
[21:29:17] [DEBUG] CMySQLQuery::~CMySQLQuery() - deconstructor called
and the code

Код:
 mysql_format(mysql, query, sizeof(query), "UPDATE `Accounts` SET Score=%d, Cash=%d, Level=%d, Kills=%d, Deaths=%d, pMute=%d, Warns=%d  WHERE Name=`%s`",\
  score,  money,  PlayerInfo[playerid][Level],  PlayerInfo[playerid][Kills],  PlayerInfo[playerid][Deaths],  PlayerInfo[playerid][muted],  PlayerInfo[playerid][Warns],  GetName(playerid));
  mysql_tquery(mysql, query, "", "");
pls someone help :\
Reply


Messages In This Thread
MySQL help - by Vaishnav - 20.05.2014, 15:44
Re: MySQL help - by LemonPunch - 20.05.2014, 18:34
Re: MySQL help - by iReacheR - 20.05.2014, 19:04
Re: MySQL help - by Vaishnav - 21.05.2014, 00:10

Forum Jump:


Users browsing this thread: 1 Guest(s)