Does anyone know what this error means?
#1

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;
}
Reply
#2

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

query was successfully executed within 33.776 milliseconds

Reply
#3

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.
Reply
#4

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`
Reply
#5

Quote:

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

stands for last params of mysql_tquery
Quote:

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

Reply
#6

Quote:
Originally Posted by J4Rr3x
Посмотреть сообщение
stands for last params of mysql_tquery
So what could be the problem of not saving?
Reply
#7

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


Forum Jump:


Users browsing this thread: 1 Guest(s)