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

SQL API Error in civicrm_group_roles module for Drupal

    Details

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

      Description

      Line 235 of /drupal/modules/civicrm_group_roles/civicrm_group_roles.module has an incorrect usage of the Drupal db_query function. Here is a diff with it corrected:

      235c235
      < $rolecount = db_result(db_query('SELECT count FROM `drup_civicrm_group_roles_rules` WHERE group_id in(%s) AND role_id=%d', $grpsuserin, $rid));

      > $rolecount = db_result(db_query('SELECT count FROM

      {civicrm_group_roles_rules}

      WHERE group_id in(%s) AND role_id=%d', $grpsuserin, $rid));

      Should be self-explanatory--the issue is that the table "drup_civicrm_group_roles_rules" doesn't exist.

        Attachments

          Activity

            People

            • Assignee:
              kurund Kurund Jalmi
              Reporter:
              hershel Hershel Robinson
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 10 minutes
                10m
                Remaining:
                Remaining Estimate - 10 minutes
                10m
                Logged:
                Time Spent - Not Specified
                Not Specified