Data Collection Error

Getting the error:

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.

Any help would be appreciated,

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 download a new MySQL JDBC driver from here:

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: … g-mysql-56


1 Like