FAQ - MySQL 5.7 - Strict Mode

FAQ - MySQL 5.7 - Strict Mode

07.03.2017 153


With the release of MySQL 5.7 strict mode has been added by standard, that will break certain queries in CMS and HelpDesk.

You will need to change the mode back to what it was in 5.6.

IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

Within the next updates we will make sure that CMS and the new HelpDesk 3 is compatible with the new standard modes from MySQL 5.7.