Error Code: 1055 incompatible with sql_mode=only_full_group_by

2024-08-30 01:07:37

OperationalError at /

(1055, "Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'forum.forum_topic.reply_count' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by")

登录mysql

set global sql_mode = 'STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';

https://stackoverflow.com/questions/36207042/error-code-1055-incompatible-with-sql-mode-only-full-group-by

最新文章

热门文章