mysql error - Printable Version

mysql error - 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: mysql error (/showthread.php?tid=596894)

mysql error - danielpalade - 23.12.2015

Alright, so this is my OnPlayerDisconnect.

Код:

public OnPlayerDisconnect(playerid, reason)
{
	new query[128], aName[MAX_PLAYER_NAME];
	GetPlayerName(playerid, aName, sizeof(aName));
	mysql_format(mysql, query, sizeof(query), "UPDATE `accounts` SET (`AdminLevel`, `Age`, `Gender`, `Skin`) VALUES ('%i', '%i', '%i', '%i') WHERE `Username` = '%s'", pInfo[playerid][AdminLevel], pInfo[playerid][Age], pInfo[playerid][Gender], pInfo[playerid][Skin], aName);
	mysql_tquery(mysql, query);
	return 1;
}

This is what my mysql_log tells me.

Код:

[23:49:22] [DEBUG] mysql_format - connection: 1, len: 128, format: "UPDATE `accounts` SET (`AdminLevel`, `Age`, `Gender`, `Skin`) VALUES ('%i', '%i', '%i', '%i') WHERE `Username` = '%s'"
[23:49:22] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `accounts` SET (`AdminLevel`, `Age`, `Gender`, `Skin`) VA", callback: "(null)", format: "(null)"
[23:49:22] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[23:49:22] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(`AdminLevel`, `Age`, `Gender`, `Skin`) VALUES ('0', '16', '1', '60') WHERE `Use' at line 1
[23:49:22] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError

What did I do wrong?

Re: mysql error - Scrillex - 23.12.2015

%d not %i

Re: mysql error - danielpalade - 23.12.2015

Quote:

Originally Posted by Scrillex

%d not %i

That didn't fix it.

Код:

[00:01:20] [DEBUG] mysql_format - connection: 1, len: 128, format: "UPDATE `accounts` SET (`AdminLevel`, `Age`, `Gender`, `Skin`) VALUES ('%d', '%d', '%d', '%d') WHERE `Username` = '%s'"
[00:01:20] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `accounts` SET (`AdminLevel`, `Age`, `Gender`, `Skin`) VA", callback: "(null)", format: "(null)"
[00:01:20] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[00:01:20] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(`AdminLevel`, `Age`, `Gender`, `Skin`) VALUES ('0', '16', '1', '60') WHERE `Use' at line 1
[00:01:20] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError

Re: mysql error - Vince - 23.12.2015

http://dev.mysql.com/doc/refman/5.5/en/update.html

Re: mysql error - danielpalade - 23.12.2015

Quote:

Originally Posted by Vince

http://dev.mysql.com/doc/refman/5.5/en/update.html

And what exactly did I do wrong?

Respuesta: mysql error - Zume - 23.12.2015

by the way:

that:

PHP код:



UPDATE `accounts` SET (`AdminLevel`, `Age`, `Gender`, `Skin`) VALUES ('%i', '%i', '%i', '%i') WHERE `Username` = '%s'

have 126 characters.

assume the maximum of characters in names is 24 (MAX_PLAYER_NAME), you exceeds the new query [128];

Re: Respuesta: mysql error - danielpalade - 23.12.2015

Quote:

Originally Posted by _Zume

by the way:

that:

PHP код:



UPDATE `accounts` SET (`AdminLevel`, `Age`, `Gender`, `Skin`) VALUES ('%i', '%i', '%i', '%i') WHERE `Username` = '%s'

have 126 characters.

assume the maximum of characters in names is 24 (MAX_PLAYER_NAME), you exceeds the new query [128];

Ow yea, thanks.
But it still doesn't fix the error