[AnthonyIta]

I have this error:

Код:

[10:06:31] [DEBUG] mysql_tquery - scheduling query "UPDATE `house` SET enter_x='1482.148803', enter_y='-1589.184692', enter_z='13.382812', enter_angle='312.686218', enter_interior"..
[10:06:31] [DEBUG] CMySQLQuery::Execute[SendQuery()] - starting query execution
[10:06:31] [ERROR] CMySQLQuery::Execute[SendQuery()] - (error #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 '' at line 1
[10:06:31] [DEBUG] CMySQLQuery::Execute[SendQuery()] - error will be triggered in OnQueryError
[10:06:31] [DEBUG] CMySQLQuery::Execute[SendQuery()] - data being passed to ProcessCallbacks()
[10:06:31] [DEBUG] CMySQLQuery::~CMySQLQuery() - deconstructor called

code:

pawn Код:

format(query, sizeof(query), "UPDATE `house` SET enter_x='%f', enter_y='%f', enter_z='%f', enter_angle='%f', enter_interior='%d', enter_world='%d' WHERE id='%d'",
        HouseInfo[id][EnterX],
        HouseInfo[id][EnterY],
        HouseInfo[id][EnterZ],
        HouseInfo[id][EnterAngle],
        HouseInfo[id][EnterInterior],
        HouseInfo[id][EnterWorld],
        HouseInfo[id][HouseId]);

Help is much appreciated.

[Jstylezzz]

How big is the size of the query string? I can't find any problems with the query itself, so maybe the string size is too short. Try increasing it and see what happens.

[AnthonyIta]

Quote:

Originally Posted by Jstylezzz How big is the size of the query string? I can't find any problems with the query itself, so maybe the string size is too short. Try increasing it and see what happens.

Thanks!!