EasyChart Errors

I am getting the following error when I try to load historical data into my easychart:

Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: 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 ‘OPTION SQL_SELECT_LIMIT=1’ at line 1

All the tags are in a transaction group that is running and logging. I cannot see what the problem is with the query.

You are getting that error because you are using MySQL 5.6 and the driver in Ignition is too old for that version. You need to upgrade your MySQL JDBC driver in Ignition. Do the following:

  1. First download the latest MySQL JDBC driver from their website:

mysql.com/downloads/connector/j/

Get the zip file. Unzip it and locate the file called mysql-connector-java-5.X.XX-bin.jar.

  1. Log in to the Ignition Gateway configuration page.

  2. Select Databases > Drivers from the left.

  3. Edit the MySQL connector driver.

  4. Choose the newly downloaded .jar file and save the changes.

  5. Restart Ignition just to be safe.

It should work after that.

Thanks a lot, the error indication is now gone and the chart is working.