Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.Unable to edit node after upgrading to 7.x-1.0-beta 1:
PDOException: SQLSTATE[42803]: Grouping error: 7 ERROR: column "td.name" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT td.tid AS tid, td.name AS name, COUNT(tn.tid) AS coun... ^: SELECT td.tid AS tid, td.name AS name, COUNT(tn.tid) AS count FROM {taxonomy_term_data} td INNER JOIN {taxonomy_vocabulary} tv ON tv.vid = td.vid LEFT OUTER JOIN {taxonomy_index} tn ON tn.tid = td.tid WHERE (tv.machine_name = :db_condition_placeholder_0) GROUP BY td.tid ORDER BY count DESC, name ASC; Array ( [:db_condition_placeholder_0] => meal_types ) v _popular_tags_get_terms() (line 92 from /data/b/o/example.com/web/sites/all/modules/popular-tags/popular_tags.widget.inc).
Comments
Comment #1
jitesh doshi commentedSorry to see this break for you.
Unfortunately, I'm not able to reproduce the problem. Can you send your settings for the content-type field-instance? Basically, I need all the settings under "Popular Tags" fieldset on "admin/structure/types/manage/article/fields/field_tags" page (in this example, I'm using content-type=article and field=field_tags, but your situation might be different).
Comment #2
xado commentedI have just checked "Use Clickable Popular Tags?" under "Popular tags" fieldset on "admin/structure/types/manage/recipe/fields/field_tags"
and "Limit": empty
db: postgresql 9.0
rollback to popular-tags 7.x-1.0-alpha2 works as expected
Comment #3
xado commentedComment #5
jitesh doshi commentedI have committed and pushed a fix to Git (on the main 7.x-1.x branch). @xado, please test that the issue is resolved. I'm itching to create 1.0 release.
Comment #6
jitesh doshi commentedThis was fixed long time back with 7.x-1.0 release.