Mysql error 1064
#1

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.
Reply


Messages In This Thread
Mysql error 1064 - by AnthonyIta - 11.05.2014, 08:03
Re: Mysql error 1064 - by Jstylezzz - 11.05.2014, 08:10
Re: Mysql error 1064 - by AnthonyIta - 11.05.2014, 08:57

Forum Jump:


Users browsing this thread: 2 Guest(s)