Contrib.social

SELECT list is not in GROUP BY clause and contains nonaggregated column

Open on Drupal.org →
Created on 31 January 2023, about 2 years ago

Problem/Motivation

Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column

Proposed resolution

Add non-static expressions to group by clause.

🐛 Bug report
Status

Fixed

Version

1.1

Component

Code

Created by

🇺🇸United States robphillips

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

contrib.social Blog FAQ Discussions
Production build 0.71.5 2024