Early Bird Registration for DrupalCon Portland 2024 is open! Register by 23:59 PST on 31 March 2024, to get $100 off your ticket.
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