Если Вы нашли ответ на вопрос, пожалуйста, пометьте необходимый ответ лучшим (галочка сбоку от сообщения) и поблагодарите автора этого ответа поднятием репутации (плюс в нижней правой части сообщения). Спасибо.
Подробнее:
FAQ по форуму
Как пометить ответ лучшим

Вопросы

Гость
Новичок

Помогите, не понимаю в чем ошибка, с базой данных особо не дружу, подключено все верно, как на локальной сети, так и на хостинге не работает
 

Спойлер

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

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

[11:47:57] 
[11:47:57] Server Plugins
[11:47:57] --------------
[11:47:57]  Loading plugin: crashdetect.so
[11:47:57]   CrashDetect v4.15.1 is OK.
[11:47:57]   Loaded.
[11:47:57]  Loading plugin: streamer.so
[11:47:57] 

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

[11:47:57]   Loaded.
[11:47:57]  Loading plugin: mysql_static.so
[11:47:57]  >> plugin.mysql: R39-5 successfully loaded.
[11:47:57]   Loaded.
[11:47:57]  Loading plugin: pawncmd.so
[11:47:57] Pawn.CMD plugin v3.1.2 by urShadow loaded
[11:47:57]   Loaded.
[11:47:57]  Loading plugin: sscanf.so
[11:47:57] 

[11:47:57]  ===============================

[11:47:57]       sscanf plugin loaded.     

[11:47:57]          Version:  2.8.1        

[11:47:57]    (c) 2012 Alex "Y_Less" Cole  

[11:47:57]  ===============================

[11:47:57]   Loaded.
[11:47:57]  Loading plugin: regex.so
[11:47:57] 

[11:47:57] ______________________________________

[11:47:57]  Regular Expression Plugin v0.2.1 loaded
[11:47:57] ______________________________________

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

[11:47:57]   Loaded.
[11:47:57]  Loading plugin: CRP.so
[11:47:57] 

[11:47:57] ______________________________________

[11:47:57]  Convert Rus To Pwn v0.1.1 loaded
[11:47:57] ______________________________________

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

[11:47:57]   Loaded.
[11:47:57]  Loaded 7 plugins.

[11:47:57] 
[11:47:57] Filterscripts
[11:47:57] ---------------
[11:47:57]   Loading filterscript 'grob.amx'...
[11:47:57] 
######################################### #
[11:47:57] ### Gravestones filterscript Loaded
[11:47:57] ### Author: Tr1viUm
[11:47:57] #########################################
 
[11:47:57]   Loading filterscript 'antidos.amx'...
[11:47:57] 
-------------------------------------------
[11:47:57] * AntiDoS by Ildar - успешно загружен *
[11:47:57] -------------------------------------------

[11:47:57]   Loaded 2 filterscripts.

[11:47:57]  
[11:47:57]  
[11:47:57]  
[11:47:57]  ======================================= 
[11:47:57]  |                                     | 
[11:47:57]  |        YSI version 3.09.0684        | 
[11:47:57]  |        By Alex "Y_Less" Cole        | 
[11:47:57]  |                                     | 
[11:47:57]  ======================================= 
[11:47:57]  
[11:47:57] Error while reading MySQL settings file (database). Error code: -9
[11:47:57] DOOME CONNECT - Идёт подключение к базе данных: gs50
[11:47:57] -> Динамических объектов: 27822
[11:47:57] -> Статических объектов: 0
[11:47:57] -> Видимых объектов (стример): 1000
[11:47:57] _______________________________________________________
[11:47:57]  HCS --> Especially --> Just        		  	  		  
[11:47:57]  Авторы доработки: Виталий Аницаев, Владимир Макаревич 
[11:47:57]  Для проекта TimePlay RP RP 2016-2017 (25.01.2016)   		  
[11:47:57] _______________________________________________________
[11:47:57] Number of vehicle models: 25

 

Спойлер

[17:11:14] [ERROR] CMySQLQuery::Execute[LoadFamily] - (error #1146) Table 'gs50.family_system' doesn't exist
[17:11:14] [ERROR] CMySQLQuery::Execute[LoadPodezd] - (error #1146) Table 'gs50.podezd' doesn't exist
[17:11:14] [ERROR] CMySQLQuery::Execute[LoadRooms] - (error #1146) Table 'gs50.rooms' doesn't exist
[17:16:06] [ERROR] mysql_connect - empty connection data specified
[17:16:06] [ERROR] mysql_errno - invalid connection handle (id: 1)
[17:16:07] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:16:08] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:16:09] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:16:11] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:16:12] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:16:13] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:16:14] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:16:15] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:16:16] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:16:17] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:16:18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:16:19] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:16:20] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:16:21] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:16:22] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:16:23] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:16:24] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:16:25] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:16:26] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:16:27] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:16:28] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:16:29] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:16:30] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:16:31] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:16:32] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:16:33] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:16:34] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:16:35] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:20:46] [ERROR] mysql_connect - empty connection data specified
[17:20:46] [ERROR] mysql_errno - invalid connection handle (id: 1)
[17:20:47] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:20:48] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:20:49] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:20:50] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:20:51] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:20:52] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:20:53] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:20:54] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:20:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:20:56] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:20:57] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:20:58] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:20:59] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:00] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:01] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:03] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:04] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:05] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:06] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:07] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:08] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:09] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:10] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:11] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:12] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:13] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:14] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:15] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:16] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:17] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:19] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:20] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:21] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:22] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:23] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:24] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:25] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:26] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:27] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:28] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:29] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:30] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:31] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:33] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:34] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:35] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:36] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:37] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:38] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:39] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:40] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:41] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:42] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:43] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:44] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:45] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:46] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:47] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:48] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:49] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:50] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:51] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:52] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:53] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:54] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:56] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:57] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:58] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:21:59] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:22:00] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:22:01] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:22:03] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:22:04] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:22:05] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:22:06] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:22:07] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:22:08] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:22:09] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:22:10] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:22:11] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:22:12] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:22:13] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:22:14] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:22:15] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:22:16] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:22:17] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:22:18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:22:19] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:22:20] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:22:21] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:22:22] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:22:23] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:22:24] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:22:25] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:22:26] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:22:27] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:22:28] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:22:29] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:22:31] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:22:32] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:22:33] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:22:34] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:22:35] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:22:36] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:22:37] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:22:38] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:22:39] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:22:40] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:22:49] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on '94.142.141.41' (111)
[17:22:49] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on '94.142.141.41' (111)
[17:22:49] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on '94.142.141.41' (111)
[17:22:49] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on '94.142.141.41' (111)
[17:23:54] [ERROR] mysql_connect - empty connection data specified
[17:23:54] [ERROR] mysql_errno - invalid connection handle (id: 1)
[17:23:56] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:23:57] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:23:58] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:23:59] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:24:00] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:24:01] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:24:02] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:24:03] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:24:04] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:24:34] [ERROR] mysql_connect - empty connection data specified
[17:24:34] [ERROR] mysql_errno - invalid connection handle (id: 1)
[17:24:35] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:24:36] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:24:37] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:24:38] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:24:39] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:30:02] [ERROR] mysql_connect - empty connection data specified
[17:30:02] [ERROR] mysql_errno - invalid connection handle (id: 1)
[17:30:03] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:30:04] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:30:05] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:30:06] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:30:07] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:30:08] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:30:09] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:30:10] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[11:47:57] [ERROR] mysql_connect - empty connection data specified
[11:47:57] [ERROR] mysql_errno - invalid connection handle (id: 1)
[11:47:58] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[11:47:59] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[11:48:00] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[11:48:01] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[11:48:02] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[11:48:03] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[11:48:04] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[11:48:06] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[11:48:07] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[11:48:08] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[11:48:09] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[11:48:10] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[11:48:11] [ERROR] mysql_tquery - invalid connection handle (id: 0)

 

 

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты

21 ответ на этот вопрос

  • 0
Гость
Новичок

@stibs у меня тестовый хостинг сейчас по этому мне серовно:
 

host = 94.142.141.41
username = gs50
password = wun2AlNVz4
datebase = gs50

у меня это идет отдельным файлом

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты
  • 0
Гость stibs
Новичок

Найдите эту строку в моде и скиньте код, который с ней связан: 
 

Error while reading MySQL settings file (database). Error code:

 

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты
  • 0
Гость
Новичок

@stibs 

stock LoadMySQLSettings()
{
	new FileID = ini_openFile("mysql_settings.ini"),errCode;
	if(FileID < 0)
	{
		printf("Error while opening MySQL settings file. Error code: %d",FileID);
		return 0;
	}
	errCode = ini_getString(FileID,"host",MySQLSettings[DOOME_HOST]);
	if(errCode < 0) printf("Error while reading MySQL settings file (host). Error code: %d",errCode);
	errCode = ini_getString(FileID,"username",MySQLSettings[DOOME_USERNAME]);
	if(errCode < 0) printf("Error while reading MySQL settings file (username). Error code: %d",errCode);
	errCode = ini_getString(FileID,"password",MySQLSettings[DOOME_PASSWORD]);
	if(errCode < 0) printf("Error while reading MySQL settings file (password). Error code: %d",errCode);
	errCode = ini_getString(FileID,"database",MySQLSettings[DOOME_DATABASE]);
	if(errCode < 0) printf("Error while reading MySQL settings file (database). Error code: %d",errCode);
	ini_closeFile(FileID);
	return 1;
}

 

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты
  • 0
Гость stibs
Новичок

Замените свои настройки на эти: 
 

host = 94.142.141.41
username = gs50
password = wun2AlNVz4
database = gs50

 

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты
  • 0
Гость
Новичок

@stibs 

Спойлер

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

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

[14:03:27] 
[14:03:27] Server Plugins
[14:03:27] --------------
[14:03:27]  Loading plugin: crashdetect.so
[14:03:27]   CrashDetect v4.15.1 is OK.
[14:03:27]   Loaded.
[14:03:27]  Loading plugin: streamer.so
[14:03:27] 

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

[14:03:27]   Loaded.
[14:03:27]  Loading plugin: mysql_static.so
[14:03:27]  >> plugin.mysql: R39-5 successfully loaded.
[14:03:27]   Loaded.
[14:03:27]  Loading plugin: pawncmd.so
[14:03:27] Pawn.CMD plugin v3.1.2 by urShadow loaded
[14:03:27]   Loaded.
[14:03:27]  Loading plugin: sscanf.so
[14:03:27] 

[14:03:27]  ===============================

[14:03:27]       sscanf plugin loaded.     

[14:03:27]          Version:  2.8.1        

[14:03:27]    (c) 2012 Alex "Y_Less" Cole  

[14:03:27]  ===============================

[14:03:27]   Loaded.
[14:03:27]  Loading plugin: regex.so
[14:03:27] 

[14:03:27] ______________________________________

[14:03:27]  Regular Expression Plugin v0.2.1 loaded
[14:03:27] ______________________________________

[14:03:27]  By: Fro (c) Copyright <TBG> 2009-2011
[14:03:27] ______________________________________

[14:03:27]   Loaded.
[14:03:27]  Loading plugin: CRP.so
[14:03:27] 

[14:03:27] ______________________________________

[14:03:27]  Convert Rus To Pwn v0.1.1 loaded
[14:03:27] ______________________________________

[14:03:27]  By: Fro (c) Copyright <TBG> 2009-2011
[14:03:27] ______________________________________

[14:03:27]   Loaded.
[14:03:27]  Loaded 7 plugins.

[14:03:27] 
[14:03:27] Filterscripts
[14:03:27] ---------------
[14:03:27]   Loading filterscript 'grob.amx'...
[14:03:27] 
######################################### #
[14:03:27] ### Gravestones filterscript Loaded
[14:03:27] ### Author: Tr1viUm
[14:03:27] #########################################
 
[14:03:27]   Loading filterscript 'antidos.amx'...
[14:03:28] 
-------------------------------------------
[14:03:28] * AntiDoS by Ildar - успешно загружен *
[14:03:28] -------------------------------------------

[14:03:28]   Loaded 2 filterscripts.

[14:03:28]  
[14:03:28]  
[14:03:28]  
[14:03:28]  ======================================= 
[14:03:28]  |                                     | 
[14:03:28]  |        YSI version 3.09.0684        | 
[14:03:28]  |        By Alex "Y_Less" Cole        | 
[14:03:28]  |                                     | 
[14:03:28]  ======================================= 
[14:03:28]  
[14:03:28] DOOME CONNECT - Идёт подключение к базе данных: gs50
[14:03:28]   MySQL connection: TRUE (local)

[14:03:28] -> Динамических объектов: 27822
[14:03:28] -> Статических объектов: 0
[14:03:28] -> Видимых объектов (стример): 1000
[14:03:28] _______________________________________________________
[14:03:28]  HCS --> Especially --> Just        		  	  		  
[14:03:28]  Авторы доработки: Виталий Аницаев, Владимир Макаревич 
[14:03:28]  Для проекта TimePlay RP RP 2016-2017 (25.01.2016)   		  
[14:03:28] _______________________________________________________
[14:03:28] Number of vehicle models: 25

 

Спойлер

[14:03:28] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on '94.142.141.41' (111)
[14:03:28] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on '94.142.141.41' (111)
[14:03:28] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on '94.142.141.41' (111)
[14:03:28] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on '94.142.141.41' (111)

 

 

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты
  • 0
Гость
Новичок

@stibs может из за этого проблема?
 

public OnGameModeInit()
{
    gamemodeloaded = 0;
    LoadMySQLSettings();
	SetGameModeText("LOADING...");
	AntiDeAMX();
	
/*	for(new i = 0; i<MAX_PLAYERS; i++)
	{
	    MessagesCount[i] = 9999999;
	}
	SetTimer("NetworkUpdate", 5000, true);*/

	new bind[64];
    GetServerVarAsString("bind", bind, sizeof(bind));
 	printf("DOOME CONNECT - Идёт подключение к базе данных: %s", MySQLSettings[DOOME_USERNAME]);
	if(!strcmp(bind, "localhost", true))
	{
	    dbHandle = mysql_connect(MySQLSettings[DOOME_HOST],MySQLSettings[DOOME_USERNAME],MySQLSettings[DOOME_DATABASE],MySQLSettings[DOOME_PASSWORD]);
	    TEST_SERVER = true;
	}
	else
	{
	    dbHandle = mysql_connect(MySQLSettings[DOOME_HOST],MySQLSettings[DOOME_USERNAME],MySQLSettings[DOOME_DATABASE],MySQLSettings[DOOME_PASSWORD]);
	}
	mysql_log(LOG_WARNING | LOG_ERROR);
    if(mysql_errno() == -1)
    {
        if(!strcmp(bind, "localhost", true)) SetGameModeText(""SERVER_NAME" | Error SQL");
        else print("  MySQL connection: FALSE (host)\n");
    }
    else
    {
        if(!strcmp(bind, "localhost", true)) print("  MySQL connection: TRUE (local)\n");
	    else print("  MySQL connection: TRUE (host)\n");
	    
	    mysql_tquery(dbHandle, "SET NAMES 'cp1251'", "", "");
		mysql_tquery(dbHandle, "SET CHARACTER SET 'cp1251'", "", "");
		mysql_tquery(dbHandle, "SELECT * FROM "T_VEHICLE"", "LoadVeh", "");
		mysql_tquery(dbHandle, "SELECT * FROM "T_BIZZ" ORDER BY  "T_BIZZ".`id` ASC ", "LoadBizz", "");
		mysql_tquery(dbHandle, "SELECT * FROM "T_HOUSE" ORDER BY  "T_HOUSE".`id` ASC ", "LoadHouse", "");
		mysql_tquery(dbHandle, "SELECT * FROM "T_MAFIA"", "LoadMafia", "");
		mysql_tquery(dbHandle, "SELECT * FROM "T_GANG"", "LoadGang", "");
		mysql_tquery(dbHandle, "SELECT * FROM "T_GANGZONE"", "LoadGZ", "");
		mysql_tquery(dbHandle, "SELECT * FROM "T_ATM"", "LoadATM", "");
		mysql_tquery(dbHandle, "SELECT * FROM "T_OTHER"", "LoadOther", "");
		mysql_tquery(dbHandle, "SELECT * FROM "T_RADAR"", "LoadRadar", "");
		mysql_tquery(dbHandle, "SELECT * FROM "T_DROPIT"","LoadDropItem", "");
		mysql_tquery(dbHandle, "SELECT * FROM "T_FAMILY"","LoadFamily", "");
	    mysql_tquery(dbHandle, "SELECT * FROM "T_PODEZD"", "LoadPodezd", "");
	    mysql_tquery(dbHandle, "SELECT * FROM "T_ROOMS"", "LoadRooms", "");
		
		mysql_tquery(dbHandle, "UPDATE "T_ADMIN" SET `timemin` = '0'", "", "");
    }
    
	SendRconCommand("mapname Russia");
	SendRconCommand("weburl "SERVER_WEBSITE"");

 

Отредактировано пользователем Daniil Roslyakov

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты
  • 0
Гость
Новичок

@stibs я сверил авторизацию, основного мода Just и дороботки Just
В итоге все одинакова кроме базы данных (подключение разное)

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты
  • 0
Гость
Новичок

@stibs теперь

Спойлер

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

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

[17:16:39] 
[17:16:39] Server Plugins
[17:16:39] --------------
[17:16:39]  Loading plugin: crashdetect.so
[17:16:39]   CrashDetect v4.15.1 is OK.
[17:16:39]   Loaded.
[17:16:39]  Loading plugin: streamer.so
[17:16:39] 

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

[17:16:39]   Loaded.
[17:16:39]  Loading plugin: mysql_static.so
[17:16:39]  >> plugin.mysql: R39-5 successfully loaded.
[17:16:39]   Loaded.
[17:16:39]  Loading plugin: pawncmd.so
[17:16:39] Pawn.CMD plugin v3.1.2 by urShadow loaded
[17:16:39]   Loaded.
[17:16:39]  Loading plugin: sscanf.so
[17:16:39] 

[17:16:39]  ===============================

[17:16:39]       sscanf plugin loaded.     

[17:16:39]          Version:  2.8.1        

[17:16:39]    (c) 2012 Alex "Y_Less" Cole  

[17:16:39]  ===============================

[17:16:39]   Loaded.
[17:16:39]  Loading plugin: regex.so
[17:16:39] 

[17:16:39] ______________________________________

[17:16:39]  Regular Expression Plugin v0.2.1 loaded
[17:16:39] ______________________________________

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

[17:16:39]   Loaded.
[17:16:39]  Loading plugin: CRP.so
[17:16:39] 

[17:16:39] ______________________________________

[17:16:39]  Convert Rus To Pwn v0.1.1 loaded
[17:16:39] ______________________________________

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

[17:16:39]   Loaded.
[17:16:39]  Loaded 7 plugins.

[17:16:39] 
[17:16:39] Filterscripts
[17:16:39] ---------------
[17:16:39]   Loading filterscript 'grob.amx'...
[17:16:40] 
######################################### #
[17:16:40] ### Gravestones filterscript Loaded
[17:16:40] ### Author: Tr1viUm
[17:16:40] #########################################
 
[17:16:40]   Loading filterscript 'antidos.amx'...
[17:16:40] 
-------------------------------------------
[17:16:40] * AntiDoS by Ildar - успешно загружен *
[17:16:40] -------------------------------------------

[17:16:40]   Loaded 2 filterscripts.

[17:16:40]  
[17:16:40]  
[17:16:40]  
[17:16:40]  ======================================= 
[17:16:40]  |                                     | 
[17:16:40]  |        YSI version 3.09.0684        | 
[17:16:40]  |        By Alex "Y_Less" Cole        | 
[17:16:40]  |                                     | 
[17:16:40]  ======================================= 
[17:16:41]  
[17:16:41]   MySQL connection: TRUE (host)

[17:16:41] -> Динамических объектов: 27822
[17:16:41] -> Статических объектов: 0
[17:16:41] -> Видимых объектов (стример): 1000
[17:16:41] _______________________________________________________
[17:16:41]  HCS --> Especially --> Just        		  	  		  
[17:16:41]  Авторы доработки: Виталий Аницаев, Владимир Макаревич 
[17:16:41]  Для проекта TimePlay RP RP 2016-2017 (25.01.2016)   		  
[17:16:41] _______________________________________________________
[17:16:41] Number of vehicle models: 25
[17:16:41] [Загружено орг/раб. автомобилей]: <0>. Потрачено: <0 ms>.
[17:16:41] [Загружено бизнесов]: <0>. Потрачено: <0 ms>.
[17:16:41] [Загружено домов]: <0>. Потрачено: <0 ms>.
[17:16:41] [Загружены склады мафий]: Потрачено: <0 ms>.
[17:16:41] [Загружены склады банд]: Потрачено: <0 ms>.
[17:16:41] [Загружено гангзон]: <100>. Потрачено: <2 ms>.
[17:16:41] [Загружено банкоматов]: <0>. Потрачено: <0 ms>.
[17:16:41] [Загружено остальное]: Потрачено: <0 ms>.
[17:16:41] [Загружено радаров]: <0>. Потрачено: <0 ms>.
[17:16:41] [Загружено итемов]: <0>. Потрачено: <0 мс>
[17:16:41] [Загружено семей]: <0>. Потрачено: <->.
[17:16:41] [Загружено подъездов]: <0>. Потрачено: <0 ms>.
[17:16:41] [Загружено квартир]: <0>. Потрачено: <0 ms>.
[17:17:06] Incoming connection: 89.145.154.128:50397
[17:17:09] [join] Jaliba_Baron has joined the server (0:89.145.154.128)
[17:17:16] [debug] Run time error 4: "Array index out of bounds"
[17:17:16] [debug]  Accessing element at index 5 past array upper bound 4
[17:17:16] [debug] AMX backtrace:
[17:17:16] [debug] #0 00027b7c in public OnPlayerRequestClass (playerid=0, classid=0) at J:\Сервер TimePlay RolePlay\Новый мод\gamemodes\timeplay.pwn:4234
[17:17:25] [debug] Run time error 4: "Array index out of bounds"
[17:17:25] [debug]  Accessing element at index 3 past array upper bound 2
[17:17:25] [debug] AMX backtrace:
[17:17:25] [debug] #0 0002cc2c in public Itter_OnPlayerDisconnect (playerid=0, reason=1) at J:\Сервер TimePlay RolePlay\Новый мод\gamemodes\timeplay.pwn:4577
[17:17:25] [debug] #1 00013f00 in public SSCANF_OnPlayerDisconnect (playerid=0, reason=1) at J:\Сервер TimePlay RolePlay\Новый мод\pawno\include\YSI\y_iterate.inc:909
[17:17:25] [debug] #2 0000bdd4 in public OnPlayerDisconnect (playerid=0, reason=1) at J:\Сервер TimePlay RolePlay\Новый мод\pawno\include\sscanf2.inc:260
[17:17:25] [part] Jaliba_Baron has left the server (0:1)

 

Спойлер

[14:12:36] [ERROR] CMySQLQuery::Execute[LoadFamily] - (error #1146) Table 'gs50.family_system' doesn't exist
[14:12:36] [ERROR] CMySQLQuery::Execute[LoadPodezd] - (error #1146) Table 'gs50.podezd' doesn't exist
[14:12:36] [ERROR] CMySQLQuery::Execute[LoadRooms] - (error #1146) Table 'gs50.rooms' doesn't exist

 

 

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты
  • 0
Гость stibs
Новичок

@Daniil Roslyakov ошибки не в мускул, ошибке в вашем моде: 

1 минуту назад, Daniil Roslyakov сказал:

[17:17:16] [debug] Run time error 4: "Array index out of bounds" [17:17:16] [debug] Accessing element at index 5 past array upper bound 4 [17:17:16] [debug] AMX backtrace: [17:17:16] [debug] #0 00027b7c in public OnPlayerRequestClass (playerid=0, classid=0) at J:\Сервер TimePlay RolePlay\Новый мод\gamemodes\timeplay.pwn:4234 [17:17:25] [debug] Run time error 4: "Array index out of bounds" [17:17:25] [debug] Accessing element at index 3 past array upper bound 2 [17:17:25] [debug] AMX backtrace: [17:17:25] [debug] #0 0002cc2c in public Itter_OnPlayerDisconnect (playerid=0, reason=1) at J:\Сервер TimePlay RolePlay\Новый мод\gamemodes\timeplay.pwn:4577 [17:17:25] [debug] #1 00013f00 in public SSCANF_OnPlayerDisconnect (playerid=0, reason=1) at J:\Сервер TimePlay RolePlay\Новый мод\pawno\include\YSI\y_iterate.inc:909 [17:17:25] [debug] #2 0000bdd4 in public OnPlayerDisconnect (playerid=0, reason=1) at J:\Сервер TimePlay RolePlay\Новый мод\pawno\include\sscanf2.inc:260

Если заинтересованы в их решении, создавайте отдельную тему. Эта тема решена. 

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты
Гость
Эта тема закрыта для публикации ответов.

  • Последние посетители   0 пользователей онлайн

    Ни одного зарегистрированного пользователя не просматривает данную страницу

  • Похожий контент

    • patrickk
      От patrickk
      Всем привет, решил написать dm сервер и довольно хорошим получился, даже на голову выше Goat dm. Оставил не решенную проблему тем что  у меня есть 4 локации с rp run и cj run ну а как добавить cj бег на те локации не знаю и как эта система работает. Надеюсь мне помогут знающие люди
    • Samolet
      От Samolet
      Здраствуйте, cоздаю копию Arizona на ОМП, опен мультиплеер, загрузил и подключил бд, но сервер не хочет вот лог :[2026-10-20T21:03:32+0300] [Info] Log file reloaded. Starting open.mp server (1.5.8.3079) from commit c6759bd8d265171ae3d86598895a23d5a8d92a3b Loading component $CAPI.so Successfully loaded component C-API (1.5.8.3079) with UID 10467dd8d4c56fc6 Loading component LegacyConfig.so Successfully loaded component LegacyConfig (1.5.8.3079) with UID 24ef6216838f9ffc Loading component NPCs.so Successfully loaded component NPCs (1.5.8.3079) with UID 3d0e59e87f4e90bc Loading component Recordings.so Successfully loaded component Recordings (1.5.8.3079) with UID 871144d399f5f613 Loading component Checkpoints.so Successfully loaded component Checkpoints (1.5.8.3079) with UID 44a937350d611dde Loading component TextDraws.so Successfully loaded component TextDraws (1.5.8.3079) with UID 9b5dc2b1d15c992a Loading component Pawn.so Successfully loaded component Pawn (1.5.8.3079) with UID 78906cd9f19c36a6 Loading component GangZones.so Successfully loaded component GangZones (1.5.8.3079) with UID b3351d11ee8d8056 Loading component Actors.so Successfully loaded component Actors (1.5.8.3079) with UID c81ca021eae2ad5c Loading component Pickups.so Successfully loaded component Pickups (1.5.8.3079) with UID cf304faa363dd971 Loading component Dialogs.so Successfully loaded component Dialogs (1.5.8.3079) with UID 44a111350d611dde Loading component Objects.so Successfully loaded component Objects (1.5.8.3079) with UID 59f8415f72da6160 Loading component Console.so Successfully loaded component Console (1.5.8.3079) with UID bfa24e49d0c95ee4 Loading component TextLabels.so Successfully loaded component TextLabels (1.5.8.3079) with UID a0c57ea80a009742 Loading component Variables.so Successfully loaded component Variables (1.5.8.3079) with UID 75e121848bc01fa2 Loading component Databases.so Successfully loaded component Databases (1.5.8.3079) with UID 80092e7eb5821a96 Loading component LegacyNetwork.so Successfully loaded component RakNetLegacyNetwork (1.5.8.3079) with UID ea9799fd79cf8442 Loading component CustomModels.so Successfully loaded component CustomModels (1.5.8.3079) with UID 15e3cb1e7c77ffff Loading component Menus.so Successfully loaded component Menus (1.5.8.3079) with UID 621e219eb97ee0b2 Loading component Vehicles.so Successfully loaded component Vehicles (1.5.8.3079) with UID 3f1f62ee9e22ab19 Loading component Classes.so Successfully loaded component Classes (1.5.8.3079) with UID 8cfb3183976da208 Loading component Timers.so Successfully loaded component Timers (1.5.8.3079) with UID 2ad8124c5ea257a3 Loaded 22 component(s) from /home/gs113492/components Executing Server Config... [2026-10-20T21:03:33+0300] [Info] Loading plugin: crashdetect.so [2026-10-20T21:03:33+0300] [Info] CrashDetect plugin 4.19 [2026-10-20T21:03:33+0300] [Info] Loading plugin: mapandreas.so [2026-10-20T21:03:33+0300] [Info] Loading plugin: streamer.so [2026-10-20T21:03:33+0300] [Info] *** Streamer Plugin v2.9.4 by Incognito loaded *** [2026-10-20T21:03:33+0300] [Info] Loading plugin: sscanf.so [2026-10-20T21:03:33+0300] [Info] [2026-10-20T21:03:33+0300] [Info] =============================== [2026-10-20T21:03:33+0300] [Info] sscanf plugin loaded. [2026-10-20T21:03:33+0300] [Info] Version: 2.8.3 [2026-10-20T21:03:33+0300] [Info] (c) 2018 Alex "Y_Less" Cole [2026-10-20T21:03:33+0300] [Info] =============================== [2026-10-20T21:03:33+0300] [Info] Loading plugin: TOTP.so [2026-10-20T21:03:33+0300] [Info] TOTP plugin v1.0.1 by Games loaded. [2026-10-20T21:03:33+0300] [Info] Loading plugin: mysql_static.so [2026-10-20T21:03:33+0300] [Info] >> plugin.mysql: R39-6 successfully loaded. [2026-10-20T21:03:33+0300] [Info] Loading plugin: libpawn_json.so [2026-10-20T21:03:34+0300] [Error] Function not registered: YSF_SetTickRate [2026-10-20T21:03:34+0300] [Error] Function not registered: PC_Init [2026-10-20T21:03:34+0300] [Info] [debug] Run time error 19: "File or function is not found" [2026-10-20T21:03:34+0300] [Info] [debug] PC_Init [2026-10-20T21:03:34+0300] [Info] [debug] YSF_SetTickRate [2026-10-20T21:03:34+0300] [Error] File or function is not found [2026-10-20T21:03:34+0300] [Error] Function not registered: PC_RegAlias [2026-10-20T21:03:34+0300] [Error] Function not registered: BS_GetWriteOffset [2026-10-20T21:03:34+0300] [Error] Function not registered: BS_Reset [2026-10-20T21:03:34+0300] [Error] Function not registered: PR_RegHandler [2026-10-20T21:03:34+0300] [Error] Function not registered: BS_Delete [2026-10-20T21:03:34+0300] [Error] Function not registered: BS_New [2026-10-20T21:03:34+0300] [Error] Function not registered: BS_ResetReadPointer [2026-10-20T21:03:34+0300] [Error] Function not registered: BS_SetWriteOffset [2026-10-20T21:03:34+0300] [Error] Function not registered: BS_IgnoreBits [2026-10-20T21:03:34+0300] [Error] Function not registered: PR_Init [2026-10-20T21:03:34+0300] [Error] Function not registered: PR_SendRPC [2026-10-20T21:03:34+0300] [Error] Function not registered: PR_SendPacket [2026-10-20T21:03:34+0300] [Error] Function not registered: BS_WriteValue [2026-10-20T21:03:34+0300] [Error] Function not registered: BS_GetNumberOfBytesUsed [2026-10-20T21:03:34+0300] [Error] Function not registered: BS_ReadValue [2026-10-20T21:03:34+0300] [Error] Function not registered: PC_Init [2026-10-20T21:03:34+0300] [Info] [debug] Run time error 19: "File or function is not found" [2026-10-20T21:03:34+0300] [Info] [debug] PC_Init [2026-10-20T21:03:34+0300] [Info] [debug] BS_ReadValue [2026-10-20T21:03:34+0300] [Info] [debug] BS_GetNumberOfBytesUsed [2026-10-20T21:03:34+0300] [Info] [debug] BS_WriteValue [2026-10-20T21:03:34+0300] [Info] [debug] PR_SendPacket [2026-10-20T21:03:34+0300] [Info] [debug] PR_SendRPC [2026-10-20T21:03:34+0300] [Info] [debug] PR_Init [2026-10-20T21:03:34+0300] [Info] [debug] BS_IgnoreBits [2026-10-20T21:03:34+0300] [Info] [debug] BS_SetWriteOffset [2026-10-20T21:03:34+0300] [Info] [debug] BS_ResetReadPointer [2026-10-20T21:03:34+0300] [Info] [debug] BS_New [2026-10-20T21:03:34+0300] [Info] [debug] BS_Delete [2026-10-20T21:03:34+0300] [Info] [debug] PR_RegHandler [2026-10-20T21:03:34+0300] [Info] [debug] BS_Reset [2026-10-20T21:03:34+0300] [Info] [debug] BS_GetWriteOffset [2026-10-20T21:03:34+0300] [Info] [debug] PC_RegAlias [2026-10-20T21:03:34+0300] [Error] File or function is not found [2026-10-20T21:03:34+0300] [Info] [debug] Run time error 19: "File or function is not found" [2026-10-20T21:03:34+0300] [Info] [debug] PC_Init [2026-10-20T21:03:34+0300] [Info] [debug] YSF_SetTickRate [2026-10-20T21:03:34+0300] [Error] File or function is not found [2026-10-20T21:03:34+0300] [Info] [debug] Run time error 19: "File or function is not found" [2026-10-20T21:03:34+0300] [Info] [debug] PC_Init [2026-10-20T21:03:34+0300] [Info] [debug] BS_ReadValue [2026-10-20T21:03:34+0300] [Info] [debug] BS_GetNumberOfBytesUsed [2026-10-20T21:03:34+0300] [Info] [debug] BS_WriteValue [2026-10-20T21:03:34+0300] [Info] [debug] PR_SendPacket [2026-10-20T21:03:34+0300] [Info] [debug] PR_SendRPC [2026-10-20T21:03:34+0300] [Info] [debug] PR_Init [2026-10-20T21:03:34+0300] [Info] [debug] BS_IgnoreBits [2026-10-20T21:03:34+0300] [Info] [debug] BS_SetWriteOffset [2026-10-20T21:03:34+0300] [Info] [debug] BS_ResetReadPointer [2026-10-20T21:03:34+0300] [Info] [debug] BS_New [2026-10-20T21:03:34+0300] [Info] [debug] BS_Delete [2026-10-20T21:03:34+0300] [Info] [debug] PR_RegHandler [2026-10-20T21:03:34+0300] [Info] [debug] BS_Reset [2026-10-20T21:03:34+0300] [Info] [debug] BS_GetWriteOffset [2026-10-20T21:03:34+0300] [Info] [debug] PC_RegAlias [2026-10-20T21:03:34+0300] [Info] Legacy Network started on ***.**.**.***:2717. Помогите пожалуйста