Question
12
Replies
2330
Views
Posted: June 12, 2018
Last activity: June 14, 2018
Closed
error in your SQL syntax; check the manual that corresponds to your MySQL server version
I'm getting exception in report definition, My properties mapped into external mysql DB, When i was run the report definition, this exception occurred
Error:
** An error occured on executing the query for the report definition - There was a problem getting a list: code: 1064 SQLState: 42000 Message: 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 '.`customerid` AS "customerid" , "PC0".`customername` AS "customername" FROM TELE' at line 1 DatabaseException caused by prior exception: java.sql.SQLSyntaxErrorException: 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 '.`customerid` AS "customerid" , "PC0".`customername` AS "customername" FROM TELE' at line 1 | SQL Code: 1064 | SQL State: 42000
"
Hi,
This error can have multiple causes. Please refer.
https://www.inmotionhosting.com/support/website/database-troubleshooting/error-1064
Also, see the query in tracer(enable DB query in settings) and run it directly from the database. Also, post the complete query here so that we can look into it.
Regards,
Rachit