(error #1064) You have an error in your SQL syntax

(error #1064) 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: (error #1064) You have an error in your SQL syntax (/showthread.php?tid=647388)

(error #1064) You have an error in your SQL syntax - Lirbo - 04.01.2018

PHP код:



[19:56:48 01/04/18] [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 'SELECT MAX(`id`) FROM `server_item`+1, 'test', 1, 0, 3, 5, 7, 1, 1, 5, 5, 7)' at line 1 (Query: "INSERT IGNORE INTO `server_item` (`id`, `name`, `type`, `required_level`, `attack`, `maxhp`, `maxmp`, `hp_regeneration`, `mp_regeneration`, `jump`, `speed`, `slots`)VALUES (SELECT MAX(`id`) FROM `server_item`+1, 'test', 1, 0, 3, 5, 7, 1, 1, 5, 5, 7)")

I copied it to the phpmyadmin SQL and it works perfectly manually, how do I do it on this mysql version?

Re: (error #1064) You have an error in your SQL syntax - Misiur - 04.01.2018

Quote:

SELECT MAX(`id`) FROM `server_item`+1

? If you want max + 1, then place it before "FROM"

Re: (error #1064) You have an error in your SQL syntax - Lirbo - 04.01.2018

Quote:

Originally Posted by Misiur

? If you want max + 1, then place it before "FROM"

the problem is with the SELECT MAX(`id`) FROM `server_item`, how do I get the highest id of an item?

Re: (error #1064) You have an error in your SQL syntax - Misiur - 04.01.2018

I mean in your query you put "+1" after "FROM tablename", that's not right. MAX(`id`) is correct for getting highest id, and if you want + 1 just put it right after MAX, not after FROM part.

Re: (error #1064) You have an error in your SQL syntax - Lirbo - 04.01.2018

Quote:

Originally Posted by Misiur

I mean in your query you put "+1" after "FROM tablename", that's not right. MAX(`id`) is correct for getting highest id, and if you want + 1 just put it right after MAX, not after FROM part.

PHP код:



[20:43:22 01/04/18] [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 'SELECT MAX(`id`) FROM `server_item`, 'test', 1, 0, 3, 5, 7, 1, 1, 5, 5, 7)' at line 1 (Query: "INSERT IGNORE INTO `server_item` (`id`, `name`, `type`, `required_level`, `attack`, `maxhp`, `maxmp`, `hp_regeneration`, `mp_regeneration`, `jump`, `speed`, `slots`)VALUES (SELECT MAX(`id`) FROM `server_item`, 'test', 1, 0, 3, 5, 7, 1, 1, 5, 5, 7)")

that's without +1, just to show you that is indeed wrong

Re: (error #1064) You have an error in your SQL syntax - Misiur - 04.01.2018

Oh, I see. You are trying to insert id via subselecting max id from the table. Well, that's not the way to do it. Is your id column set to `AUTO_INCREMENT`? If yes, then you don't have to pass anything (or pass null to use default value (auto incremented id in this case) if you don't specify which fields you are inserting)

Re: (error #1064) You have an error in your SQL syntax - Lirbo - 04.01.2018

Quote:

Originally Posted by Misiur

Oh, I see. You are trying to insert id via subselecting max id from the table. Well, that's not the way to do it. Is your id column set to `AUTO_INCREMENT`? If yes, then you don't have to pass anything (or pass null to use default value (auto incremented id in this case) if you don't specify which fields you are inserting)

yeah I realized it was related, fixed it, thanks mate