SA-MP Forums Archive
[Ayuda] Error con MYSQL! - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: Non-English (https://sampforum.blast.hk/forumdisplay.php?fid=9)
+--- Forum: Languages (https://sampforum.blast.hk/forumdisplay.php?fid=33)
+---- Forum: Español/Spanish (https://sampforum.blast.hk/forumdisplay.php?fid=29)
+---- Thread: [Ayuda] Error con MYSQL! (/showthread.php?tid=542770)


[Ayuda] Error con MYSQL! - ManuelAbregu - 22.10.2014

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!

Respuesta: [Ayuda] Error con MYSQL! - aoEXE - 22.10.2014

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

Respuesta: [Ayuda] Error con MYSQL! - ManuelAbregu - 22.10.2014

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

Respuesta: [Ayuda] Error con MYSQL! - Zume - 22.10.2014

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

Respuesta: [Ayuda] Error con MYSQL! - fabianlamas33 - 22.10.2014

Debe montar o usar el #WAMP D
Usaste eso?

Respuesta: [Ayuda] Error con MYSQL! - ManuelAbregu - 22.10.2014

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

Respuesta: [Ayuda] Error con MYSQL! - Juand - 22.10.2014

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

Respuesta: [Ayuda] Error con MYSQL! - fabianlamas33 - 22.10.2014

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"


Respuesta: [Ayuda] Error con MYSQL! - ManuelAbregu - 22.10.2014

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!

Respuesta: [Ayuda] Error con MYSQL! - Goncho28 - 23.10.2014

Ahora todos usan ese GM, el nuevo CP