[Maime]

Nothing saves and i get this errors in mysql log please help me

Quote:

[09:54:19] [ERROR] CMySQLQuery::Execute[SendQuery()] - (error #1054) Unknown column 'X' in 'field list' [09:55:08] [ERROR] CMySQLQuery::Execute[SendQuery()] - (error #1054) Unknown column 'X' in 'field list' [09:55:10] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('8') [09:55:11] [ERROR] cache_get_row_float - invalid data type [09:55:13] [ERROR] CMySQLQuery::Execute[SendQuery()] - (error #1054) Unknown column 'X' in 'field list'

code

pawn Код:

stock SaveAccount(playerid)
{
new
query[300],
Floatos[4],
Float:health;

GetPlayerPos(playerid, posArr{pos});
GetPlayerFacingAngle(playerid, pos[3]);
GetPlayerHealth(playerid, health);

format(query, sizeof(query), "UPDATE `users` SET health = %.1f, X = %.2f, Y = %.2f, Z = %.2f, A = %.2f, interior = %d, vw = %d, skin = %d WHERE `id` = %d",
health,
posArrEx{pos},
GetPlayerInterior(playerid),
GetPlayerVirtualWorld(playerid),
GetPlayerSkin(playerid),
g_PlayerInfo[playerid][pSQLid]
);

mysql_function_query(g_Handle, query, false, "SendQuery", "");
return 1;
}

[Wizza]

You haven't created column X into your database, create it using phpMyAdmin.