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

Contribution Summary Report doesn't work when an ACL is in place

          Details

          • Type: Bug
          • Status: Done/Fixed
          • Priority: Minor
          • Resolution: Fixed/Completed
          • Affects Version/s: 4.5.5
          • Fix Version/s: 4.6
          • Component/s: CiviContribute
          • Labels:
            None
          • Documentation Required?:
            None

            Description

            Can't be replicated on demo, but I replicated on HEAD just now. To replicate:

            • Create a user without "View All Contacts" or "Edit All Contacts" permission.
            • (Try to) run the Contribution summary Report.

            You'll get:
            DB Error: no such field
            Database Error Code: Unknown column 'aclContactCache.user_id' in 'where clause', 1054

            Reason being, $this->_aclFrom isn't being added to the "from" clause.

            I'm pretty surprised this hasn't been caught sooner!

            Anyway, I've got a fix in a local repo, I'll push a PR in a few minutes.

              Attachments

                Activity

                  People

                  • Assignee:
                    yashodha Yashodha Chaku
                    Reporter:
                    palantejon Jon K Goldberg
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    1 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: