PDOException: SQLSTATE[42000]: [Microsoft][SQL Server Native Client 11.0][SQL Server]Column 'groups.title' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.: SELECT TOP(25) g.[gid] AS [gid], COUNT(distinct gm.uid) AS members, title AS _field_0, g.gid AS _field_1 FROM {groups} g LEFT OUTER JOIN {group_membership} gm ON g.gid=gm.gid GROUP BY g.gid ORDER BY title ASC; Array ( ) in PagerDefault->execute() (line 79 of C:\Users\erorenf\Documents\My Web Sites\CancellationApprovalApp\includes\pager.inc).

CommentFileSizeAuthor
#2 group-overview-sqlserver-2416067-2.patch409 bytesdabblela
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

kristiaanvandeneynde’s picture

kristiaanvandeneynde
Primary language Dutch
Location Antwerp, Belgium
CreditAttribution: kristiaanvandeneynde commented

Hi there!

This is a standard SQL error for when you are using a GROUP BY query but some field isn't being aggregated. In this case "groups.title". Could you perhaps tell me where the query is from?

Is it a View, if so which set-up? A query you wrote yourself? ...?

dabblela’s picture

dabblela CreditAttribution: dabblela commented
Assigned: trinin » Unassigned
Status: Active » Needs review
FileSize
group-overview-sqlserver-2416067-2.patch409 bytes

A little more context: This is an error generated by SQL Server when visiting the group overview page. Patch attached.

Prashant.c’s picture

Prashant.c
he/him
Primary language English
Location Dharamshala
CreditAttribution: Prashant.c as a volunteer and at gai Technologies Pvt Ltd for gai Technologies Pvt Ltd commented

Can you please let us know following :

1. Which version of the module are you using ?
2. How can we replicate the issue ?

Because iam also using the 7.x version and not facing any issues on groups overview page i.e. admin/group .

Soul88’s picture

Soul88
Primary language Ukrainian
Location Ukraine
CreditAttribution: Soul88 commented
Status: Needs review » Closed (outdated)

We thank everyone for their collaboration on this issue, but as the D7 version is no longer supported, we will now close all D7 issues to keep the issue queue a bit tidier. This information won't go anywhere, it just won't show up on the list of open issues anymore.

Please see: https://www.drupal.org/project/group/issues/3163655 and https://www.drupal.org/project/group/issues/3203863#comment-14100281 for more details.