請(qǐng)?jiān)诖嗽敿?xì)描述你所遇到的問(wèn)題
【產(chǎn)品名稱(chēng)】:JAVA版多商戶(hù)
【產(chǎn)品版本】:例:v1.4
【部署方式】:例: linux寶塔面板
【部署環(huán)境】:例:本地環(huán)境 &線上環(huán)境
【Mysql版本】:例:5.7
【使用終端】:例:后臺(tái)
報(bào)錯(cuò)接口admin/platform/finance/merchant/closing/config
報(bào)錯(cuò)信息
### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'java_mer_dev.eb_system_config.value' 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/SystemConfigDao.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT name,value FROM eb_system_config WHERE (name IN (?,?,?,?,?) AND status = ?) GROUP BY name ORDER BY id DESC
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'java_mer_dev.eb_system_config.value' 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 #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'java_mer_dev.eb_system_config.value' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by