Question

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, "", "");

 

Share this post


Link to post

4 answers to this question

  • 0

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

Share this post


Link to post
  • 0

@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'

 

Share this post


Link to post
  • 0

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

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

 

Share this post


Link to post
  • 0

@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

 

Share this post


Link to post
Guest
This topic is now closed to further replies.
Sign in to follow this  
Followers 0
  • Recently Browsing   0 members

    No registered users viewing this page.

  • Similar Content

    • Dexter Nomad
      By Dexter Nomad
      При попытке компиляции кода возникает ошибка:
      error 076: syntax error in the expression, or invalid function call
      Не могу найти причину, буду благодарен, если не только укажете, где сама ошибка, но еще и исправите ее.
      Сам код:
          if(strcmp(cmd, "/carsharing", true) == 0)     {         if(IsPlayerConnected(playerid))         {             if(PlayerInfo[playerid][CarLic] == 0) return SCM(playerid, COLOR_RED, "У вас нет вод.прав! Вы можете получить их в автошколе!");         }     }  
    • Sanya_Greison
      By Sanya_Greison
      Куплю РП мод под сервер без бонуса. Бюджет до 150 $
      А также скриптера с Украины
      мой вк vk.com/i_am_sashko