1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
server crashes
mineralo
Gangsta
****
Posts: 552
Threads: 84
Joined: Oct 2011
Reputation: 0
#1

19.02.2013, 19:02
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)
mysql_log
Код:
[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.
server_log
Код:
----------
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)
in game I just used cmd unban which updating info from mysql and then server just crash :/
Find
Reply
BlackBank
Gangsta
****
Posts: 508
Threads: 9
Joined: Dec 2010
Reputation: 0
#2

19.02.2013, 21:30
Maybe it's a nice idea to show your unban command.
Find
Reply
mineralo
Gangsta
****
Posts: 552
Threads: 84
Joined: Oct 2011
Reputation: 0
#3

20.02.2013, 15:08
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;
}
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help