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

Membership detail report error when ACL used

    Details

    • Type: Bug
    • Status: Won't Do
    • Priority: Critical
    • Resolution: Won't Do
    • Affects Version/s: 4.7.31
    • Fix Version/s: None
    • Component/s: CiviMember
    • Versioning Impact:
      Patch (backwards-compatible bug fixes)
    • Documentation Required?:
      Developer Doc
    • Funding Source:
      Needs Funding
    • Verified?:
      No
    • How it works currently:
      When a restricted user accesses the Membership Detail Form, an error is thrown.
    • How it should work:
      When a restricted user accesses the Membership Detail Form, the report should be displayed.

      Description

      The Membership Detail report fails when used by a user which is restricted by an ACL.

      In the SQL statement an INNER JOIN is duplicated on aclContactCache, which causes a multiple table/alias problem.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              edvanleeuwen Ed van Leeuwen
            • Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: