# Data Collection Error

**URL:** <https://forum.inductiveautomation.com/t/data-collection-error/11249>\
**Category:** Archived Topics\
**Created:** [February 22, 2016, 8:23pm UTC](https://forum.inductiveautomation.com/t/data-collection-error/11249 "2016-02-22T20:23:44Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![estout](https://avatars.discourse-cdn.com/v4/letter/e/3ec8ea/32.png) [@estout](https://forum.inductiveautomation.com/u/estout)\
**Post date:** [February 22, 2016, 8:23pm UTC](https://forum.inductiveautomation.com/t/data-collection-error/11249/1 "2016-02-22T20:23:44Z")

</div>

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,  
Thanks

---

<div class="post-metadata">

**Author:** ![nmudge](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nmudge/32/3394_2.png) [@nmudge](https://forum.inductiveautomation.com/u/nmudge)\
**Post date:** [February 22, 2016, 10:08pm UTC](https://forum.inductiveautomation.com/t/data-collection-error/11249/2 "2016-02-22T22:08:42Z")

</div>

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: [dev.mysql.com/downloads/connector/j/](http://dev.mysql.com/downloads/connector/j/)

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](https://support.inductiveautomation.com/index.php?/Knowledgebase/Article/View/37/0/mysql-syntax-error-near-option-sql_select_limit1-received-when-using-mysql-56)

Best,