[MySQL]: You have an error in your SQL syntax;

[MySQL]: You have an error in your SQL syntax; - 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]: You have an error in your SQL syntax; (/showthread.php?tid=657364)

[MySQL]: You have an error in your SQL syntax; - R3SpaWn0 - 05.08.2018

This its what my server log say.. wtf, i didnt touch databases, how can i find the error? where is 18, line 1? wtf?!!

Quote:

** [MySQL]: 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 ''18' at line 1
** [MySQL]: 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 ''18' at line 1
** [MySQL]: 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 ''18' at line 1
** [MySQL]: 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 ''18' at line 1
** [MySQL]: 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 ''18' at line 1

[01:25:25 08/06/18] [ERROR] CMySQLQuery::Execute[] - (error #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 ''18' at line 1

PHP код:



(Query: "UPDATE `plants` SET `plantOwner` = 'Kenny_Montana', `plantType` = '1', `plantDrugs` = '17', `plantX` = '2257.5900', `plantY` = '-1211.7399', `plantZ` = '1049.0200', `plantA` = '226.6150', `plantInterior` = '10', `plantWorld` = '5295' WHERE `plantID` = '18")

[01:26:31 08/06/18] [ERROR] CMySQLQuery::Execute[] - (error #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 ''18' at line 1 (Query: "UPDATE `plants` SET `plantOwner` = 'Kenny_Montana', `plantType` = '1', `plantDrugs` = '18', `plantX` = '2257.5900', `plantY` = '-1211.7399', `plantZ` = '1049.0200', `plantA` = '226.6150', `plantInterior` = '10', `plantWorld` = '5295' WHERE `plantID` = '18")

here what is the fail?

Re: [MySQL]: You have an error in your SQL syntax; - Mobtiesgangsa - 06.08.2018

WHERE `plantID` = '18' ");

notice here where it say's

you are missing one ( ' ) Color Magenta

Re: [MySQL]: You have an error in your SQL syntax; - R3SpaWn0 - 06.08.2018

Quote:

Originally Posted by Mobtiesgangsa

WHERE `plantID` = '18' ");

notice here where it say's

you are missing one ( ' ) Color Magenta

Oh, shit man, thank you for your eyes hahaha, i looked 5 million times but i didnt see becouse the " , thank you, it s working now ! Im new ( my 7 years acc dont say anything, i was afk all this years, i startes learning now