app一进入就报一个数据库相关问题，刷新首页就有

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]" }