laravel group by 42000 错误解决方法

最新推荐文章于 2024-01-17 09:26:17 发布

原创最新推荐文章于 2024-01-17 09:26:17 发布 · 685 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#Laravel 42000

MySql 专栏收录该内容

1 篇文章

订阅专栏

本文详细描述了在Laravel框架中遇到SQLSTATE[42000]语法错误或访问违规的情况，特别是在使用GROUP BY子句时。错误发生在尝试从多个表中选择未在GROUP BY子句中出现的非聚合列。文中提供了在config/database.php文件中修改'strict'参数值的方法，将其从true更改为false，以此解决only_full_group_by问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

错误代码:

{“msg”:“SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘fanqiepp_api_test.interest_order.truetotal’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (SQL: SELECT member.id,member.username,interest_order.truetotal,sum(interest_order.truetotal) as total_count FROM member INNER JOIN interest_member_relation ON member.id = interest_member_relation.thr_member_id INNER JOIN interest_order ON interest_member_relation.member_id = interest_order.member_id WHERE member.remark IS NULL AND member.level = 3 GROUP BY member.id ORDER BY total_count desc)”,“code”:500}