user warning on og/users/X
>>> [!note] Migrated issue
<!-- Drupal.org comment -->
<!-- Migrated from issue #417126. -->
Reported by: [scottrigby](https://www.drupal.org/user/145945)
>>>
<p>When visiting a group's members link (og/users/GID) I get the following errors: </p>
<pre> * 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.<br> * 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.</pre><p>I'm using Organic groups HEAD (2009-Mar-27) with D6.10. Would more info about my installation be helpful?</p>
issue