Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-857

sql error recieved when searching as a user with view privileges on a specific group with default search criteria


    • Type: Bug
    • Status: Done/Fixed
    • Priority: Minor
    • Resolution: Fixed/Completed
    • Affects Version/s: 1.4
    • Fix Version/s: None
    • Labels:


      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
      "unrecoverable error
      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.




            • Assignee:
              lobo Donald A. Lobo
              jiradougt Doug Tangren
            • Votes:
              0 Vote for this issue
              0 Start watching this issue


              • Created: