Affects Version/s: 1.4
Fix Version/s: None
Component/s: Technical infrastructure
I am using Drupal 4.6.5 with CiviCRM 1.4. I have read your documentation on creating groups and roles to limit access to civicrm member data. I have created a group and a role to view that group giving that role the privileges 'Access CiviCRM', 'profile listings and forms', and 'view contacts in groupName'.
When I search for a given name of a memeber in that group as the user with the privileges to view members in that group I get an accurate listing as long as the second list box listing group names is marked with the correct group. If that list box is left as is being marked '- any group -'. I get a sql error that states
Sorry. A non-recoverable error has occurred.
Database Error Code: Unknown column 'civicrm_group_contact.group_id' in 'where clause', 1054
Return to CiviCRM menu.
As I mentioned above, I searched for a user with the second list box set to the group I had to privilege to view with no problem. When I tried again with the default '
any group' I got the above error. I would think that the group I define would fall under the 'any group' category but something is going awry when the sql statement is being created.