Connection to MySQL Database Fails with 'You have an error in your SQL syntax' Error
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.
Fisheye is being run with an unsupported version of MySQL - in this case 4.1.20.
Refer to the supported platforms guide and upgrade MySQL to a supported version.