SA-MP Forums Archive
Server crashes when I login (MySQL) - 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: Server crashes when I login (MySQL) (/showthread.php?tid=554384)



Server crashes when I login (MySQL) - MythicalMarauder - 03.01.2015

The server stays online when I register, but when I quit and join with the same account and login, nothing happens after the login dialog and the server turns off. It worked properly on my local host, but not on other hosts (Linux)

Could it possibly be a wrong plugin?


Re: Server crashes when I login (MySQL) - Kelbac - 03.01.2015

I don't know things about MySQL , but you can just use Y_INI or something..


Re: Server crashes when I login (MySQL) - NLFMaster - 03.01.2015

Show us your server_log.txt


Re: Server crashes when I login (MySQL) - Gaurav_Rawat - 03.01.2015

Use crash detect plugin to look for errors.


Re: Server crashes when I login (MySQL) - MythicalMarauder - 03.01.2015

Quote:
Originally Posted by Kelbac
View Post
I don't know things about MySQL , but you can just use Y_INI or something..
No man. I used Y_INI and it sucked.

Quote:
Originally Posted by NLFMaster
View Post
Show us your server_log.txt
Code:
----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3z-R4, ©2005-2014 SA-MP Team

[13:34:27] password = ""  (string)
[13:34:27] 
[13:34:27] Server Plugins
[13:34:27] --------------
[13:34:27]  Loading plugin: mysql.so
[13:34:27] 

  > MySQL plugin R6 successfully loaded.

[13:34:27]   Loaded.
[13:34:27]  Loaded 1 plugins.

[13:34:27] 
[13:34:27] Filterscripts
[13:34:27] ---------------
[13:34:27]   Loading filterscript 'UltraHost.amx'...
[13:34:27]   Loaded 1 filterscripts.

[13:34:27] 
----------------------------------
[13:34:27]  S4S Open world Deathmatch          
[13:34:27] ----------------------------------

[13:34:27] Number of vehicle models: 32
[13:34:52] [join] [WTF]DedSec has joined the server
Quote:
Originally Posted by Gaurav_Rawat
View Post
Use crash detect plugin to look for errors.
Alright will use it and post results.


Re: Server crashes when I login (MySQL) - NLFMaster - 03.01.2015

Okay,now post the server_log with crashdetect loaded


Re: Server crashes when I login (MySQL) - MythicalMarauder - 03.01.2015

here it is:
Code:
----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3z-R4, ©2005-2014 SA-MP Team

[16:37:14] password = ""  (string)
[16:37:14] 
[16:37:14] Server Plugins
[16:37:14] --------------
[16:37:14]  Loading plugin: mysql.so
[16:37:14] 

  > MySQL plugin R6 successfully loaded.

[16:37:14]   Loaded.
[16:37:14]  Loading plugin: crashdetect.so
[16:37:14]   CrashDetect v4.15.1 is OK.
[16:37:14]   Loaded.
[16:37:14]  Loaded 2 plugins.

[16:37:14] 
[16:37:14] Filterscripts
[16:37:14] ---------------
[16:37:14]   Loading filterscript 'UltraHost.amx'...
[16:37:14]   Loaded 1 filterscripts.

[16:37:14] 
----------------------------------
[16:37:14]  S4S Open world Deathmatch          
[16:37:14] ----------------------------------

[16:37:14] Number of vehicle models: 32
[16:37:43] Incoming connection: 176.205.59.94:49914
[16:37:43] [join] [WTF]DedSec has joined the server (0:176.205.59.94)
[16:38:08] [debug] Server crashed while executing s4sdm.amx
[16:38:08] [debug] AMX backtrace:
[16:38:08] [debug] #0 native mysql_fetch_field_row () from mysql.so
[16:38:08] [debug] #1 000167c0 in ?? (0) from s4sdm.amx
[16:38:08] [debug] #2 0001027c in public OnDialogResponse (0, 12348, 1, -1, 175952) from s4sdm.amx
[16:38:09] [debug] Native backtrace:
[16:38:09] [debug] #0 b6a74e8b in _ZN10StackTraceC1EPv () from plugins/crashdetect.so
[16:38:09] [debug] #1 b6a6dbcf in _ZN11CrashDetect20PrintNativeBacktraceERSoPv () from plugins/crashdetect.so
[16:38:09] [debug] #2 b6a6edbc in _ZN11CrashDetect20PrintNativeBacktraceEPv () from plugins/crashdetect.so
[16:38:09] [debug] #3 b6a6f226 in _ZN11CrashDetect11OnExceptionEPv () from plugins/crashdetect.so
[16:38:09] [debug] #4 b6a74adc in ?? () from plugins/crashdetect.so
[16:38:09] [debug] #5 b777c40c in ?? ()
[16:38:09] [debug] #6 b7543f36 in ?? () from /lib/i386-linux-gnu/i686/cmov/libc.so.6
[16:38:09] [debug] #7 b771e073 in _ZNKSs7compareEPKc () from /usr/lib/i386-linux-gnu/libstdc++.so.6
[16:38:09] [debug] #8 b74b3973 in _ZN13CMySQLHandler10FetchFieldESs () from plugins/mysql.so
[16:38:09] [debug] #9 b74b8820 in _ZN7Natives23n_mysql_fetch_field_rowEP6tagAMXPi () from plugins/mysql.so
[16:38:09] [debug] #10 08094054 in ?? () from ./sampsvr-port_5068
[16:38:09] [debug] #11 b6a7094b in _ZN11CrashDetect13DoAmxCallbackEiPiS0_ () from plugins/crashdetect.so
[16:38:09] [debug] #12 b6a738f8 in ?? () from plugins/crashdetect.so
[16:38:09] [debug] #13 b6a77916 in amx_Exec () from plugins/crashdetect.so
[16:38:09] [debug] #14 b6a6fbe6 in _ZN11CrashDetect9DoAmxExecEPii () from plugins/crashdetect.so
[16:38:09] [debug] #15 b6a73659 in ?? () from plugins/crashdetect.so
[16:38:09] [debug] #16 080a524f in ?? () from ./sampsvr-port_5068
[16:38:09] [debug] #17 080b11c4 in ?? () from ./sampsvr-port_5068
[16:38:09] [debug] #18 08071b38 in ?? () from ./sampsvr-port_5068
[16:38:09] [debug] #19 08071c32 in ?? () from ./sampsvr-port_5068
[16:38:09] [debug] #20 0807bb80 in ?? () from ./sampsvr-port_5068
[16:38:09] [debug] #21 080ad3bd in ?? () from ./sampsvr-port_5068
[16:38:09] [debug] #22 080ad562 in ?? () from ./sampsvr-port_5068
[16:38:09] [debug] #23 080a88ce in ?? () from ./sampsvr-port_5068
[16:38:09] [debug] #24 b74dae66 in __libc_start_main () from /lib/i386-linux-gnu/i686/cmov/libc.so.6
[16:38:09] [debug] #25 0804b4d1 in ?? () from ./sampsvr-port_5068



Re: Server crashes when I login (MySQL) - NLFMaster - 03.01.2015

Hmm..Something is wrong with the login dialog at OnDialogResponse.Would you show that too?


Re: Server crashes when I login (MySQL) - MythicalMarauder - 03.01.2015

pawn Code:
case DIALOG_LOGIN:
        {
            if(!response)
            {
                SendClientMessage(playerid, RED, "You must login before you spawn!");
                ShowDialog(playerid, DIALOG_LOGIN);
            }
            if(response)
            {
                new query[200], pname[24], escapepass[100];
                GetPlayerName(playerid, pname, 24);
                mysql_real_escape_string(inputtext, escapepass);
                format(query, sizeof(query), "SELECT `user` FROM playerdata WHERE user = '%s' AND password = SHA1('%s')", pname, escapepass);
                mysql_query(query);
                mysql_store_result();
                new numrows = mysql_num_rows();
                if(numrows == 1)
                {
                    MySQL_Login(playerid);
                    Muted[playerid] = 0;
                    SendClientMessage(playerid, GREEN, "You have successfully logged in");
                    new string[256];
                    Clan[playerid] = pInfo[playerid][pClan];
                }



Re: Server crashes when I login (MySQL) - NLFMaster - 03.01.2015

Search in your gamemode for the "MySQL_Login(playerid)" function and post it!