[01:33:41] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Disable/delete old contribution_tracking module - https://phabricator.wikimedia.org/T354708 (10Eileenmcnaughton) @Pcoombe the values are ` select v.value,v.label FROM civicrm_option_value v INNER JOIN civicrm_option_group g ON g.id = v.option_group_id W... [01:52:19] (03CR) 10Cstone: [C: 03+2] "thanks for this, looks good!" [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/992790 (https://phabricator.wikimedia.org/T351689) (owner: 10Damilare Adedoyin) [01:54:12] (03Merged) 10jenkins-bot: Send iOS app version to contribution tracking. [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/992790 (https://phabricator.wikimedia.org/T351689) (owner: 10Damilare Adedoyin) [02:01:57] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10FR-donorservices: Manually settled Adyen transaction not coming up in Civi - https://phabricator.wikimedia.org/T344472 (10Cstone) This is the same issue we saw in {T325415} and thought was fixed, although it was around the same time frame as this phab... [02:03:16] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10FR-donorservices: Deduper causing deadlocks - https://phabricator.wikimedia.org/T355677 (10Cstone) [02:03:18] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 10FR-Civi-Dedupe: Revisit deduper interface with a view to making it possible to do a search in search kit to dedupe - https://phabricator.wikimedia.org/T327728 (10Cstone) [09:32:17] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10FR-donorservices: Manually settled Adyen transaction not coming up in Civi - https://phabricator.wikimedia.org/T344472 (10krobinson) @Cstone Amber is out until 5th Feb, but I just checked and the few we have recently settled appear to be in Civi. Th... [15:06:12] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 10Patch-For-Review: Disable/delete old contribution_tracking module - https://phabricator.wikimedia.org/T354708 (10Pcoombe) Okay, that's all the test_tools scripts updated, and I think I've done all the ad hoc queries in Google Sheets (e.g. for sidebar,... [17:15:14] 10Fundraising-Backlog, 10FR-Tech-Analytics, 10FR-tech-data-integrity: FRU Donors Missing Country Info - https://phabricator.wikimedia.org/T355959 (10JMando) [18:11:55] (03CR) 10Ejegg: [C: 03+2] "After an extra system.flush I can load the deduper locally too. Our message templates look fine, and queue consumers seem to work normally" [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/989632 (https://phabricator.wikimedia.org/T354706) (owner: 10Eileen) [18:12:06] (03PS5) 10Ejegg: CiviCRM 5.70-rc [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/989632 (https://phabricator.wikimedia.org/T354706) (owner: 10Eileen) [18:24:51] (03PS3) 10Ejegg: Port https://github.com/civicrm/civicrm-core/pull/29057 [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/992254 (https://phabricator.wikimedia.org/T341902) (owner: 10Eileen) [18:24:55] (03CR) 10Ejegg: [C: 03+2] Port https://github.com/civicrm/civicrm-core/pull/29057 [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/992254 (https://phabricator.wikimedia.org/T341902) (owner: 10Eileen) [18:29:13] (03CR) 10Ejegg: "The job type DB lookup is already cached in Civi::cache('metadata')->get('UserJobTypes') -- do we need to add the extra layer of caching i" [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/992255 (https://phabricator.wikimedia.org/T341902) (owner: 10Eileen) [18:38:52] 10Fundraising-Backlog, 10FR-Tech-Analytics, 10FR-tech-data-integrity: FRU Donors Missing Country Info - https://phabricator.wikimedia.org/T355959 (10Ejegg) Looks like a return of {T351773} [18:41:09] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Disable/delete old contribution_tracking module - https://phabricator.wikimedia.org/T354708 (10JMando) If it helps, for payment_method name I do: ` SELECT c.payment_instrument_id, cov.name AS payment_method, FROM civicrm.civicrm_contribution AS c... [18:43:03] (03Merged) 10jenkins-bot: CiviCRM 5.70-rc [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/989632 (https://phabricator.wikimedia.org/T354706) (owner: 10Eileen) [18:45:43] (03Merged) 10jenkins-bot: Port https://github.com/civicrm/civicrm-core/pull/29057 [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/992254 (https://phabricator.wikimedia.org/T341902) (owner: 10Eileen) [18:58:37] (03PS1) 10Ejegg: Update vendor [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/993181 [18:58:40] (03CR) 10Ejegg: [C: 03+2] Update vendor [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/993181 (owner: 10Ejegg) [18:59:29] (03Merged) 10jenkins-bot: Update vendor [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/993181 (owner: 10Ejegg) [19:02:36] !log fundraising civicrm upgraded from 8c0dc1d2 to b953d667 [19:02:40] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [19:12:17] (03PS3) 10Ejegg: Port https://github.com/civicrm/civicrm-core/pull/29061 [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/992256 (https://phabricator.wikimedia.org/T341902) (owner: 10Eileen) [19:12:40] (03CR) 10Ejegg: [C: 03+2] "Yay caching reflection, yay faster API4" [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/992256 (https://phabricator.wikimedia.org/T341902) (owner: 10Eileen) [19:27:45] 10Fundraising Spring - anybodyKnowWhatThisDoes(), 10Fundraising Sprint Uptown cURL, 10Fundraising-Backlog: Confirm all Ingenico Tokens made it across to Adyen - https://phabricator.wikimedia.org/T348770 (10EMartin) @MBeat33 To avoid duplication, Michael, I reached out to Kristie about this already and she is... [19:37:54] (03Merged) 10jenkins-bot: Port https://github.com/civicrm/civicrm-core/pull/29061 [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/992256 (https://phabricator.wikimedia.org/T341902) (owner: 10Eileen) [19:49:15] (03PS3) 10Ejegg: Port https://github.com/civicrm/civicrm-core/pull/29059 [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/992255 (https://phabricator.wikimedia.org/T341902) (owner: 10Eileen) [19:49:53] (03CR) 10Ejegg: [C: 03+2] "OK, I see now that this does reduce a bunch of extra UserJob lookups." [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/992255 (https://phabricator.wikimedia.org/T341902) (owner: 10Eileen) [20:03:26] (03CR) 10Ejegg: "Reasoning makes sense. Want to get rid of that extraneous use statement in this version too?" [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/992257 (https://phabricator.wikimedia.org/T341902) (owner: 10Eileen) [20:07:19] (03Merged) 10jenkins-bot: Port https://github.com/civicrm/civicrm-core/pull/29059 [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/992255 (https://phabricator.wikimedia.org/T341902) (owner: 10Eileen) [20:19:36] 10Fundraising-Backlog, 10fundraising-tech-ops: Issue new SSL Client Certificate for mbeat - https://phabricator.wikimedia.org/T355701 (10Dwisehaupt) Renewed certificate and sent via email. Password sent via SMS. [20:21:20] 10Fundraising-Backlog, 10fundraising-tech-ops: Issue new SSL Client Certificate for eileen - https://phabricator.wikimedia.org/T355902 (10Dwisehaupt) Renewed certificate and sent via email and placed on frpm. Password in place on frpm. [20:38:30] 10fundraising-tech-ops: Deactivate fundraising accounts for ajett - https://phabricator.wikimedia.org/T355965 (10Dwisehaupt) [20:39:03] (03PS4) 10Wfan: Also update next_sched_contribution_date and cycle_day for for old paypal [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/992237 (https://phabricator.wikimedia.org/T354327) [20:41:45] 10fundraising-tech-ops: Deactivate fundraising accounts for ajett - https://phabricator.wikimedia.org/T355965 (10Dwisehaupt) [20:47:39] 10fundraising-tech-ops: Deactivate fundraising accounts for ajett - https://phabricator.wikimedia.org/T355965 (10Dwisehaupt) Verified with emartin: ` Date: Fri, 26 Jan 2024 09:49:43 From: Evelyn Martin To: Dallas Wisehaupt No Dallas, she is not.  She finished up in early January. ` [20:47:57] (03CR) 10Cstone: [C: 03+2] "Looks good! Thanks for walking through it for the review!" [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/992237 (https://phabricator.wikimedia.org/T354327) (owner: 10Wfan) [20:48:42] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: Add a time limit to contribution tracking queue consume - https://phabricator.wikimedia.org/T329600 (10AnnWF) p:05Medium→03High [20:53:32] 10Fundraising-Backlog, 10fundraising-tech-ops: Issue new SSL Client Certificate for ajett - https://phabricator.wikimedia.org/T355583 (10Dwisehaupt) 05Open→03Resolved No longer at the foundation. Certificate revoked as part of T355965. [20:55:04] 10fundraising-tech-ops: Deactivate fundraising accounts for ajett - https://phabricator.wikimedia.org/T355965 (10Dwisehaupt) [20:56:31] 10Fundraising-Backlog, 10fundraising-tech-ops: Issue new SSL Client Certificate for spatton - https://phabricator.wikimedia.org/T355967 (10Dwisehaupt) [20:57:16] 10Fundraising-Backlog, 10fundraising-tech-ops: Issue new SSL Client Certificate for amjohnson - https://phabricator.wikimedia.org/T355968 (10Dwisehaupt) [20:57:50] 10Fundraising-Backlog, 10fundraising-tech-ops: Issue new SSL Client Certificate for sguseman - https://phabricator.wikimedia.org/T355969 (10Dwisehaupt) [20:58:24] 10Fundraising-Backlog, 10fundraising-tech-ops: Issue new SSL Client Certificate for ewhite - https://phabricator.wikimedia.org/T355970 (10Dwisehaupt) [21:02:30] 10Fundraising-Backlog, 10fundraising-tech-ops: Issue new SSL Client Certificate for jianwong - https://phabricator.wikimedia.org/T355971 (10Dwisehaupt) [21:04:29] 10Fundraising-Backlog, 10FR-Tech-Analytics, 10FR-tech-data-integrity: FRU Donors Missing Country Info - https://phabricator.wikimedia.org/T355959 (10Ejegg) In the earlier ticket @Damilare mentions doing a 28k row backfill but this query to find contacts with a FRUP ID and no address still returns 28k rows: `... [21:04:37] (03Merged) 10jenkins-bot: Also update next_sched_contribution_date and cycle_day for for old paypal [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/992237 (https://phabricator.wikimedia.org/T354327) (owner: 10Wfan) [21:10:16] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: Wired Client Error - https://phabricator.wikimedia.org/T310737 (10AnnWF) [21:10:52] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: Wired Client Error - https://phabricator.wikimedia.org/T310737 (10AnnWF) [21:15:53] 10Fundraising-Backlog, 10FR-Tech-Analytics, 10FR-tech-data-integrity: FRU Donors Missing Country Info - https://phabricator.wikimedia.org/T355959 (10Damilare) @Ejegg for that run it was just the country that was backfilled. I can use the same script to import the address details as well. [21:16:53] 10fundraising-tech-ops: Deactivate fundraising accounts for ajett - https://phabricator.wikimedia.org/T355965 (10Dwisehaupt) Reached out to Evelyn about disabling associated processor accounts. [21:19:49] 10Fundraising-Backlog, 10FR-Tech-Analytics, 10FR-tech-data-integrity: FRU Donors Missing Country Info - https://phabricator.wikimedia.org/T355959 (10Ejegg) Thanks, that would be great! I didn't see the backfill script attached to the other ticket, but I may have just skimmed past it. Would you mind linking i... [21:22:44] 10fundraising-tech-ops: Deactivate fundraising accounts for ajett - https://phabricator.wikimedia.org/T355965 (10Dwisehaupt) [21:23:36] 10fundraising-tech-ops: Deactivate fundraising accounts for ajett - https://phabricator.wikimedia.org/T355965 (10Dwisehaupt) 05Open→03Resolved a:03Dwisehaupt Evelyn is verifying the processor accounts are handled. All set. [21:25:57] 10Fundraising-Backlog: Gift not importing, but error reason is not showing - https://phabricator.wikimedia.org/T355827 (10MDemosWMF) @Eileenmcnaughton Yes, I think they are duplicates as well! I can merge them after adding the last name back in of course and reimport, but if this donor pops up again with no las... [21:30:45] 10Fundraising Spring - anybodyKnowWhatThisDoes(), 10Fundraising-Backlog, 10Patch-For-Review: EFT Matching Organization Import - Duplicate error override not working - https://phabricator.wikimedia.org/T353907 (10MDemosWMF) I just retried the import and it did go through, everything looks good with the gift o... [22:25:21] 10Fundraising-Backlog, 10FR-Tech-Analytics: Some Recent Email Send have No Clicks Or Donations - https://phabricator.wikimedia.org/T355974 (10JMando) [22:45:14] 10Fundraising-Backlog, 10FR-Tech-Analytics: Some Recent Email Send have No Clicks Or Donations - https://phabricator.wikimedia.org/T355974 (10RLopez-WMF) This is the donation link we added: https://donate.wikimedia.org/w/index.php?title=Special:LandingPage&uselang=%%isolang%%&utm_campaign=C2324_ThankYou-Recurr... [22:48:25] 10Fundraising-Backlog, 10FR-Tech-Analytics: Some Recent Email Send have No Clicks Or Donations - https://phabricator.wikimedia.org/T355974 (10Cstone) Was the utm_source with the sp73859018 for example, added to any of the links @RLopez-WMF ? [22:54:57] 10Fundraising-Backlog, 10FR-Tech-Analytics: Some Recent Email Send have No Clicks Or Donations - https://phabricator.wikimedia.org/T355974 (10RLopez-WMF) No, utm_source was not added [22:55:40] 10Fundraising-Backlog, 10FR-Tech-Analytics: Some Recent Email Send have No Clicks Or Donations - https://phabricator.wikimedia.org/T355974 (10Cstone) I see 36 donations with utm_campaign=C2324_ThankYou-Recurring but looks like they are missing the sp info in the utm source that @JMando 's queries are usually l... [23:00:54] 10Fundraising-Backlog, 10FR-Tech-Analytics: Some Recent Email Send have No Clicks Or Donations - https://phabricator.wikimedia.org/T355974 (10RLopez-WMF) Got it. I'll update the base template to avoid this issue in any future send