CiviCRM Community Forums (archive)

We note that when we launch an activity report with a user that uses ACLs rules, the activity report fails with no response.

If we look into the database we can found the query with the status "Copying to tmp table" and the query never ends. The problem appears in the function buildACLClause() in the /CRM/Report/Form/Activity.php file. The function adds to the final query three inner joins with a suspicious IS NULL comparation.

Then, the code added for the buildACLClause()

INNER JOIN civicrm_acl_contact_cache aclContactCache_0 ON ( civicrm_contact_source.id = aclContactCache_0.contact_id OR civicrm_contact_source.id IS NULL ) AND aclContactCache_0.user_id = 721
INNER JOIN civicrm_acl_contact_cache aclContactCache_1 ON ( contact_civireport.id = aclContactCache_1.contact_id OR contact_civireport.id IS NULL ) AND aclContactCache_1.user_id = 721
INNER JOIN civicrm_acl_contact_cache aclContactCache_2 ON ( civicrm_contact_assignee.id = aclContactCache_2.contact_id OR civicrm_contact_assignee.id IS NULL ) AND aclContactCache_2.user_id = 721

If we launch the query with only one of any of the three inner joins the query ends successfully. But when two or three of the inner joins are launched the query hangs. I think I lack knowledge of MySQL from there to see what is happening.

Someone can reproduce this issue? Someone with good skills of MySQL can check if this triple inner join query has any problem?

Thanks Eileen! I upgraded from 4.3.4 to 4.4.5 and it works!

Anyway, I had to apply the following patch: https://github.com/civicrm/civicrm-core/pull/2530/files.