[Czeladnik]

Hi,

When I use the function "mysql_ping" of plugin BlueG ... My server crashing. Please help.

Код:

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

SA-MP Server: 0.3e



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



Registers:

EAX: 0x000007D6	EBX: 0x1000D08C	ECX: 0x7FFFFFFE	EDX: 0x00000073

ESI: 0x00000000	EDI: 0x000007D6	EBP: 0x0012E378	ESP: 0x0012E0F4

EFLAGS: 0x00010202



Stack:

+0000: 0x0077C250   0x00000000   0x00000000   0x01A80000

+0010: 0x017F56D0   0x00000000   0x00000007   0x02B5073D

+0020: 0x01850C2C   0x00000000   0x01A894C8   0x01A81740

+0030: 0x01A807D0   0x0012E101   0x0012E39C   0x00000000

+0040: 0x00000000   0x00000000   0x1000D08C   0x00000000

+0050: 0x00000000   0x00000000   0x00000248   0x00000040

+0060: 0x0012E534   0x00000008   0x000007D6   0xFFFFFFFF

+0070: 0x73000000   0x00000000   0x71432E2B   0x01980950

+0080: 0x00000000   0x03000003   0x01998690   0xFD0004F9

+0090: 0x714454BF   0x714A7408   0x00000000   0x000007FF

+00A0: 0x0000000C   0x35001A2F   0x019D9820   0x00000001

+00B0: 0x0012E190   0x00000002   0x00000008   0x01985EC0

+00C0: 0x01985EC0   0x01985EBB   0x00000000   0x0038CF4B

+00D0: 0x01A80000   0x013818FC   0x0012E114   0x0077C250

+00E0: 0x76F3572C   0x752BC2E2   0x000001C0   0x0012E214

+00F0: 0x0012E21C   0x00000008   0x0000000E   0xFFFFFFFF

+0100: 0x00000003   0x714AD6A0   0x00075000   0x00000000

+0110: 0x00074A2B   0x00000000   0x00000001   0x00000000

+0120: 0x00000000   0x00000000   0x00074A2B   0x00000000

+0130: 0x0012E24C   0x76F3494C   0x74AC64B4   0x00000194



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



Loaded Modules:

samp-server.exe	A: 0x00400000 - 0x004EE000	(C:\Users\Cirasean\Desktop\MZ-RP\samp-server.exe)

ntdll.dll	A: 0x76EF0000 - 0x7702C000	(C:\Windows\SYSTEM32\ntdll.dll)

kernel32.dll	A: 0x755B0000 - 0x75684000	(C:\Windows\system32\kernel32.dll)

KERNELBASE.dll	A: 0x752B0000 - 0x752FA000	(C:\Windows\system32\KERNELBASE.dll)

snxhk.dll	A: 0x6EE30000 - 0x6EE6C000	(D:\Sterowniki\Avast\snxhk.dll)

SHELL32.dll	A: 0x75D10000 - 0x76959000	(C:\Windows\system32\SHELL32.dll)

msvcrt.dll	A: 0x75500000 - 0x755AC000	(C:\Windows\system32\msvcrt.dll)

SHLWAPI.dll	A: 0x75380000 - 0x753D7000	(C:\Windows\system32\SHLWAPI.dll)

GDI32.dll	A: 0x75C20000 - 0x75C6E000	(C:\Windows\system32\GDI32.dll)

USER32.dll	A: 0x76960000 - 0x76A29000	(C:\Windows\system32\USER32.dll)

LPK.dll	A: 0x77080000 - 0x7708A000	(C:\Windows\system32\LPK.dll)

USP10.dll	A: 0x75A60000 - 0x75AFD000	(C:\Windows\system32\USP10.dll)

WSOCK32.dll	A: 0x72F90000 - 0x72F97000	(C:\Windows\system32\WSOCK32.dll)

WS2_32.dll	A: 0x757E0000 - 0x75815000	(C:\Windows\system32\WS2_32.dll)

RPCRT4.dll	A: 0x756F0000 - 0x75791000	(C:\Windows\system32\RPCRT4.dll)

NSI.dll	A: 0x757D0000 - 0x757D6000	(C:\Windows\system32\NSI.dll)

WINMM.dll	A: 0x73510000 - 0x73542000	(C:\Windows\system32\WINMM.dll)

IMM32.DLL	A: 0x76C60000 - 0x76C7F000	(C:\Windows\system32\IMM32.DLL)

MSCTF.dll	A: 0x76A30000 - 0x76AFC000	(C:\Windows\system32\MSCTF.dll)

mysql.dll	A: 0x10000000 - 0x10013000	(C:\Users\Cirasean\Desktop\MZ-RP\plugins\mysql.dll)

LIBMYSQL.dll	A: 0x017F0000 - 0x01966000	(C:\Users\Cirasean\Desktop\MZ-RP\LIBMYSQL.dll)

ADVAPI32.dll	A: 0x75C70000 - 0x75D10000	(C:\Windows\system32\ADVAPI32.dll)

sechost.dll	A: 0x76C90000 - 0x76CA9000	(C:\Windows\SYSTEM32\sechost.dll)

MSVCR90.dll	A: 0x71410000 - 0x714B3000	(C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.4926_none_508ed732bcbc0e5a\MSVCR90.dll)

MSVCP90.dll	A: 0x71380000 - 0x7140E000	(C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.4926_none_508ed732bcbc0e5a\MSVCP90.dll)

NLAapi.dll	A: 0x73340000 - 0x73350000	(C:\Windows\system32\NLAapi.dll)

mswsock.dll	A: 0x74AC0000 - 0x74AFC000	(C:\Windows\System32\mswsock.dll)

DNSAPI.dll	A: 0x74980000 - 0x749C4000	(C:\Windows\system32\DNSAPI.dll)

winrnr.dll	A: 0x6F120000 - 0x6F128000	(C:\Windows\System32\winrnr.dll)

napinsp.dll	A: 0x6F110000 - 0x6F120000	(C:\Windows\system32\napinsp.dll)

pnrpnsp.dll	A: 0x6F0F0000 - 0x6F102000	(C:\Windows\system32\pnrpnsp.dll)

rasadhlp.dll	A: 0x6FB20000 - 0x6FB26000	(C:\Windows\system32\rasadhlp.dll)

streamer.dll	A: 0x73110000 - 0x7314B000	(C:\Users\Cirasean\Desktop\MZ-RP\plugins\streamer.dll)

sscanf.dll	A: 0x00630000 - 0x0063C000	(C:\Users\Cirasean\Desktop\MZ-RP\plugins\sscanf.dll)

MSVCR100.dll	A: 0x63520000 - 0x635DF000	(C:\Windows\system32\MSVCR100.dll)

wshtcpip.dll	A: 0x74610000 - 0x74615000	(C:\Windows\System32\wshtcpip.dll)

IPHLPAPI.DLL	A: 0x72E50000 - 0x72E6C000	(C:\Windows\system32\IPHLPAPI.DLL)

WINNSI.DLL	A: 0x72E40000 - 0x72E47000	(C:\Windows\system32\WINNSI.DLL)

CRYPTBASE.dll	A: 0x75000000 - 0x7500C000	(C:\Windows\system32\CRYPTBASE.dll)

uxtheme.dll	A: 0x73E50000 - 0x73E90000	(C:\Windows\system32\uxtheme.dll)

PROPSYS.dll	A: 0x73FA0000 - 0x74095000	(C:\Windows\system32\PROPSYS.dll)

OLEAUT32.dll	A: 0x75820000 - 0x758AF000	(C:\Windows\system32\OLEAUT32.dll)

comctl32.dll	A: 0x740E0000 - 0x7427E000	(C:\Windows\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_6.0.7600.16661_none_420fe3fa2b8113bd\comctl32.dll)

apphelp.dll	A: 0x74F80000 - 0x74FCB000	(C:\Windows\system32\apphelp.dll)

CLBCatQ.DLL	A: 0x77090000 - 0x77113000	(C:\Windows\system32\CLBCatQ.DLL)

iertutil.dll	A: 0x76D30000 - 0x76EE8000	(C:\Windows\system32\iertutil.dll)

urlmon.dll	A: 0x753E0000 - 0x754F1000	(C:\Windows\system32\urlmon.dll)

WININET.dll	A: 0x75B00000 - 0x75C1B000	(C:\Windows\system32\WININET.dll)

Normaliz.dll	A: 0x758B0000 - 0x758B3000	(C:\Windows\system32\Normaliz.dll)

SETUPAPI.dll	A: 0x758C0000 - 0x75A5D000	(C:\Windows\system32\SETUPAPI.dll)

CFGMGR32.dll	A: 0x75320000 - 0x75347000	(C:\Windows\system32\CFGMGR32.dll)

DEVOBJ.dll	A: 0x75300000 - 0x75312000	(C:\Windows\system32\DEVOBJ.dll)

ntmarta.dll	A: 0x73990000 - 0x739B1000	(C:\Windows\system32\ntmarta.dll)

WLDAP32.dll	A: 0x77030000 - 0x77075000	(C:\Windows\system32\WLDAP32.dll)

Secur32.dll	A: 0x74E10000 - 0x74E18000	(C:\Windows\system32\Secur32.dll)

SSPICLI.DLL	A: 0x74F60000 - 0x74F7A000	(C:\Windows\system32\SSPICLI.DLL)

[WillyP]

Quote:

Originally Posted by Czeladnik Re: hiuston - we have problem - MySQL Plugin - mysql_ping crash

Nice spelling of 'Houston'.. Why use 'Houston - we have problem'? Makes you look like an utter tard

[pyrodave]

Quote:

Originally Posted by [FU]Victious Nice spelling of 'Houston'.. Why use 'Houston - we have problem'? Makes you look like an utter tard

And posting irrelevant and insulting comments does not?

Anyway, back to the topic at hand; for what reason are you using the mysql_ping function? It would also help if you said which version of the plugin you are using, as there are some fairly major differences between them. I am currently using R7-2 which seems to be working fine using this:

pawn Код:

printf("MySQL is: %s",mysql_ping()==-1?("Dead"):("Alive"));

[Czeladnik]

ok, I changed plugin versions to R6 - mysql works, but now OnPlayerSpawn don't works -.-'

[pyrodave]

Well perhaps there is something in OnPlayerSpawn which is causing it to return early, or there may be a runtime error of some sort; if you can't spot it immediately, try the crash detect plugin, it may reveal something.

[Czeladnik]

Код:

public OnPlayerSpawn(playerid)
{
    Log("[PLAYER]Gracz %s został zespawnowany.", LOG_PLAYERSTATE, P[playerid][pNick]);
	if(IsPlayerNPC(playerid))
	{
	    CzyscGracza(playerid);
	    SetPlayerSkin(playerid, 16);
	    PutPlayerInVehicle(playerid, NPCVehID, 0);
	    return 1;
	}

	if(!P[playerid][pLogin]) { Info(playerid, "Nie jesteś zalogowany, więc nie możesz się zrespawnować."); Kick(playerid); }
    ReloadAnims(playerid);
    
	TextDrawHideForPlayer(playerid, Zaslona[0]);
	TextDrawHideForPlayer(playerid, Zaslona[1]);
	
	ResetPlayerMoney(playerid);
	SetPlayerVW(playerid, P[playerid][pVW]);


	GivePlayerMoney(playerid, P[playerid][pCash]);
	
	SetPlayerHealth(playerid, P[playerid][pHP]);
	SetPlayerSkin(playerid, P[playerid][pSkin]);
	

	
	//TextDrawShowForPlayer(playerid, TDKary);
	SetPlayerPos(playerid, P[playerid][pPosX], P[playerid][pPosY], P[playerid][pPosZ]);
	

	printf("%f, %f, %f, %i",P[playerid][pPosX], P[playerid][pPosY], P[playerid][pPosZ]+1, P[playerid][pSkin]);

	return 1;
}

[pyrodave]

Well the only thing which might be causing problems relating to MySQL is the Log() function.

[Czeladnik]

Код:

#define	Log(%1,%2,%3); if (logtype & %2) { printf(%1, %3); }

and:

Код:

#define		LOG_MYSQL			1
#define		LOG_INIT			2
#define		LOG_VEHICLE			4
#define		LOG_PLAYERSTATE		8
#define		LOG_CONNECT			16
#define		LOG_DISCONNECT		32
#define		LOG_COMMAND			64
#define		LOG_CREATE			128
#define		LOG_CACHE			256
#define		LOG_ALL				511
new logtype = 511;

[pyrodave]

Looks fine to me; it doesn't use MySQL at all...what do you mean exactly by not working.