MySQL Error ID: 1064
#1

Hello, exactly one hour I'm trying to fix this error, I've tried a lot of different options, but still the same..

Код:
GetPlayerPos(playerid, PropertyPos[0], PropertyPos[1], PropertyPos[2]);

format(Query, sizeof(Query), "INSERT INTO `propertys` (ID, PosX, PosY, PosZ) VALUES ('%d', '%f', '%f, '%f')", PropertyID, PropertyPos[0], PropertyPos[1], PropertyPos[2]);
mysql_query(Query);
Код:
CMySQLHandler::Query(INSERT INTO `propertys` (ID, PosX, PosY, PosZ) VALUES ('0', '-218.448944', '1093.840209, '19.600383')) - An error has occured. (Error ID: 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 '19.600383')' at line 1)
Reply
#2

Does this row in your database is formatted to be a float?
Reply
#3

Yes.
Reply
#4

What version of plugin are You using?
Reply
#5

Код:
GetPlayerPos(playerid, PropertyPos[0], PropertyPos[1], PropertyPos[2]);

format(Query, sizeof(Query), "INSERT INTO `propertys` (ID, PosX, PosY, PosZ) VALUES ('%d', '%f', '%f', '%f')", PropertyID, PropertyPos[0], PropertyPos[1], PropertyPos[2]);
mysql_query(Query);
Reply
#6

Well it's sad to tell that we are blind.
Reply
#7



Thanks, and sorry for my stupidity level over 9999
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)