My Server Crashes
#1

Hi all i have a question. my server crashes after registering user name and when you logout and log back on it crashes as soon you enter info. but if you just don't register it doesn't crash the server which i don't understand.
Reply
#2

You are probably using a MySQL script, have you linked the server to your MySQL database? And use crashdetect plugin and show us what it says.
Reply
#3

SA-MP Server: 0.3z-R4



Exception At Address: 0x71FAB9F0 Module: (MSVCR90.dll)



Registers:

EAX: 0x0327F048 EBX: 0x030F391C ECX: 0x00000000 EDX: 0x00598B18

ESI: 0x0019F7C0 EDI: 0x0296C458 EBP: 0x0019F784 ESP: 0x0019F778

EFLAGS: 0x00210246



Stack:

+0000: 0x71EE5DB4 0x00000000 0x0296C458 0x0019F7B8

+0010: 0x1000952E 0x00000000 0xA6CC7B3B 0x0019F7C0

+0020: 0x030F391C 0x00598B18 0x71EE72AA 0x00000001

+0030: 0x00000000 0x0019F81C 0x10009FFD 0x00000000

+0040: 0x0019F828 0x100067D3 0x10009EDB 0x726F6353

+0050: 0x00190065 0x100067AF 0x0019F7F4 0x00000005

+0060: 0x0000000F 0xA6CC74AB 0x02477AC2 0x0019F7C0

+0070: 0x0327D058 0x00000000 0x0019F7C0 0x00598B18

+0080: 0x726F6353 0x00590065 0x1000D180 0x00000001

+0090: 0x00000005 0x0000000F 0xA6CC74AB 0x00598B18

+00A0: 0x00000000 0x0019FB44 0x1000A150 0x00000000

+00B0: 0x0318E5F0 0x004010B6 0x0296C458 0x0326DB8C

+00C0: 0x03196F20 0x00402B63 0x0296C458 0x00000038

+00D0: 0x0019F860 0x0326DB8C 0x0019FB50 0x0296C458

+00E0: 0x00000000 0x00000000 0x00000001 0x000D6C6C

+00F0: 0x000D6C6C 0x000D788C 0x000D38BC 0x000D782C

+0100: 0x000D38BC 0x030F391C 0x03196F20 0x00000000

+0110: 0x030F1020 0x000A3604 0x0046E161 0x0296C458

+0120: 0x0019F8E0 0x0000001B 0x0296C458 0x00000000

+0130: 0x0296C458 0x00000000 0x0296C458 0x00000001



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



Loaded Modules:

samp-server.exe A: 0x00400000 - 0x004F6000 (C:\Users\rnw3089\Desktop\SnB\samp-server.exe)

ntdll.dll A: 0x77D50000 - 0x77EC9000 (C:\WINDOWS\SYSTEM32\ntdll.dll)

KERNEL32.DLL A: 0x77C10000 - 0x77D00000 (C:\WINDOWS\SYSTEM32\KERNEL32.DLL)

KERNELBASE.dll A: 0x77A10000 - 0x77B78000 (C:\WINDOWS\SYSTEM32\KERNELBASE.dll)

SHELL32.dll A: 0x753C0000 - 0x76795000 (C:\WINDOWS\SYSTEM32\SHELL32.dll)

msvcrt.dll A: 0x76C20000 - 0x76CDE000 (C:\WINDOWS\SYSTEM32\msvcrt.dll)

USER32.dll A: 0x774F0000 - 0x77654000 (C:\WINDOWS\SYSTEM32\USER32.dll)

GDI32.dll A: 0x772E0000 - 0x77427000 (C:\WINDOWS\SYSTEM32\GDI32.dll)

WSOCK32.dll A: 0x74EC0000 - 0x74EC8000 (C:\WINDOWS\SYSTEM32\WSOCK32.dll)

WS2_32.dll A: 0x77120000 - 0x77170000 (C:\WINDOWS\SYSTEM32\WS2_32.dll)

NSI.dll A: 0x76F70000 - 0x76F77000 (C:\WINDOWS\SYSTEM32\NSI.dll)

RPCRT4.dll A: 0x767A0000 - 0x7685A000 (C:\WINDOWS\SYSTEM32\RPCRT4.dll)

SspiCli.dll A: 0x753A0000 - 0x753BE000 (C:\WINDOWS\SYSTEM32\SspiCli.dll)

CRYPTBASE.dll A: 0x75390000 - 0x7539A000 (C:\WINDOWS\SYSTEM32\CRYPTBASE.dll)

bcryptPrimitives.dll A: 0x75330000 - 0x75386000 (C:\WINDOWS\SYSTEM32\bcryptPrimitives.dll)

sechost.dll A: 0x77D00000 - 0x77D42000 (C:\WINDOWS\SYSTEM32\sechost.dll)

WINMM.dll A: 0x72320000 - 0x72343000 (C:\WINDOWS\SYSTEM32\WINMM.dll)

WINMMBASE.dll A: 0x722F0000 - 0x72313000 (C:\WINDOWS\SYSTEM32\WINMMBASE.dll)

cfgmgr32.dll A: 0x779D0000 - 0x77A06000 (C:\WINDOWS\SYSTEM32\cfgmgr32.dll)

DEVOBJ.dll A: 0x74D30000 - 0x74D51000 (C:\WINDOWS\SYSTEM32\DEVOBJ.dll)

IMM32.DLL A: 0x77940000 - 0x7796A000 (C:\WINDOWS\SYSTEM32\IMM32.DLL)

MSCTF.dll A: 0x76F80000 - 0x77099000 (C:\WINDOWS\SYSTEM32\MSCTF.dll)

OLEAUT32.dll A: 0x76AD0000 - 0x76B62000 (C:\WINDOWS\SYSTEM32\OLEAUT32.dll)

combase.dll A: 0x76D50000 - 0x76EDC000 (C:\WINDOWS\SYSTEM32\combase.dll)

mysql.DLL A: 0x10000000 - 0x10013000 (C:\Users\rnw3089\Desktop\SnB\plugins\mysql.DLL)

LIBMYSQL.dll A: 0x72020000 - 0x722EA000 (C:\Users\rnw3089\Desktop\SnB\LIBMYSQL.dll)

ADVAPI32.dll A: 0x770A0000 - 0x7711A000 (C:\WINDOWS\SYSTEM32\ADVAPI32.dll)

MSVCR90.dll A: 0x71F70000 - 0x72013000 (C:\WINDOWS\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9 a1e18e3b_9.0.30729.9132_none_50903d3abcbab068\MSVC R90.dll)

MSVCP90.dll A: 0x71EE0000 - 0x71F6E000 (C:\WINDOWS\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9 a1e18e3b_9.0.30729.9132_none_50903d3abcbab068\MSVC P90.dll)

napinsp.dll A: 0x74760000 - 0x74771000 (C:\WINDOWS\system32\napinsp.dll)

pnrpnsp.dll A: 0x74740000 - 0x74756000 (C:\WINDOWS\system32\pnrpnsp.dll)

NLAapi.dll A: 0x74720000 - 0x74733000 (C:\WINDOWS\system32\NLAapi.dll)

mswsock.dll A: 0x74A40000 - 0x74A89000 (C:\WINDOWS\System32\mswsock.dll)

DNSAPI.dll A: 0x749B0000 - 0x74A32000 (C:\WINDOWS\SYSTEM32\DNSAPI.dll)

winrnr.dll A: 0x74710000 - 0x7471A000 (C:\WINDOWS\System32\winrnr.dll)

rasadhlp.dll A: 0x74950000 - 0x74958000 (C:\Windows\System32\rasadhlp.dll)

sscanf.DLL A: 0x00580000 - 0x0058D000 (C:\Users\rnw3089\Desktop\SnB\plugins\sscanf.DLL)

MSVCR100.dll A: 0x71E20000 - 0x71EDE000 (C:\WINDOWS\SYSTEM32\MSVCR100.dll)

irc.DLL A: 0x71DD0000 - 0x71E20000 (C:\Users\rnw3089\Desktop\SnB\plugins\irc.DLL)

MSVCP120.dll A: 0x71D50000 - 0x71DC1000 (C:\WINDOWS\SYSTEM32\MSVCP120.dll)

SSLEAY32.dll A: 0x00680000 - 0x006C7000 (C:\WINDOWS\SYSTEM32\SSLEAY32.dll)

MSVCR120.dll A: 0x71C60000 - 0x71D4E000 (C:\WINDOWS\SYSTEM32\MSVCR120.dll)

LIBEAY32.dll A: 0x02580000 - 0x026A5000 (C:\WINDOWS\SYSTEM32\LIBEAY32.dll)

nativechecker.DLL A: 0x71C50000 - 0x71C55000 (C:\Users\rnw3089\Desktop\SnB\plugins\nativechecke r.DLL)

IPHLPAPI.DLL A: 0x74D90000 - 0x74DBF000 (C:\WINDOWS\SYSTEM32\IPHLPAPI.DLL)

WINNSI.DLL A: 0x74D80000 - 0x74D88000 (C:\WINDOWS\SYSTEM32\WINNSI.DLL)

i have a player base that i use to store user names -maps-donator-ect that use mysql and i use wamp server for that via phpmyadmin.
Reply
#4

Sorry About The Top Post I Forgot i didn't have my crash detect in my server config

[09:15:11] [debug] Server crashed while executing GM.amx
[09:15:11] [debug] AMX backtrace:
[09:15:11] [debug] #0 native mysql_fetch_field_row () from mysql.DLL
[09:15:11] [debug] #1 0009acd4 in ?? (0, 866432) from GM.amx
[09:15:11] [debug] #2 0009863c in ?? (0, 0, 1, -1, 866432) from GM.amx
[09:15:11] [debug] #3 00010ec0 in public OnDialogResponse (0, 0, 1, -1, 866432) from GM.amx
[09:15:11] [debug] Native backtrace:
[09:15:11] [debug] #0 7225b9f0 in ?? () from C:\WINDOWS\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a 1e18e3b_9.0.30729.9132_none_50903d3abcbab068\MSVCR 90.dll
[09:15:11] [debug] #1 1000952e in ?? () from plugins\mysql.DLL
[09:15:11] [debug] #2 100067d3 in ?? () from plugins\mysql.DLL
[09:15:11] [debug] #3 004010b6 in ?? () from samp-server.exe
[09:15:11] [debug] #4 6da662ca in ?? () from plugins\crashdetect.DLL
[09:15:11] [debug] #5 6da68b28 in ?? () from plugins\crashdetect.DLL
[09:15:11] [debug] #6 6da609c7 in ?? () from plugins\crashdetect.DLL
[09:15:11] [debug] #7 6da6631a in ?? () from plugins\crashdetect.DLL
[09:15:11] [debug] #8 0046e161 in ?? () from samp-server.exe
[09:15:11] [debug] #9 004529e0 in ?? () from samp-server.exe
[09:15:11] [debug] #10 6da6631a in ?? () from plugins\crashdetect.DLL
[09:15:11] [debug] #11 0046dee0 in ?? () from samp-server.exe
[09:15:11] [debug] #12 0049a6f9 in ?? () from samp-server.exe
[09:15:11] [debug] #13 0045b4ca in ?? () from samp-server.exe
[09:15:11] [debug] #14 100016df in ?? () from plugins\mysql.DLL
[09:15:11] [debug] #15 100081b2 in ?? () from plugins\mysql.DLL
[09:15:11] [debug] #16 0048816b in ?? () from samp-server.exe
[09:15:11] [debug] #17 5c8b01f8 in ?? () from samp-server.exe
[09:15:11] [debug] #18 61750824 in ?? () from samp-server.exe
Reply
#5

Bump
Reply
#6

Bump
Reply
#7

Can you show us the code?
Reply
#8

public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
switch(dialogid)
{
case DIALOG_REGISTER:
{
if(response)
{
new string[256];
format(string,sizeof(string),"{AFE7FF}Registering to [NMC] Destruction Derby (step 1):\n\n{C3C3C3}You have chosen to register the name %s. Choose a password to login with below. (Do not forget this password)\nAfterwards press 'continue'.",pName(playerid));
ShowPlayerDialog(playerid,DIALOG_REGISTER_1,DIALOG _STYLE_INPUT,"Register (step 1)",string,"Continue","Cancel");
}
}

case DIALOG_REGISTER_1:
{
if(response)
{
new string[256];
mysql_real_escape_string(inputtext,Player_Data[playerid][tmp_RegisterText1]);
if(strlen(Player_Data[playerid][tmp_RegisterText1]) <= 5)
{
SendClientMessage(playerid,RED,"Password too short. Try again.");
format(string,sizeof(string),"{AFE7FF}Registering to [NMC] Destruction Derby (step 1):\n\n{C3C3C3}You have chosen to register the name %s. Choose a password to login with below. (Do not forget this password)\nAfterwards press 'continue'.",pName(playerid));
ShowPlayerDialog(playerid,DIALOG_REGISTER_1,DIALOG _STYLE_INPUT,"Register (step 1)",string,"Continue","Cancel");
}
else
{
format(string,sizeof(string),"{AFE7FF}Registering to [NMC] Destruction Derby (step 2):\n\n{C3C3C3}You have chosen your password, if you're sure you typed it good enter your e-mail and press 'continue'.\nBe sure to type a valid e-mail !",pName(playerid));
ShowPlayerDialog(playerid,DIALOG_REGISTER_2,DIALOG _STYLE_INPUT,"Register (step 2)",string,"Continue","Cancel");
}
}
}

case DIALOG_REGISTER_2:
{
if(response)
{
mysql_real_escape_string(inputtext,Player_Data[playerid][tmp_RegisterText2]);
if(!IsValidEmail(Player_Data[playerid][tmp_RegisterText2]))
{
new string[256];
SendClientMessage(playerid,RED,"Invalid e-mail. Try again.");
format(string,sizeof(string),"{AFE7FF}Registering to [NMC] Destruction Derby (step 2):\n\n{C3C3C3}You have chosen your password, if you're sure you typed it good enter your e-mail and press 'continue'.\nBe sure to type a valid e-mail !",pName(playerid));
ShowPlayerDialog(playerid,DIALOG_REGISTER_2,DIALOG _STYLE_INPUT,"Register (step 2)",string,"Continue","Cancel");
}
else MySQL_Register(playerid);
}
}

case DIALOG_LOGIN:
{
if(response)
{
MySQL_Login(playerid, inputtext);
}
else
{
if(Server_Data[VoteActive])
{
ShowPlayerDialog(playerid,DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "Login", "Welcome back!\nPlease login by typing your password below.", "Login", "Cancel");
return 1;
}
new string[256];
SendClientMessage(playerid, WHITE, "This account is registered and therefor indentification is required.");
format(string, sizeof(string), "%s has been forced to disconnect. (Kicked: Failed to login)", pName(playerid));
SendClientMessageToAll(GREY, string);
Kick(playerid);
}
}
Reply
#9

Bump. It has been awhile since someone last replied, any more pointers of what i need to fix for this problem?
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)