Проблема с Базой Данных

[Гость]

Помогите исправить данную ошибку, если надо что-то еще пишите кину!
 

[07:25:33] [ERROR] cache_get_row_int - invalid datatype
[07:25:33] [ERROR] cache_get_row_int - invalid datatype
[07:25:33] [ERROR] CMySQLQuery::Execute[] - (error #1054) Unknown column 'online' in 'field list'
[07:25:33] [ERROR] CMySQLQuery::Execute[] - (error #1054) Unknown column 'online' in 'field list'
[07:31:24] [ERROR] CMySQLQuery::Execute[] - (error #1054) Unknown column 'online' in 'field list'
[07:31:24] [ERROR] CMySQLQuery::Execute[] - (error #1054) Unknown column 'online' in 'field list'
[07:31: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 'WHERE `name` = 'Jaliba_Baron'' at line 1

 

[Гость stibs]

Эту строку:

f(string, "%s `fwarn` = '%d', ",               string, PI[playerid][pfWarn]);

Замените на эту:

f(string, "%s `fwarn` = '%d' ",               string, PI[playerid][pfWarn]);

 

[Гость stibs]

Здравствуйте. Данная проблема возникла вследствие неверного mySQL запроса. А точнее, не найдена колонка "online" в аккаунте игрока. 

Если не знаете, в каком запросе ошибка, то:

Вставьте этот код в public OnQueryError (если такой есть):
 

printf("[DEBUG]: error: %d, errorname: %s, callback: %s, querystr: %s, connection id: %d", errorid, error, callback, query, connectionHandle);

Если паблика OnQueryError нет, то вставьте:

public OnQueryError(errorid, error[], callback[], query[], connectionHandle)
{
    printf("[DEBUG]: error: %d, errorname: %s, callback: %s, querystr: %s, connection id: %d", errorid, error, callback, query, connectionHandle);
    return true;
}

И скиньте логи сервера (файл server_log.txt) после очередного появления ошибки.

Отредактировано 30 июля, 2017 пользователем stibs

[Гость]

@stibs я каким та оброзам смог упривать ошибку 1054, а ошибка под номером 1064 осталось, и не нашол "public OnQueryError" и "OnQueryError"

Помоги что нужно?

[Гость stibs]

@Daniil Roslyakov просто киньте данный код в любое место мода, главное не в сток и не в паблик: 

public OnQueryError(errorid, error[], callback[], query[], connectionHandle)
{
    printf("[DEBUG]: error: %d, errorname: %s, callback: %s, querystr: %s, connection id: %d", errorid, error, callback, query, connectionHandle);
    return true;
}

Потом скомплируйте мод, вызовите эту ошибку и выложите логи (server_log.txt). 

[Гость]

@stibs  вот

 

Server_log

  Логи (открыть спойлер)

----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3e, (C)2005-2012 SA-MP Team

[15:05:39] filterscripts = ""  (string)
[15:05:39] 
[15:05:39] Server Plugins
[15:05:39] --------------
[15:05:39]  Loading plugin: crashdetect.so
[15:05:39]   CrashDetect v4.15.1 is OK.
[15:05:39]   Loaded.
[15:05:39]  Loading plugin: streamer.so
[15:05:39] 

*** Streamer Plugin v2.8.2 by Incognito loaded ***

[15:05:39]   Loaded.
[15:05:39]  Loading plugin: sscanf.so
[15:05:39] 

[15:05:39]  ===============================

[15:05:39]       sscanf plugin loaded.     

[15:05:39]          Version:  2.8.1        

[15:05:39]    (c) 2012 Alex "Y_Less" Cole  

[15:05:39]  ===============================

[15:05:39]   Loaded.
[15:05:39]  Loading plugin: mysql_static.so
[15:05:39]  >> plugin.mysql: R39-5 successfully loaded.
[15:05:39]   Loaded.
[15:05:39]  Loading plugin: CRP.so
[15:05:39] 

[15:05:39] ______________________________________

[15:05:39]  Convert Rus To Pwn v0.1.1 loaded
[15:05:39] ______________________________________

[15:05:39]  By: Fro (c) Copyright <TBG> 2009-2011
[15:05:39] ______________________________________

[15:05:39]   Loaded.
[15:05:39]  Loading plugin: regex.so
[15:05:39] 


[15:05:39] ______________________________________


[15:05:39]  Regular Expression Plugin v0.2.1 loaded
[15:05:39] ______________________________________


[15:05:39]  By: Fro (c) Copyright <TBG> 2009-2011
[15:05:39] ______________________________________


[15:05:39]   Loaded.
[15:05:39]  Loading plugin: dc_cmd.so
[15:05:39]   Daniel's CMD plugin v2.8
[15:05:39]     (c) 2014 Daniel_Cortez
[15:05:39] 	www.pro-pawn.ru
[15:05:39]   Loaded.
[15:05:39]  Loaded 7 plugins.

[15:05:39] 
[15:05:39] Ban list
[15:05:39] --------
[15:05:39]  Loaded: samp.ban
[15:05:39] 
[15:05:39] 
[15:05:39] Filterscripts
[15:05:39] ---------------
[15:05:39]   Loaded 0 filterscripts.

[15:05:39] Incoming connection: 185.17.135.222:2077
[15:05:39]  
[15:05:39]  
[15:05:39]  
[15:05:39]  ======================================= 
[15:05:39]  |                                     | 
[15:05:39]  |        YSI version 3.09.0684        | 
[15:05:39]  |        By Alex "Y_Less" Cole        | 
[15:05:39]  |                                     | 
[15:05:39]  ======================================= 
[15:05:39]  
[15:05:39] [MySQL]: Подключение к базе данных прошло успешно
[15:05:39] Number of vehicle models: 10
[15:05:39] [Загружено орг/раб. автомобилей]: <135>. Потрачено: <3 ms>.
[15:05:39] [Загружено рангов для фракций]: <12>. Потрачено: <0 ms>.
[15:05:39] [Загружено бизнесов]: <0>. Потрачено: <0 ms>.
[15:05:39] [Загружено домов]: <0>. Потрачено: <0 ms>.
[15:05:39] [Загружены склады мафий]: Потрачено: <0 ms>.
[15:05:39] [Загружены склады ОПГ]: Потрачено: <0 ms>.
[15:05:39] [Загружено банкоматов]: <0>. Потрачено: <0 ms>.
[15:05:39] [Загружено остальное]: Потрачено: <0 ms>.
[15:05:39] [Загружено радаров]: <0>. Потрачено: <0 ms>.
[15:05:39] [System Hotels]: 50 hotels successfully loaded
[15:05:39] Incoming connection: 89.145.154.128:54387
[15:05:40] [join] Jaliba_Baron has joined the server (1:89.145.154.128)
[15:05:51] [join] Luka_Popov has joined the server (0:185.17.135.222)
[15:21:07] [chat] [Luka_Popov]: если что админку даш ок?
[15:33:13] [part] Luka_Popov has left the server (0:1)
[15:33:13] [DEBUG]: error: 1064, errorname: 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 'WHERE `name` = 'Luka_Popov'' at line 1, callback: , querystr: UPDATE `accounts` SET `name` = 'Luka_Popov',  `ip` = '185.17.135.222',  `admin` = '0',  `securitycode` = '0',  `level` = '1',  `cash` = '500',  `bank` = '0',  `exp` = '0',  `leader` = '0',  `templeader` = '0',  `member` = '0',  `rank` = '0',  `warn` = '0',  `sex` = '1',  `age` = '23',  `model` = '289',  `memberskin` = '0',  `lic` = '0, 0, 0, 0',  `mute` = '0',  `pick` = '0',  `checktime` = '256',  `news` = '0',  `phonenumber` = '0',  `jail` = '0',  `jailtime` = '0',  `wanted` = '0',  `wantedtime` = '0',  `wantedwho` = 'None',  `wantedreason` = 'None',  `heal` = '100.000000',  `drugs` = '0',  `patron` = '0',  `gunamount` = '0',  `crimes` = '0',  `job` = '0',  `married` = '0',  `whomarried` = 'None',  `paycheck` = '0',  `charity` = '0',  `vip` = '0',  `viptime` = '0',  `time` = '0',  `fstyle` = '0',  `credits` = '0',  `totalcredits` = '0',  `skin1` = '0',  `skin2` = '0',  `skin3` = 'Luka_Popov',  `spawnchange` = '0',  `sdpistol` = '0',  `deserteagle` = '0',  `shotgun` = '0',  `mp5` = '0',  `ak47` = '0',  `m4` = '0',  `pistol` = '0',  `microuzi` = '0',  `hunger` = '94',  `healths` = '100.000000',  `sportexp` = '0',  `zakon` = '0',  `city` = '0',  `repcar` = '0, 0',  `bed` = '0',  `watch` = '0',  `ciggare` = '0',  `sprunk` = '0',  `mask` = '0',  `phonebalance` = '100',  `truckskill` = '0',  `veh_number` = 'Транзит/Транзит',  `cModel` = '0/0',  `cClass` = '1/1',  `cFuel` = '0/0',  `cMilleage` = '0.000000/0.000000',  `cColor1` = '0/0',  `cColor2` = '0/0',  `cLock` = '0/0',  `cCost` = '0/0',  `cVehcom` = '0,0,0,0,0,0,0,0,0,0,0,0,0,0/0,0,0,0,0,0,0,0,0,0,0,0,0,0',  `cPaintjob` = '3/3',  `cVirtual` = '0/0',  `cX` = '0.000000/0.000000',  `cY` = '0.000000/0.000000',  `cZ` = '0.000000/0.000000',  `cA` = '0.000000/0.000000',  `vehiclekey` = '0',  `vehiclekey1` = '0',  `aptechka` = '0',  `Voennik` = '0',  `music` = '0',  `improves` = '0, 0, 0, 0',  `settings` = '1, 1, 1, 1, 1, 1, 1',  `phnumber1` = '0',  `phnumber2` = '0',  `phnumber3` = '0',  `phnumber4` = '0',  `phnumber5` = '0',  `phnumber6` = '0',  `phnumber7` = '0',  `fishki` = '0',  `thour` = '256',  `tday` = '256',  `tlastday` = '0',  `balon1` = '0',  `balon2` = '0',  `balon3` = '0',  `balon4` = '0',  `balon5` = '0',  `balon6` = '0',  `balon7` = '0',  `remont` = '0',  `sleep` = '94',  `fwarn` = '0',  WHERE `name` = 'Luka_Popov', connection id: 1
[15:33:13] [debug] Server crashed while executing stel.amx
[15:33:13] [debug] AMX backtrace:
[15:33:13] [debug] #0 native printf () from samp03svr-cr
[15:33:13] [debug] #1 005a8870 in public OnQueryError (errorid=1064, error[]=@00286be0 "You have an error in your SQL syntax; check the manual that corresponds to your ...", callback[]=@00286bdc "", query[]=@002847c0 "UPDATE `accounts` SET `name` = 'Luka_Popov',  `ip` = '185.17.135.222',  `admin` ...", connectionHandle=1) at C:\Users\Даниил\Desktop\STEL NEW\gamemodes\stel.pwn:2939

----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3e, (C)2005-2012 SA-MP Team

[15:35:57] filterscripts = ""  (string)
[15:35:57] 
[15:35:57] Server Plugins
[15:35:57] --------------
[15:35:57]  Loading plugin: crashdetect.so
[15:35:57]   CrashDetect v4.15.1 is OK.
[15:35:57]   Loaded.
[15:35:57]  Loading plugin: streamer.so
[15:35:57] 

*** Streamer Plugin v2.8.2 by Incognito loaded ***

[15:35:57]   Loaded.
[15:35:57]  Loading plugin: sscanf.so
[15:35:57] 

[15:35:57]  ===============================

[15:35:57]       sscanf plugin loaded.     

[15:35:57]          Version:  2.8.1        

[15:35:57]    (c) 2012 Alex "Y_Less" Cole  

[15:35:57]  ===============================

[15:35:57]   Loaded.
[15:35:57]  Loading plugin: mysql_static.so
[15:35:57]  >> plugin.mysql: R39-5 successfully loaded.
[15:35:57]   Loaded.
[15:35:57]  Loading plugin: CRP.so
[15:35:57] 

[15:35:57] ______________________________________

[15:35:57]  Convert Rus To Pwn v0.1.1 loaded
[15:35:57] ______________________________________

[15:35:57]  By: Fro (c) Copyright <TBG> 2009-2011
[15:35:57] ______________________________________

[15:35:57]   Loaded.
[15:35:57]  Loading plugin: regex.so
[15:35:57] 


[15:35:57] ______________________________________


[15:35:57]  Regular Expression Plugin v0.2.1 loaded
[15:35:57] ______________________________________


[15:35:57]  By: Fro (c) Copyright <TBG> 2009-2011
[15:35:57] ______________________________________


[15:35:57]   Loaded.
[15:35:57]  Loading plugin: dc_cmd.so
[15:35:57]   Daniel's CMD plugin v2.8
[15:35:57]     (c) 2014 Daniel_Cortez
[15:35:57] 	www.pro-pawn.ru
[15:35:57]   Loaded.
[15:35:57]  Loaded 7 plugins.

[15:35:57] 
[15:35:57] Ban list
[15:35:57] --------
[15:35:57]  Loaded: samp.ban
[15:35:57] 
[15:35:57] 
[15:35:57] Filterscripts
[15:35:57] ---------------
[15:35:57]   Loaded 0 filterscripts.

[15:35:58]  
[15:35:58]  
[15:35:58]  
[15:35:58]  ======================================= 
[15:35:58]  |                                     | 
[15:35:58]  |        YSI version 3.09.0684        | 
[15:35:58]  |        By Alex "Y_Less" Cole        | 
[15:35:58]  |                                     | 
[15:35:58]  ======================================= 
[15:35:58]  
[15:35:58] [MySQL]: Подключение к базе данных прошло успешно
[15:35:58] Number of vehicle models: 10
[15:35:58] [Загружено орг/раб. автомобилей]: <135>. Потрачено: <2 ms>.
[15:35:58] [Загружено рангов для фракций]: <12>. Потрачено: <0 ms>.
[15:35:58] [Загружено бизнесов]: <0>. Потрачено: <0 ms>.
[15:35:58] [Загружено домов]: <0>. Потрачено: <0 ms>.
[15:35:58] [Загружены склады мафий]: Потрачено: <0 ms>.
[15:35:58] [Загружены склады ОПГ]: Потрачено: <0 ms>.
[15:35:58] [Загружено банкоматов]: <0>. Потрачено: <0 ms>.
[15:35:58] [Загружено остальное]: Потрачено: <0 ms>.
[15:35:58] [Загружено радаров]: <0>. Потрачено: <0 ms>.
[15:35:58] [System Hotels]: 50 hotels successfully loaded
[15:38:33] Incoming connection: 89.145.154.128:52794
[15:38:33] [join] Jaliba_Baron has joined the server (0:89.145.154.128)
[15:42:40] [part] Jaliba_Baron has left the server (0:1)
[15:42:40] [DEBUG]: error: 1064, errorname: 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 'WHERE `name` = 'Jaliba_Baron'' at line 1, callback: , querystr: UPDATE `accounts` SET `name` = 'Jaliba_Baron',  `ip` = '89.145.154.128',  `admin` = '0',  `securitycode` = '0',  `level` = '1',  `cash` = '780',  `bank` = '0',  `exp` = '0',  `leader` = '0',  `templeader` = '0',  `member` = '0',  `rank` = '0',  `warn` = '0',  `sex` = '1',  `age` = '18',  `model` = '161',  `memberskin` = '0',  `lic` = '0, 0, 0, 0',  `mute` = '0',  `pick` = '0',  `checktime` = '187',  `news` = '0',  `phonenumber` = '0',  `jail` = '0',  `jailtime` = '0',  `wanted` = '0',  `wantedtime` = '0',  `wantedwho` = 'None',  `wantedreason` = 'None',  `heal` = '95.000000',  `drugs` = '0',  `patron` = '0',  `gunamount` = '0',  `crimes` = '0',  `job` = '0',  `married` = '0',  `whomarried` = 'None',  `paycheck` = '0',  `charity` = '0',  `vip` = '0',  `viptime` = '0',  `time` = '0',  `fstyle` = '0',  `credits` = '0',  `totalcredits` = '0',  `skin1` = '0',  `skin2` = '0',  `skin3` = 'Jaliba_Baron',  `spawnchange` = '0',  `sdpistol` = '0',  `deserteagle` = '0',  `shotgun` = '0',  `mp5` = '0',  `ak47` = '0',  `m4` = '0',  `pistol` = '0',  `microuzi` = '0',  `hunger` = '99',  `healths` = '100.000000',  `sportexp` = '0',  `zakon` = '0',  `city` = '0',  `repcar` = '0, 0',  `bed` = '0',  `watch` = '0',  `ciggare` = '0',  `sprunk` = '0',  `mask` = '0',  `phonebalance` = '100',  `truckskill` = '0',  `veh_number` = 'Транзит/Транзит',  `cModel` = '0/0',  `cClass` = '1/1',  `cFuel` = '0/0',  `cMilleage` = '0.000000/0.000000',  `cColor1` = '0/0',  `cColor2` = '0/0',  `cLock` = '0/0',  `cCost` = '0/0',  `cVehcom` = '0,0,0,0,0,0,0,0,0,0,0,0,0,0/0,0,0,0,0,0,0,0,0,0,0,0,0,0',  `cPaintjob` = '3/3',  `cVirtual` = '0/0',  `cX` = '0.000000/0.000000',  `cY` = '0.000000/0.000000',  `cZ` = '0.000000/0.000000',  `cA` = '0.000000/0.000000',  `vehiclekey` = '0',  `vehiclekey1` = '0',  `aptechka` = '0',  `Voennik` = '0',  `music` = '0',  `improves` = '0, 0, 0, 0',  `settings` = '1, 1, 1, 1, 1, 1, 1',  `phnumber1` = '0',  `phnumber2` = '0',  `phnumber3` = '0',  `phnumber4` = '0',  `phnumber5` = '0',  `phnumber6` = '0',  `phnumber7` = '0',  `fishki` = '0',  `thour` = '187',  `tday` = '187',  `tlastday` = '0',  `balon1` = '0',  `balon2` = '0',  `balon3` = '0',  `balon4` = '0',  `balon5` = '0',  `balon6` = '0',  `balon7` = '0',  `remont` = '0',  `sleep` = '99',  `fwarn` = '0',  WHERE `name` = 'Jaliba_Baron', connection id: 1
[15:42:40] [debug] Server crashed while executing stel.amx
[15:42:40] [debug] AMX backtrace:
[15:42:40] [debug] #0 native printf () from samp03svr-cr
[15:42:40] [debug] #1 005a8870 in public OnQueryError (errorid=1064, error[]=@00286bf4 "You have an error in your SQL syntax; check the manual that corresponds to your ...", callback[]=@00286bf0 "", query[]=@002847c0 "UPDATE `accounts` SET `name` = 'Jaliba_Baron',  `ip` = '89.145.154.128',  `admin...", connectionHandle=1) at C:\Users\Даниил\Desktop\STEL NEW\gamemodes\stel.pwn:2939

[15:33: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 'WHERE `name` = 'Luka_Popov'' at line 1
[15:42:40] [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 'WHERE `name` = 'Jaliba_Baron'' at line 1

 

mySQL_log

Отредактировано 30 июля, 2017 пользователем vlad
Причина: Взял логи под спойлер

[Гость stibs]

@Daniil Roslyakov Удалите этот паблик, который я вам скинул, и сделайте вот что. 

Найдите строку в моде такого рода, скорее всего она находится в сохранении игрока:

`remont` = '%d',  `sleep` = '%d',  `fwarn` = '%d',  WHERE `name` = '%s'

И в ней уберите запятую перед WHERE `name`

и получится вот так:

`remont` = '%d',  `sleep` = '%d',  `fwarn` = '%d'  WHERE `name` = '%s'

 

[Гость]

@stibs нету такого, что делать?

[Гость stibs]

@Daniil Roslyakov Скиньте паблик / сток сохранения. Он должен называться по типу SaveAccount SavePlayer или что-то в этом роде. 

[Гость]

@stibs 

  Паблик (открыть спойлер)

stock SaveAccount(playerid)
{
	if(PlayerLogged[playerid] == false || IsPlayerConnected(playerid) == 0) return 1;
	new zapros[128];
	
	format(PI[playerid][pSettings],64,"%i, %i, %i, %i, %i, %i, %i",PI[playerid][pSetting][0],PI[playerid][pSetting][1],PI[playerid][pSetting][2],PI[playerid][pSetting][3],PI[playerid][pSetting][4],PI[playerid][pSetting][5],PI[playerid][pSetting][6]);
	format(PI[playerid][pImproves],64,"%i, %i, %i, %i",PI[playerid][pImprove][0],PI[playerid][pImprove][1],PI[playerid][pImprove][2],PI[playerid][pImprove][3]);
	format(PI[playerid][pLics],64,"%i, %i, %i, %i",PI[playerid][pLic][0],PI[playerid][pLic][1],PI[playerid][pLic][2],PI[playerid][pLic][3]);
	format(PI[playerid][pRepcars],64,"%i, %i",PI[playerid][pRepcar][0],PI[playerid][pRepcar][1]);
	
	new string[3128] = "UPDATE "T_ACCOUNTS" SET";
	
	f(string, "%s `name` = '%s', ",                string, PI[playerid][pName]);
	f(string, "%s `ip` = '%s', ",                  string, PI[playerid][pIP]);
	f(string, "%s `admin` = '%d', ",               string, PI[playerid][pAdmin]);
	f(string, "%s `securitycode` = '%i', ",        string, PI[playerid][pSecurityCode]);
	f(string, "%s `level` = '%d', ",               string, PI[playerid][pLevel]);
	f(string, "%s `cash` = '%d', ",                string, PI[playerid][pCash]);
	f(string, "%s `bank` = '%d', ",                string, PI[playerid][pBank]);
	f(string, "%s `exp` = '%d', ",                 string, PI[playerid][pExp]);
	f(string, "%s `leader` = '%d', ",              string, PI[playerid][pLeader]);
	f(string, "%s `templeader` = '%d', ",          string, PI[playerid][pTempLeader]);
	f(string, "%s `member` = '%d', ",              string, PI[playerid][pMember]);
	f(string, "%s `rank` = '%d', ",                string, PI[playerid][pRank]);
	f(string, "%s `warn` = '%d', ",                string, PI[playerid][pWarn]);
	f(string, "%s `sex` = '%d', ",                 string, PI[playerid][pSex]);
	f(string, "%s `age` = '%d', ",                 string, PI[playerid][pAge]);
	f(string, "%s `model` = '%d', ",               string, PI[playerid][pModel]);
	f(string, "%s `memberskin` = '%d', ",          string, PI[playerid][pMemberSkin]);
    f(string, "%s `lic` = '%s', ",                 string, PI[playerid][pLics]);
	f(string, "%s `mute` = '%d', ",                string, PI[playerid][pMuted]);
	f(string, "%s `pick` = '%d', ",                string, PI[playerid][pPick]);
	f(string, "%s `checktime` = '%d', ",           string, PI[playerid][pCheckTime]);
	f(string, "%s `news` = '%d', ",                string, PI[playerid][pNews]);
	f(string, "%s `phonenumber` = '%d', ",         string, PI[playerid][pPhoneNumber]);
	f(string, "%s `jail` = '%d', ",                string, PI[playerid][pJail]);
	f(string, "%s `jailtime` = '%d', ",            string, PI[playerid][pJailTime]);
	f(string, "%s `wanted` = '%d', ",              string, PI[playerid][pWanted]);
	f(string, "%s `wantedtime` = '%d', ",          string, PI[playerid][pWantedTime]);
	f(string, "%s `wantedwho` = '%s', ",           string, PI[playerid][pWantedWho]);
	f(string, "%s `wantedreason` = '%s', ",        string, PI[playerid][pWantedReason]);
	f(string, "%s `heal` = '%f', ",                string, PI[playerid][pHeal]);
	f(string, "%s `drugs` = '%d', ",               string, PI[playerid][pDrugs]);
	f(string, "%s `patron` = '%d', ",              string, PI[playerid][pPatron]);
	f(string, "%s `gunamount` = '%d', ",           string, PI[playerid][pGunAmount]);
	f(string, "%s `crimes` = '%d', ",              string, PI[playerid][pCrimes]);
	f(string, "%s `job` = '%d', ",                 string, PI[playerid][pJob]);
	f(string, "%s `married` = '%d', ",             string, PI[playerid][pMarried]);
	f(string, "%s `whomarried` = '%s', ",          string, PI[playerid][pWhoMarried]);
	f(string, "%s `paycheck` = '%d', ",            string, PI[playerid][pPayCheck]);
	f(string, "%s `charity` = '%d', ",             string, PI[playerid][pCharity]);
	f(string, "%s `vip` = '%d', ",                 string, PI[playerid][pVip]);
	f(string, "%s `viptime` = '%d', ",             string, PI[playerid][pVipTime]);
	f(string, "%s `time` = '%d', ",                string, PI[playerid][pTime]);
	f(string, "%s `fstyle` = '%d', ",              string, PI[playerid][pFightStyle]);
	f(string, "%s `credits` = '%d', ",             string, PI[playerid][pCredits]);
	f(string, "%s `totalcredits` = '%d', ",        string, PI[playerid][pTotalCredits]);
	f(string, "%s `skin1` = '%d', ",               string, PI[playerid][pSkin][0]);
	f(string, "%s `skin2` = '%d', ",               string, PI[playerid][pSkin][1]);
	f(string, "%s `skin3` = '%s', ",               string, PI[playerid][pName]);
	f(string, "%s `spawnchange` = '%d', ",         string, PI[playerid][pSpawnChange]);
	f(string, "%s `sdpistol` = '%d', ",            string, PI[playerid][pGunSkill][0]);
	f(string, "%s `deserteagle` = '%d', ",         string, PI[playerid][pGunSkill][1]);
	f(string, "%s `shotgun` = '%d', ",             string, PI[playerid][pGunSkill][2]);
	f(string, "%s `mp5` = '%d', ",                 string, PI[playerid][pGunSkill][3]);
	f(string, "%s `ak47` = '%d', ",                string, PI[playerid][pGunSkill][4]);
	f(string, "%s `m4` = '%d', ",                  string, PI[playerid][pGunSkill][5]);
	f(string, "%s `pistol` = '%d', ",              string, PI[playerid][pGunSkill][6]);
	f(string, "%s `microuzi` = '%d', ",            string, PI[playerid][pGunSkill][7]);
	f(string, "%s `hunger` = '%d', ",              string, PI[playerid][pHunger]);
	f(string, "%s `healths` = '%f', ",             string, PI[playerid][pHealthS]);
	f(string, "%s `sportexp` = '%d', ",            string, PI[playerid][pSportExp]);
	f(string, "%s `zakon` = '%d', ",               string, PI[playerid][pZakon]);
	f(string, "%s `city` = '%d', ",                string, PI[playerid][pCity]);
	f(string, "%s `repcar` = '%s', ",              string, PI[playerid][pRepcars]);
	f(string, "%s `bed` = '%d', ",                 string, PI[playerid][pBed]);
	f(string, "%s `watch` = '%d', ",               string, PI[playerid][pWatch]);
	f(string, "%s `ciggare` = '%d', ",             string, PI[playerid][pCiggare]);
	f(string, "%s `sprunk` = '%d', ",              string, PI[playerid][pSprunk]);
	f(string, "%s `mask` = '%d', ",                string, PI[playerid][pMask]);
	f(string, "%s `phonebalance` = '%d', ",        string, PI[playerid][pPhoneBalance]);
	f(string, "%s `truckskill` = '%d', ",          string, PI[playerid][pTruckSkill]);
	//---Àâòîìîáèëè-------------------------------------------------------------
	format(zapros,sizeof(zapros),"%s/%s",cNumberVehicle[playerid][0],cNumberVehicle[playerid][1]);
	f(string, "%s `veh_number` = '%s', ",          string, zapros);
	
	format(zapros,sizeof(zapros),"%i/%i",cModel[playerid][0],cModel[playerid][1]);
	f(string, "%s `cModel` = '%s', ",              string, zapros);
	
	format(zapros,sizeof(zapros),"%i/%i",cClass[playerid][0],cClass[playerid][1]);
	f(string, "%s `cClass` = '%s', ",              string, zapros);
	
	format(zapros,sizeof(zapros),"%i/%i",cFuel[playerid][0],cFuel[playerid][1]);
	f(string, "%s `cFuel` = '%s', ",               string, zapros);
	
	format(zapros,sizeof(zapros),"%f/%f",cMilleage[playerid][0],cMilleage[playerid][1]);
	f(string, "%s `cMilleage` = '%s', ",           string, zapros);
	
	format(zapros,sizeof(zapros),"%i/%i",cColor0[playerid][0], cColor0[playerid][1]);
	f(string, "%s `cColor1` = '%s', ",             string, zapros);
	
	format(zapros,sizeof(zapros),"%i/%i",cColor1[playerid][0], cColor1[playerid][1]);
	f(string, "%s `cColor2` = '%s', ",             string, zapros);
	
	format(zapros,sizeof(zapros),"%i/%i",cLock[playerid][0],cLock[playerid][1]);
	f(string, "%s `cLock` = '%s', ",               string, zapros);
	
	format(zapros,sizeof(zapros),"%i/%i",cCost[playerid][0],cCost[playerid][1]);
	f(string, "%s `cCost` = '%s', ",               string, zapros);
	
	format(cVehcom3[playerid],128,"%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d/%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d",
	cVehcoms1[playerid][0], cVehcoms1[playerid][1], cVehcoms1[playerid][2],
	cVehcoms1[playerid][3], cVehcoms1[playerid][4], cVehcoms1[playerid][5],
	cVehcoms1[playerid][6], cVehcoms1[playerid][7], cVehcoms1[playerid][8],
	cVehcoms1[playerid][9], cVehcoms1[playerid][10], cVehcoms1[playerid][11],
	cVehcoms1[playerid][12], cVehcoms1[playerid][13],
	cVehcoms2[playerid][0],cVehcoms2[playerid][1], cVehcoms2[playerid][2],
	cVehcoms2[playerid][3],cVehcoms2[playerid][4], cVehcoms2[playerid][5],
	cVehcoms2[playerid][6],cVehcoms2[playerid][7], cVehcoms2[playerid][8],
	cVehcoms2[playerid][9],cVehcoms2[playerid][10], cVehcoms2[playerid][11],
	cVehcoms2[playerid][12],cVehcoms2[playerid][13]);
	f(string, "%s `cVehcom` = '%s', ",             string, cVehcom3[playerid]);
	
	format(zapros,sizeof(zapros),"%i/%i",cPaintjob[playerid][0],cPaintjob[playerid][1]);
	f(string, "%s `cPaintjob` = '%s', ",           string, zapros);
	
	format(zapros,sizeof(zapros),"%i/%i",cVirtual[playerid][0],cVirtual[playerid][1]);
	f(string, "%s `cVirtual` = '%s', ",            string, zapros);
	
	format(zapros,sizeof(zapros),"%f/%f",CarParkX[playerid][0],CarParkX[playerid][1]);
	f(string, "%s `cX` = '%s', ",                  string, zapros);

	format(zapros,sizeof(zapros),"%f/%f",CarParkY[playerid][0],CarParkY[playerid][1]);
	f(string, "%s `cY` = '%s', ",                  string, zapros);
	
	format(zapros,sizeof(zapros),"%f/%f",CarParkZ[playerid][0],CarParkZ[playerid][1]);
	f(string, "%s `cZ` = '%s', ",                  string, zapros);
	
	format(zapros,sizeof(zapros),"%f/%f",CarParkA[playerid][0],CarParkA[playerid][1]);
	f(string, "%s `cA` = '%s', ",                  string, zapros);
	//--------------------------------------------------------------------------
	f(string, "%s `vehiclekey` = '%d', ",          string, PI[playerid][pVehicleKey][0]);
	f(string, "%s `vehiclekey1` = '%d', ",         string, PI[playerid][pVehicleKey][0]);
	f(string, "%s `aptechka` = '%d', ",            string, PI[playerid][pAptechka]);
	f(string, "%s `Voennik` = '%d', ",             string, PI[playerid][pVoennik]);
	f(string, "%s `music` = '%d', ",               string, PI[playerid][pMusic]);
	f(string, "%s `improves` = '%s', ",            string, PI[playerid][pImproves]);
	f(string, "%s `settings` = '%s', ",            string, PI[playerid][pSettings]);
	f(string, "%s `phnumber1` = '%i', ",           string, PhoneNumbers[playerid][0]);
	f(string, "%s `phnumber2` = '%i', ",           string, PhoneNumbers[playerid][1]);
	f(string, "%s `phnumber3` = '%i', ",           string, PhoneNumbers[playerid][2]);
	f(string, "%s `phnumber4` = '%i', ",           string, PhoneNumbers[playerid][3]);
	f(string, "%s `phnumber5` = '%i', ",           string, PhoneNumbers[playerid][4]);
	f(string, "%s `phnumber6` = '%i', ",           string, PhoneNumbers[playerid][5]);
	f(string, "%s `phnumber7` = '%i', ",           string, PhoneNumbers[playerid][6]);
	f(string, "%s `fishki` = '%i', ",              string, PI[playerid][pFishkis]);
	f(string, "%s `thour` = '%d', ",               string, PI[playerid][pTimeHour]);
	f(string, "%s `tday` = '%d', ",                string, PI[playerid][pTimeDay]);
	f(string, "%s `tlastday` = '%d', ",            string, PI[playerid][pTimeLastDay]);
	f(string, "%s `balon1` = '%d', ",              string, PI[playerid][pBalon][0]);
	f(string, "%s `balon2` = '%d', ",              string, PI[playerid][pBalon][1]);
	f(string, "%s `balon3` = '%d', ",              string, PI[playerid][pBalon][2]);
	f(string, "%s `balon4` = '%d', ",              string, PI[playerid][pBalon][3]);
	f(string, "%s `balon5` = '%d', ",              string, PI[playerid][pBalon][4]);
	f(string, "%s `balon6` = '%d', ",              string, PI[playerid][pBalon][5]);
	f(string, "%s `balon7` = '%d', ",              string, PI[playerid][pBalon][6]);
    f(string, "%s `remont` = '%d', ",              string, PI[playerid][pRemontNabor]);
	f(string, "%s `sleep` = '%d', ",               string, PI[playerid][pSleep]);
	f(string, "%s `fwarn` = '%d', ",               string, PI[playerid][pfWarn]);
	
	f(string, "%s WHERE `name` = '%s'", 		   string, PI[playerid][pName]);
	mysql_function_query(dbHandle, string, false, "", "");
	return 1;
}

Отредактировано 30 июля, 2017 пользователем vlad
Причина: взял код под спойлер

[Гость]

@stibs заменил

[Гость stibs]

@Daniil Roslyakov Теперь пробуйте, если ошибка исчезла нажмите на галочку возле правильного ответа, если нет, то опять скиньте mysql_log. 

[Гость]

СПАСИБО БОЛЬШОЕ МИЛЛИОН ПЛЮСОВ ТЕБЕ!!!!!!!!!!!!!!