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=488466)
+- 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=488466)
MySQL Error ID: 1064 - TudvariHUN - 18.01.2014
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);
Re: MySQL Error ID: 1064 - TudvariHUN - 18.01.2014
bump
Re: MySQL Error ID: 1064 - TudvariHUN - 18.01.2014
bumpdsds
Re: MySQL Error ID: 1064 - TudvariHUN - 18.01.2014
bump
Re: MySQL Error ID: 1064 - InglewoodRoleplay - 18.01.2014
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);
Re: MySQL Error ID: 1064 - TudvariHUN - 18.01.2014
In other Inserts it was good that way
Re: MySQL Error ID: 1064 - TudvariHUN - 18.01.2014
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);
Re: MySQL Error ID: 1064 - TudvariHUN - 19.01.2014
bump (you can delete the older bumps)
Re: MySQL Error ID: 1064 - TudvariHUN - 19.01.2014
This is the table: http://gyazo.com/7f3bc1a27d33c3ba51ae47185e1e3370.png
(Nem means not null)
Re: MySQL Error ID: 1064 - TudvariHUN - 19.01.2014
bump