SA-MP Forums Archive
Help , Please ? - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Help , Please ? (/showthread.php?tid=590796)



Help , Please ? - raizo - 04.10.2015

I have recently came in contact with a MySQL script , As i am not much familiar into the MySQL concept , I have some errors of starting the GameMode (It crashes)
Here is the log : (Crash Detect)

Код:
[22:53:18] :: MySQL Conecting :: To '127.0.0.1' as 'port_5076' to database 'port_5076'.
[22:53:18] :: MySQL :: Connection to '127.0.0.1' established.
[22:53:18] :: MySQL :: Database 'port_5076' selected.
[22:53:18] [debug] Server crashed while executing xyx.amx
[22:53:18] [debug] AMX backtrace:
[22:53:18] [debug] #0 native mysql_query () from mysqlS.so
[22:53:18] [debug] #1 0001f42c in public FC_OnGameModeInit () from xyx.amx
[22:53:18] [debug] #2 native CallLocalFunction () from sampsvr-port_5076
[22:53:18] [debug] #3 0000d2f0 in public F_OnGameModeInit () from xyx.amx
[22:53:18] [debug] #4 native CallLocalFunction () from sampsvr-port_5076
[22:53:18] [debug] #5 0000a148 in public Streamer_OnGameModeInit () from xyx.amx
[22:53:18] [debug] #6 native CallLocalFunction () from sampsvr-port_5076
[22:53:18] [debug] #7 00008284 in public Itter_OnGameModeInit () from xyx.amx
[22:53:18] [debug] #8 native CallLocalFunction () from sampsvr-port_5076
[22:53:18] [debug] #9 00007558 in public ScriptInit_OnGameModeInit () from xyx.amx
[22:53:18] [debug] #10 0000674c in public SSCANF_OnGameModeInit () from xyx.amx
[22:53:18] [debug] #11 00000708 in public OnGameModeInit () from xyx.amx
[22:53:18] [debug] Native backtrace:
[22:53:18] [debug] #0 b74a4e8b in _ZN10StackTraceC1EPv () from plugins/crashdetect.so
[22:53:18] [debug] #1 b749dbcf in _ZN11CrashDetect20PrintNativeBacktraceERSoPv () from plugins/crashdetect.so
[22:53:18] [debug] #2 b749edbc in _ZN11CrashDetect20PrintNativeBacktraceEPv () from plugins/crashdetect.so
[22:53:18] [debug] #3 b749f226 in _ZN11CrashDetect11OnExceptionEPv () from plugins/crashdetect.so
[22:53:18] [debug] #4 b74a4adc in ?? () from plugins/crashdetect.so
[22:53:18] [debug] #5 b778740c in ?? ()
[22:53:18] [debug] #6 b69c9aec in _Z5ErrorP5MySQLPKci () from plugins/mysqlS.so
[22:53:18] [debug] #7 b69cdaab in _ZN7Natives13n_mysql_queryEP6tagAMXPi () from plugins/mysqlS.so
[22:53:18] [debug] #8 080950e4 in ?? () from ./sampsvr-port_5076
[22:53:18] [debug] #9 b74a094b in _ZN11CrashDetect13DoAmxCallbackEiPiS0_ () from plugins/crashdetect.so
[22:53:18] [debug] #10 b74a38f8 in ?? () from plugins/crashdetect.so
[22:53:18] [debug] #11 b74a7916 in amx_Exec () from plugins/crashdetect.so
[22:53:18] [debug] #12 b749fbe6 in _ZN11CrashDetect9DoAmxExecEPii () from plugins/crashdetect.so
[22:53:18] [debug] #13 b74a3659 in ?? () from plugins/crashdetect.so
[22:53:18] [debug] #14 080dfd62 in ?? () from ./sampsvr-port_5076
[22:53:18] [debug] #15 080950e4 in ?? () from ./sampsvr-port_5076
[22:53:18] [debug] #16 b74a094b in _ZN11CrashDetect13DoAmxCallbackEiPiS0_ () from plugins/crashdetect.so
[22:53:18] [debug] #17 b74a38f8 in ?? () from plugins/crashdetect.so
[22:53:18] [debug] #18 b74a7916 in amx_Exec () from plugins/crashdetect.so
[22:53:18] [debug] #19 b749fbe6 in _ZN11CrashDetect9DoAmxExecEPii () from plugins/crashdetect.so
[22:53:18] [debug] #20 b74a3659 in ?? () from plugins/crashdetect.so
[22:53:18] [debug] #21 080dfd62 in ?? () from ./sampsvr-port_5076
[22:53:18] [debug] #22 080950e4 in ?? () from ./sampsvr-port_5076
[22:53:18] [debug] #23 b74a094b in _ZN11CrashDetect13DoAmxCallbackEiPiS0_ () from plugins/crashdetect.so
[22:53:18] [debug] #24 b74a38f8 in ?? () from plugins/crashdetect.so
[22:53:18] [debug] #25 b74a7916 in amx_Exec () from plugins/crashdetect.so
[22:53:18] [debug] #26 b749fbe6 in _ZN11CrashDetect9DoAmxExecEPii () from plugins/crashdetect.so
[22:53:18] [debug] #27 b74a3659 in ?? () from plugins/crashdetect.so
[22:53:18] [debug] #28 080dfd62 in ?? () from ./sampsvr-port_5076
[22:53:18] [debug] #29 080950e4 in ?? () from ./sampsvr-port_5076
[22:53:18] [debug] #30 b74a094b in _ZN11CrashDetect13DoAmxCallbackEiPiS0_ () from plugins/crashdetect.so
[22:53:18] [debug] #31 b74a38f8 in ?? () from plugins/crashdetect.so
[22:53:18] [debug] #32 b74a7916 in amx_Exec () from plugins/crashdetect.so
[22:53:18] [debug] #33 b749fbe6 in _ZN11CrashDetect9DoAmxExecEPii () from plugins/crashdetect.so
[22:53:18] [debug] #34 b74a3659 in ?? () from plugins/crashdetect.so
[22:53:18] [debug] #35 080dfd62 in ?? () from ./sampsvr-port_5076
[22:53:18] [debug] #36 080950e4 in ?? () from ./sampsvr-port_5076
[22:53:18] [debug] #37 b74a094b in _ZN11CrashDetect13DoAmxCallbackEiPiS0_ () from plugins/crashdetect.so
[22:53:18] [debug] #38 b74a38f8 in ?? () from plugins/crashdetect.so
[22:53:18] [debug] #39 b74a7916 in amx_Exec () from plugins/crashdetect.so
[22:53:18] [debug] #40 b749fbe6 in _ZN11CrashDetect9DoAmxExecEPii () from plugins/crashdetect.so
[22:53:18] [debug] #41 b74a3659 in ?? () from plugins/crashdetect.so
[22:53:18] [debug] #42 080a503b in ?? () from ./sampsvr-port_5076
[22:53:18] [debug] #43 080ab922 in ?? () from ./sampsvr-port_5076
[22:53:18] [debug] #44 080aa0fd in ?? () from ./sampsvr-port_5076
[22:53:18] [debug] #45 b74dfe66 in __libc_start_main () from /lib/i386-linux-gnu/i686/cmov/libc.so.6
[22:53:18] [debug] #46 0804b4e1 in ?? () from ./sampsvr-port_5076
Please help !


Re: Help , Please ? - Sew_Sumi - 04.10.2015

Who even said to use crash detect? You should post up what is happening, and actually post your SERVER logs, before even trying CrashDetect.

Even though it "works" you shouldn't be instantly adding it, and posting the logs as your first go-to...

Look at the last lines saying about libc6... Chances are you need that installed.


Re: Help , Please ? - raizo - 04.10.2015

Oh , I'm sorry , If you could make out something from this ? (Non Crash Detect Log)

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

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

[05:24:49] password = ""  (string)
[05:24:49] 
[05:24:49] Server Plugins
[05:24:49] --------------
[05:24:49]  Loading plugin: gvar.so
[05:24:49] 

*** GVar Plugin v1.3 by Incognito loaded ***

[05:24:49]   Loaded.
[05:24:49]  Loading plugin: sscanf.so
[05:24:49] 

[05:24:49]  ===============================

[05:24:49]       sscanf plugin loaded.     

[05:24:49]          Version:  2.8.1        

[05:24:49]    © 2012 Alex "******" Cole  

[05:24:49]  ===============================

[05:24:49]   Loaded.
[05:24:49]  Loading plugin: mysql.so
[05:24:49] 

  > MySQL plugin R7 successfully loaded.

[05:24:49]   Loaded.
[05:24:49]  Loading plugin: mysqlS.so
[05:24:49]  SA:MP MySQL Plugin v2.1.1 Loaded.
[05:24:49]   Loaded.
[05:24:49]  Loading plugin: streamer.so
[05:24:49] [MySQL] Thread running. Threadsafe: Yes.
[05:24:49] 

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

[05:24:49]   Loaded.
[05:24:49]  Loading plugin: fixes2.so
[05:24:49] 

[05:24:49]  ===============================

[05:24:49]        fixes plugin loaded.     

[05:24:49]    © 2012 Alex "******" Cole

[05:24:49]  ===============================

[05:24:49]   Loaded.
[05:24:49]  Loading plugin: LIFE-CMD.so
[05:24:49] *====================================================*
[05:24:49] *                                                    *
[05:24:49] *                  LIFE:CMD - Loaded                 *
[05:24:49] *                                                    *
[05:24:49] *                    Version: v2.0                   *
[05:24:49] *                                                    *
[05:24:49] *                    ©2013 Kazon                   *
[05:24:49] *                                                    *
[05:24:49] *====================================================*

[05:24:49]   Loaded.
[05:24:49]  Loading plugin: socket.so
[05:24:49]  Socket plugin v0.1b loaded.
[05:24:49]   Loaded.
[05:24:49]  Loading plugin: whirlpool.so
[05:24:49]  
[05:24:49]  ==================
[05:24:49]  
[05:24:49]   Whirlpool loaded
[05:24:49]  
[05:24:49]  ==================
[05:24:49]  
[05:24:49]   Loaded.
[05:24:49]  Loaded 9 plugins.

[05:24:49] 
[05:24:49] Filterscripts
[05:24:49] ---------------
[05:24:49]   Loading filterscript 'UltraHost.amx'...
[05:24:49]   Loading filterscript 'ClanBases.amx'...
[05:24:49]   Loading filterscript 'GangBases.amx'...
[05:24:49]   Loaded 3 filterscripts.

[05:24:49]  
[05:24:49]  
[05:24:49]  
[05:24:49]  ======================================= 
[05:24:49]  |                                     | 
[05:24:49]  |        YSI version 3.09.0684        | 
[05:24:49]  |        By Alex "******" Cole        | 
[05:24:49]  |                                     | 
[05:24:49]  ======================================= 
[05:24:49]  
[05:24:49] :: MySQL Conecting :: To '127.0.0.1' as 'port_5076' to database 'port_5076'.
[05:24:49] :: MySQL :: Connection to '127.0.0.1' established.
[05:24:49] :: MySQL :: Database 'port_5076' selected.
Thanks


Re: Help , Please ? - Sew_Sumi - 04.10.2015

When did it start doing it? Has it ever run? If it hasn't ever run, this is a guess, but try updating the "/lib/i386-linux-gnu/i686/cmov/libc.so.6" that it says in the CrashDetect.

Try updating to the latest version. Does seem odd that it all runs in the same second on the log, and weird that it "connects" then crashes completely.


Re: Help , Please ? - raizo - 04.10.2015

It has run before , But that is when i didn't install the "MySQLs" (My SQL from Stricken Kid) With an Unknown Gamemode . (Game mode was unknown and we just spawned like in Grand Lacrency) .

Yea ... the administrator of my host said that it had something to do with Mysql_queries . (I don't know what he's talking about) .

So pm me if you find a solution of just reply to this post .


Re: Help , Please ? - Sew_Sumi - 04.10.2015

If you aren't using that gamemode anymore, you should get rid of that MySQL plugin, and use Blues one. If you are using that gamemode, you'll need to update it to handle blues.

Best bet, is to start over maybe if you are switching gamemodes and changing bits. Always clean SA-MP server/MySQL/Userfiles.