MySQL error #1064

[MagicOfCookies]

Sveiki, kaip išspręsti šią problemą?

[16:34:33] [DEBUG] CMySQLQuery::Execute[()] - starting query execution
[16:34:34] [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 ''vartotojai' SET 'Admin'=0, 'Vip'=0, 'Pinigai'=0, `PosX`=157.725540, `PosY`=-64.' at line 1
[16:34:34] [DEBUG] CMySQLQuery::Execute[()] - error will be triggered in OnQueryError
[16:34:34] [DEBUG] CMySQLQuery::Execute[()] - data being passed to ProcessCallbacks()
[16:34:34] [DEBUG] CMySQLQuery::~CMySQLQuery() - deconstructor called

Bandžiau didinti stringus, nepadėjo. Pats kodas:

public OnPlayerDisconnect(playerid, reason)
{
	new string[128], Float:Pos[3];
	GetPlayerPos(playerid, Pos[0], Pos[1], Pos[2]);
	mysql_format(Duombaze, string, sizeof(string), "UPDATE 'vartotojai' SET 'Admin'=%d, 'Vip'=%d, 'Pinigai'=%d, `PosX`=%f, `PosY`=%f, `PosZ`=%f, WHERE 'ID'=%d",\
 	zInfo[playerid][Admin], zInfo[playerid][Vip], zInfo[playerid][Pinigai], Pos[0], Pos[1], Pos[2], zInfo[playerid][ID]);
	mysql_tquery(Duombaze, string, "", "", playerid);
	return 1;
}

 

[Sport1]

Formatuojama užklausa netelpa į masyvą

new string[128]

[bebras]

Prieš "WHERE" sakinį nereikia kablelio. 

UPDATE 'vartotojai' SET 'Admin'=%d, 'Vip'=%d, 'Pinigai'=%d, `PosX`=%f, `PosY`=%f, `PosZ`=%f WHERE 'ID'=%d"

 

Redaguota Sausio 16, 2017, nario bebras