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

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

maikeru’s picture

mkinnan’s picture

Thanks for this patch! It worked perfectly. It should be rolled into OG module.

kenorb’s picture

Status: Active » Needs review
scott.whittaker’s picture

Patch works for us too

somersoft’s picture

Patch works for me too.

scott.whittaker’s picture

Status: Needs review » Reviewed & tested by the community