24.07.2013, 14:21
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.