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
 - 
    Labels:
 
- 
        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.