Pattern selector

Most relevant patterns first. Most helpful ones displayed. Click here to show all.

  1. DelegatingPreparedStatement.executeQuery() has thrown a MySQLSyntaxErrorException
    Tomcat DBCP
    0
    0
    0
  2. Unable to process query due to syntax error in SQL statement
    MySQL Connector/J
    53
    7
    9

Your stack trace compared to the selected pattern

Jump to solutionsExpand frames
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'lportal.quartz_triggers' doesn't exist
    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)
75 frames hidden

External results for this pattern (10)

  1. kwootvia GitHub2 months ago
    Error executing SQL CREATE TABLE `issue_log` (`id` BIGINT AUTO_INCREMENT NOT NULL, `code` VARCHAR(25) NULL, `project` BIGINT NULL, `type` INT NULL, `description` VARCHAR(512) NULL, `priority` INT NULL, `severity` INT NULL, `created_by` BIGINT NULL, `assigned_to` VARCHAR(50) NULL, `status` VARCHAR(50) NULL, `date_raised` TIMESTAMP, `deadline` TIMESTAMP, `date_resolved` TIMESTAMP, `notes` VARCHAR(256) NULL, CONSTRAINT `issue_log_pkey` PRIMARY KEY (`id`)): Invalid default value for 'deadline'
    Show stack trace
  2. kwootvia GitHub2 months ago
    java.lang.reflect.InvocationTargetException
    Show stack trace
  3. 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 '? AND suggestedfood.selected=? AND suggestedfood.Removed=? GROUP BY suggestedfoo' at line 1
    Show stack trace
  4. Angelinevia Stack Overflow4 months ago
    Access denied for user 'root'@'172.20.169.174' to database 'struts2'
    Show stack trace
  5. gunter rombautsvia Pentaho BI Platform Tracking4 months ago
    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 'LibFormulaErrorValue' at line 1
    Show stack trace
  6. kwootvia GitHub4 months ago
    could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
    Show stack trace
  7. kwootvia GitHub4 months ago
    could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
    Show stack trace
  8. kwootvia GitHub4 months ago
    could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
    Show stack trace
  9. Unknown authorvia liferay.com4 months ago
    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
    Show stack trace
  10. Unknown authorvia liferay.com4 months ago
    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
    Show stack trace