Page MenuHomePhabricator

Write a script to generate fail mail when integrity checks fail
Open, Needs TriagePublic4 Estimated Story Points


We have some integrity checks we have written but not mechanism to run them & ensure they stay clean - e.g send fail-mail if there are contacts with no primary address or blank location types

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptNov 9 2016, 11:45 PM
Eileenmcnaughton set the point value for this task to 4.

Basically 'no information' contacts

select * from civicrm_contact c  LEFT JOIN civicrm_contribution con ON = con.contact_id  LEFT JOIN civicrm_contribution_soft s ON s.contact_id =  LEFT JOIN civicrm_relationship r ON r.contact_id_a  =  LEFT JOIN civicrm_relationship r2 ON r2.contact_id_b  =  LEFT JOIN civicrm_group_contact gc ON gc.contact_id = AND gc.group_id =173 LEFT JOIN civicrm_value_1_prospect_5 v ON v.entity_id = WHERE IS NULL AND IS NULL AND  is_deleted = 0  AND IS NULL AND IS NULL  AND IS NULL AND IS NULL ORDER BY DESC LIMIT 5000

Note we should schedule the check from when we hit this

Eileenmcnaughton renamed this task from Write some integrity check scripts to Write a script to generate fail mail when integrity checks fail.Mar 28 2019, 3:36 AM
Eileenmcnaughton updated the task description. (Show Details)
Aklapper removed Eileenmcnaughton as the assignee of this task.Jun 19 2020, 4:15 PM

This task has been assigned to the same task owner for more than two years. Resetting task assignee due to inactivity, to decrease task cookie-licking and to get a slightly more realistic overview of plans. Please feel free to assign this task to yourself again if you still realistically work or plan to work on this task - it would be welcome!

For tips how to manage individual work in Phabricator (noisy notifications, lists of task, etc.), see for available options.
(For the records, two emails were sent to assignee addresses before resetting assignees. See T228575 for more info and for potential feedback. Thanks!)