When visiting a group's members link (og/users/GID) I get the following errors: 

    * user warning: Column 'uid' in field list is ambiguous query: SELECT COUNT(*) FROM (SELECT uid FROM users users LEFT JOIN og_uid og_uid ON users.uid = og_uid.uid LEFT JOIN node node_og_uid ON og_uid.nid = node_og_uid.nid WHERE (users.status <> 0) AND (og_uid.nid = 6) ) count_alias in /Applications/MAMP/htdocs/MYSITE/sites/all/modules/views/includes/view.inc on line 705.
    * user warning: Column 'uid' in field list is ambiguous query: SELECT uid, users.name AS users_name, og_uid.is_active AS og_uid_is_active, og_uid.uid AS og_uid_uid, og_uid.nid AS og_uid_nid, og_uid.is_admin AS og_uid_is_admin FROM users users LEFT JOIN og_uid og_uid ON users.uid = og_uid.uid LEFT JOIN node node_og_uid ON og_uid.nid = node_og_uid.nid WHERE (users.status <> 0) AND (og_uid.nid = 6) ORDER BY og_uid_is_admin DESC, og_uid_is_active ASC, users_name ASC LIMIT 0, 90 in /Applications/MAMP/htdocs/MYSITE/sites/all/modules/views/includes/view.inc on line 731.

I'm using Organic groups HEAD (2009-Mar-27) with D6.10. Would more info about my installation be helpful?

Comments

technivant’s picture

technivant commented

I had this same error. When I reverted to Views 6.x-2.3 from 6.x-2.x-dev it disappeared.

TyraelTLK’s picture

TyraelTLK commented

Same problem with Views 6.x-2.4.

RAFA3L’s picture

RAFA3L commented

Same here with Views 6.x-2.4

highvoltage’s picture

highvoltage commented

Same here, latest organic groups and views.

Screenshot of my error:

http://img207.imageshack.us/img207/9651/error03.png

giacomo lozito’s picture

giacomo lozito commented

I can confirm the issue with drupal-6.10, og-6.x-1.2 and views-6.x-2.4, my website uses a PostgreSQL database. The issue doesn't appear with views-6.x-2.3 in combination with other elements.
PostgreSQL won't provide the group user list if that warning is issued (the query will fail).

cletusalphonse’s picture

cletusalphonse commented

Same, Subscribing.

moshe weitzman’s picture

moshe weitzman commented
Status: Active » Fixed

Committed to both new branches - 6--1 and 6--2 branches. HEAD is no longer in use.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

PEpe’s picture

PEpe commented

I have slightly different error message, but solution is same in my opinion:

1) Go to Site building->Views and Edit view named "og_members"
2) Click on field "(Group) Organic groups: OG: Is the group manager"
3) From "Relationship" select list select "Group"
4) Save, save, save
5) go on beer with me :-)

EDIT: upsss, sorry, still not working perfect, I'm going to find something more

un11imig’s picture

un11imig commented

I have the same problem.

un11imig’s picture

un11imig commented

This solves my problem.

Thanks!