[ManuelAbregu]

Buenas! Bueno mi problema es que al ejectuar el "server.exe" del GM Nexus RP, me sale el siguiente error de MYSQL :

Si alguien sabe solucionarlo agradecerнa su comentario!

[aoEXE]

en el archivo 'mysql_log' puede que te diga que pasa

[ManuelAbregu]

Esto es lo que me aparece dentro del "mysql_log" :

[01:49:04] [DEBUG] mysql_connect - host: "localhost", user: "root", database: "nexusrp", password: "****", port: 3306, autoreconnect: true
[01:49:04] [DEBUG] CMySQLHandle::Create - creating new connection..
[01:49:04] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called
[01:49:04] [DEBUG] CMySQLHandle::Create - connection created with ID = 1
[01:49:05] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[01:49:06] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[01:49:06] [DEBUG] mysql_query - connection: 1, query: "SELECT Nombre FROM usuarios WHERE Nombre = 'Plantilla'", use_cache: true
[01:49:06] [DEBUG] CMySQLQuery::CMySQLQuery() - constructor called
[01:49:06] [DEBUG] CMySQLQuery::Execute[()] - starting query execution
[01:49:06] [ERROR] CMySQLQuery::Execute[()] - (error #2006) MySQL server has gone away
[01:49:06] [WARNING] CMySQLQuery::Execute[()] - lost connection, reconnecting..
[01:49:06] [DEBUG] CMySQLConnection:isconnect - connection was closed
[01:49:07] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[01:49:07] [DEBUG] CMySQLQuery::~CMySQLQuery() - deconstructor called
[01:49:07] [DEBUG] cache_get_row_count - connection: 1
[01:49:07] [WARNING] cache_get_row_count - no active cache
[01:49:07] [DEBUG] mysql_query - connection: 1, query: "SELECT SQLID FROM vehiculos ORDER BY SQLID DESC", use_cache: true
[01:49:07] [DEBUG] CMySQLQuery::CMySQLQuery() - constructor called
[01:49:07] [DEBUG] CMySQLQuery::Execute[()] - starting query execution
[01:49:07] [ERROR] CMySQLQuery::Execute[()] - (error #2006) MySQL server has gone away
[01:49:07] [WARNING] CMySQLQuery::Execute[()] - lost connection, reconnecting..
[01:49:07] [DEBUG] CMySQLConnection:isconnect - connection was closed
[01:49:08] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[01:49:08] [DEBUG] CMySQLQuery::~CMySQLQuery() - deconstructor called
[01:49:08] [DEBUG] cache_get_row_count - connection: 1
[01:49:08] [WARNING] cache_get_row_count - no active cache
[01:49:08] [DEBUG] cache_get_field_count - connection: 1
[01:49:08] [WARNING] cache_get_field_count - no active cache
[01:49:08] [DEBUG] mysql_query - connection: 1, query: "SELECT ID FROM casas ORDER BY ID DESC", use_cache: true
[01:49:08] [DEBUG] CMySQLQuery::CMySQLQuery() - constructor called
[01:49:08] [DEBUG] CMySQLQuery::Execute[()] - starting query execution
[01:49:08] [ERROR] CMySQLQuery::Execute[()] - (error #2006) MySQL server has gone away
[01:49:08] [WARNING] CMySQLQuery::Execute[()] - lost connection, reconnecting..
[01:49:08] [DEBUG] CMySQLConnection:isconnect - connection was closed
[01:49:09] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[01:49:09] [DEBUG] CMySQLQuery::~CMySQLQuery() - deconstructor called
[01:49:09] [DEBUG] cache_get_row_count - connection: 1
[01:49:09] [WARNING] cache_get_row_count - no active cache
[01:49:09] [DEBUG] cache_get_field_count - connection: 1
[01:49:09] [WARNING] cache_get_field_count - no active cache
[01:49:09] [DEBUG] mysql_query - connection: 1, query: "SELECT ID FROM negocios ORDER BY ID DESC", use_cache: true
[01:49:09] [DEBUG] CMySQLQuery::CMySQLQuery() - constructor called
[01:49:09] [DEBUG] CMySQLQuery::Execute[()] - starting query execution
[01:49:09] [ERROR] CMySQLQuery::Execute[()] - (error #2006) MySQL server has gone away
[01:49:09] [WARNING] CMySQLQuery::Execute[()] - lost connection, reconnecting..
[01:49:09] [DEBUG] CMySQLConnection:isconnect - connection was closed
[01:49:10] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[01:49:10] [DEBUG] CMySQLQuery::~CMySQLQuery() - deconstructor called
[01:49:10] [DEBUG] cache_get_row_count - connection: 1
[01:49:10] [WARNING] cache_get_row_count - no active cache
[01:49:10] [DEBUG] cache_get_field_count - connection: 1
[01:49:10] [WARNING] cache_get_field_count - no active cache
[01:49:10] [DEBUG] mysql_query - connection: 1, query: "SELECT ID FROM turfs ORDER BY ID DESC", use_cache: true
[01:49:10] [DEBUG] CMySQLQuery::CMySQLQuery() - constructor called
[01:49:10] [DEBUG] CMySQLQuery::Execute[()] - starting query execution
[01:49:10] [ERROR] CMySQLQuery::Execute[()] - (error #2006) MySQL server has gone away
[01:49:10] [WARNING] CMySQLQuery::Execute[()] - lost connection, reconnecting..
[01:49:10] [DEBUG] CMySQLConnection:isconnect - connection was closed
[01:49:11] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[01:49:11] [DEBUG] CMySQLQuery::~CMySQLQuery() - deconstructor called
[01:49:11] [DEBUG] cache_get_row_count - connection: 1
[01:49:11] [WARNING] cache_get_row_count - no active cache
[01:49:11] [DEBUG] cache_get_field_count - connection: 1
[01:49:11] [WARNING] cache_get_field_count - no active cache
[01:49:11] [DEBUG] mysql_query - connection: 1, query: "SELECT ID FROM facciones ORDER BY ID DESC", use_cache: true
[01:49:11] [DEBUG] CMySQLQuery::CMySQLQuery() - constructor called
[01:49:11] [DEBUG] CMySQLQuery::Execute[()] - starting query execution
[01:49:11] [ERROR] CMySQLQuery::Execute[()] - (error #2006) MySQL server has gone away
[01:49:11] [WARNING] CMySQLQuery::Execute[()] - lost connection, reconnecting..
[01:49:11] [DEBUG] CMySQLConnection:isconnect - connection was closed
[01:49:12] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[01:49:12] [DEBUG] CMySQLQuery::~CMySQLQuery() - deconstructor called
[01:49:12] [DEBUG] cache_get_row_count - connection: 1
[01:49:12] [WARNING] cache_get_row_count - no active cache
[01:49:12] [DEBUG] cache_get_field_count - connection: 1
[01:49:12] [WARNING] cache_get_field_count - no active cache
[01:49:12] [DEBUG] mysql_format - connection: 1, len: 180, format: "SELECT * FROM `facciones` WHERE `ID` = %d"
[01:49:12] [DEBUG] mysql_query - connection: 1, query: "SELECT * FROM `facciones` WHERE `ID` = 0", use_cache: true
[01:49:12] [DEBUG] CMySQLQuery::CMySQLQuery() - constructor called
[01:49:12] [DEBUG] CMySQLQuery::Execute[()] - starting query execution
[01:49:12] [ERROR] CMySQLQuery::Execute[()] - (error #2006) MySQL server has gone away
[01:49:12] [WARNING] CMySQLQuery::Execute[()] - lost connection, reconnecting..
[01:49:12] [DEBUG] CMySQLConnection:isconnect - connection was closed
[01:49:13] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[01:49:13] [DEBUG] CMySQLQuery::~CMySQLQuery() - deconstructor called
[01:49:13] [DEBUG] cache_get_field_content_int - row: 0, field_name: "ID", connection: 1
[01:49:13] [WARNING] cache_get_field_content_int - no active cache
[01:49:13] [DEBUG] cache_get_field_content - row: 0, field_name: "Nombre", connection: 1, max_len: 60
[01:49:13] [WARNING] cache_get_field_content - no active cache
[01:49:13] [DEBUG] cache_get_field_content - row: 0, field_name: "Rango1", connection: 1, max_len: 60
[01:49:13] [WARNING] cache_get_field_content - no active cache
[01:49:13] [DEBUG] cache_get_field_content - row: 0, field_name: "Rango2", connection: 1, max_len: 60
[01:49:13] [WARNING] cache_get_field_content - no active cache
[01:49:13] [DEBUG] cache_get_field_content - row: 0, field_name: "Rango3", connection: 1, max_len: 60
[01:49:13] [WARNING] cache_get_field_content - no active cache
[01:49:13] [DEBUG] cache_get_field_content - row: 0, field_name: "Rango4", connection: 1, max_len: 60
[01:49:13] [WARNING] cache_get_field_content - no active cache
[01:49:13] [DEBUG] cache_get_field_content - row: 0, field_name: "Rango5", connection: 1, max_len: 60
[01:49:13] [WARNING] cache_get_field_content - no active cache
[01:49:13] [DEBUG] cache_get_field_content - row: 0, field_name: "Rango6", connection: 1, max_len: 60
[01:49:13] [WARNING] cache_get_field_content - no active cache
[01:49:13] [DEBUG] cache_get_field_content - row: 0, field_name: "Rango7", connection: 1, max_len: 60
[01:49:13] [WARNING] cache_get_field_content - no active cache
[01:49:13] [DEBUG] cache_get_field_content - row: 0, field_name: "Rango8", connection: 1, max_len: 60
[01:49:13] [WARNING] cache_get_field_content - no active cache
[01:49:13] [DEBUG] cache_get_field_content - row: 0, field_name: "Lider", connection: 1, max_len: 60
[01:49:13] [WARNING] cache_get_field_content - no active cache
[01:49:13] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Tipo", connection: 1
[01:49:13] [WARNING] cache_get_field_content_int - no active cache
[01:49:13] [DEBUG] cache_get_field_content - row: 0, field_name: "Color", connection: 1, max_len: 60
[01:49:13] [WARNING] cache_get_field_content - no active cache
[01:49:13] [DEBUG] cache_get_field_content_int - row: 0, field_name: "PuntosExpansion", connection: 1
[01:49:13] [WARNING] cache_get_field_content_int - no active cache
[01:49:13] [DEBUG] cache_get_field_content_int - row: 0, field_name: "TiempoArmas", connection: 1
[01:49:13] [WARNING] cache_get_field_content_int - no active cache
[01:49:13] [DEBUG] cache_get_field_content_int - row: 0, field_name: "TiempoDrogas", connection: 1
[01:49:13] [WARNING] cache_get_field_content_int - no active cache
[01:49:13] [DEBUG] mysql_query - connection: 1, query: "SELECT SQLID FROM plantaciones ORDER BY SQLID DESC", use_cache: true
[01:49:13] [DEBUG] CMySQLQuery::CMySQLQuery() - constructor called
[01:49:13] [DEBUG] CMySQLQuery::Execute[()] - starting query execution
[01:49:13] [ERROR] CMySQLQuery::Execute[()] - (error #2006) MySQL server has gone away
[01:49:13] [WARNING] CMySQLQuery::Execute[()] - lost connection, reconnecting..
[01:49:13] [DEBUG] CMySQLConnection:isconnect - connection was closed
[01:49:14] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[01:49:14] [DEBUG] CMySQLQuery::~CMySQLQuery() - deconstructor called
[01:49:14] [DEBUG] cache_get_row_count - connection: 1
[01:49:14] [WARNING] cache_get_row_count - no active cache
[01:49:14] [DEBUG] cache_get_field_count - connection: 1
[01:49:14] [WARNING] cache_get_field_count - no active cache
[01:49:14] [DEBUG] mysql_format - connection: 1, len: 180, format: "SELECT * FROM `plantaciones` WHERE `SQLID` = %d"
[01:49:14] [DEBUG] mysql_query - connection: 1, query: "SELECT * FROM `plantaciones` WHERE `SQLID` = 0", use_cache: true
[01:49:14] [DEBUG] CMySQLQuery::CMySQLQuery() - constructor called
[01:49:14] [DEBUG] CMySQLQuery::Execute[()] - starting query execution
[01:49:14] [ERROR] CMySQLQuery::Execute[()] - (error #2006) MySQL server has gone away
[01:49:14] [WARNING] CMySQLQuery::Execute[()] - lost connection, reconnecting..
[01:49:14] [DEBUG] CMySQLConnection:isconnect - connection was closed
[01:49:15] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[01:49:15] [DEBUG] CMySQLQuery::~CMySQLQuery() - deconstructor called
[01:49:15] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Estado", connection: 1
[01:49:15] [WARNING] cache_get_field_content_int - no active cache
[01:49:17] [DEBUG] CMySQLHandle::~CMySQLHandle - deconstructor called

[Zume]

Has comprobado que los datos a los que conecta estбn bien?

[fabianlamas33]

Debe montar o usar el #WAMP D
Usaste eso?

[ManuelAbregu]

Quote:

Originally Posted by DesingP Debe montar o usar el #WAMP D Usaste eso?

Lo instalй e intentй usarlo pero me sigue apareciendo lo mismo u.u

[Juand]

Para que comienzas con un gm como estos si a duras penas sabes scriptear?

[fabianlamas33]

Primero que nada debes configurar el gm el host que vendria a ser localhost y el usuario root y la pass libre en blanco, segun veo es nexus, dentro de la carpeta de los archivos osea el archiv principal viene un archivo sql que lo tenes que exportar con wamp, seria exportar y luego abris el samp-server y ahi tendria que funcionarte si no me equivoque.

EDIT: Tendria que ser asi dentro del gm el archivo bla bla, es facil.
EDIT DOBLE: Es importar no exportar and sorry

pawn Код:

//----------- MYSQL ----------------//
#define SQL_HOST "localhost"
#define SQL_USER "root"
#define SQL_PASS ""
#define SQL_DB "nexusrp"

[ManuelAbregu]

Quote:

Originally Posted by DesingP Primero que nada debes configurar el gm el host que vendria a ser localhost y el usuario root y la pass libre en blanco, segun veo es nexus, dentro de la carpeta de los archivos osea el archiv principal viene un archivo sql que lo tenes que exportar con wamp, seria exportar y luego abris el samp-server y ahi tendria que funcionarte si no me equivoque. EDIT: Tendria que ser asi dentro del gm el archivo bla bla, es facil. EDIT DOBLE: Es importar no exportar and sorry pawn Код: //----------- MYSQL ----------------// #define SQL_HOST "localhost" #define SQL_USER "root" #define SQL_PASS "" #define SQL_DB "nexusrp"

Muchisimas gracias, despuйs de unas cuentas vueltas con tu ayuda logrй solucionar me parece, gracias!

[Goncho28]

Ahora todos usan ese GM, el nuevo CP