this is incompatible with sql_mode=only_full_group_by

问题

this is incompatible with sql_mode=only_full_group_by

验证

select @@global.sql_mode;

解决

[mysqld]
...
sql_mode=""
#sql_mode = "STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

上面的两个方法都可以