FAQ - MySQL 5.7 - Strict Mode

MySQL 5.7 - Strict Mode

07.03.2017 2844

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.

sql-mode strict-mode mode strict mysql

---

Like