Вход

Просмотр полной версии : [Вопрос] Лог ошибок mysql



DmX
17.12.2016, 03:53
[02:48:57] [WARNING] CMySQLResult::GetRowDataByName - field not found ("FamMute")
[02:48:57] [ERROR] cache_get_field_content_int - invalid datatype
[02:49:00] [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 '`FamWarn` = '0', `FamMute` = '0', `Ban` = '0' WHERE `ID` = '6'' at line 1
[02:49:03] [WARNING] CMySQLResult::GetRowDataByName - field not found ("FamMute")
[02:49:03] [ERROR] cache_get_field_content_int - invalid datatype
[02:49:22] [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 '`FamWarn` = '0', `FamMute` = '0', `Ban` = '0' WHERE `ID` = '6'' at line 1
[02:49:25] [WARNING] CMySQLResult::GetRowDataByName - field not found ("FamMute")
[02:49:25] [ERROR] cache_get_field_content_int - invalid datatype
[02:49:50] [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 '`FamWarn` = '0', `FamMute` = '0', `Ban` = '1484005790' WHERE `ID` = '6'' at line 1


format(query_string, sizeof(query_string), "%s `Mute` = '%i',", query_string, PlayerInfo[playerid][pMute]);
format(query_string, sizeof(query_string), "%s `Job` = '%i',", query_string, PlayerInfo[playerid][pJob]);
format(query_string, sizeof(query_string), "%s `SDetekt` = '%i',", query_string, PlayerInfo[playerid][pSDetekt]);
format(query_string, sizeof(query_string), "%s `JailTime` = '%i',", query_string, PlayerInfo[playerid][pJailTime]);
format(query_string, sizeof(query_string), "%s `Jail` = '%i',", query_string, PlayerInfo[playerid][pJail]);
format(query_string, sizeof(query_string), "%s `DInvite` = '%s',", query_string, PlayerInfo[playerid][pDInvite]);
format(query_string, sizeof(query_string), "%s `FamWarn` = '%i',", query_string, PlayerInfo[playerid][pFamWarn]);
format(query_string, sizeof(query_string), "%s `FamMute` = '%i',", query_string, PlayerInfo[playerid][pFamMute]);
format(query_string, sizeof(query_string), "%s `Ban` = '%i'", query_string, PlayerInfo[playerid][pBan]);

format(query_string, sizeof(query_string), "%s WHERE `ID` = '%d'", query_string, PlayerInfo[playerid][pID]);
mysql_function_query(connects, query_string, false, "", "");

Saibot
17.12.2016, 03:57
Попробуй увеличить массив query_string
И создай в БД поле "FamMute".