SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column

错误信息：

SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column cms_edit_log.real_name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

错误解决：

修改/etc/my.cnf在[mysqld]下面添加如下列：

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES