[BlackRaven]

Why this query is not working?

pawn Код:

command(test, playerid, params[])
{
    new query[100];
    format(query, sizeof(query),"UPDATE vehicles SET lock = %d WHERE id = %d",0,61);
    mysql_query(query);
    return 1;
}

EDIT: I'm using BlueG plugin the version is R6.

EDIT: Error from Debug file:

Quote:

[13:51:49] CMySQLHandler::Query(UPDATE vehicles SET lock = 0 WHERE id = 61) - An error has occured. (Error ID: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'lock = 0 WHERE id = 61' at line 1)