# MySQL5.6 error OPTION SQL\_SELECT\_LIMIT=1

**URL:** <https://forum.inductiveautomation.com/t/mysql5-6-error-option-sql-select-limit-1/6458>\
**Category:** Ignition\
**Created:** [May 13, 2013, 11:00pm UTC](https://forum.inductiveautomation.com/t/mysql5-6-error-option-sql-select-limit-1/6458 "2013-05-13T23:00:32Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![rcorkern](https://avatars.discourse-cdn.com/v4/letter/r/90db22/32.png) [@rcorkern](https://forum.inductiveautomation.com/u/rcorkern)\
**Post date:** [May 13, 2013, 11:00pm UTC](https://forum.inductiveautomation.com/t/mysql5-6-error-option-sql-select-limit-1/6458/1 "2013-05-13T23:00:32Z")

</div>

Time Logger Message

5:56:06 PM SQLTags.TagProviders.Provider[Halliburton\_ddp].TagStore Error upgrading external provider schema. Will attempt again the next time that the provider starts.

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  
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)  
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2934)  
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1616)  
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1708)  
at com.mysql.jdbc.Connection.execSQL(Connection.java:3249)  
at com.mysql.jdbc.Connection.execSQL(Connection.java:3178)  
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1408)  
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)  
at com.inductiveautomation.ignition.gateway.datasource.SRConnectionWrapper$SRPreparedStatement.executeQuery(SRConnectionWrapper.java:808)  
at com.inductiveautomation.ignition.gateway.datasource.SRConnectionWrapper.runScalarPrepQuery(SRConnectionWrapper.java:193)  
at com.inductiveautomation.ignition.gateway.sqltags.providers.datasource.tagstore.DBTagStore.checkVersion(DBTagStore.java:2991)  
at com.inductiveautomation.ignition.gateway.sqltags.providers.datasource.tagstore.DBTagStore.runTableVerification(DBTagStore.java:2939)  
at com.inductiveautomation.ignition.gateway.sqltags.providers.datasource.tagstore.DBTagStore.configPoll(DBTagStore.java:436)  
at com.inductiveautomation.ignition.gateway.sqltags.providers.datasource.tagstore.DBTagStore$PollRunner.run(DBTagStore.java:3732)  
at com.inductiveautomation.ignition.common.execution.impl.BasicExecutionEngine$TrackedTask.run(BasicExecutionEngine.java:573)  
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)  
at java.util.concurrent.FutureTask$Sync.innerRunAndReset(Unknown Source)  
at java.util.concurrent.FutureTask.runAndReset(Unknown Source)  
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(Unknown Source)  
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)  
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)  
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)  
at java.lang.Thread.run(Unknown Source)

I saw similar issue ([viewtopic.php?f=72&t=9976&p=35013&hilit=com.mysql.jdbc.SQLError.createSQLException#p35013](http://inductiveautomation.com/forum/viewtopic.php?f=72&t=9976&p=35013&hilit=com.mysql.jdbc.SQLError.createSQLException#p35013)) I reloaded jar (mysql-connector-java-5.1.24-bin.jar) file and restarted gateway a few times, still getting this same error.

Thanks in advance with any tips.

---

<div class="post-metadata">

**Author:** ![rcorkern](https://avatars.discourse-cdn.com/v4/letter/r/90db22/32.png) [@rcorkern](https://forum.inductiveautomation.com/u/rcorkern)\
**Post date:** [May 14, 2013, 12:28pm UTC](https://forum.inductiveautomation.com/t/mysql5-6-error-option-sql-select-limit-1/6458/2 "2013-05-14T12:28:43Z")

</div>

here are the exported logs  
[logs.bin.gz](https://us1.discourse-cdn.com/inductiveautomation/original/2X/8/86d97ee08192fe46a8c51a160ca78de0a31847a6.gz) (212 KB)

---

<div class="post-metadata">

**Author:** ![rcorkern](https://avatars.discourse-cdn.com/v4/letter/r/90db22/32.png) [@rcorkern](https://forum.inductiveautomation.com/u/rcorkern)\
**Post date:** [May 14, 2013, 2:03pm UTC](https://forum.inductiveautomation.com/t/mysql5-6-error-option-sql-select-limit-1/6458/3 "2013-05-14T14:03:08Z")

</div>

[inductiveautomation.com/support/kb/154](http://inductiveautomation.com/support/kb/154)

removing the old MySQL connector-jar from the install directory resolved the issue.