Mysql field problem - Printable Version

Mysql field problem - 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 field problem (/showthread.php?tid=453305)

Mysql field problem - Gh0s7 - 24.07.2013

I have a problem with Key field . That field exists in database but when i call it, it gives me this error Field doesn't exist.

Код:

	format(query, sizeof(query), "SELECT * FROM `accounts` WHERE `Name` = '%s'", MysqlGetName(playerid));
	mysql_query(query, THREAD_ACCOUNT_EXIST, playerid, CGRData);

Код:

[17:02:24] [DEBUG] CMySQLHandler::FreeResult() - Result was successfully freed.
[17:02:24] [DEBUG] ProcessQueryThread(OnQueryFinish) - Executing query SELECT `Level`, `VIP`, `LastOn`, `Money`, `Kills`, `Warns`, `Jails`, `Bans`, `Kicks`, `Mutes`, `Reacs`, `Points`, `Positive`, `Deaths`, `Coins`, `Score`, `Hours`, `Mins` , `Secs`, `LoggedIn`, `Registered`, `Date`, `IP` FROM `accounts` WHERE `Name` = 'Gh0s7.'...
[17:02:24] [DEBUG] ProcessQueryThread(OnQueryFinish) - Query was successful.
[17:02:24] [DEBUG] ProcessQueryThread(OnQueryFinish) - Data being passed to ProcessTick().
[17:02:24] [DEBUG] OnQueryFinish(siii) - Callback is being called...
[17:02:24] [DEBUG] >> mysql_store_result(Connection handle: 1)
[17:02:24] [DEBUG] CMySQLHandler::StoreResult() - Result was stored.
[17:02:24] [DEBUG] >> mysql_retrieve_row(Connection handle: 1)
[17:02:24] [DEBUG] >> mysql_fetch_field_row(Connection handle: 1)
[17:02:24] [ERROR] CMySQLHandler::FetchField("Key") - Field doesn't exist.

Re: Mysql field problem - Gh0s7 - 25.07.2013

Up...