Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
As suggested in https://drupal.org/comment/7855179#comment-7855179 Postgres doesn't like the views role filter.
Error when adding filter in views ui:
PDOException: SQLSTATE[42803]: Grouping error: 7 ERROR: column "r.rid" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT r.* ^: SELECT r.* FROM {og_role} r GROUP BY r.name; Array ( ) in og_handler_filter_user_roles->get_value_options() (line 14 of /og/includes/views/handlers/og_handler_filter_user_roles.inc).
The solution suggested to add r.rid to the query seems to work. Patch incoming
Comment | File | Size | Author |
---|---|---|---|
#1 | og-postgres-role-filter-2189821-1.patch | 614 bytes | maikeru |
|
Comments
Comment #1
maikeru CreditAttribution: maikeru commentedAttaching patch
Comment #2
mkinnan CreditAttribution: mkinnan commentedThanks for this patch! It worked perfectly. It should be rolled into OG module.
Comment #3
kenorb CreditAttribution: kenorb commentedComment #4
scott.whittaker CreditAttribution: scott.whittaker as a volunteer commentedPatch works for us too
Comment #5
somersoft CreditAttribution: somersoft commentedPatch works for me too.
Comment #6
scott.whittaker CreditAttribution: scott.whittaker as a volunteer commented