Server Crashing
#1

server logs

Код:
[09:31:53] [debug] Server crashed while executing Opticalx.amx
[09:31:53] [debug] Backtrace:
[09:31:53] [debug] #0  native mysql_tquery () from mysql.DLL
[09:31:53] [debug] #1  000cb558 in public ReportUpdateTimer001 (playerid=0) at E:\OrigalX\gamemodes\Opticalx.pwn:12344
[09:31:53] [debug] Thread backtrace:
[09:31:53] [debug] #0  0049E676 in ?? () from E:\OrigalX\samp-server.exe
[09:31:53] [debug] #1  00497AB1 in ?? () from E:\OrigalX\samp-server.exe
[09:31:53] [debug] #2  7604EE1C in BaseThreadInitThunk () from C:\Windows\system32\kernel32.dll
[09:31:53] [debug] #3  76EC37EB in RtlInitializeExceptionChain () from C:\Windows\SYSTEM32\ntdll.dll
[09:31:53] [debug] #4  76EC37BE in RtlInitializeExceptionChain () from C:\Windows\SYSTEM32\ntdll.dll
code
pawn Код:
// under OnGameModeInit()

    SetTimer("ReportUpdateTimer001", 3000, true);

//
public ReportUpdateTimer001(playerid)
{
    new Query[100];
    format(Query,sizeof(Query),"SELECT * FROM `reports` ORDER BY `ID` DESC LIMIT 1, 1 ");
    mysql_tquery(mysql, Query, "DisplayReportsx", "i", playerid);
   
    new Queryz[100];
    format(Queryz,sizeof(Queryz),"SELECT * FROM `reports` ORDER BY `ID` DESC LIMIT 2, 2 ");
    mysql_tquery(mysql, Queryz, "DisplayReportsz", "i", playerid);
   
    return 1;
}
crashinfo

Код:
SA-MP Server: 0.3z



Exception At Address: 0x692A226A Module: (mysql.DLL)



Registers:

EAX: 0x00000000	EBX: 0x00000000	ECX: 0x0012FA70	EDX: 0x0313F2FC

ESI: 0x6735DD10	EDI: 0x002EBF44	EBP: 0x0012FB38	ESP: 0x0012FA54

EFLAGS: 0x00010212



Stack:

+0000: 0xF8A482F6   0x002EBF58   0x002EBF20   0x00000004

+0010: 0x000365CC   0xFFFFFFFE   0x77B52FE7   0x00000000

+0020: 0x01619270   0x035B2740   0x002EBF44   0x002C0000

+0030: 0x0012FC28   0x00000000   0x000365CC   0xFFFFFFFE

+0040: 0x00000002   0x00000000   0x00000048   0x00000058

+0050: 0x0012FAC4   0x6735DCFF   0x002C0000   0x00000000

+0060: 0x00000040   0x0000003F   0x0000000F   0x0012FBF4

+0070: 0x0012FAE0   0x6735DDA7   0x00000040   0x00000002

+0080: 0x00000000   0x00000010   0x00000068   0x0012FB14

+0090: 0x692A1757   0x00000040   0xF8A482DA   0x00000036

+00A0: 0x0012FBF4   0x0012FB70   0x0012FBF4   0x002E0A98

+00B0: 0x0012FAEC   0x0012FC28   0x0012FBF4   0x0000000F

+00C0: 0x692A148D   0x0012FBF4   0x0012FB60   0x0000000F

+00D0: 0x0012FBF4   0xF8A482F6   0x0012FC28   0x692C8D04

+00E0: 0xFFFFFFFF   0x0012FC34   0x692BF628   0x0012FB50

+00F0: 0x01619270   0x035B272C   0x00000004   0x00120069

+0100: 0x01619270   0x0012FBC8   0x692BF286   0x70736944

+0110: 0x5279616C   0x726F7065   0x00787374   0x454C4553

+0120: 0x2A205443   0x4F524620   0x7260204D   0x726F7065

+0130: 0x20607374   0x4544524F   0x59422052   0x44496020



--------------------------



Loaded Modules:

samp-server.exe	A: 0x00400000 - 0x004F5000	(E:\OrigalX\samp-server.exe)

ntdll.dll	A: 0x77B00000 - 0x77C3C000	(C:\Windows\SYSTEM32\ntdll.dll)

kernel32.dll	A: 0x77C40000 - 0x77D14000	(C:\Windows\system32\kernel32.dll)

KERNELBASE.dll	A: 0x75DA0000 - 0x75DEB000	(C:\Windows\system32\KERNELBASE.dll)

SHELL32.dll	A: 0x76290000 - 0x76EDA000	(C:\Windows\system32\SHELL32.dll)

msvcrt.dll	A: 0x77060000 - 0x7710C000	(C:\Windows\system32\msvcrt.dll)

SHLWAPI.dll	A: 0x76190000 - 0x761E7000	(C:\Windows\system32\SHLWAPI.dll)

GDI32.dll	A: 0x77010000 - 0x7705E000	(C:\Windows\system32\GDI32.dll)

USER32.dll	A: 0x77230000 - 0x772F9000	(C:\Windows\system32\USER32.dll)

LPK.dll	A: 0x77520000 - 0x7752A000	(C:\Windows\system32\LPK.dll)

USP10.dll	A: 0x77300000 - 0x7739D000	(C:\Windows\system32\USP10.dll)

WSOCK32.dll	A: 0x705A0000 - 0x705A7000	(C:\Windows\system32\WSOCK32.dll)

WS2_32.dll	A: 0x76EE0000 - 0x76F15000	(C:\Windows\system32\WS2_32.dll)

RPCRT4.dll	A: 0x77110000 - 0x771B2000	(C:\Windows\system32\RPCRT4.dll)

NSI.dll	A: 0x77D20000 - 0x77D26000	(C:\Windows\system32\NSI.dll)

WINMM.dll	A: 0x73890000 - 0x738C2000	(C:\Windows\system32\WINMM.dll)

IMM32.DLL	A: 0x77500000 - 0x7751F000	(C:\Windows\system32\IMM32.DLL)

MSCTF.dll	A: 0x760C0000 - 0x7618C000	(C:\Windows\system32\MSCTF.dll)

sscanf.DLL	A: 0x10000000 - 0x1000D000	(E:\OrigalX\plugins\sscanf.DLL)

MSVCR100.dll	A: 0x68080000 - 0x6813F000	(C:\Windows\system32\MSVCR100.dll)

whirlpool.DLL	A: 0x003E0000 - 0x003EC000	(E:\OrigalX\plugins\whirlpool.DLL)

MSVCR80.dll	A: 0x6F670000 - 0x6F70B000	(C:\Windows\WinSxS\x86_microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.4940_none_d08cc06a442b34fc\MSVCR80.dll)

mysql.DLL	A: 0x692A0000 - 0x692E4000	(E:\OrigalX\plugins\mysql.DLL)

LIBMYSQL.dll	A: 0x66E90000 - 0x6715A000	(E:\OrigalX\LIBMYSQL.dll)

ADVAPI32.dll	A: 0x761F0000 - 0x76290000	(C:\Windows\system32\ADVAPI32.dll)

sechost.dll	A: 0x77210000 - 0x77229000	(C:\Windows\SYSTEM32\sechost.dll)

MSVCR110.dll	A: 0x67350000 - 0x67426000	(E:\OrigalX\MSVCR110.dll)

MSVCP110.dll	A: 0x69210000 - 0x69295000	(E:\OrigalX\MSVCP110.dll)

NLAapi.dll	A: 0x73880000 - 0x73890000	(C:\Windows\system32\NLAapi.dll)

napinsp.dll	A: 0x704D0000 - 0x704E0000	(C:\Windows\system32\napinsp.dll)

pnrpnsp.dll	A: 0x704B0000 - 0x704C2000	(C:\Windows\system32\pnrpnsp.dll)

mswsock.dll	A: 0x754D0000 - 0x7550C000	(C:\Windows\System32\mswsock.dll)

DNSAPI.dll	A: 0x75390000 - 0x753D4000	(C:\Windows\system32\DNSAPI.dll)

winrnr.dll	A: 0x6FF00000 - 0x6FF08000	(C:\Windows\System32\winrnr.dll)

rasadhlp.dll	A: 0x707B0000 - 0x707B6000	(C:\Windows\system32\rasadhlp.dll)

MSVCP100.dll	A: 0x68010000 - 0x68079000	(C:\Windows\system32\MSVCP100.dll)

irc.DLL	A: 0x67300000 - 0x67348000	(E:\OrigalX\plugins\irc.DLL)

MSVCP120.dll	A: 0x67280000 - 0x672F1000	(E:\OrigalX\MSVCP120.dll)

MSVCR120.dll	A: 0x67190000 - 0x6727E000	(E:\OrigalX\MSVCR120.dll)

streamer.DLL	A: 0x66E40000 - 0x66E81000	(E:\OrigalX\plugins\streamer.DLL)

iTD.DLL	A: 0x74000000 - 0x74006000	(E:\OrigalX\plugins\iTD.DLL)

YSF.DLL	A: 0x020E0000 - 0x0219A000	(E:\OrigalX\plugins\YSF.DLL)

wshtcpip.dll	A: 0x75040000 - 0x75045000	(C:\Windows\System32\wshtcpip.dll)

IPHLPAPI.DLL	A: 0x73460000 - 0x7347C000	(C:\Windows\system32\IPHLPAPI.DLL)

WINNSI.DLL	A: 0x73440000 - 0x73447000	(C:\Windows\system32\WINNSI.DLL)

wship6.dll	A: 0x754C0000 - 0x754C6000	(C:\Windows\System32\wship6.dll)
Reply
#2

What version of mysql plugin are you using?
Reply
#3

What are you even doing? Placing two queries in a 3 second REPEATING timer is one of the idiotic thing you could ever do.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)