[MYSQL] Plugin R41-2 not retrieving data.

[MYSQL] Plugin R41-2 not retrieving data. - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Server (https://sampforum.blast.hk/forumdisplay.php?fid=6)
+--- Forum: Server Support (https://sampforum.blast.hk/forumdisplay.php?fid=19)
+--- Thread: [MYSQL] Plugin R41-2 not retrieving data. (/showthread.php?tid=624175)

[MYSQL] Plugin R41-2 not retrieving data. - Tessa - 12.12.2016

Hello!

My server currently operates on MySQL R41-2, but it's not exactly working.
I'll just give proper examples.

This is the callback for the code:

Код:

forward LoadPlayerData(playerid);
public LoadPlayerData(playerid)
{
	new tempscore;
	cache_get_value_name_int(0, "Score", tempscore);
	SetPlayerScore(playerid, tempscore);
	cache_get_value_name_int(0, "Donator", Player_Data[playerid][Donator]); 
	cache_get_value_name_int(0, "Adminlevel", Player_Data[playerid][Adminlevel]);
	cache_get_value_name_int(0, "RoundsWon", Player_Data[playerid][RoundsWon]); 
	cache_get_value_name_int(0, "RoundsLost", Player_Data[playerid][RoundsLost]); 
	cache_get_value_name_int(0, "RoundsLastSurvivor", Player_Data[playerid][RoundsLastSurvivor]); 
	cache_get_value_name_int(0, "RoundsLeastDamage", Player_Data[playerid][RoundsLeastDamage]); 
	cache_get_value_name_int(0, "TotalRounds", Player_Data[playerid][TotalRounds]); 
	cache_get_value_name_int(0, "Q_A", Player_Data[playerid][Q_A]); 
	cache_get_value_name_int(0, "EventPoints", Player_Data[playerid][EventPoints]); 
	cache_get_value_name_int(0, "ExperiencePoints", Player_Data[playerid][EXP]); 
	cache_get_value_name_int(0, "Level", Player_Data[playerid][lvl]); 

	new debugfucker[128];
	new tmp = cache_is_any_active();
	new rows = cache_get_row_count(rows);
	new rows1 = cache_get_field_count(rows1);
	new field_name[32];
	cache_get_field_name(5, field_name);
	return 1; 
}

However; this is not loading the required information.
I've gone ahead and debugged the code and this is the result of the debugging:

Код:

<&Princess> DEBUG: Number of rows? 1 -- Numbers of fields? 1 -- Field name is Adminlevel
<&Princess> DEBUG: Is cache active? 1
<&Princess> DEBUG: Score: 0
<&Princess> DEBUG: Admin level: 0
<&Princess> DEBUG: Some random ass RoundsWon: 0

As you can see; the code does execute as it's supposed to; but it simply is not assigning values.
All logs from log_core are perfectly fine.

Some suggested that downgrading to R39 as R41-2 gets fixed as they claim this is a plugin error; not a code error.
However; such option for me is not available as I run on CentOS 7.

Re: [MYSQL] Plugin R41-2 not retrieving data. - Konstantinos - 12.12.2016

Are you sure you select all the data instead of Adminlevel column only when executing the query? Nobody has reported anything similar so apparently that is unlikely a plugin issue.

Re: [MYSQL] Plugin R41-2 not retrieving data. - Tessa - 12.12.2016

Hello!
Sorry for the late response.
For some reason the server was failing to perform it's password validation and was actually attempting to log in people; regardless if their PW matched the DB... Which explain above problems.

This has since been rectified and all is well