PDA

Просмотр полной версии : [Вопрос] Ошибка в запросе


M1RoN
29.01.2015, 00:49
Приветствую всех
суть проблемы
при загрузке банлиста, в лог mysql выводится ошибка:


[23:46:29] [WARNING] CMySQLResult::GetRowDataByName - field not found ("BANDATE")
[23:46:29] [WARNING] CMySQLResult::GetRowDataByName - field not found ("BANDATE")
[23:46:29] [WARNING] CMySQLResult::GetRowDataByName - field not found ("BANDATE")
[23:46:29] [WARNING] CMySQLResult::GetRowDataByName - field not found ("BANDATE")
[23:46:29] [WARNING] CMySQLResult::GetRowDataByName - field not found ("BANDATE")
[23:46:29] [WARNING] CMySQLResult::GetRowDataByName - field not found ("BANDATE")
[23:46:29] [WARNING] CMySQLResult::GetRowDataByName - field not found ("BANDATE")
[23:46:29] [WARNING] CMySQLResult::GetRowDataByName - field not found ("BANDATE")
[23:46:29] [WARNING] CMySQLResult::GetRowDataByName - field not found ("BANDATE")
[23:46:29] [WARNING] CMySQLResult::GetRowDataByName - field not found ("BANDATE")
[23:46:29] [WARNING] CMySQLResult::GetRowDataByName - field not found ("BANDATE")

При этом столбец BANDATE - имеется
Загрузка банлиста:


forward mysql_OnPlayerBanlistGet(playerid);
public mysql_OnPlayerBanlistGet(playerid)
{
new rows,fields;
cache_get_data(rows, fields);
if(!rows) return Message(playerid, COLOR_GREEN, "Список забаненых игроков пуст");
new banned[MAX_PLAYER_NAME],unban[11],i;
new string[128];
while(i < rows)
{
cache_get_field_content(i, "BANNED", banned, dbHandle, 24);
cache_get_field_content(i, "BANDATE", unban, dbHable);
if(gettime() >= strval(unban))
{
f(string, "DELETE FROM "T_GETBANS" WHERE `BANNED`='%e'", banned);
mysql_function_query(dbHandle, string, false, "", "");
}
i++;
}
mysql_function_query(dbHandle, "SELECT `BANNED` FROM "T_GETBANS"", true, "mysql_OnPlayerBanlistShow", "i", playerid);
return 1;
}
Mazzilla
29.01.2015, 08:09
cache_get_field_content(i, "BANNED", banned, dbHandle, 24);
cache_get_field_content(i, "BANDATE", unban, dbHable);
M1RoN
30.01.2015, 01:31
cache_get_field_content(i, "BANNED", banned, dbHandle, 24);
cache_get_field_content(i, "BANDATE", unban, dbHable);

это я опечатался на форуме.
уже давно нашёл ошибку, закрываю.