so I rolled out that braintree patch & I think the one I was looking at cleared but I have a new one...

If we retrieved Pending using sql that prioritises the correct one it looks like

OK - looking at it the error happened in the Smashpig processing from the IPN

@Cstone just fyi - I think you are looking at others like this - but this was a bit earlier

upstream https://lab.civicrm.org/dev/core/-/issues/6229

More serious repetition is this one - this function used to be cached CRM_Core_OptionValue::getValues()

echo '{"criteria":{"where":[["modified_date","BETWEEN",["2025-12-01 20:29:41","2025-12-01 21:29:41"]]]},"search_limit":0}' | wmf-cv -vv --in=json api Job.process_batch_merge
Entity: Job
Action: process_batch_merge
Params: {

"version": 3,
"criteria": {
    "where": [
        [
            "modified_date",
            "BETWEEN",
            [
                "2025-12-01 20:29:41",
                "2025-12-01 21:29:41"
            ]
        ]
    ]
},
"search_limit": 0,
"debug": 1

}
[PHP Warning] Undefined array key "fields" at /srv/org.wikimedia.civicrm/ext/deduper/CRM/Deduper/BAO/MergeHandler.php:817

I'm having trouble determining the dedupe pair in question - I think it's cached in the prevnext table - I've put up a patch to try to output the pair being merged before the attempt starts to get the contact ID. I need to also check when the table is flushed....

We should fix on ingress but I'm also looking at handling the merges in deduper

Just some more data points - basically the gravy ID in the braintree log has 0% cross over with the gravy ID in the transaction log & they don't give us our contribution_tracking_id back...

MariaDB [civicrm]> select * FROM damaged_view WHERE message LIKE '%4dKvU4tsIv5DZRxK4jYbib%'\G
Empty set (0.728 sec)

MariaDB [civicrm]> select * FROM civicrm_transaction_log WHERE message LIKE '%4dKvU4tsIv5DZRxK4jYbib%'\G
Empty set (59.709 sec)

@Cstone is this a case where gravy has 'stolen' our contribution_tracking_id field?
settlement_batch_report_2025-11-20.json

https://civicrm.wikimedia.org/civicrm/search#/display/Monolog%20configuration/Monologs is the config

This appears to be working OK now & around 600 contacts have merged since I rolled it out an hour ago.

We should probably create an activity for these - I guess we just need to decide what the activity type should be

Sorry - that was a manual test run I did - I didn't think about everyone else seeing the failmail

Replacement opt out job https://cloud.goacoustic.com/campaign-automation/Data/Data_jobs?cuiOverrideSrc=https%253A%252F%252Fcampaign-us-4.goacoustic.com%252FdataJobs.do%253FisShellUser%253D1%2526action%253DdataJobsDetail%2526triggerId%253D253751434

Full link to MSL upload https://cloud.goacoustic.com/campaign-automation/Data/Data_jobs?cuiOverrideSrc=https%253A%252F%252Fcampaign-us-4.goacoustic.com%252FdataJobs.do%253FisShellUser%253D1%2526action%253DdataJobsDetail%2526triggerId%253D253751401

I pushed out the fixes & ran the new job - it was OK for the Checksum but for the opt out the action was missing - resulting in it doing the default create+update action

If you have a list is should be possible to import them.... over at https://civicrm.wikimedia.org/civicrm/import/option_value - although it looks like we need to expose more fields to import

I went back the write up I did last year https://docs.google.com/document/d/1oMBOy4buw_8BR9Hs1Nj5WsVo5pu53fifqcDEBYK2b4A/edit?usp=sharing - we did a bunch of mitigations but the scenario described ^^ is the one we didn't have a mitigation for - although I speculated on a couple of things we might investigate

I have not yet tested it but I believe this https://gerrit.wikimedia.org/r/c/wikimedia/fundraising/tools/+/1208155 would cause consented contacts to have their details pushed in

Thanks @EWilfong_WMF - I think that is the case for all of them - 6k - seems like a reasonable number for that to have affected? The problem is I'm not sure how to clean them up

Number 2 - an email only donor

During our call we found a contact who has

• a phone
• an email
• no segment

https://civicrm.wikimedia.org/civicrm/admin/search#/create/PhoneConsent?params=%7B%22version%22:4,%22select%22:%5B%22PhoneConsent_Phone_phone_number_01_Phone_Contact_contact_id_01.wmf_donor.donor_segment_id:label%22,%22COUNT(id)%20AS%20COUNT_id%22%5D,%22orderBy%22:%7B%7D,%22where%22:%5B%5D,%22groupBy%22:%5B%22PhoneConsent_Phone_phone_number_01_Phone_Contact_contact_id_01.wmf_donor.donor_segment_id%22%5D,%22join%22:%5B%5B%22Phone%20AS%20PhoneConsent_Phone_phone_number_01%22,%22INNER%22,%5B%22phone_number%22,%22%3D%22,%22PhoneConsent_Phone_phone_number_01.phone_numeric%22%5D%5D,%5B%22Contact%20AS%20PhoneConsent_Phone_phone_number_01_Phone_Contact_contact_id_01%22,%22INNER%22,%5B%22PhoneConsent_Phone_phone_number_01.contact_id%22,%22%3D%22,%22PhoneConsent_Phone_phone_number_01_Phone_Contact_contact_id_01.id%22%5D%5D%5D,%22having%22:%5B%5D%7D

https://civicrm.wikimedia.org/civicrm/admin/search#/create/PhoneConsent?params=%7B%22version%22:4,%22select%22:%5B%22PhoneConsent_Phone_phone_number_01_Phone_Contact_contact_id_01.wmf_donor.donor_status_id:label%22,%22PhoneConsent_Phone_phone_number_01_Phone_Contact_contact_id_01.wmf_donor.donor_segment_id:label%22,%22COUNT(id)%20AS%20COUNT_id%22%5D,%22orderBy%22:%7B%7D,%22where%22:%5B%5D,%22groupBy%22:%5B%22PhoneConsent_Phone_phone_number_01_Phone_Contact_contact_id_01.wmf_donor.donor_segment_id%22,%22PhoneConsent_Phone_phone_number_01_Phone_Contact_contact_id_01.wmf_donor.donor_status_id%22%5D,%22join%22:%5B%5B%22Phone%20AS%20PhoneConsent_Phone_phone_number_01%22,%22INNER%22,%5B%22phone_number%22,%22%3D%22,%22PhoneConsent_Phone_phone_number_01.phone_numeric%22%5D%5D,%5B%22Contact%20AS%20PhoneConsent_Phone_phone_number_01_Phone_Contact_contact_id_01%22,%22INNER%22,%5B%22PhoneConsent_Phone_phone_number_01.contact_id%22,%22%3D%22,%22PhoneConsent_Phone_phone_number_01_Phone_Contact_contact_id_01.id%22%5D%5D%5D,%22having%22:%5B%5D%7D

@JMando I just pushed up https://gerrit.wikimedia.org/r/c/wikimedia/fundraising/crm/+/1207234 to consider _dsk_ before mob

Confirmed all 4 are paypal

Seems the issue was I mis-tagged the release.... @Ejegg is fixing

One the patch currently in review has gone out I will ask Joseph to review with regards to

I've moved this to Done just because I'm swapping out the old 'do everything' phabs for the more specific 'tasks still to be done' - I opened a separate one for getting major gifts flagged correctly which I'll look at once all the channels are assigned