[Вопрос] Не записываются некоторые данные в БД

Не записываются некоторые данные в БД

Не записываются некоторые данные в БД , хотя всё по списку идёт

PHP код:

if(GetPVarInt(playerid, !"Logged") > 0) { new query[128] = "UPDATE "table_account" SET "; format(query, sizeof(query), "%s `Skin` = '%d',", query, PlayerInfo[playerid][pSkin]); format(query, sizeof(query), "%s `Sex` = '%d',", query, PlayerInfo[playerid][pSex]); format(query, sizeof(query), "%s `Cash` = '%d',", query, PlayerInfo[playerid][pCash]); format(query, sizeof(query), "%s `Level` = '%d',", query, PlayerInfo[playerid][pLevel]); format(query, sizeof(query), "%s `Admin` = '%d',", query, PlayerInfo[playerid][pAdmin]); format(query, sizeof(query), "%s `Pohodka` = '%d',", query, PlayerInfo[playerid][pPohodka]); format(query, sizeof(query), "%s `Rasa` = '%d',", query, PlayerInfo[playerid][pRasa]); format(query, sizeof(query), "%s `Yazik` = '%d',", query, PlayerInfo[playerid][pYazik]); format(query, sizeof(query), "%s `Gorod` = '%d',", query, PlayerInfo[playerid][pGorod]); format(query, sizeof(query), "%s WHERE `Name` = '%s'", query, GN(playerid)); mysql_function_query(mysql_connection, query, false, "", ""); } return true;

http://ihost.pro-pawn.ru/image.php?di=AJ8A

Не мало памяти выделено для запроса?

Цитата:

Сообщение от Web

Не мало памяти выделено для запроса?

Да нет даже много

Запятая лишняя перед WHERE есть просто

Цитата:

format(query, sizeof(query), "%s `Gorod` = '%d',", query, PlayerInfo[playerid][pGorod]);

И вряд ли хватит 128 ячеек для запроса. Уже сейчас, даже без информации из переменных, у тебя больше 250 символов в строке

Не сахраняет всё равно

Ну так значит до сих пор есть либо ошибка в запросе, либо массива не хватает.
Убери лишние пробелы между именем столбца и спецификатором("%d"), а после подсчитай нормально размер для запроса.

UPD:

PHP код:

if(GetPVarInt(playerid, !"Logged") > 0) { new query[19+(7+3)+(6+1)+(7+11)+(8+11)+(8+2)+(10+2)+(7+2)+(8+2)+(7+1)+(14+MAX_PLAYER_NAME)+1] = "UPDATE account SET ";//19 format(query, sizeof(query), "%s Skin=%d,", query, PlayerInfo[playerid][pSkin]);//7+3 format(query, sizeof(query), "%s Sex=%d,", query, PlayerInfo[playerid][pSex]);//6+1 format(query, sizeof(query), "%s Cash=%d,", query, PlayerInfo[playerid][pCash]);//7+11 format(query, sizeof(query), "%s Level=%d,", query, PlayerInfo[playerid][pLevel]);//8+11 format(query, sizeof(query), "%s Admin=%d,", query, PlayerInfo[playerid][pAdmin]);//8+2 format(query, sizeof(query), "%s Pohodka=%d,", query, PlayerInfo[playerid][pPohodka]);//10+2 format(query, sizeof(query), "%s Rasa=%d,", query, PlayerInfo[playerid][pRasa]);//7+2 format(query, sizeof(query), "%s Yazik=%d,", query, PlayerInfo[playerid][pYazik]);//8+2 format(query, sizeof(query), "%s Gorod=%d", query, PlayerInfo[playerid][pGorod]);//7+1 format(query, sizeof(query), "%s WHERE Name='%s'", query, GN(playerid));//14+MAX_PLAYER_NAME mysql_function_query(mysql_connection, query, false, "", ""); }

http://ihost.pro-pawn.ru/image.php?di=Y51F
Всё равно так же

Ну так покажи логи MySQL

PHP код:

[23:13:14] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061) [23:13:16] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061) [23:13:16] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061) [14:18:20] [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 '' at line 1 [14:18:29] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [14:18:29] [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 '' at line 1 [14:25:20] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [14:25:20] [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 '' at line 1 [14:27:20] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [14:27:20] [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 '' at line 1 [14:31:45] [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 '' at line 1 [15:25:36] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [15:25:36] [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 '' at line 1 [15:26:14] [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 '' at line 1 [15:26:20] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [15:26:20] [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 '' at line 1 [15:28:38] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [15:28:39] [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 '' at line 1 [15:30:33] [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 '' at line 1 [15:30:39] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [15:30:39] [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 '' at line 1 [15:59:03] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [15:59:03] [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 '' at line 1 [15:59:36] [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 '' at line 1 [15:59:43] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [15:59:43] [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 '' at line 1 [16:01:28] [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 '' at line 1 [16:01:35] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [16:01:35] [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 '' at line 1 [16:02:39] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [16:02:39] [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 '' at line 1 [16:03:02] [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 '' at line 1 [16:03:09] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [16:03:09] [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 '' at line 1 [16:16:44] [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 '' at line 1 [16:16:48] [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 '' at line 1 [16:16:51] [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 '' at line 1 [16:27:04] [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 '' at line 1 [18:52:29] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [18:52:29] [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 '' at line 1 [18:55:11] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [18:55:11] [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 '' at line 1 [19:02:56] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [19:02:56] [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 '' at line 1 [19:06:24] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [19:06:24] [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 '' at line 1 [19:12:05] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [19:12:05] [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 '' at line 1 [19:15:54] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [19:15:54] [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 '' at line 1 [19:23:46] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [19:23:46] [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 '' at line 1 [19:29:53] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [19:29:53] [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 '' at line 1 [19:31:49] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [19:31:49] [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 '' at line 1 [19:32:54] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [19:32:54] [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 '' at line 1 [19:34:30] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [19:34:30] [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 '' at line 1 [19:45:48] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [19:45:48] [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 '' at line 1 [19:46:13] [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 '' at line 1 [20:01:27] [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 '' at line 1 [20:03:07] [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 '' at line 1 [20:03:12] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [20:03:12] [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 '' at line 1 [20:03:20] [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 '' at line 1 [20:21:54] [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 '' at line 1 [20:22:56] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [20:22:56] [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 '' at line 1 [20:51:56] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [20:51:56] [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 '' at line 1 [21:21:37] [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 '' at line 1 [22:01:41] [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 '' at line 1 [22:06:36] [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 '' at line 1 [22:08:32] [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 '' at line 1 [17:05:08] [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 '' at line 1 [17:41:19] [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 '' at line 1 [17:41:39] [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 '' at line 1 [17:41: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 '' at line 1 [17:45:18] [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 '' at line 1 [18:05:32] [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 '' at line 1 [18:12:10] [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 '' at line 1 [18:40:04] [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 '' at line 1 [22:12:58] [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 ''9' at line 1 [22:13:04] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [22:13:04] [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 ''9' at line 1 [22:25:46] [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 '' at line 1 [22:25:53] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [22:25:53] [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 '' at line 1 [22:28:48] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [22:28:48] [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 '' at line 1 [22:38:01] [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 '' at line 1 [01:46:33] [ERROR] CMySQLQuery::Execute[] - (error #1136) Column count doesn't match value count at row 1 [01:55:09] [ERROR] CMySQLQuery::Execute[UploadPlayerAccountNumber] - (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 '`Sex` = '0' `Cash` = '970' `Level` = '1' `Admin` = '0' `Pohodka` = '0' ' at line 1 [01:58:33] [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 '`Sex` = '0' `Cash` = '970' `Level` = '1' `Admin` = '0' `Pohodka` = '0' ' at line 1 [01:58: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 '`Sex` = '0' `Cash` = '970' `Level` = '1' `Admin` = '0' `Pohodka` = '0' ' at line 1 [02:02:39] [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 '`Sex` = '2' `Cash` = '970' `Level` = '1' `Admin` = '0' `Pohodka` = '1' ' at line 1 [02:08:24] [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 '`Sex` = '1' `Cash` = '970' `Level` = '1' `Admin` = '0' `Pohodka` = '3' ' at line 1 [02:14:37] [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 '`Sex` = '1' `Cash` = '970' `Level` = '1' `Admin` = '0' `Pohodka` = '3' ' at line 1 [18:20:32] [ERROR] CMySQLQuery::Execute[] - (error #1146) Table '1ns1de.account' doesn't exist [23:25:09] [ERROR] CMySQLQuery::Execute[] - (error #1146) Table '1ns1de.account' doesn't exist [23:26:12] [ERROR] CMySQLQuery::Execute[] - (error #1146) Table '1ns1de.account' doesn't exist [23:47:15] [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 ''Cub_Andersonj' at line 1

Во-первых, ты где-то пытаешься обратиться к столбцу "ID", которого нет (у тебя столбец записан как "id")
Во-вторых, сделай так и скинь логи сервера после выхода с этого самого сервера

PHP код:

if(GetPVarInt(playerid, !"Logged") > 0) { new query[19+(7+3)+(6+1)+(7+11)+(8+11)+(8+2)+(10+2)+(7+2)+(8+2)+(7+1)+(14+MAX_PLAYER_NAME)+1] = "UPDATE account SET ";//19 format(query, sizeof(query), "%s Skin=%d,", query, PlayerInfo[playerid][pSkin]);//7+3 format(query, sizeof(query), "%s Sex=%d,", query, PlayerInfo[playerid][pSex]);//6+1 format(query, sizeof(query), "%s Cash=%d,", query, PlayerInfo[playerid][pCash]);//7+11 format(query, sizeof(query), "%s Level=%d,", query, PlayerInfo[playerid][pLevel]);//8+11 format(query, sizeof(query), "%s Admin=%d,", query, PlayerInfo[playerid][pAdmin]);//8+2 format(query, sizeof(query), "%s Pohodka=%d,", query, PlayerInfo[playerid][pPohodka]);//10+2 format(query, sizeof(query), "%s Rasa=%d,", query, PlayerInfo[playerid][pRasa]);//7+2 format(query, sizeof(query), "%s Yazik=%d,", query, PlayerInfo[playerid][pYazik]);//8+2 format(query, sizeof(query), "%s Gorod=%d", query, PlayerInfo[playerid][pGorod]);//7+1 format(query, sizeof(query), "%s WHERE Name='%s'", query, GN(playerid));//14+MAX_PLAYER_NAME mysql_function_query(mysql_connection, query, false, "", ""); printf("\n\n\n\n|%s|\n\n\n\n", query); }