SA-MP Forums Archive
MySQL Error ID: 1064 - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL Error ID: 1064 (/showthread.php?tid=660616)


MySQL Error ID: 1064 - rOps - 08.11.2018

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)


Re: MySQL Error ID: 1064 - PawelQ - 08.11.2018

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

Re: MySQL Error ID: 1064 - rOps - 08.11.2018

Yes.

Re: MySQL Error ID: 1064 - PawelQ - 08.11.2018

What version of plugin are You using?

Re: MySQL Error ID: 1064 - Rolux - 08.11.2018

Код:
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);


Re: MySQL Error ID: 1064 - PawelQ - 08.11.2018

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

Re: MySQL Error ID: 1064 - rOps - 08.11.2018



Thanks, and sorry for my stupidity level over 9999