app一進(jìn)入就報(bào)一個(gè)數(shù)據(jù)庫相關(guān)問題，刷新首頁就有

管理

編輯

刪除

sp Java單商戶 v 2.0 2024-03-19 00:11:47

其他

app進(jìn)入報(bào)一個(gè)數(shù)據(jù)庫相關(guān)問題，刷新首頁就有

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

}

【產(chǎn)品名稱】： JAVA版

【部署方式】 linux

【部署環(huán)境】：本地環(huán)境 / 線上環(huán)境

【Mysql版本】：5.7，docker的

【使用終端】：H5

后臺報(bào)錯(cuò)信息 ：

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