MySQL 5.7+ Settings

If your database version is MySQL 5.7 or above, you may need to set your sql_mode setting in your my.cnf file (this is called my.ini in Windows).

This is because MySQL changed some of the default functionality of their queries starting at this version.

If you see error messages relating to sql_mode in FlightPath, please undertake the following steps on your server:

 

Edit Configuration File

If you are on a Linux/Unix machine, your my.cnf file is probably located at:

/etc/mysql/my.cnf

Edit this file, and under the [mysqld] section (notice the 'd' at the end), add the following line (or edit the existing one, if already there):

sql_mode = STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

(This should all be on one line, no line breaks or word wrap)

 

Restarting MySQL

After this, you will need to restart your MySQL server, or the entire machine if that is easier.  For Ubuntu 16.x, the restart command is:

sudo service mysql restart