You are currently reviewing an older revision of this page.

DRAFT KB-XXXX Tomcat fails to load with "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version"

Symptoms

Tomcat fails to start with the following error:

ERROR org.hibernate.util.JDBCExceptionReporter - 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 'system, url_alias, uuid, version_uuid) values (X, XXXXXXXXXXXX, X, XXXXXXXXXXXX' at line 1

Cause

Tomcat will return this error when the environment is using an unsupported version of MySQL.

To check the MySQL version:

  • In Windows, open cmd.exe as Administrator and run the following command: C:\Program Files\MySQL\MySQL Server x.x\bin\mysqld.exe" -V.
  • In Linux, open a command line and run the following command: mysql -V.

Action

Refer to the System Requirements documentation to determine the supported versions of MySQL and upgrade MySQL accordingly.

Affected Versions

This article applies to Appian 18.3 and later.

Last Reviewed: October 2018.