WARN: Simple Query could not be completedYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘OPTION SQL_SELECT_LIMIT=100’ at line 1
This is the query I am using:
SELECT * FROM simple_history1
Just wanting to bring in a simple query into a report and getting this error. I can run this query in the DataBase Query Browser but I get <N/A> in all the columns.
The MySQL JDBC driver that installed in your Ignition Gateway does not support MySQL 5.6. The solution is replace your driver with a driver that does support it.
You can install it using Ignition’s Gateway web interface for installing database drivers or follow the instructions given in the article at this link: support.inductiveautomation.com … g-mysql-56