1. SA-MP Forums Archive
  2. Non-English
  3. Languages
  4. Español/Spanish

Threaded Mode
[Ayuda] Error con MYSQL!
ManuelAbregu
Big Clucker
***
Posts: 133
Threads: 25
Joined: May 2014
Reputation: 0
#1

22.10.2014, 04:15
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!
Find
Reply
aoEXE
Gangsta
*****
Posts: 789
Threads: 36
Joined: Dec 2013
Reputation: 0
#2

22.10.2014, 04:41
en el archivo 'mysql_log' puede que te diga que pasa
Find
Reply
ManuelAbregu
Big Clucker
***
Posts: 133
Threads: 25
Joined: May 2014
Reputation: 0
#3

22.10.2014, 04:50
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
Find
Reply
Zume
High-roller
*****
Posts: 1,642
Threads: 35
Joined: Nov 2011
Reputation: 0
#4

22.10.2014, 05:25
Has comprobado que los datos a los que conecta estбn bien?
Find
Reply
fabianlamas33
Banned
Posts: 484
Threads: 19
Joined: Jul 2014
#5

22.10.2014, 06:48
Debe montar o usar el #WAMP D
Usaste eso?
Find
Reply
ManuelAbregu
Big Clucker
***
Posts: 133
Threads: 25
Joined: May 2014
Reputation: 0
#6

22.10.2014, 16:28
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
Find
Reply
Juand
Huge Clucker
****
Posts: 305
Threads: 27
Joined: Oct 2014
Reputation: 0
#7

22.10.2014, 17:30
Para que comienzas con un gm como estos si a duras penas sabes scriptear?
Find
Reply
fabianlamas33
Banned
Posts: 484
Threads: 19
Joined: Jul 2014
#8

22.10.2014, 17:45
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"
Find
Reply
ManuelAbregu
Big Clucker
***
Posts: 133
Threads: 25
Joined: May 2014
Reputation: 0
#9

22.10.2014, 18:20
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!
Find
Reply
Goncho28
High-roller
*****
Posts: 1,414
Threads: 25
Joined: Feb 2014
Reputation: 0
#10

23.10.2014, 22:30
Ahora todos usan ese GM, el nuevo CP
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. Non-English
  3. Languages
  4. Español/Spanish