Does anyone know what this error means?

Does anyone know what this error means? - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Does anyone know what this error means? (/showthread.php?tid=597153)

Does anyone know what this error means? - danielpalade - 27.12.2015

Whenever my script tries to save the player data I get this in my mysql_log.

Код:

[14:57:22] [DEBUG] mysql_format - connection: 1, len: 1024, format: "UPDATE `accounts` SET `AdminLevel`=%d, `Age`=%d, `Gender`=%d, `Skin`=%d, `Money`=%d, `Level`=%d, `Job`=%d, `Materials`=%d, `Drug..."
[14:57:22] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `accounts` SET `AdminLevel`=2, `Age`=16, `Gender`=1, `Ski", callback: "(null)", format: "(null)"
[14:57:22] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[14:57:22] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 33.776 milliseconds
[14:57:22] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving

This is my OnPlayerDisconnect

Код:

public OnPlayerDisconnect(playerid, reason)
{
	new query[1024], aName[MAX_PLAYER_NAME];
	GetPlayerName(playerid, aName, sizeof(aName));
	mysql_format(mysql, query, sizeof(query), "UPDATE `accounts` SET `AdminLevel`=%d, `Age`=%d, `Gender`=%d, `Skin`=%d, `Money`=%d, `Level`=%d, `Job`=%d, `Materials`=%d, `Drugs`=%d WHERE `ID`=%d", pInfo[playerid][AdminLevel], pInfo[playerid][Age], pInfo[playerid][Gender], pInfo[playerid][Skin], pInfo[playerid][Money], pInfo[playerid][Level], pInfo[playerid][Job], pInfo[playerid][Materials], pInfo[playerid][Drugs], pInfo[playerid][ID]);
	mysql_tquery(mysql, query, "", "");
	return 1;
}

Re: Does anyone know what this error means? - J4Rr3x - 27.12.2015

There aren't any error.
This is only a debug message, in fact it says:

Quote:

query was successfully executed within 33.776 milliseconds

Re: Does anyone know what this error means? - FreAkeD - 27.12.2015

As said above there's no errors or warning, your script is just debugging and just outputting how long the MYSQL query took to execute. This comes in handy if you'd like to know how long a query or something took to execute.

Re: Does anyone know what this error means? - danielpalade - 27.12.2015

Quote:

Originally Posted by J4Rr3x

There aren't any error.
This is only a debug message, in fact it says:

Well yea, but the thing is. It doesn't save anything except the AdminLevel, Age and the Gender.
It output's

Код:

"(null)", format: "(null)"

after the `Skin`

Re: Does anyone know what this error means? - J4Rr3x - 27.12.2015

Quote:

"(null)", format: "(null)"

stands for last params of mysql_tquery

Quote:

mysql_tquery(mysql, query, "", "");

Re: Does anyone know what this error means? - danielpalade - 27.12.2015

Quote:

Originally Posted by J4Rr3x

stands for last params of mysql_tquery

So what could be the problem of not saving?

Re: Does anyone know what this error means? - J4Rr3x - 27.12.2015

Your query works, only that the mysql truncate string when print it otherwise be a very long line.