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

Рекомендованные сообщения



22 posts in this topic

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

Спойлер

----------
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)

 

 

Share this post


Link to post
Share on other sites

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

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

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

Share this post


Link to post
Share on other sites

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

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

 

Share this post


Link to post
Share on other sites

@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;
}

 

Share this post


Link to post
Share on other sites

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

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

 

Share this post


Link to post
Share on other sites

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

 

 

Share this post


Link to post
Share on other sites

@Daniil Roslyakov в логах написано, что подключение активно. Попробуйте вновь заменить вместо IP на localhost

Share this post


Link to post
Share on other sites

@Daniil Roslyakov значит либо у вас проблемы в моде, либо проблемы у хостера, либо вы не залили базу данных

Share this post


Link to post
Share on other sites

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

 

Edited by Daniil Roslyakov

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

@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

 

 

Share this post


Link to post
Share on other sites

@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

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

Share this post


Link to post
Share on other sites
Guest
This topic is now closed to further replies.
Sign in to follow this  
Followers 0