...
The following SQL Mode must not be set: ONLY_FULL_GROUP_BY, NO_ZERO_IN_DATE, NO_ZERO_DATE, STRICT_TRANS_TABLES
Executing the following command in mysql lists the current SQL modes:
SHOW VARIABLES WHERE Variable_name = 'sql_mode';To achieve this, you can add / change the following setting to your mysql configuration file:
...