Server crashes on joining - 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 on joining (
/showthread.php?tid=664129)
Server crashes on joining -
IndependentGaming - 19.02.2019
Hello, when I start the server and I try to join it it show me welcome to the server, and before you type in your password the server crashes
Server Logs
Код:
----------
Loaded log file: "server_log.txt".
----------
SA-MP Dedicated Server
----------------------
v0.3.7-R2, ©2005-2015 SA-MP Team
[21:31:32] filterscripts = "" (string)
[19/02/2019 21:31:32]
[19/02/2019 21:31:32] Server Plugins
[19/02/2019 21:31:32] --------------
[19/02/2019 21:31:32] Loading plugin: crashdetect
[19/02/2019 21:31:32] CrashDetect v4.16 is OK.
[19/02/2019 21:31:32] Loaded.
[19/02/2019 21:31:32] Loading plugin: mysql
[19/02/2019 21:31:32]
> MySQL plugin R6-2 successfully loaded.
[19/02/2019 21:31:32] Loaded.
[19/02/2019 21:31:32] Loading plugin: sscanf
[19/02/2019 21:31:32]
[19/02/2019 21:31:32] ===============================
[19/02/2019 21:31:32] sscanf plugin loaded.
[19/02/2019 21:31:32] Version: 2.8.1
[19/02/2019 21:31:32] © 2012 Alex "******" Cole
[19/02/2019 21:31:32] ===============================
[19/02/2019 21:31:32] Loaded.
[19/02/2019 21:31:32] Loading plugin: streamer
[19/02/2019 21:31:32]
*** Streamer Plugin v2.8.2 by Incognito loaded ***
[19/02/2019 21:31:32] Loaded.
[19/02/2019 21:31:32] Loading plugin: Whirlpool
[19/02/2019 21:31:32]
[19/02/2019 21:31:32] ==================
[19/02/2019 21:31:32]
[19/02/2019 21:31:32] Whirlpool loaded
[19/02/2019 21:31:32]
[19/02/2019 21:31:32] ==================
[19/02/2019 21:31:32]
[19/02/2019 21:31:32] Loaded.
[19/02/2019 21:31:32] Loaded 5 plugins.
[19/02/2019 21:31:32]
[19/02/2019 21:31:32] Filterscripts
[19/02/2019 21:31:32] ---------------
[19/02/2019 21:31:32] Loaded 0 filterscripts.
[19/02/2019 21:31:38]
----------------------------------
[19/02/2019 21:31:38] Gamemode Roleplay
[19/02/2019 21:31:38] ----------------------------------
[19/02/2019 21:31:38] Number of vehicle models: 115
[19/02/2019 21:32:04] [connection] 127.0.0.1:61387 requests connection cookie.
[19/02/2019 21:32:05] [connection] incoming connection: 127.0.0.1:61387 id: 0
[19/02/2019 21:32:05] [join] Jeffery_Jenkens has joined the server (0:127.0.0.1)
[19/02/2019 21:32:06] [debug] Server crashed while executing Gamemode.amx
[19/02/2019 21:32:06] [debug] AMX backtrace:
[19/02/2019 21:32:06] [debug] #0 native mysql_real_escape_string () from mysql.DLL
[19/02/2019 21:32:06] [debug] #1 00200be4 in public Login (0) from Gamemode.amx
[19/02/2019 21:32:07] [debug] Native backtrace:
[19/02/2019 21:32:07] [debug] #0 64a21bb0 in ?? () from C:\WINDOWS\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.9415_none_508df7e2bcbccb90\MSVCR90.dll
[19/02/2019 21:32:07] [debug] #1 64a04951 in ?? () from C:\WINDOWS\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.9415_none_508df7e2bcbccb90\MSVCR90.dll
[19/02/2019 21:32:07] [debug] #2 64a04996 in ?? () from C:\WINDOWS\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.9415_none_508df7e2bcbccb90\MSVCR90.dll
[19/02/2019 21:32:07] [debug] #3 10005b71 in ?? () from plugins\mysql.DLL
[19/02/2019 21:32:07] [debug] #4 10005d7d in ?? () from plugins\mysql.DLL
[19/02/2019 21:32:07] [debug] #5 10008bd8 in ?? () from plugins\mysql.DLL
[19/02/2019 21:32:07] [debug] #6 10006bd6 in ?? () from plugins\mysql.DLL
[19/02/2019 21:32:07] [debug] #7 004010b6 in ?? () from samp-server.exe
[19/02/2019 21:32:07] [debug] #8 5bf6c6fa in ?? () from plugins\crashdetect.DLL
[19/02/2019 21:32:07] [debug] #9 5bf72278 in ?? () from plugins\crashdetect.DLL
[19/02/2019 21:32:07] [debug] #10 5bf6a0d7 in ?? () from plugins\crashdetect.DLL
[19/02/2019 21:32:07] [debug] #11 5bf6c74a in ?? () from plugins\crashdetect.DLL
[19/02/2019 21:32:07] [debug] #12 5be94509 in ?? () from plugins\streamer.DLL
[19/02/2019 21:32:07] [debug] #13 00482a68 in ?? () from samp-server.exe
[19/02/2019 21:32:07] [debug] #14 004912ba in ?? () from samp-server.exe
Server Debug log
Код:
[21:31:32]
[21:31:32] ---------------------------
[21:31:32] MySQL Debugging activated (02/19/19)
[21:31:32] ---------------------------
[21:31:32]
[21:31:32] >> mysql_query( Connection handle: 1 )
[21:31:32] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)
[21:32:06] >> mysql_real_escape_string( Connection handle: 1 )
Public Login
PHP код:
forward Login(playerid);
public Login(playerid)
{
// Display the main menu
ShowMainMenuGUI(playerid);
ClearChatbox(playerid);
SetPlayerVirtualWorld(playerid, 0);
SetPlayerCameraPos(playerid, 2022.083740, -1308.260620, 80.478797);
SetPlayerCameraLookAt(playerid, 1970.506103, -1201.447143, 25.596593);
new
szQuery[128],
szPlayerName[MAX_PLAYER_NAME],
szPlayerName2[MAX_PLAYER_NAME];
GetPlayerName(playerid, szPlayerName, sizeof(szPlayerName));
mysql_real_escape_string(szPlayerName, szPlayerName2, g_MySQLConnections[0]);
// Check MySQL to see if any accounts exist with the specified username on login.
format(szQuery, sizeof(szQuery), "SELECT COUNT(*) FROM players WHERE Username = '%s'", szPlayerName);
mysql_query(szQuery, THREAD_CONFIRM_USERNAME, playerid, g_MySQLConnections[0]);
//ConnectionLog(playerid, PlayerInfo[playerid][pID], szPlayerName);
return 1;
}
Re: Server crashes on joining -
SymonClash - 19.02.2019
Just remove mysql_real_escape_string and replace %s with '%e'.
Also i don't understand why are you doing:
new szPlayerName, szPlayerName2, but retrieving just the first szPlayerName and escaping the second.
Doesn't make sense.