Не идет число в БД

[archiboy6 P Хороший 7]

format(STRING_GLOBAL, sizeof(STRING_GLOBAL), "UPDATE "T_GANG" SET grovepat=%d,ballaspat=%d,rifapat=%d,aztecpat=%d,vagospat=%d", GangPatr[0], GangPatr[1], GangPatr[2], GangPatr[3], GangPatr[4]);
			mysql_tquery(dbHandle, STRING_GLOBAL, "", "");

 

[Jawn Максимальный 346]

@archiboy6, ну, посмотрите в в логах MySQL, есть что толковое там?

[archiboy6 P Хороший 7]

@odosenok 

[05:01:10] [WARNING] CMySQLConnection::Disconnect - no connection available
[06:00:00] [ERROR] CMySQLQuery::Execute[] - (error #1054) Unknown column 'mafia' in 'field list'
[12:00:00] [ERROR] CMySQLQuery::Execute[] - (error #1054) Unknown column 'mafia' in 'field list'
[12:04:43] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('751')
[12:06:57] [ERROR] CMySQLQuery::Execute[] - (error #1054) Unknown column 'mafia' in 'field list'
[12:07:12] [ERROR] CMySQLQuery::Execute - (error #1062) Duplicate entry '1' for key 'PRIMARY'
[15:04:44] [WARNING] CMySQLResult::GetRowDataByName - field not found ("amount")
[15:04:44] [ERROR] cache_get_field_content_int - invalid datatype
[15:10:17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("amount")
[15:10:17] [ERROR] cache_get_field_content_int - invalid datatype
[15:36:31] [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 ''Giuseppe_Moretti' at line 1
[15:36:31] [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 ''Mishannya_Zapadn' at line 1
[15:37:21] [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 ''Giuseppe_Moretti' at line 1
[15:37:21] [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 ''Mishannya_Zapadn' at line 1
[16:00:00] [ERROR] CMySQLQuery::Execute[] - (error #1054) Unknown column 'mafia' in 'field list'

 

[Jawn Максимальный 346]

@archiboy6, вы уверены, что этот запрос вообще выполняется? Попробуйте после mysql_tquery дописать:

/**/printf("[DEBUG] %s", STRING_GLOBAL); // в начале специально написал, чтобы сбить табуляцию и вы получили предупреждение. Иначе можете забыть убрать эту строку

 

[archiboy6 P Хороший 7]

@odosenok server_logs в mmysql ничего

[16:43:18] Giuseppe_Moretti[0] - dialogid: 4003 response: 1 listitem: -1 inputtext: 1000000
[16:43:18] [DEBUG] UPDATE `gang` SET grovebank=0,ballasbank=1000000,rifabank=0,aztecbank=0,vagosbank=0