[TudvariHUN]

Hi!
I need help with this error:

Код:

CMySQLHandler::Query(INSERT INTO Hazak (X,Y,Z,Ar,Zarva,bX,bY,bZ,Interior) VALUES ('295.081359','-54.543411','2.777210','5000000','1','223.04','1287.26','1081.2','1')) - 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 'bY,bZ,Interior) VALUES ('295.081359','-54.543411','2.777210','5000000','1','223.' at line 1)

Код:

   							format(file, sizeof(file), "INSERT INTO Hazak (X,Y,Z,Ar,Zarva,bX,bY,bZ,Interior) VALUES ('%f','%f','%f','%d','1','223.04','1287.26','1081.2','1')", x,y,z,ar);
							mysql_query(file);

Thanks for you further help

[TudvariHUN]

bump

[TudvariHUN]

bumpdsds

[TudvariHUN]

bump

[InglewoodRoleplay]

https://sampforum.blast.hk/showthread.php?tid=285432
http://stackoverflow.com/questions/1...-synchronizing
https://sampforum.blast.hk/showthread.php?tid=392919
https://www.******.com/?gws_rd=cr&ei...+error+id+1064

******'s your best friend, no need to bump. Recheck your query syntax.

pawn Код:

format(file, sizeof(file), "INSERT INTO `Hazak` (`X`,`Y`,`Z`,`Ar`,`Zarva`,`bX`,`bY`,`bZ`,`Interior`) VALUES ('%f','%f','%f','%d','1','223.04','1287.26','1081.2','1')", x,y,z,ar);
mysql_query(file);

[TudvariHUN]

In other Inserts it was good that way

[TudvariHUN]

None of your fixes were good (I already tried them.) I was ******ing the whole afternoon with 0 fixes,because this error is not enough concrete.

Код:

format(file, sizeof(file), "INSERT INTO 'Hazak' (X,Y,Z,Interior,bX,bY,bZ,Zarva,Ar) VALUES (%f,%f,%f,1,223.04,1287.26,1081.2,1,%d)", x,y,z,ar);

[TudvariHUN]

bump (you can delete the older bumps)

[TudvariHUN]

This is the table: http://gyazo.com/7f3bc1a27d33c3ba51ae47185e1e3370.png

(Nem means not null)

[TudvariHUN]

bump