Page MenuHomePhabricator

Updates to Recurring contributions may not make it to Acoustic
Closed, ResolvedPublic

Description

When we upload data to acoustic our dataset is based on contacts modified in a certain time period. This calculation is based on the contact.modified_date which is updated if any of the following are added, deleted or updated

  • contact details
  • address, email, website, phone details
  • contact custom fields
  • contributions (by virtue of them causing wmf_donor update).
  • other things I haven' t confirmed such as adding tags or groups

Absent any other change to the contact a change to the contribution_recur table may not trigger a change to modified date field on the contact & hence may not cause a change to be pushed through.

We can fix this by tweaking 'triggers' on the contribution_recur table

Event Timeline

Change 826683 had a related patch set uploaded (by Ejegg; author: Ejegg):

[wikimedia/fundraising/crm@master] Contribution Recur trigger updates contact modified_date

https://gerrit.wikimedia.org/r/826683

Change 826683 merged by jenkins-bot:

[wikimedia/fundraising/crm@master] Contribution Recur trigger updates contact modified_date

https://gerrit.wikimedia.org/r/826683

Looks like this is all set