{
"status": 400,
"timestamp": "2021-02-14 23:31:09",
"message": "\n### Error querying database. Cause: java.sql.SQLSyntaxErrorException: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'yshop.yx_store_order.add_time' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by\n### The error may exist in co/yixiang/modules/shop/service/mapper/StoreOrderMapper.java (best guess)\n### The error may involve co.yixiang.modules.shop.service.mapper.StoreOrderMapper.chartList-Inline\n### The error occurred while setting parameters\n### SQL: SELECT IFNULL(sum(pay_price),0) as num,FROM_UNIXTIME(add_time, '%m-%d') as time FROM yx_store_order where refund_status=0 and is_del=0 and paid=1 and pay_time >= 1612108800 GROUP BY FROM_UNIXTIME(add_time,'%Y-%m-%d') ORDER BY add_time ASC\n### Cause: java.sql.SQLSyntaxErrorException: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'yshop.yx_store_order.add_time' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by\n; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'yshop.yx_store_order.add_time' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by"
}
解决方法如下,/etc/my.cnf 配置文件末尾添加如下配置
sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'
千万不要用百度中csdn第一篇,对于8.0.18的mysql会报错的