Проблема с MySQL - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: Non-English (https://sampforum.blast.hk/forumdisplay.php?fid=9)
+--- Forum: Languages (https://sampforum.blast.hk/forumdisplay.php?fid=33)
+---- Forum: Русский/Russian (https://sampforum.blast.hk/forumdisplay.php?fid=32)
+---- Thread: Проблема с MySQL (/showthread.php?tid=361146)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: Non-English (https://sampforum.blast.hk/forumdisplay.php?fid=9)
+--- Forum: Languages (https://sampforum.blast.hk/forumdisplay.php?fid=33)
+---- Forum: Русский/Russian (https://sampforum.blast.hk/forumdisplay.php?fid=32)
+---- Thread: Проблема с MySQL (/showthread.php?tid=361146)
Проблема с MySQL - Gettopro - 20.07.2012
Всем привет, вчера первый раз попробовали с другом протестировать сервер вдвоём и тестирование так скажем - не удалось. Когда первый залогинен и второй заходит на сервер и вводит пароль, то сервер вырубается! Думали из-за чего может быть, так вот, попробовал я значит сделать 2 запроса к mysql подряд, результат тот же - сервер вырубился. Вот собственно код:
PHP Code:
format(query, 128, "UPDATE `accounts` SET `uonline` = 1 WHERE `uname` = '%s'", PlayerInfo[playerid][usqlname]);
mysql_function_query(MYSQL, query, false, "OnPlayerLoginSaved", "dd", playerid, GetTickCount());
mysql_function_query(MYSQL, query, false, "OnPlayerLoginSaved", "dd", playerid, GetTickCount());
PHP Code:
protected OnPlayerLoginSaved(playerid, tickcount);
public OnPlayerLoginSaved(playerid, tickcount)
{
printf("MySQL Log: Update success(%s, %d msec)", PlayerInfo[playerid][uname],(GetTickCount() - tickcount));
return 1;
}
Re: Проблема с MySQL - Stepashka - 20.07.2012
crashdetect плагин заюзай.
И кстати, зачем тебе лог в колбеке, мускул плагин сам ведет логи.
Re: Проблема с MySQL - Gettopro - 20.07.2012
Quote:
|
Originally Posted by Stepashka
 crashdetect плагин заюзай.
И кстати, зачем тебе лог в колбеке, мускул плагин сам ведет логи. |
Re: Проблема с MySQL - Gettopro - 20.07.2012
PHP Code:
[12:39:59] [debug] Server crashed while executing Samp.amx
[12:39:59] [debug] AMX backtrace:
[12:39:59] [debug] #0 native mysql_function_query () [10008f00] from mysql.DLL
[12:39:59] [debug] #1 0000a794 in public OnLoginFinished () from Samp.amx
[12:39:59] [debug] System backtrace:
[12:39:59] [debug] #0 77c4e023 in ?? () from C:\Windows\SysWOW64\ntdll.dll
[12:39:59] [debug] #1 75ce14dd in ?? () from C:\Windows\syswow64\kernel32.dll
[12:39:59] [debug] #2 70a23c1b in ?? () from C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.6161_none_50934f2ebcb7eb57\MSVCR90.dll
[12:39:59] [debug] #3 70a9be9a in ?? () from C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.6161_none_50934f2ebcb7eb57\MSVCP90.dll
[12:39:59] [debug] #4 70a9bf88 in ?? () from C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.6161_none_50934f2ebcb7eb57\MSVCP90.dll
[12:39:59] [debug] #5 70ab39a0 in ?? () from C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.6161_none_50934f2ebcb7eb57\MSVCP90.dll
[12:39:59] [debug] #6 70ab8d63 in ?? () from C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.6161_none_50934f2ebcb7eb57\MSVCP90.dll
[12:39:59] [debug] #7 10008f54 in ?? () from C:\Users\WiseAlex\SAMP\Samp Samp\plugins\mysql.DLL
[12:39:59] [debug] #8 004010b6 in ?? () from C:\Users\WiseAlex\SAMP\Samp Samp\samp-server.exe
[12:39:59] [debug] #9 73603c32 in ?? () from C:\Users\WiseAlex\SAMP\Samp Samp\plugins\crashdetect.DLL
[12:39:59] [debug] #10 73606076 in ?? () from C:\Users\WiseAlex\SAMP\Samp Samp\plugins\crashdetect.DLL
[12:39:59] [debug] #11 735fc05a in ?? () from C:\Users\WiseAlex\SAMP\Samp Samp\plugins\crashdetect.DLL
[12:39:59] [debug] #12 73603c5e in ?? () from C:\Users\WiseAlex\SAMP\Samp Samp\plugins\crashdetect.DLL
[12:39:59] [debug] #13 1000a0ec in ?? () from C:\Users\WiseAlex\SAMP\Samp Samp\plugins\mysql.DLL
[12:39:59] [debug] #14 004693d6 in ?? () from C:\Users\WiseAlex\SAMP\Samp Samp\samp-server.exe
[12:39:59] [debug] #15 004866ce in ?? () from C:\Users\WiseAlex\SAMP\Samp Samp\samp-server.exe
[12:39:59] [debug] #16 00494881 in ?? () from C:\Users\WiseAlex\SAMP\Samp Samp\samp-server.exe
[12:39:59] [debug] #17 00494891 in ?? () from C:\Users\WiseAlex\SAMP\Samp Samp\samp-server.exe
[12:39:59] [debug] #18 ffc30000 in ?? () from C:\Users\WiseAlex\SAMP\Samp Samp\samp-server.exe
[12:39:59] [debug] #19 e8042474 in ?? () from C:\Users\WiseAlex\SAMP\Samp Samp\samp-server.exe
[12:39:59] [debug] #20 ffffffbf in ?? () from C:\Users\WiseAlex\SAMP\Samp Samp\samp-server.exe
[12:39:59] [debug] #21 c01bd8f7 in ?? () from C:\Users\WiseAlex\SAMP\Samp Samp\samp-server.exe
[12:39:59] [debug] #22 4859d8f7 in ?? () from C:\Users\WiseAlex\SAMP\Samp Samp\samp-server.exe
[12:39:59] [debug] #23 247c83c3 in ?? () from C:\Users\WiseAlex\SAMP\Samp Samp\samp-server.exe
[12:39:59] [debug] #24 06740008 in ?? () from C:\Users\WiseAlex\SAMP\Samp Samp\samp-server.exe
[12:39:59] [debug] #25 412d01c6 in ?? () from C:\Users\WiseAlex\SAMP\Samp Samp\samp-server.exe
[12:39:59] [debug] #26 8b56d8f7 in ?? () from C:\Users\WiseAlex\SAMP\Samp Samp\samp-server.exe
[12:39:59] [debug] #27 f7d233f1 in ?? () from C:\Users\WiseAlex\SAMP\Samp Samp\samp-server.exe
[12:39:59] [debug] #28 83082474 in ?? () from C:\Users\WiseAlex\SAMP\Samp Samp\samp-server.exe
[12:39:59] [debug] #29 057609fa in ?? () from C:\Users\WiseAlex\SAMP\Samp Samp\samp-server.exe
[12:39:59] [debug] #30 eb57c280 in ?? () from C:\Users\WiseAlex\SAMP\Samp Samp\samp-server.exe
[12:39:59] [debug] #31 30c28003 in ?? () from C:\Users\WiseAlex\SAMP\Samp Samp\samp-server.exe
[12:39:59] [debug] #32 85411188 in ?? () from C:\Users\WiseAlex\SAMP\Samp Samp\samp-server.exe
[12:39:59] [debug] #33 c6e677c0 in ?? () from C:\Users\WiseAlex\SAMP\Samp Samp\samp-server.exe
[12:39:59] [debug] #34 8a490001 in ?? () from C:\Users\WiseAlex\SAMP\Samp Samp\samp-server.exe
[12:39:59] [debug] #35 88018a16 in ?? () from C:\Users\WiseAlex\SAMP\Samp Samp\samp-server.exe
[12:39:59] [debug] #36 06884911 in ?? () from C:\Users\WiseAlex\SAMP\Samp Samp\samp-server.exe
[12:39:59] [debug] #37 72f13b46 in ?? () from C:\Users\WiseAlex\SAMP\Samp Samp\samp-server.exe
[12:39:59] [debug] #38 55c35ef2 in ?? () from C:\Users\WiseAlex\SAMP\Samp Samp\samp-server.exe
[12:39:59] [debug] #39 7d83ec8b in ?? () from C:\Users\WiseAlex\SAMP\Samp Samp\samp-server.exe
[12:39:59] [debug] #40 458b0a10 in ?? () from C:\Users\WiseAlex\SAMP\Samp Samp\samp-server.exe
[12:39:59] [debug] #41 850a7508 in ?? () from C:\Users\WiseAlex\SAMP\Samp Samp\samp-server.exe
[12:39:59] [debug] #42 6a067dc0 in ?? () from C:\Users\WiseAlex\SAMP\Samp Samp\samp-server.exe
[12:39:59] [debug] #43 eb0a6a01 in ?? () from C:\Users\WiseAlex\SAMP\Samp Samp\samp-server.exe
[12:39:59] [debug] #44 ff006a05 in ?? () from C:\Users\WiseAlex\SAMP\Samp Samp\samp-server.exe
[12:39:59] [debug] #45 4d8b1075 in ?? () from C:\Users\WiseAlex\SAMP\Samp Samp\samp-server.exe
[12:39:59] [debug] #46 ff9fe80c in ?? () from C:\Users\WiseAlex\SAMP\Samp Samp\samp-server.exe
[12:39:59] [debug] #47 458bffff in ?? () from C:\Users\WiseAlex\SAMP\Samp Samp\samp-server.exe
[12:39:59] [debug] #48 5d59590c in ?? () from C:\Users\WiseAlex\SAMP\Samp Samp\samp-server.exe
[12:39:59] [debug] #49 244c8bc3 in ?? () from C:\Users\WiseAlex\SAMP\Samp Samp\samp-server.exe
[12:39:59] [debug] #50 24448b08 in ?? () from C:\Users\WiseAlex\SAMP\Samp Samp\samp-server.exe
[12:39:59] [debug] #51 ff006a04 in ?? () from C:\Users\WiseAlex\SAMP\Samp Samp\samp-server.exe
[12:39:59] [debug] #52 e8102474 in ?? () from C:\Users\WiseAlex\SAMP\Samp Samp\samp-server.exe
[12:39:59] [debug] #53 ffffff85 in ?? () from C:\Users\WiseAlex\SAMP\Samp Samp\samp-server.exe
[12:39:59] [debug] #54 1024448b in ?? () from C:\Users\WiseAlex\SAMP\Samp Samp\samp-server.exe
[12:39:59] [debug] #55 a1c35959 in ?? () from C:\Users\WiseAlex\SAMP\Samp Samp\samp-server.exe
[12:39:59] [debug] #56 004db7f0 in ?? () from C:\Users\WiseAlex\SAMP\Samp Samp\samp-server.exe
[12:39:59] [debug] #57 0274c085 in ?? ()
Re: Проблема с MySQL - -Stranger- - 20.07.2012
Gettopro, а при компиляции был создан файлик pawn.cfg со строчкой "-d3" ?
Судя по логу нет...
Re: Проблема с MySQL - Gettopro - 20.07.2012
Quote:
|
Originally Posted by -Stranger-
Gettopro, а при компиляции был создан файлик pawn.cfg со строчкой "-d3" ?
Судя по логу нет... |
PHP Code:
--------------------------
SA-MP Server: 0.3e
Exception At Address: 0x0274C085 Module: (LIBMYSQL.dll)
Registers:
EAX: 0x00000000 EBX: 0xCF890001 ECX: 0x00000053 EDX: 0x00000000
ESI: 0x029E6920 EDI: 0xCF890000 EBP: 0x004DB7F0 ESP: 0x00494925
EFLAGS: 0x00010206
Stack:
+0000: 0xE856D0FF 0x00003950 0xF685F08B 0x106A0875
+0010: 0x0015A6E8 0xE8565900 0x00003AF4 0x2474FF59
+0020: 0xB015FF08 0x5E004A51 0xE8680C6A 0xE8004B13
+0030: 0x00001C4B 0xBC0435FF 0x15FF004D 0x004EB700
+0040: 0xF685F08B 0x758B2675 0x35FF5608 0x004DBC04
+0050: 0xB70415FF 0xC085004E 0x106A0875 0x00155AE8
+0060: 0x15FF5900 0x004A51B4 0x16EB0689 0x8B08458B
+0070: 0x4E894C48 0x50488B4C 0x50504E89 0xFFD7E0E8
+0080: 0xECA159FF 0x85004DB7 0xFF0274C0 0xFC6583D0
+0090: 0x5076FF00 0x504C56FF 0xFFFF5AE8 0xEC458BFF
+00A0: 0x098B088B 0x50E44D89 0x8154E851 0x59590000
+00B0: 0xE8658BC3 0xE8E475FF 0x00000A82 0xEC8B55CC
+00C0: 0x7D8B5753 0x85DB3310 0xE80F75FF 0x000040A6
+00D0: 0x001600C7 0xC0330000 0x68566AEB 0x0000008C
+00E0: 0x61E8016A 0x8B000000 0x59F685F0 0x56407459
+00F0: 0x003850E8 0x14458B00 0xFF044E83 0x8B504689
+0100: 0xC0851C45 0x4C7E8959 0x458D0375 0x75FF5010
+0110: 0x4D685618 0xFF004949 0x75FF0C75 0x1015FF08
+0120: 0x85004A51 0xFF1C75C0 0x4A506815 0x56D88B00
+0130: 0xFFD72CE8 0x59DB85FF 0xE8530774 0x00004048
--------------------------
Loaded Modules:
samp-server.exe A: 0x00400000 - 0x004EE000 (C:\Users\WiseAlex\SAMP\Jupiter Samp\samp-server.exe)
ntdll.dll A: 0x77C20000 - 0x77DA0000 (C:\Windows\SysWOW64\ntdll.dll)
kernel32.dll A: 0x75CD0000 - 0x75DE0000 (C:\Windows\syswow64\kernel32.dll)
KERNELBASE.dll A: 0x75EA0000 - 0x75EE6000 (C:\Windows\syswow64\KERNELBASE.dll)
SHELL32.dll A: 0x764E0000 - 0x7712A000 (C:\Windows\syswow64\SHELL32.dll)
msvcrt.dll A: 0x77160000 - 0x7720C000 (C:\Windows\syswow64\msvcrt.dll)
SHLWAPI.dll A: 0x761F0000 - 0x76247000 (C:\Windows\syswow64\SHLWAPI.dll)
GDI32.dll A: 0x75DE0000 - 0x75E70000 (C:\Windows\syswow64\GDI32.dll)
USER32.dll A: 0x75EF0000 - 0x75FF0000 (C:\Windows\syswow64\USER32.dll)
ADVAPI32.dll A: 0x776B0000 - 0x77750000 (C:\Windows\syswow64\ADVAPI32.dll)
sechost.dll A: 0x75A70000 - 0x75A89000 (C:\Windows\SysWOW64\sechost.dll)
RPCRT4.dll A: 0x775C0000 - 0x776B0000 (C:\Windows\syswow64\RPCRT4.dll)
SspiCli.dll A: 0x75780000 - 0x757E0000 (C:\Windows\syswow64\SspiCli.dll)
CRYPTBASE.dll A: 0x75770000 - 0x7577C000 (C:\Windows\syswow64\CRYPTBASE.dll)
LPK.dll A: 0x775B0000 - 0x775BA000 (C:\Windows\syswow64\LPK.dll)
USP10.dll A: 0x75FF0000 - 0x7608D000 (C:\Windows\syswow64\USP10.dll)
WSOCK32.dll A: 0x75290000 - 0x75297000 (C:\Windows\system32\WSOCK32.dll)
WS2_32.dll A: 0x75AE0000 - 0x75B15000 (C:\Windows\syswow64\WS2_32.dll)
NSI.dll A: 0x773A0000 - 0x773A6000 (C:\Windows\syswow64\NSI.dll)
WINMM.dll A: 0x73620000 - 0x73652000 (C:\Windows\system32\WINMM.dll)
IMM32.DLL A: 0x75A10000 - 0x75A70000 (C:\Windows\system32\IMM32.DLL)
MSCTF.dll A: 0x77750000 - 0x7781C000 (C:\Windows\syswow64\MSCTF.dll)
mysql.DLL A: 0x10000000 - 0x10015000 (C:\Users\WiseAlex\SAMP\Jupiter Samp\plugins\mysql.DLL)
LIBMYSQL.dll A: 0x026D0000 - 0x02811000 (C:\Users\WiseAlex\SAMP\Jupiter Samp\LIBMYSQL.dll)
MSVCR90.dll A: 0x70B00000 - 0x70BA3000 (C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.6161_none_50934f2ebcb7eb57\MSVCR90.dll)
MSVCP90.dll A: 0x708A0000 - 0x7092E000 (C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.6161_none_50934f2ebcb7eb57\MSVCP90.dll)
NLAapi.dll A: 0x738B0000 - 0x738C0000 (C:\Windows\system32\NLAapi.dll)
napinsp.dll A: 0x738A0000 - 0x738B0000 (C:\Windows\system32\napinsp.dll)
pnrpnsp.dll A: 0x73880000 - 0x73892000 (C:\Windows\system32\pnrpnsp.dll)
mswsock.dll A: 0x74100000 - 0x7413C000 (C:\Windows\System32\mswsock.dll)
DNSAPI.dll A: 0x73830000 - 0x73874000 (C:\Windows\system32\DNSAPI.dll)
winrnr.dll A: 0x73820000 - 0x73828000 (C:\Windows\System32\winrnr.dll)
rasadhlp.dll A: 0x737D0000 - 0x737D6000 (C:\Windows\system32\rasadhlp.dll)
sscanf.DLL A: 0x00320000 - 0x0032C000 (C:\Users\WiseAlex\SAMP\Jupiter Samp\plugins\sscanf.DLL)
MSVCR100.dll A: 0x707E0000 - 0x7089F000 (C:\Windows\system32\MSVCR100.dll)
MSVCP100.dll A: 0x70770000 - 0x707D9000 (C:\Windows\system32\MSVCP100.dll)
wshtcpip.dll A: 0x737C0000 - 0x737C5000 (C:\Windows\System32\wshtcpip.dll)
IPHLPAPI.DLL A: 0x74150000 - 0x7416C000 (C:\Windows\system32\IPHLPAPI.DLL)
WINNSI.DLL A: 0x74140000 - 0x74147000 (C:\Windows\system32\WINNSI.DLL)
Re: Проблема с MySQL - Alexander_Petrov - 20.07.2012
Quote:
|
Originally Posted by Gettopro
Нет, вот что ещё пишет краш инфо:
PHP Code:
|
Re: Проблема с MySQL - Gettopro - 20.07.2012
Quote:
|
Originally Posted by Alexander_Petrov
Так скомпилируй с параметром -d3 и выложи лог.
|
Re: Проблема с MySQL - Gettopro - 20.07.2012
Разобрался.