讨论 使用交流 题库搜素和题库标签均出现500,其他正常

题库搜素和题库标签均出现500,其他正常

mywuxin 发表于    阅读:145    回复:4

问题描述:

题库搜素和题库标签均出现500,其他正常


[2024-01-04 08:29:50] product.ERROR: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'lztkcp.tkquestion_tag_map.tagId' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (SQL: select count(*) as aggregate from `tkquestion` where (`isOpen` = 1 and `parentId` = 0) and (`catId` = 1) and id IN ( SELECT t.questionId AS id FROM (

SELECT questionId,tagId FROM tkquestion_tag_map

WHERE questionId IN (

    SELECT questionId FROM tkquestion_tag_map

    WHERE tagId IN (2)

    GROUP BY questionId

)

环境信息:

PHP版本、系统版本、模块版本等

复现步骤:

1

2

3

建议与意见:

1

2

3

评论

数据库是什么版本?

 

QQ联系看一下

 

@ModStart: QQ已加,麻烦通过下

 
1
我来评论
QQ
微信