Advertisement
Guest User

CiviCRM ACL causes MySQL to crash

a guest
Oct 8th, 2012
46
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 4.08 KB | None | 0 0
  1. SELECT SQL_CALC_FOUND_ROWS contact_civireport.sort_name AS civicrm_contact_contact_source,
  2.         GROUP_CONCAT(DISTINCT civicrm_contact_assignee.sort_name  ORDER BY activity_assignment_civireport.assignee_contact_id SEPARATOR '^A') AS civicrm_contact_contact_a
  3. ssignee,
  4.         GROUP_CONCAT(DISTINCT civicrm_contact_target.sort_name  ORDER BY activity_target_civireport.target_contact_id SEPARATOR '^A') AS civicrm_contact_contact_target,
  5.         activity_civireport.id AS civicrm_activity_id, activity_civireport.source_record_id AS civicrm_activity_source_record_id,
  6.         activity_civireport.activity_type_id AS civicrm_activity_activity_type_id, activity_civireport.subject AS civicrm_activity_activity_subject,
  7.         activity_civireport.source_contact_id AS civicrm_activity_source_contact_id, activity_civireport.activity_date_time AS civicrm_activity_activity_date_time,
  8.         activity_civireport.status_id AS civicrm_activity_status_id,
  9.         GROUP_CONCAT(DISTINCT activity_assignment_civireport.assignee_contact_id  ORDER BY activity_assignment_civireport.assignee_contact_id SEPARATOR '^A') AS civicrm_activity_assignment_assignee_contact_id,
  10.         GROUP_CONCAT(DISTINCT activity_target_civireport.target_contact_id  ORDER BY activity_target_civireport.target_contact_id SEPARATOR '^A') AS civicrm_activity_target_target_contact_id,
  11.         case_activity_civireport.case_id AS civicrm_case_activity_case_id
  12. FROM civicrm_activity activity_civireport
  13.  
  14. LEFT JOIN civicrm_activity_target  activity_target_civireport
  15.     ON activity_civireport.id = activity_target_civireport.activity_id
  16. LEFT JOIN civicrm_activity_assignment activity_assignment_civireport
  17.     ON activity_civireport.id = activity_assignment_civireport.activity_id
  18. LEFT JOIN civicrm_contact contact_civireport
  19.     ON activity_civireport.source_contact_id = contact_civireport.id
  20. LEFT JOIN civicrm_contact civicrm_contact_target
  21.     ON activity_target_civireport.target_contact_id = civicrm_contact_target.id
  22. LEFT JOIN civicrm_contact civicrm_contact_assignee
  23.     ON activity_assignment_civireport.assignee_contact_id = civicrm_contact_assignee.id
  24.  
  25. INNER JOIN civicrm_acl_contact_cache aclContactCache_0 ON
  26.   ( contact_civireport.id = aclContactCache_0.contact_id OR contact_civireport.id IS NULL )
  27.     AND aclContactCache_0.user_id = 1332
  28.  
  29.  
  30. /* xxxxxxxxxxxxxxxxxxxxxx If the following 2 INNER JOINS are commented, the query xxxxxxxxxxxxx
  31.    xxxxxxxxxxxxxxxxxxxxxx does not crash the MySQL server. If either are left in  xxxxxxxxxxxxx
  32.    xxxxxxxxxxxxxxxxxxxxxx a crash will occur.                                     xxxxxxxxxxxxx
  33. */
  34.   INNER JOIN civicrm_acl_contact_cache aclContactCache_1 ON ( civicrm_contact_target.id = aclContactCache_1.contact_id OR civicrm_contact_target.id IS NULL )
  35.     AND aclContactCache_1.user_id = 1332
  36. INNER JOIN civicrm_acl_contact_cache aclContactCache_2 ON ( civicrm_contact_assignee.id = aclContactCache_2.contact_id OR civicrm_contact_assignee.id IS NULL )
  37.     AND aclContactCache_2.user_id = 1332
  38.  
  39. /* xxxxxxxxxxxxxxxxxxxxxx */
  40.  
  41. LEFT JOIN civicrm_option_value
  42.     ON ( activity_civireport.activity_type_id = civicrm_option_value.VALUE )
  43. LEFT JOIN civicrm_option_group
  44.     ON civicrm_option_group.id = civicrm_option_value.option_group_id
  45. LEFT JOIN civicrm_case_activity case_activity_civireport
  46.     ON case_activity_civireport.activity_id = activity_civireport.id
  47. LEFT JOIN civicrm_case
  48.     ON case_activity_civireport.case_id = civicrm_case.id
  49. LEFT JOIN civicrm_case_contact
  50.     ON civicrm_case_contact.case_id = civicrm_case.id
  51. WHERE civicrm_option_group.name = 'activity_type' AND
  52.                 activity_civireport.is_test = 0 AND
  53.                 activity_civireport.is_deleted = 0 AND
  54.                 activity_civireport.is_current_revision = 1 AND ( contact_civireport.id = 1332 OR civicrm_contact_assignee.id = 1332 OR civicrm_contact_target.id = 1332 ) AND ( activity_date_time >= 20121001000000 ) AND ( activity_date_time <= 20121031235959 ) AND ( activity_civireport.activity_type_id IN (28, 29) ) GROUP BY activity_civireport.id  ORDER BY activity_civireport.source_contact_id ASC  LIMIT 0, 50
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement