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

Threaded Mode
Varios errores, GM ZZ [EN EL MYSQL]
Romero837
Big Clucker
***
Posts: 132
Threads: 40
Joined: Jul 2016
Reputation: 0
#1

18.12.2016, 00:16
Buenas tardes, que tal todos.


Quizб recurrir a este foro que me a ayudado mucho, bueno mi problema se basa en el gamemode Zona Zero liberado antes en este foro por Parka y Lucas Clemente (VER GM EN ESTE HILO: https://sampforum.blast.hk/showthread.php?pid=3712739#pid3712739


Bueno el error se basa bбsicamente en intentar encender el servidor, la base de datos fue configurada correctamente a mi parecer y obviamente no creу que ese sea el error ya que los que me arroja son distintos.


Код:
----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3.7-R2, ©2005-2015 SA-MP Team

password = ""  (string)

Server Plugins
--------------
 Loading plugin: sscanf.so


 ===============================

      sscanf plugin loaded.     

         Version:  2.8.1        

   © 2012 Alex "******" Cole  

 ===============================

  Loaded.
 Loading plugin: crashdetect.so
[18:36:52]   crashdetect v4.8.5 is OK.
  Loaded.
 Loading plugin: streamer.so


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

  Loaded.
 Loading plugin: mysql_static.so
 >> plugin.mysql: R39-2 successfully loaded.
  Loaded.
 Loaded 4 plugins.


Filterscripts
---------------
  Loading filterscript 'cameditor.amx'...

--------------------------------------
 CamEditor by Drebin
--------------------------------------

  Loaded 1 filterscripts.

OnGameo
-CreateDynamicObjetcs[13427]
[18:36:52] [debug] Run time error 4: "Array index out of bounds"
[18:36:52] [debug]  Accessing element at index 150 past array upper bound 149
[18:36:52] [debug] AMX backtrace:
[18:36:52] [debug] #0 00025900 in public SSCANF_OnGameModeInit () from delta.amx
[18:36:52] [debug] #1 native CallLocalFunction () [080dfac0] from samp03svr
[18:36:52] [debug] #2 00001d1c in public zcmd_OnGameModeInit () from delta.amx
[18:36:52] [debug] #3 native CallLocalFunction () [080dfac0] from samp03svr
[18:36:52] [debug] #4 00001634 in public OnGameModeInit () from delta.amx
Number of vehicle models: 0
Aviso: Este error me lo arroja en el log del servidor, aviso que no he movido nada, lo raro es que funcionaba con el antiguo host Linux que usaba, ahora uso otro pero mismo sistema operativo.


Код:
ERROR MYSQL_LOG:

[09:48:42] [ERROR] CMySQLQuery::Execute - (error #1065) Query was empty
[09:48:49] [ERROR] CMySQLQuery::Execute - (error #1065) Query was empty
[09:48:59] [ERROR] CMySQLQuery::Execute - (error #1065) Query was empty
[11:36:17] [ERROR] mysql_format - destination size is too small
[11:36:17] [ERROR] CMySQLQuery::Execute[ConsultarCuenta] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
[11:37:39] [ERROR] mysql_format - destination size is too small
[11:37:39] [ERROR] CMySQLQuery::Execute[ConsultarCuenta] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
[15:09:06] [ERROR] mysql_format - destination size is too small
[15:09:06] [ERROR] CMySQLQuery::Execute[ConsultarCuenta] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
[15:10:47] [ERROR] mysql_format - destination size is too small
[15:10:47] [ERROR] CMySQLQuery::Execute[ConsultarCuenta] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
[18:19:16] [ERROR] mysql_format - destination size is too small
[18:19:16] [ERROR] CMySQLQuery::Execute[ConsultarCuenta] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
[18:43:31] [ERROR] mysql_format - destination size is too small
[18:43:31] [ERROR] CMySQLQuery::Execute[ConsultarCuenta] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
[18:29:23] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[18:29:23] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[18:29:23] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[18:29:23] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[18:29:23] [ERROR] CMySQLQuery::Execute - (error #2006) MySQL server has gone away
[18:29:23] [WARNING] cache_get_row_count - no active cache
[18:29:23] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
[18:29:23] [ERROR] CMySQLQuery::Execute - (error #2006) MySQL server has gone away
[18:29:23] [WARNING] cache_get_row_count - no active cache
[18:29:23] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
[18:29:23] [ERROR] CMySQLQuery::Execute - (error #2006) MySQL server has gone away
[18:29:23] [WARNING] cache_get_row_count - no active cache
[18:29:23] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
[18:29:23] [ERROR] CMySQLQuery::Execute - (error #2006) MySQL server has gone away
[18:29:23] [WARNING] cache_get_row_count - no active cache
[18:29:23] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
[18:29:23] [ERROR] CMySQLQuery::Execute - (error #2006) MySQL server has gone away
[18:29:23] [WARNING] cache_get_row_count - no active cache
[18:29:23] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
[18:36:52] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[18:36:52] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[18:36:52] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[18:36:52] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[18:36:52] [ERROR] CMySQLQuery::Execute - (error #2006) MySQL server has gone away
[18:36:52] [WARNING] cache_get_row_count - no active cache
[18:36:52] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
[18:36:52] [ERROR] CMySQLQuery::Execute - (error #2006) MySQL server has gone away
[18:36:52] [WARNING] cache_get_row_count - no active cache
[18:36:52] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
[18:36:52] [ERROR] CMySQLQuery::Execute - (error #2006) MySQL server has gone away
[18:36:52] [WARNING] cache_get_row_count - no active cache
[18:36:52] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
[18:36:52] [ERROR] CMySQLQuery::Execute - (error #2006) MySQL server has gone away
[18:36:52] [WARNING] cache_get_row_count - no active cache
[18:36:52] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
[18:36:52] [ERROR] CMySQLQuery::Execute - (error #2006) MySQL server has gone away
[18:36:52] [WARNING] cache_get_row_count - no active cache
[18:36:52] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
[18:51:44] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[18:51:44] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[18:51:44] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[18:51:44] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[18:51:44] [ERROR] CMySQLQuery::Execute - (error #2006) MySQL server has gone away
[18:51:44] [WARNING] cache_get_row_count - no active cache
[18:51:44] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
[18:51:44] [ERROR] CMySQLQuery::Execute - (error #2006) MySQL server has gone away
[18:51:44] [WARNING] cache_get_row_count - no active cache
[18:51:44] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
[18:51:44] [ERROR] CMySQLQuery::Execute - (error #2006) MySQL server has gone away
[18:51:44] [WARNING] cache_get_row_count - no active cache
[18:51:44] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
[18:51:44] [ERROR] CMySQLQuery::Execute - (error #2006) MySQL server has gone away
[18:51:44] [WARNING] cache_get_row_count - no active cache
[18:51:44] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
[18:51:44] [ERROR] CMySQLQuery::Execute - (error #2006) MySQL server has gone away
[18:51:44] [WARNING] cache_get_row_count - no active cache
[18:51:44] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
[18:54:04] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[18:54:04] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[18:54:04] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[18:54:04] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[18:54:04] [ERROR] CMySQLQuery::Execute - (error #2006) MySQL server has gone away
[18:54:04] [WARNING] cache_get_row_count - no active cache
[18:54:04] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
[18:54:04] [ERROR] CMySQLQuery::Execute - (error #2006) MySQL server has gone away
[18:54:04] [WARNING] cache_get_row_count - no active cache
[18:54:04] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
[18:54:04] [ERROR] CMySQLQuery::Execute - (error #2006) MySQL server has gone away
[18:54:04] [WARNING] cache_get_row_count - no active cache
[18:54:04] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
[18:54:04] [ERROR] CMySQLQuery::Execute - (error #2006) MySQL server has gone away
[18:54:04] [WARNING] cache_get_row_count - no active cache
[18:54:04] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
[18:54:04] [ERROR] CMySQLQuery::Execute - (error #2006) MySQL server has gone away
[18:54:04] [WARNING] cache_get_row_count - no active cache
[18:54:04] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
[19:09:42] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[19:09:42] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[19:09:42] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[19:09:42] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[19:09:42] [ERROR] CMySQLQuery::Execute - (error #2006) MySQL server has gone away
[19:09:42] [WARNING] cache_get_row_count - no active cache
[19:09:42] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
[19:09:42] [ERROR] CMySQLQuery::Execute - (error #2006) MySQL server has gone away
[19:09:42] [WARNING] cache_get_row_count - no active cache
[19:09:42] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
[19:09:42] [ERROR] CMySQLQuery::Execute - (error #2006) MySQL server has gone away
[19:09:42] [WARNING] cache_get_row_count - no active cache
[19:09:42] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
[19:09:42] [ERROR] CMySQLQuery::Execute - (error #2006) MySQL server has gone away
[19:09:42] [WARNING] cache_get_row_count - no active cache
[19:09:42] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
[19:09:42] [ERROR] CMySQLQuery::Execute - (error #2006) MySQL server has gone away
[19:09:42] [WARNING] cache_get_row_count - no active cache
[19:09:42] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
[19:11:24] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[19:11:24] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[19:11:24] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[19:11:24] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[19:11:24] [ERROR] CMySQLQuery::Execute - (error #2006) MySQL server has gone away
[19:11:24] [WARNING] cache_get_row_count - no active cache
[19:11:24] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
[19:11:24] [ERROR] CMySQLQuery::Execute - (error #2006) MySQL server has gone away
[19:11:24] [WARNING] cache_get_row_count - no active cache
[19:11:24] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
[19:11:24] [ERROR] CMySQLQuery::Execute - (error #2006) MySQL server has gone away
[19:11:24] [WARNING] cache_get_row_count - no active cache
[19:11:24] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
[19:11:24] [ERROR] CMySQLQuery::Execute - (error #2006) MySQL server has gone away
[19:11:24] [WARNING] cache_get_row_count - no active cache
[19:11:24] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
[19:11:24] [ERROR] CMySQLQuery::Execute - (error #2006) MySQL server has gone away
[19:11:24] [WARNING] cache_get_row_count - no active cache
[19:11:24] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
[19:12:34] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[19:12:34] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[19:12:34] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[19:12:34] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[19:12:34] [ERROR] CMySQLQuery::Execute - (error #2006) MySQL server has gone away
[19:12:34] [WARNING] cache_get_row_count - no active cache
[19:12:34] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
[19:12:34] [ERROR] CMySQLQuery::Execute - (error #2006) MySQL server has gone away
[19:12:34] [WARNING] cache_get_row_count - no active cache
[19:12:34] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
[19:12:34] [ERROR] CMySQLQuery::Execute - (error #2006) MySQL server has gone away
[19:12:34] [WARNING] cache_get_row_count - no active cache
[19:12:34] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
[19:12:34] [ERROR] CMySQLQuery::Execute - (error #2006) MySQL server has gone away
[19:12:34] [WARNING] cache_get_row_count - no active cache
[19:12:34] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
[19:12:34] [ERROR] CMySQLQuery::Execute - (error #2006) MySQL server has gone away
[19:12:34] [WARNING] cache_get_row_count - no active cache
[19:12:34] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
[19:29:11] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[19:29:11] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[19:29:11] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[19:29:11] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[19:29:11] [ERROR] CMySQLQuery::Execute - (error #2006) MySQL server has gone away
[19:29:11] [WARNING] cache_get_row_count - no active cache
[19:29:11] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
[19:29:11] [ERROR] CMySQLQuery::Execute - (error #2006) MySQL server has gone away
[19:29:11] [WARNING] cache_get_row_count - no active cache
[19:29:11] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
[19:29:11] [ERROR] CMySQLQuery::Execute - (error #2006) MySQL server has gone away
[19:29:11] [WARNING] cache_get_row_count - no active cache
[19:29:11] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
[19:29:11] [ERROR] CMySQLQuery::Execute - (error #2006) MySQL server has gone away
[19:29:11] [WARNING] cache_get_row_count - no active cache
[19:29:11] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
[19:29:11] [ERROR] CMySQLQuery::Execute - (error #2006) MySQL server has gone away
[19:29:11] [WARNING] cache_get_row_count - no active cache
[19:29:11] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
Espero poder solucionar esto, tal vez serнa la versiуn del MYSQL, pero no se la verdad, muchas gracias a todos por sus respuestas.
Find
Reply
Swedky
Banned
Posts: 2,041
Threads: 97
Joined: Jun 2013
#2

18.12.2016, 00:50
http://forum.sa-mp.com/showpost.php?...55&postcount=2

En tu caso serнa que intentas acceder al нndice 150 de 149 posibles.
Find
Reply
Romero837
Big Clucker
***
Posts: 132
Threads: 40
Joined: Jul 2016
Reputation: 0
#3

18.12.2016, 00:56
Lo que no entiendo es que lo pruebo en mi pc (Windows funciona bien, todo normal, lo probй en vps Linux Ubuntu y funcionу bien, ahora fui a probar en otro vps Linux y nada, primera vez que sale ese error
Find
Reply
Eloy
Huge Clucker
****
Posts: 261
Threads: 3
Joined: May 2016
Reputation: 0
#4

19.12.2016, 21:29
Chequeaste que tengas los plugins necesarios para ese sistema operativo?
Find
Reply
Romero837
Big Clucker
***
Posts: 132
Threads: 40
Joined: Jul 2016
Reputation: 0
#5

20.12.2016, 02:49
Claro, verifiquй, todo carga normal...
Find
Reply
Romero837
Big Clucker
***
Posts: 132
Threads: 40
Joined: Jul 2016
Reputation: 0
#6

21.12.2016, 16:41
їPodrнa ser alguna configuraciуn en el VPS? їTal vez falta de permisos?...
Find
Reply
Parka
High-roller
*****
Posts: 1,666
Threads: 126
Joined: Aug 2011
Reputation: 0
#7

21.12.2016, 17:30
Eso dice que estбs intentando acceder a un index que no existe, ehmm pasa si colocaste 200 slot, cuando el MAX_PLAYERS esta en 150, debes compilar con el MAX_PLAYERS en 200, por ejemplo.
Find
Reply
Romero837
Big Clucker
***
Posts: 132
Threads: 40
Joined: Jul 2016
Reputation: 0
#8

21.12.2016, 19:09
Muchнsimas gracias Parka, ya encendiу el servidor y la verdad habнa pasado esto por alto, pero a lo ultimo en el register me he topado con un nuevo error.

Код:
[15:00:47] [ERROR] CMySQLQuery::Execute[ConsultarCuenta] - (error #1364) Field 'clave2' doesn't have a default value
Esto sale en el mysql log, y obviamente importй la base de datos que se encuentra en el sitio de descarga de tu gamemode.
Find
Reply
Romero837
Big Clucker
***
Posts: 132
Threads: 40
Joined: Jul 2016
Reputation: 0
#9

23.12.2016, 00:07
їAlguna soluciуn? їEsto podrнa ocurrir por la libreria de mysql? Puesto que la que usa la versiуn R39 Actualmente la que usa este gamemode es la lib6 y la actual de mysql creу que es otra.
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