MySQL error
#1

Hi, i have the next problem

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

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

[16:26:17] filterscripts = ""  (string)
[16:26:17] 
[16:26:17] Server Plugins
[16:26:17] --------------
[16:26:17]  Loading plugin: mysql.so
[16:26:17]  >> plugin.mysql: R41-2 successfully loaded.
[16:26:17]   Loaded.
[16:26:17]  Loading plugin: mysql_static.so
[16:26:17]  >> plugin.mysql: R39-6 successfully loaded.
[16:26:17]   Loaded.
[16:26:17]  Loading plugin: crashdetect.so
[16:26:17]   CrashDetect v4.15.1 is OK.
[16:26:17]   Loaded.
[16:26:17]  Loading plugin: streamer.so
[16:26:17] 

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

[16:26:17]   Loaded.
[16:26:17]  Loading plugin: sscanf.so
[16:26:17] 

[16:26:17]  ===============================

[16:26:17]       sscanf plugin loaded.     

[16:26:17]          Version:  2.8.1        

[16:26:17]    © 2012 Alex "******" Cole  

[16:26:17]  ===============================

[16:26:17]   Loaded.
[16:26:17]  Loading plugin: nativechecker.so
[16:26:17]   Loaded.
[16:26:17]  Loaded 6 plugins.

[16:26:17] 
[16:26:17] Filterscripts
[16:26:17] ---------------
[16:26:17]   Loaded 0 filterscripts.

[16:26:17]  
[16:26:17]  
[16:26:17]  
[16:26:17]  ======================================= 
[16:26:17]  |                                     | 
[16:26:17]  |        YSI version 3.09.0684        | 
[16:26:17]  |        By Alex "******" Cole        | 
[16:26:17]  |                                     | 
[16:26:17]  ======================================= 
[16:26:17]  
[16:26:17]  
[16:26:17]  
[16:26:17] |=========================Database=========================

[16:26:17] MYSQL: Conectando a servidor...

[16:26:17] MYSQL: Error de conexiуn, reconectando...

[16:26:17] MYSQL: La conexiуn no se pudo realizar, saliendo...
[16:26:17] Basuras totales: 0 (MAX: 50)
[16:26:17] Seсales totales: 0 (MAX: 600)
[16:26:17] Casas Totales: 0 (MAX: 900)
[16:26:17] Almacenes Totales: 0 (MAX: 30)
[16:26:17] Talleres Totales: 0 (MAX: 5)
[16:26:17] Varios cargados
[16:26:17] Delitos Totales: 0 (MAX: 9999)
[16:26:17] Facciones Totales: 0 (MAX: 20)
[16:26:17] Garajes Totales: 0 (MAX: 800)
[16:26:17] Negocios cargados: 0 (MAX: 400)
[16:26:17] Menus cargados: 0 (MAX: 150)
[16:26:17]  ==== SquadGames Roleplay ====
[16:26:17]  ====         2017        ====
[16:26:17] Number of vehicle models: 0
[16:26:17] --- Server Shutting Down.
[16:26:17] plugin.mysql: Unloading plugin...
[16:26:17] plugin.mysql: Plugin unloaded.
[16:26:17] plugin.mysql: Unloading plugin...
[16:26:17] plugin.mysql: Plugin unloaded.
[16:26:17] 

*** Streamer Plugin v2.7.8 by Incognito unloaded ***

[16:26:17] 

[16:26:17]  ===============================

[16:26:17]      sscanf plugin unloaded.    

[16:26:17]  ===============================
But I do not know how to fix it

Pleas any solution?

Thanks!!
Reply
#2

Is the details to the mysql database correct? Check again
Reply
#3

Why you are using 2x mysql plugins? mysql.so mysql_static.so
Reply
#4

Quote:
Originally Posted by Immortal99
Посмотреть сообщение
Is the details to the mysql database correct? Check again
Yes, the details is correct.

Quote:
Originally Posted by Yousha
Посмотреть сообщение
Why you are using 2x mysql plugins? mysql.so mysql_static.so
Im using this mysql plugin...

https://github.com/pBlueG/SA-MP-MySQL/releases
Reply
#5

His not asking you what version of mysql plugin you using. He is saying you are using 2 mysql plugins in server.cfg just use one mahn.
Reply
#6

Use only mysql_static plugin and that error is because of in-correct mysql details in your mysql config. Data can not be accessed because of incorrect details...!
Reply
#7

Quote:
Originally Posted by Immortal99
Посмотреть сообщение
His not asking you what version of mysql plugin you using. He is saying you are using 2 mysql plugins in server.cfg just use one mahn.
im using this plugin...

the latest version dont have mysql_static.so

And when I only use mysql.so Give me these mistakes:

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

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

[14:47:36] filterscripts = ""  (string)
[14:47:36] 
[14:47:36] Server Plugins
[14:47:36] --------------
[14:47:36]  Loading plugin: mysql.so
[14:47:36]  >> plugin.mysql: R41-2 successfully loaded.
[14:47:36]   Loaded.
[14:47:36]  Loading plugin: sscanf.so
[14:47:36] 

[14:47:36]  ===============================

[14:47:36]       sscanf plugin loaded.     

[14:47:36]          Version:  2.8.1        

[14:47:36]    © 2012 Alex "******" Cole  

[14:47:36]  ===============================

[14:47:36]   Loaded.
[14:47:36]  Loading plugin: crashdetect.so
[14:47:36]   CrashDetect v4.15.1 is OK.
[14:47:36]   Loaded.
[14:47:36]  Loading plugin: streamer.so
[14:47:36] 

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

[14:47:36]   Loaded.
[14:47:36]  Loading plugin: nativechecker.so
[14:47:36]   Loaded.
[14:47:36]  Loaded 5 plugins.

[14:47:36] 
[14:47:36] Filterscripts
[14:47:36] ---------------
[14:47:36]   Loaded 0 filterscripts.

[14:47:36]    Error: Function not registered: 'cache_get_row_int'
[14:47:36]    Error: Function not registered: 'cache_get_row_float'
[14:47:36]    Error: Function not registered: 'cache_get_row'
[14:47:36]    Error: Function not registered: 'cache_get_data'
[14:47:36] [debug] Run time error 19: "File or function is not found"
[14:47:36] [debug]  cache_get_row_int
[14:47:36] [debug]  cache_get_row_float
[14:47:36] [debug]  cache_get_row
[14:47:36] [debug]  cache_get_data
[14:47:36] [debug] Run time error 19: "File or function is not found"
[14:47:36] [debug]  cache_get_row_int
[14:47:36] [debug]  cache_get_row_float
[14:47:36] [debug]  cache_get_row
[14:47:36] [debug]  cache_get_data
[14:47:36] Script[gamemodes/gm.amx]: Run time error 19: "File or function is not found"
[14:47:36] Number of vehicle models: 0
Quote:
Originally Posted by muzammilfreeman
Посмотреть сообщение
Use only mysql_static plugin and that error is because of in-correct mysql details in your mysql config. Data can not be accessed because of incorrect details...!
The detail of my mysql its correct....

When I use mysql_static.so only of latest version (R39-6) Give me these mistakes:

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

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

[14:49:25] filterscripts = ""  (string)
[14:49:25] 
[14:49:25] Server Plugins
[14:49:25] --------------
[14:49:25]  Loading plugin: mysql_static.so
[14:49:25]  >> plugin.mysql: R39-6 successfully loaded.
[14:49:25]   Loaded.
[14:49:25]  Loading plugin: sscanf.so
[14:49:25] 

[14:49:25]  ===============================

[14:49:25]       sscanf plugin loaded.     

[14:49:25]          Version:  2.8.1        

[14:49:25]    © 2012 Alex "******" Cole  

[14:49:25]  ===============================

[14:49:25]   Loaded.
[14:49:25]  Loading plugin: crashdetect.so
[14:49:25]   CrashDetect v4.15.1 is OK.
[14:49:25]   Loaded.
[14:49:25]  Loading plugin: streamer.so
[14:49:25] 

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

[14:49:25]   Loaded.
[14:49:25]  Loading plugin: nativechecker.so
[14:49:25]   Loaded.
[14:49:25]  Loaded 5 plugins.

[14:49:25] 
[14:49:25] Filterscripts
[14:49:25] ---------------
[14:49:25]   Loaded 0 filterscripts.

[14:49:26]  
[14:49:26]  
[14:49:26]  
[14:49:26]  ======================================= 
[14:49:26]  |                                     | 
[14:49:26]  |        YSI version 3.09.0684        | 
[14:49:26]  |        By Alex "******" Cole        | 
[14:49:26]  |                                     | 
[14:49:26]  ======================================= 
[14:49:26]  
[14:49:26]  
[14:49:26]  
[14:49:26] |=========================Database=========================

[14:49:26] MYSQL: Conectando a servidor...

[14:49:26] [debug] Server crashed while executing gm.amx
[14:49:26] [debug] AMX backtrace:
[14:49:26] [debug] #0 native mysql_connect () from mysql_static.so
[14:49:26] [debug] #1 002af754 in ?? (43887012, 43887052, 43887072, 43887116) from gm.amx
[14:49:26] [debug] #2 001a4674 in public OnPlPa_OnGameModeInit () from gm.amx
[14:49:26] [debug] #3 native CallLocalFunction () from samp03svr
[14:49:26] [debug] #4 001a37ac in public zcmd_OnGameModeInit () from gm.amx
[14:49:26] [debug] #5 native CallLocalFunction () from samp03svr
[14:49:26] [debug] #6 00017a98 in public SSCANF_OnGameModeInit () from gm.amx
[14:49:26] [debug] #7 00011e00 in ?? () from gm.amx
[14:49:26] [debug] #8 0000b468 in public Itter_OnGameModeInit () from gm.amx
[14:49:26] [debug] #9 native CallLocalFunction () from samp03svr
[14:49:26] [debug] #10 000080a0 in public ScriptInit_OnGameModeInit () from gm.amx
[14:49:26] [debug] #11 00005310 in public OnGameModeInit () from gm.amx
[14:49:26] [debug] Native backtrace:
[14:49:26] [debug] #0 f661de8b in _ZN10StackTraceC1EPv () from plugins/crashdetect.so
[14:49:26] [debug] #1 f6616bcf in _ZN11CrashDetect20PrintNativeBacktraceERSoPv () from plugins/crashdetect.so
[14:49:26] [debug] #2 f6617dbc in _ZN11CrashDetect20PrintNativeBacktraceEPv () from plugins/crashdetect.so
[14:49:26] [debug] #3 f6618226 in _ZN11CrashDetect11OnExceptionEPv () from plugins/crashdetect.so
[14:49:26] [debug] #4 f661dadc in ?? () from plugins/crashdetect.so
[14:49:26] [debug] #5 f776b410 in ?? ()
[14:49:26] [debug] #6 f776b430 in ?? ()
[14:49:26] [debug] #7 f74481f7 in gsignal () from /lib/libc.so.6
[14:49:26] [debug] #8 f7449a33 in abort () from /lib/libc.so.6
[14:49:26] [debug] #9 f768379d in _ZN9__gnu_cxx27__verbose_terminate_handlerEv () from /lib/libstdc++.so.6
[14:49:26] [debug] #10 f7681263 in ?? () from /lib/libstdc++.so.6
[14:49:26] [debug] #11 f768129f in ?? () from /lib/libstdc++.so.6
[14:49:26] [debug] #12 f7681508 in ?? () from /lib/libstdc++.so.6
[14:49:26] [debug] #13 f70b789f in _ZN5boost15throw_exceptionINS_21thread_resource_errorEEEvRKT_ () from plugins/mysql_static.so
[14:49:26] [debug] #14 f70bdaf1 in _ZN5boost6threadC1INS_3_bi6bind_tIvNS_4_mfi3mf0Iv16CMySQLConnectionEENS2_5list1INS2_5valueIPS6_EEEEEEEEOT_ () from plugins/mysql_static.so
[14:49:26] [debug] #15 f70ba674 in _ZN16CMySQLConnectionC1ERSsS0_S0_S0_jbb () from plugins/mysql_static.so
[14:49:26] [debug] #16 f70ba7c0 in _ZN16CMySQLConnection6CreateERSsS0_S0_S0_jbb () from plugins/mysql_static.so
[14:49:26] [debug] #17 f70bf3f6 in _ZN12CMySQLHandle6CreateESsSsSsSsjjb () from plugins/mysql_static.so
[14:49:26] [debug] #18 f70d3611 in _ZN6Native13mysql_connectEP6tagAMXPi () from plugins/mysql_static.so
[14:49:26] [debug] #19 080950e4 in ?? () from ./samp03svr
[14:49:26] [debug] #20 f661994b in _ZN11CrashDetect13DoAmxCallbackEiPiS0_ () from plugins/crashdetect.so
[14:49:26] [debug] #21 f661c8f8 in ?? () from plugins/crashdetect.so
[14:49:26] [debug] #22 f6620916 in amx_Exec () from plugins/crashdetect.so
[14:49:26] [debug] #23 f6618be6 in _ZN11CrashDetect9DoAmxExecEPii () from plugins/crashdetect.so
[14:49:26] [debug] #24 f661c659 in ?? () from plugins/crashdetect.so
[14:49:26] [debug] #25 f626a25c in ?? () from plugins/streamer.so
[14:49:26] [debug] #26 080dfd62 in ?? () from ./samp03svr
[14:49:26] [debug] #27 080950e4 in ?? () from ./samp03svr
[14:49:26] [debug] #28 f661994b in _ZN11CrashDetect13DoAmxCallbackEiPiS0_ () from plugins/crashdetect.so
[14:49:26] [debug] #29 f661c8f8 in ?? () from plugins/crashdetect.so
[14:49:26] [debug] #30 f6620916 in amx_Exec () from plugins/crashdetect.so
[14:49:26] [debug] #31 f6618be6 in _ZN11CrashDetect9DoAmxExecEPii () from plugins/crashdetect.so
[14:49:26] [debug] #32 f661c659 in ?? () from plugins/crashdetect.so
[14:49:26] [debug] #33 f626a25c in ?? () from plugins/streamer.so
[14:49:26] [debug] #34 080dfd62 in ?? () from ./samp03svr
[14:49:26] [debug] #35 080950e4 in ?? () from ./samp03svr
[14:49:26] [debug] #36 f661994b in _ZN11CrashDetect13DoAmxCallbackEiPiS0_ () from plugins/crashdetect.so
[14:49:26] [debug] #37 f661c8f8 in ?? () from plugins/crashdetect.so
[14:49:26] [debug] #38 f6620916 in amx_Exec () from plugins/crashdetect.so
[14:49:26] [debug] #39 f6618be6 in _ZN11CrashDetect9DoAmxExecEPii () from plugins/crashdetect.so
[14:49:26] [debug] #40 f661c659 in ?? () from plugins/crashdetect.so
[14:49:26] [debug] #41 f626a25c in ?? () from plugins/streamer.so
[14:49:26] [debug] #42 080dfd62 in ?? () from ./samp03svr
[14:49:26] [debug] #43 080950e4 in ?? () from ./samp03svr
[14:49:26] [debug] #44 f661994b in _ZN11CrashDetect13DoAmxCallbackEiPiS0_ () from plugins/crashdetect.so
[14:49:26] [debug] #45 f661c8f8 in ?? () from plugins/crashdetect.so
[14:49:26] [debug] #46 f6620916 in amx_Exec () from plugins/crashdetect.so
[14:49:26] [debug] #47 f6618be6 in _ZN11CrashDetect9DoAmxExecEPii () from plugins/crashdetect.so
[14:49:26] [debug] #48 f661c659 in ?? () from plugins/crashdetect.so
[14:49:26] [debug] #49 f626a25c in ?? () from plugins/streamer.so
[14:49:26] [debug] #50 080a503b in ?? () from ./samp03svr
[14:49:26] [debug] #51 080ab922 in ?? () from ./samp03svr
[14:49:26] [debug] #52 080aa0fd in ?? () from ./samp03svr
[14:49:26] [debug] #53 f74339a3 in __libc_start_main () from /lib/libc.so.6
Reply
#8

Trying re-compiling gamemode and than restart server.. I hope that works..
Reply
#9

First log you posted in the thread shows that you couldn't connect to the database, nothing wrong with the plugins. However, I don't see a point of using two different mysql plugins at the same moment.
Reply
#10

Quote:
Originally Posted by muzammilfreeman
Посмотреть сообщение
Trying re-compiling gamemode and than restart server.. I hope that works..
I've already tried it and nothing

Quote:
Originally Posted by TopShooter
Посмотреть сообщение
First log you posted in the thread shows that you couldn't connect to the database, nothing wrong with the plugins. However, I don't see a point of using two different mysql plugins at the same moment.
There are two different plugins, it is the same plugin that should be used both together
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)