app进入报一个数据库相关问题，刷新首页就有
url： Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #1 of SEL
error：
{
"code": 500,
"message": "\r\n### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'crmeb.eb_store_pink.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by\r\n### The error may exist in com/zbkj/service/dao/StorePinkDao.java (best guess)\r\n### The error may involve defaultParameterMap\r\n### The error occurred while setting parameters\r\n### SQL: SELECT id,uid,order_id,order_id_key,total_num,total_price,cid,pid,people,price,add_time,stop_time,k_id,is_tpl,is_refund,status,nickname,avatar,is_virtual FROM eb_store_pink WHERE (is_refund = ? AND status IN (?,?)) GROUP BY uid ORDER BY id DESC limit 3\r\n### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'crmeb.eb_store_pink.id' 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 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'crmeb.eb_store_pink.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by",
"data": null
}
【产品名称】： JAVA版
【部署方式】 linux
【部署环境】：本地环境 / 线上环境
【Mysql版本】：5.7，docker的
【使用终端】：H5
后台报错信息 ：
### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'crmeb.eb_store_pink.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
### The error may exist in com/zbkj/service/dao/StorePinkDao.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT id,uid,order_id,order_id_key,total_num,total_price,cid,pid,people,price,add_time,stop_time,k_id,is_tpl,is_refund,status,nickname,avatar,is_virtual FROM eb_store_pink WHERE (is_refund = ? AND status IN (?,?)) GROUP BY uid ORDER BY id DESC limit 3
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'crmeb.eb_store_pink.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'crmeb.eb_store_pink.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by]" }
