Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.I get this error whenever I go onto the group front page. This only occurs when I have activated the block "Group events".
user warning: Not unique table/alias: 'n' query: SELECT DISTINCT(e.nid) FROM event e INNER JOIN node n ON n.nid = e.nid LEFT JOIN node n ON e.nid = n.nid INNER JOIN node_access na ON na.nid = e.nid INNER JOIN og_ancestry oga ON n.nid = oga.nid WHERE ((n.moderate != 1 OR n.uid = 4)) AND (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'og_public') OR (na.gid = 50 AND na.realm = 'og_subscriber') OR (na.gid = 13 AND na.realm = 'og_subscriber') OR (na.gid = 7 AND na.realm = 'og_subscriber'))) AND (oga.group_nid = 50) AND ( e.event_start >= 1194134712 ) ORDER BY e.event_start in /home/crimson/public_html/includes/database.mysql.inc on line 163.
Other OG modules: OG Forums, OG User Roles
Comments
Comment #1
darren ohYour "LEFT JOIN node n" uses the same alias as "INNER JOIN node n". Have you modified the code? I don't see a LEFT JOIN anywhere in my code.
Comment #2
darren ohFixed in CVS commit 115001.
Comment #3
Anonymous (not verified) commentedAutomatically closed -- issue fixed for two weeks with no activity.