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
"
this is the query SELECT "PC0".`customerid` AS "customerid" , "PC0".`customername` AS "customername" FROM TELECOMMUNICATION.bsstest "PC0"
Did you check- what happens when you run his query directly from the database. Can you please check if these columns/schema/tables ( customerid/customername/TELECOMMUNICATION/bsstest ) exists as query seems to be correct.
I have run that query directly from the Mysql DB, same exception occurred in mysql DB , Exception is
"SELECT "PC0".`customerid` AS "customerid" , "PC0".`customername` AS "customername" FROM TELECOMMUNICATION.bsstest "PC0" Error Code: 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 '.`customerid` AS "customerid" , "PC0".`customername` AS "customername" FROM TELE' at line 1 0.047 sec"
can you please check if "customername" and other columns exist and mapping is proper. Also, check if all the columns are in lower case i.e check case sensitivity. I actually prepared some sample data and ran a similar q
uery and it seems to be working. The problem seems to be at db end.
i'm using Mysql latest version ,i think this issue due to latest version, it's not support some old syntax . Here Attached with Screen shoot
In this query "pc0".customerid , without alias with double quotes around it working fine, pc0.customerid
Probably you can take help of DBA to address this issue. As said earlier, it does not seems to be an issue with PRPC.
What is the version of mysql with which you are facing this issue?
Version of the mysql server is 8.0.11(Mysql community server - GPL)
Hi
If the query copied is the exact the same then probably the issue is with single quotes, it seems to be different,
' or `.
query is not working with (double quotes) "pc0".customerid but query is working correctly without (double quotes) pc0.customerid
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