1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘cdr.mst.etime’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
解决办法:
set sql_mode=‘NO_DIR_IN_CREATE,NO_ENGINE_SUBSTITUTION’
或者 mysql.cnf [mysqld] 下面 增加
sql_mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,NO_DIR_IN_CREATE
重启mysql;