Hi,
I've just installed Simple access module. It looked simple and perfecly fitted for the job it does, but I got an unexpeced portal error.
What I did:
1. I created an access group X with some roles included.
2. I created a new content type and allowed viewing/updating of such content by members of group X.
3. I also allowed viewing/updating of another content type (that existed before installing simple access module) by members of group X.
4. I created (as an administrator) nodes of those content types.

In effect, members of group X can view nodes of the mentioned type, but when I click the 'Edit' button of such node, I get Error page:
"PDOException: SQLSTATE[42702]: Ambiguous column: 7 ERROR: column reference "gid" is ambiguous LINE 6: GROUP BY gid ^: SELECT g.gid AS gid FROM {simple_access_groups} g INNER JOIN {simple_access_roles} r ON g.gid = r.gid WHERE (rid IN (:db_condition_placeholder_0, :db_condition_placeholder_1, :db_condition_placeholder_2, :db_condition_placeholder_3)) GROUP BY gid; Array ( [:db_condition_placeholder_0] => 2 [:db_condition_placeholder_1] => 4 [:db_condition_placeholder_2] => 5 [:db_condition_placeholder_3] => 6 ) in simple_access_group_select() (line 670 of /var/www/html/portal/sites/all/modules/simple_access/simple_access.module)."

Fortunately admin can edit and delete the nodes of those content types without any problems.
What's wrong?

Comments

kvolo’s picture

Issue summary: View changes
Atomico’s picture

don't know if it is a fix or what but if you select this option you haven't the error anymore

http://i.imgur.com/aRrsE7h.png