Connection to MySQL Database Fails with 'You have an error in your SQL syntax' Error
Symptoms
While trying to migrate to MySQL database, upon clicking on the "Test Connection" button, the following error is reported on screen:
Couldn't connect to database: 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 'where variable_name = 'collation_database'' at line 1. See logs for details.
Cause
Fisheye is being run with an unsupported version of MySQL - in this case 4.1.20.
Resolution
Refer to the supported platforms guide and upgrade MySQL to a supported version.
Last modified on Nov 2, 2018
Powered by Confluence and Scroll Viewport.