本地docker启动,在集合和计划执行的时候报错,有没有人遇到过,已经修改过

讨论 1 215
huihui
huihui LV1 2023年10月27日 15:44 发表
<ol role="group" style="min-width: 0px; min-height: 0px; list-style-type: none; padding-left: 12px; color: rgb(32, 33, 36); font-family: consolas, &quot;lucida console&quot;, &quot;courier new&quot;, monospace; font-size: 12px; white-space-collapse: preserve;"><li role="treeitem" tabindex="0" aria-selected="true" style="min-width: 0px; min-height: 16px; outline-width: 0px; text-overflow: ellipsis; white-space: nowrap; position: relative; display: flex; align-items: center; user-select: text;"><span style="min-width: 0px; min-height: 0px; overflow: hidden; line-height: 16px; display: flex;"><span title=" ### Error querying database. Cause: java.sql.SQLSyntaxErrorException: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'liuma.c.type'; this is incompatible with sql_mode=only_full_group_by ### The error may exist in com/autotest/LiuMa/database/mapper/CollectionCaseMapper.xml ### The error may involve com.autotest.LiuMa.database.mapper.CollectionCaseMapper.getCollectionCaseCountByType-Inline ### The error occurred while setting parameters ### SQL: select c.`type` as type, count(*) as count from collection_case cc left join `case` c on c.id=cc.case_id where cc.collection_id = ? ### Cause: java.sql.SQLSyntaxErrorException: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'liuma.c.type'; this is incompatible with sql_mode=only_full_group_by ; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'liuma.c.type'; this is incompatible with sql_mode=only_full_group_by" style="min-width: 0px; min-height: 0px; white-space-collapse: preserve; unicode-bidi: -webkit-isolate; color: var(--color-syntax-1);"><p>{<br> "status": 5000,<br> "message": "未知错误",<br> "data": "\n### Error querying database. Cause: java.sql.SQLSyntaxErrorException: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'liuma.c.type'; this is incompatible with sql_mode=only_full_group_by\n### The error may exist in com/autotest/LiuMa/database/mapper/PlanCollectionMapper.xml\n### The error may involve com.autotest.LiuMa.database.mapper.PlanCollectionMapper.getPlanCaseCountByType-Inline\n### The error occurred while setting parameters\n### SQL: select c.`type` as type, count(cc.id) as count from collection_case cc left join `case` c on c.id=cc.case_id left join plan_collection pc on pc.collection_id = cc.collection_id where pc.plan_id = ?\n### Cause: java.sql.SQLSyntaxErrorException: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'liuma.c.type'; this is incompatible with sql_mode=only_full_group_by\n; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'liuma.c.type'; this is incompatible with sql_mode=only_full_group_by"<br>}</p></span></span></li><li role="treeitem" tabindex="0" aria-selected="true" style="min-width: 0px; min-height: 16px; outline-width: 0px; text-overflow: ellipsis; white-space: nowrap; position: relative; display: flex; align-items: center; user-select: text;"><p><br></p></li></ol>
收藏(0)  分享
相关标签: 讨论 mysql
注意:本文归作者所有,未经作者允许,不得转载
1个回复
  • Chras-fu
    2023年10月27日 22:03
    从报错来看是你的数据库only_full_group_by并没有去掉导致的sql不兼容。检查一下你的sql配置,修改后是否生效了
    0 0