Serverio crash

[HJones]

Sveiki, susidūriau su problema... Įjungiu linux serverį kuris surištas su mysql, su sujungimu viskas ir gerai, bet kaip prisijungiu tik iškart crashina serverį.

 

šiek tiek iš server_log.txt

[16:12:30] [debug] Server crashed while executing gRPG.amx

[16:12:30] [debug] AMX backtrace:

[16:12:30] [debug] #0 native mysql_fetch_field_row () [b74967a0] from mysql.so

[16:12:30] [debug] #1 00001d98 in ?? () from gRPG.amx

[16:12:30] [debug] #2 00000be8 in public OnPlayerSpawn () from gRPG.amx

[16:12:30] [debug] System backtrace:

[16:12:30] [debug] #0 b6a00f41 in _ZN10StackTraceC1EPv () from plugins/crashdetect.so

[16:12:30] [debug] #1 b69f741f in _ZN11crashdetect20PrintSystemBacktraceEPv () from plugins/crashdetect.so

[16:12:30] [debug] #2 b69f5963 in _ZN11crashdetect15SystemExceptionEPv () from plugins/crashdetect.so

[16:12:30] [debug] #3 b6a003c1 in ?? () from plugins/crashdetect.so

[16:12:30] [debug] #4 b7742600 in ?? ()

[16:12:30] [debug] #5 b7513db3 in strlen () from /lib/libc.so.6

[16:12:30] [debug] #6 b76c17f0 in _ZNKSs7compareEPKc () from /usr/lib/libstdc++.so.6

[16:12:30] [debug] #7 b7491973 in _ZN13CMySQLHandler10FetchFieldESs () from plugins/mysql.so

[16:12:30] [debug] #8 b7496820 in _ZN7Natives23n_mysql_fetch_field_rowEP6tagAMXPi () from plugins/mysql.so

[16:12:30] [debug] #9 08093d84 in ?? () from ./samp03svr

[16:12:30] [debug] #10 b69f65a2 in _ZN11crashdetect13DoAmxCallbackEiPiS0_ () from plugins/crashdetect.so

[16:12:30] [debug] #11 b69fe65e in ?? () from plugins/crashdetect.so

[16:12:30] [debug] #12 b6a05926 in amx_Exec () from plugins/crashdetect.so

[16:12:30] [debug] #13 b69f6622 in _ZN11crashdetect9DoAmxExecEPii () from plugins/crashdetect.so

[16:12:30] [debug] #14 b69fe699 in ?? () from plugins/crashdetect.so

[16:12:30] [debug] #15 080a3939 in ?? () from ./samp03svr

[16:12:30] [debug] #16 080aebfa in ?? () from ./samp03svr

[16:12:30] [debug] #17 08071a92 in ?? () from ./samp03svr

[16:12:30] [debug] #18 08071bc2 in ?? () from ./samp03svr

[16:12:30] [debug] #19 0807ba20 in ?? () from ./samp03svr

[16:12:30] [debug] #20 080acbfd in ?? () from ./samp03svr

[16:12:30] [debug] #21 080acda2 in ?? () from ./samp03svr

[16:12:30] [debug] #22 080a81ae in ?? () from ./samp03svr

[16:12:30] [debug] #23 b74b7cb6 in __libc_start_main () from /lib/libc.so.6

[16:12:30] [debug] #24 0804b4a1 in ?? () from ./samp03svr

už pagalbą +rep.

[renaldasj]

klaida kažkur OnPlayerSpawn, žiūrėk kažką su strlen() mysql_fetch_field_row kažką būsi pridirbęs

Redaguota Balandžio 21, 2015, nario RenaldasJ

[HJones]

klaida kažkur OnPlayerSpawn, žiūrėk kažką su strlen() mysql_fetch_field_row kažką būsi pridirbęs

Hmm, pas mane kode po OnPlayerSpawn tik vienas stockas yra naudojantis mysql_fetch_field_row funkciją, bet nieko blogo jame nematau. O kodas:

stock MySQL_Load(playerid)
{
	new
		Float: pos[3], // 0,1,2 - pozicija;
		fetch[16],
	    Query[256];

    format(Query, sizeof(Query), "SELECT * FROM `zaidejai` WHERE vardas = '%s'", GetPlayerNameEx(playerid));
    mysql_query(Query);
	mysql_store_result();
	mysql_retrieve_row();

	mysql_fetch_field_row( fetch, "x" );
	pos[0] = floatstr(fetch);
	mysql_fetch_field_row( fetch, "y" );
	pos[1] = floatstr(fetch);
	mysql_fetch_field_row( fetch, "z" );
	pos[2] = floatstr(fetch);

	SetPlayerPos( playerid, pos[0], pos[1], pos[2] + 0.75);

    mysql_fetch_field_row( fetch,"skin" );          playerData[playerid][pSkin] = strval(fetch);   	SetPlayerSkin(playerid, playerData[playerid][pSkin]);
	mysql_fetch_field_row( fetch,"pinigai" );		playerData[playerid][pPinigai] = strval(fetch);	GivePlayerMoney(playerid, playerData[playerid][pPinigai]);
	mysql_fetch_field_row( fetch,"patirtis" );      playerData[playerid][pPatirtis] = strval(fetch);   	SetPlayerScore(playerid, playerData[playerid][pPatirtis]);

	mysql_free_result();

	printf("[gRPG.pwn]: Pakrautas žaidėjas %s!", GetPlayerNameEx(playerid));

	return 1;
}

[bebras]

Ta funkcija turi klaidų.

 

http://www.supergames.lt/topic/214408-mysql-krovimas-ir-trinimas-row/#entry1535454

[HJones]

Ta funkcija turi klaidų.

 

http://www.supergames.lt/topic/214408-mysql-krovimas-ir-trinimas-row/#entry1535454

aiškiau galima?

[bebras]

aiškiau galima?

O kas neaišku? Senas plugin. Turi klaidų. Niekas jų nebetaisys.

[HJones]

Fixed, rakinkit.

Redaguota Balandžio 21, 2015, nario HJones

[bebras]

 

Gerai, su tuo dalyku susitvarkiau, išėmiau krovimą, sukursiu naują.

Dabar kita problema, kodėl kai naudoju komandą /skin [iD], neužsideda skin, tik rašo „/skin [iD]“?

 

Kodas:

CMD:skin(playerid, params[])
{
	new skinid;
	if(sscanf(params, "i", skinid)) return SendClientMessage(playerid, -1, "/skin [Skin ID]");
  	if(skinid < 0 || skinid > 299)
   	{
		SendClientMessage(playerid, -1, "Žaidėjo išvaizdos ID turėtu būti nuo 0 iki 299");
    }
    else
    {
    	SetPlayerSkin(playerid, skinid);
   	 	SendClientMessage(playerid, -1, "Pasikeitėte žaidėjo išvaizdą!");
    }
 	return 1;
}

sscanf plugin pasikrauna be problemų? Kitos komandos su sscanf veikia?

[HJones]

sscanf plugin pasikrauna be problemų? Kitos komandos su sscanf veikia?

Susitvarkiau jau viską, žiopla klaida buvo...

 

buvo:

#include <sscanf2>

 

o reikėjo pakeisti į:

#include <sscanf>

 

Rakinkit.

[bebras]

Susitvarkiau jau viską, žiopla klaida buvo...

 

buvo:

#include <sscanf2>

 

o reikėjo pakeisti į:

#include <sscanf>

 

Rakinkit.

Na kaip čia pasakius... Rekomenduočiau naudoti sscanf 2.8.1(sscanf2)