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=DEFAULT' at line 1

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • RE: Connecting with MySQL - Forums | Liferay
    via by Unknown author,
  • RE: Connecting with MySQL - Forums | Liferay
    via by Unknown author,
  • RE: Connecting with MySQL - Forums | Liferay
    via by Unknown author,
  • RE: Connecting with MySQL - Forums | Liferay
    via by Unknown author,
  • RE: Connecting with MySQL - Community Forums | Liferay
    via by Unknown author,
  • Connecting with MySQL - Community Forums | Liferay
    via by Unknown author,
  • Liferay not working with MySQL - Forums | Liferay
    via by Unknown author,
    • 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=DEFAULT' at line 1 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3250) at com.mysql.jdbc.Connection.unsetMaxRows(Connection.java:5820) at com.mysql.jdbc.Statement.realClose(Statement.java:2023) at com.mysql.jdbc.PreparedStatement.realClose(PreparedStatement.java:2185) at com.mysql.jdbc.PreparedStatement.close(PreparedStatement.java:687) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.close(NewProxyPreparedStatement.java:1811) at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.closeStatement(StdJDBCDelegate.java:3609) at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.selectTriggerToAcquire(StdJDBCDelegate.java:2932) at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2742) at org.quartz.impl.jdbcjobstore.JobStoreSupport$36.execute(JobStoreSupport.java:2728) at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3742) at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2724) at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:263)

    Users with the same issue

    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,