Syntax Mysql error - Printable Version

Syntax Mysql error - 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: Syntax Mysql error (/showthread.php?tid=553376)

Syntax Mysql error - Pitter - 29.12.2014

Код:

[13:24:05] [ERROR] CMySQLQuery::Execute[()] - (error #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 '`=0, `Preso`=0, `TempoCalado`=0, `TempoPreso`=0, `Profissao`=0, `Salario`=0, `Na' at line 1
[13:24:05] [ERROR] mysql_format - no value for specifier "%d" available
[13:24:05] [ERROR] CMySQLQuery::Execute[()] - (error #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 '' at line 1

What did can be?

Re: Syntax Mysql error - Vince - 29.12.2014

Post code! The fact that it cuts off at the end probably means your string isn't big enough.

Re: Syntax Mysql error - Pitter - 29.12.2014

Neat, missing an apostrophe, Sorry.