解决报错:sql_mode=only_full_group_by

{
  "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会报错的