server crashes - 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 (/showthread.php?tid=417107)
+- 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 (/showthread.php?tid=417107)
server crashes - mineralo - 19.02.2013
well, when I use any mysql code server just crash, what's would be problem?
code from crash info
Код:
-------------------------- SA-MP Server: 0.3x Exception At Address: 0x6DA3E543 Module: (MSVCR90.dll) Registers: EAX: 0x00000000 EBX: 0x00000000 ECX: 0x6DA9A2C0 EDX: 0xFFFFFFAC ESI: 0x45797265 EDI: 0x00000000 EBP: 0x0018FAC4 ESP: 0x0018FAA4 EFLAGS: 0x00010283 Stack: +0000: 0x00000000 0x01E70448 0x01FFFF78 0x6DA9A2C0 +0010: 0x6DA97760 0x01EF34F0 0x00008E00 0x00000000 +0020: 0x0018FAE0 0x6DA3E735 0x6DA9A3A0 0x45797265 +0030: 0x00000000 0x0000000A 0x00000000 0x0018FAF4 +0040: 0x6DA26085 0x45797265 0x00000000 0x0000000A +0050: 0x0018FE24 0x10009FEB 0x45797265 0x0293E230 +0060: 0x02931450 0x0293E230 0x02CF0568 0x01E7B60B +0070: 0x0000000F 0x75516E4F 0x45797265 0x726F7272 +0080: 0x67610000 0x416F5465 0x78456C6C 0x01F14B00 +0090: 0x0018FB50 0x0018FB84 0x00000000 0x0293E352 +00A0: 0x0293E230 0x02CF0648 0x02FBCA94 0x00000001 +00B0: 0x00000009 0xFFFFFFFD 0x02CFD2C8 0x0293E350 +00C0: 0x02CFC2C8 0x00000000 0x44206E61 0x02CFC358 +00D0: 0x004526C9 0x01E76EFA 0x01E76EF8 0x00000039 +00E0: 0x0000003F 0x000000A0 0x00003131 0x01E76ED8 +00F0: 0x00000000 0xFFFFFFFF 0x00000002 0x0000000F +0100: 0x00451F58 0x004A0030 0x0018FC8D 0x00000020 +0110: 0x00000001 0x00000001 0x0000000F 0x6400A8C0 +0120: 0x00000031 0x00000000 0x00000000 0xFFFFFFFF +0130: 0x00000001 0x0000000F 0x00000003 0x01E70900 -------------------------- Loaded Modules: samp-server.exe A: 0x00400000 - 0x004F4000 (D:\Programs\proecte ne terminate\YU samp 0.3x\samp-server.exe) ntdll.dll A: 0x77DC0000 - 0x77F40000 (C:\Windows\SysWOW64\ntdll.dll) kernel32.dll A: 0x756F0000 - 0x75800000 (C:\Windows\syswow64\kernel32.dll) KERNELBASE.dll A: 0x76E70000 - 0x76EB7000 (C:\Windows\syswow64\KERNELBASE.dll) SHELL32.dll A: 0x760C0000 - 0x76D0A000 (C:\Windows\syswow64\SHELL32.dll) msvcrt.dll A: 0x75800000 - 0x758AC000 (C:\Windows\syswow64\msvcrt.dll) SHLWAPI.dll A: 0x75D30000 - 0x75D87000 (C:\Windows\syswow64\SHLWAPI.dll) GDI32.dll A: 0x76020000 - 0x760B0000 (C:\Windows\syswow64\GDI32.dll) USER32.dll A: 0x77400000 - 0x77500000 (C:\Windows\syswow64\USER32.dll) ADVAPI32.dll A: 0x75500000 - 0x755A0000 (C:\Windows\syswow64\ADVAPI32.dll) sechost.dll A: 0x773E0000 - 0x773F9000 (C:\Windows\SysWOW64\sechost.dll) RPCRT4.dll A: 0x75AF0000 - 0x75BE0000 (C:\Windows\syswow64\RPCRT4.dll) SspiCli.dll A: 0x754A0000 - 0x75500000 (C:\Windows\syswow64\SspiCli.dll) CRYPTBASE.dll A: 0x75490000 - 0x7549C000 (C:\Windows\syswow64\CRYPTBASE.dll) LPK.dll A: 0x77D90000 - 0x77D9A000 (C:\Windows\syswow64\LPK.dll) USP10.dll A: 0x75E30000 - 0x75ECD000 (C:\Windows\syswow64\USP10.dll) WSOCK32.dll A: 0x72670000 - 0x72677000 (C:\Windows\system32\WSOCK32.dll) WS2_32.dll A: 0x75C60000 - 0x75C95000 (C:\Windows\syswow64\WS2_32.dll) NSI.dll A: 0x75DD0000 - 0x75DD6000 (C:\Windows\syswow64\NSI.dll) WINMM.dll A: 0x74BC0000 - 0x74BF2000 (C:\Windows\system32\WINMM.dll) IMM32.DLL A: 0x77180000 - 0x771E0000 (C:\Windows\system32\IMM32.DLL) MSCTF.dll A: 0x77080000 - 0x7714C000 (C:\Windows\syswow64\MSCTF.dll) mysql.DLL A: 0x10000000 - 0x10015000 (D:\Programs\proecte ne terminate\YU samp 0.3x\plugins\mysql.DLL) LIBMYSQL.dll A: 0x026E0000 - 0x02821000 (D:\Programs\proecte ne terminate\YU samp 0.3x\LIBMYSQL.dll) MSVCR90.dll A: 0x6DA00000 - 0x6DAA3000 (C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.6161_none_50934f2ebcb7eb57\MSVCR90.dll) MSVCP90.dll A: 0x6DAD0000 - 0x6DB5E000 (C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.6161_none_50934f2ebcb7eb57\MSVCP90.dll) NLAapi.dll A: 0x71D70000 - 0x71D80000 (C:\Windows\system32\NLAapi.dll) napinsp.dll A: 0x71610000 - 0x71620000 (C:\Windows\system32\napinsp.dll) pnrpnsp.dll A: 0x715F0000 - 0x71602000 (C:\Windows\system32\pnrpnsp.dll) mswsock.dll A: 0x71D10000 - 0x71D4C000 (C:\Windows\System32\mswsock.dll) DNSAPI.dll A: 0x715A0000 - 0x715E4000 (C:\Windows\system32\DNSAPI.dll) winrnr.dll A: 0x71590000 - 0x71598000 (C:\Windows\System32\winrnr.dll) rasadhlp.dll A: 0x71540000 - 0x71546000 (C:\Windows\system32\rasadhlp.dll) whirlpool.DLL A: 0x002E0000 - 0x002EC000 (D:\Programs\proecte ne terminate\YU samp 0.3x\plugins\whirlpool.DLL) MSVCR80.dll A: 0x73250000 - 0x732EB000 (C:\Windows\WinSxS\x86_microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.4940_none_d08cc06a442b34fc\MSVCR80.dll) streamer.DLL A: 0x6D9C0000 - 0x6D9FB000 (D:\Programs\proecte ne terminate\YU samp 0.3x\plugins\streamer.DLL) sscanf.DLL A: 0x003D0000 - 0x003DD000 (D:\Programs\proecte ne terminate\YU samp 0.3x\plugins\sscanf.DLL) MSVCR100.dll A: 0x6D900000 - 0x6D9BF000 (C:\Windows\system32\MSVCR100.dll) nativechecker.DLL A: 0x6E050000 - 0x6E055000 (D:\Programs\proecte ne terminate\YU samp 0.3x\plugins\nativechecker.DLL) wshtcpip.dll A: 0x71530000 - 0x71535000 (C:\Windows\System32\wshtcpip.dll) IPHLPAPI.DLL A: 0x72680000 - 0x7269C000 (C:\Windows\system32\IPHLPAPI.DLL) WINNSI.DLL A: 0x73220000 - 0x73227000 (C:\Windows\system32\WINNSI.DLL)
Код:
[22:19:21] >> mysql_connect(localhost, root, yu_rpg, ******) on port 3306 [22:19:21] CMySQLHandler::CMySQLHandler() - constructor called. [22:19:21] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "yu_rpg" | Username: "root" [22:19:21] CMySQLHandler::Connect() - Connection was successful. [22:19:21] CMySQLHandler::Connect() - Auto-Reconnect has been enabled. [22:19:21] >> mysql_connect(localhost, root, yu_rpg, ******) on port 3306 [22:19:21] CMySQLHandler::Connect() - Connection was successful. [22:19:21] CMySQLHandler::Connect() - Auto-Reconnect has been enabled. [22:19:24] >> mysql_ping( Connection handle: 1 ) [22:19:24] CMySQLHandler::Ping() - Connection is still alive. [22:19:24] >> mysql_query_callback( Connection handle: 1 ) [22:19:24] Passing query SELECT LastPasswordChange, Password, Banned, UID, Mail FROM users WHERE username LIKE 'Bughi' | d [22:19:24] ProcessQueryThread(onThreadLoadPlayerLogin) - Query was successful. (SELECT LastPasswordChange, Password, Banned, UID, Mail FROM users WHERE username LIKE 'Bughi') [22:19:24] ProcessQueryThread(onThreadLoadPlayerLogin) - Data caching enabled. [22:19:24] CMySQLHandler::StoreResult() - Result was stored. [22:19:24] CMySQLHandler::FreeResult() - Result was successfully free'd. [22:19:24] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick() [22:19:24] onThreadLoadPlayerLogin(d) - Threaded function called. [22:19:24] >> cache_get_data( Connection handle: 1 ) [22:19:24] ProcessTick() - The cache has been cleared. [22:19:27] >> mysql_query_callback( Connection handle: 1 ) [22:19:27] Passing query SELECT key_v, value FROM user_data WHERE UID = 4 | d [22:19:27] ProcessQueryThread(onTHREAD_CompleteLoadPlayer) - Query was successful. (SELECT key_v, value FROM user_data WHERE UID = 4) [22:19:27] ProcessQueryThread(onTHREAD_CompleteLoadPlayer) - Data caching enabled. [22:19:27] CMySQLHandler::StoreResult() - Result was stored. [22:19:27] CMySQLHandler::FreeResult() - Result was successfully free'd. [22:19:27] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick() [22:19:27] onTHREAD_CompleteLoadPlayer(d) - Threaded function called. [22:19:27] >> cache_get_data( Connection handle: 1 ) [22:19:27] ProcessTick() - The cache has been cleared. [22:19:36] >> mysql_query_callback( Connection handle: 1 ) [22:19:36] Passing query UPDATE users SET Banned = '0' WHERE Username LIKE 'Dorin' | siii [22:19:36] >> mysql_query_callback( Connection handle: 1 ) [22:19:36] ProcessQueryThread(OnQueryFinish) - Query was successful. (UPDATE users SET Banned = '0' WHERE Username LIKE 'Dorin') [22:19:36] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick() [22:19:36] OnQueryFinish(siii) - Threaded function called. [22:19:36] OnQueryFinish(iiis) - Threaded function called.
Код:
---------- Loaded log file: "server_log.txt". ---------- SA-MP Dedicated Server ---------------------- v0.3x, ©2005-2013 SA-MP Team [22:19:21] [22:19:21] Server Plugins [22:19:21] -------------- [22:19:21] Loading plugin: mysql [22:19:21] > MySQL plugin R7 successfully loaded. [22:19:21] Loaded. [22:19:21] Loading plugin: whirlpool [22:19:21] [22:19:21] ================== [22:19:21] [22:19:21] Whirlpool loaded [22:19:21] [22:19:21] ================== [22:19:21] [22:19:21] Loaded. [22:19:21] Loading plugin: streamer [22:19:21] *** Streamer Plugin v2.6.1 by Incognito loaded *** [22:19:21] Loaded. [22:19:21] Loading plugin: sscanf [22:19:21] [22:19:21] =============================== [22:19:21] sscanf plugin loaded. [22:19:21] Version: 2.8.1 [22:19:21] © 2012 Alex "******" Cole [22:19:21] =============================== [22:19:21] Loaded. [22:19:21] Loading plugin: nativechecker [22:19:21] Loaded. [22:19:21] Loaded 5 plugins. [22:19:21] [22:19:21] Ban list [22:19:21] -------- [22:19:21] Loaded: samp.ban [22:19:21] [22:19:21] [22:19:21] Filterscripts [22:19:21] --------------- [22:19:21] Loading filterscript 'gm.amx'... [22:19:21] -------------------------------------- [22:19:21] Game Mode Loaded [22:19:21] -------------------------------------- [22:19:21] Loaded 1 filterscripts. [22:19:21] ---------------------------------- [22:19:21] RPG [22:19:21] ---------------------------------- [22:19:21] Number of vehicle models: 0 [22:19:24] Incoming connection: 192.168.0.100:56498 [22:19:24] [join] Bughi has joined the server (0:192.168.0.100)
Re: server crashes - BlackBank - 19.02.2013
Maybe it's a nice idea to show your unban command.
Re: server crashes - mineralo - 20.02.2013
Quote:
|
Originally Posted by BlackBank3
 Maybe it's a nice idea to show your unban command.
|
pawn Код:
CMD:unban(playerid,params[])
{
new tmp[25];
if(sscanf(params, "s" ,tmp))return scm(playerid,COLOR_WHITE,"( ! ) /unban <name>");
new str[120];
format(str,256,"( A ) %s has been unbanned by %s",tmp,PlayerName(playerid));
SendMessageToAdmins(COLOR_RED,str);
UnBanPlayer(playerid,tmp);
return 1;
}
forward UnBanPlayer(id,name[]);
public UnBanPlayer(id,name[])
{
new sql[100];
format(sql,500,"UPDATE users SET Banned = '0' WHERE Username LIKE '%s'",name);
mysql_query(sql,THREAD_ignoreCallback,id, mysqlCon);
format(sql, sizeof sql, "DELETE FROM bans WHERE User ='%s'",name);
mysql_query(sql,THREAD_ignoreCallback,id, mysqlCon);
return 1;
}