[06:31:00] (03CR) 10CI reject: [V: 04-1] Localisation updates from https://translatewiki.net. [extensions/DonationInterface] (REL1_35) - 10https://gerrit.wikimedia.org/r/967718 (owner: 10L10n-bot) [14:07:24] (03CR) 10Ejegg: "Oops, we should prune this 1_35 branch of DonationInterface" [extensions/DonationInterface] (REL1_35) - 10https://gerrit.wikimedia.org/r/967718 (owner: 10L10n-bot) [14:13:54] ok, I should focus on smoke-testing my patches for moving the Adyen token [14:18:49] ah, but we should rename that External_Identifiers table [14:18:57] hi ejegg! I left some notes on the givelively patches last week so I'm gonna check in on those if they haven't already beeen merged [14:22:56] oh thanks jgleeson [14:23:08] Yep, I replied a bit in gerrit [14:23:23] ah, and I owe you a follow-on patch to make constants for those T codes [14:25:33] lemme do that before I get deep into something else [14:25:58] ejegg: if there's a ton of them maybe just do the single one an create a patch for the rest [14:26:14] that would make testing it easier too [14:26:29] There are about 6 or 8, but I figure it makes sense to do them all at once [14:26:47] but if you'd rather do the full shebang go right ahead [14:37:48] lol some of the paypal full names for those txn categories are about as opaque as the T codes [14:42:49] lol [14:49:24] fr-tech today's music plug is the good ole shire music from lotr - a thing of beauty :) https://youtu.be/K69tbUo3vGs [14:56:48] (03PS1) 10Ejegg: Use constants for T-codes [wikimedia/fundraising/tools] - 10https://gerrit.wikimedia.org/r/967947 [14:57:19] heh, sorry, 1001 albums project has me listening to Meatloaf :P [14:57:30] so cheesy [14:57:33] ah nice [14:58:03] "On a hot summer night, would you offer your throat to the wolf with the red roses?" [14:58:10] (03CR) 10CI reject: [V: 04-1] Use constants for T-codes [wikimedia/fundraising/tools] - 10https://gerrit.wikimedia.org/r/967947 (owner: 10Ejegg) [14:58:17] https://genius.com/Meat-loaf-you-took-the-words-right-out-of-my-mouth-hot-summer-night-lyrics [14:58:43] what a song [14:58:54] oh, tox doesn't like the indentation [14:59:47] but it needs to be different from the next-most indented block [14:59:56] how should I do a continuation line again? [15:00:03] Listening to that album is like listening to a theatre production [15:01:41] yeah, no end to the drama [15:04:29] (03PS2) 10Ejegg: Use constants for T-codes [wikimedia/fundraising/tools] - 10https://gerrit.wikimedia.org/r/967947 [15:42:40] 10fundraising-tech-ops: Fundraising environment support for Debian 12 (Bookworm) - https://phabricator.wikimedia.org/T344290 (10Jgreen) [16:02:12] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [16:03:33] @ejegg. Hi Elliott, from you about post payment last year: Post-payment UPI/PayTM monthly convert is also totally blocked as we need to specify up front whether it is a one-time or recurring donation (and for one-time, DLocal routes to a completely different provider). The only way to do a ‘monthly convert’ style flow would be to send all donors through the recurring flow, showing the text in the donor’s app [16:03:34] saying they were authorizing us to debit up to XXX amount regularly until YYY date, (then only charge once when the donor does not agree to add recurring). I think that would make a lot of people unhappy. (edited) [16:04:06] I'm not sure if this pertained to India only. [16:07:12] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [16:12:12] RECOVERY - check_mysql on frdb2003 is OK: Uptime: 1029981 Threads: 4 Questions: 1039552041 Slow queries: 422 Opens: 7349 Open tables: 1499 Queries per second avg: 1009.292 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 0 https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [16:12:18] emartin_: yep, that part was specific to the UPI payments [16:12:39] gottcha [16:14:21] i see we've been charging one person in ZA a recurring credit card via dlocal: https://civicrm.wikimedia.org/civicrm/contact/view?reset=1&cid=4465663&selectedChild=recurring [16:14:33] with plenty of successful installments [16:15:12] The few LATAM DLocal recurrings I can see in the db are all canceled by now [16:22:12] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [16:27:12] RECOVERY - check_mysql on frdb2003 is OK: Uptime: 1030881 Threads: 4 Questions: 1041231921 Slow queries: 422 Opens: 7356 Open tables: 1500 Queries per second avg: 1010.040 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 0 https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [16:28:16] (03CR) 10Jgleeson: [C: 03+2] "Thanks for this. LGTM!" [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/967238 (https://phabricator.wikimedia.org/T295726) (owner: 10Ejegg) [16:30:04] (03Merged) 10jenkins-bot: PayPal: Tag rather than discard GiveLively IPNs [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/967238 (https://phabricator.wikimedia.org/T295726) (owner: 10Ejegg) [16:44:24] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: Paypal Audit Import Bug: Unsupported 'Express Checkout' and 'Others' Values being assigned to payment_method - https://phabricator.wikimedia.org/T349537 (10jgleeson) [16:49:02] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: Paypal Audit Import Bug: 'thankyou_date' flag likely being set by mistake - https://phabricator.wikimedia.org/T349539 (10jgleeson) [16:50:22] (03CR) 10Jgleeson: [C: 03+2] "Thanks for the changes. I've created tickets for the FIXMEs https://phabricator.wikimedia.org/T349539 and https://phabricator.wikimedia.or" [wikimedia/fundraising/tools] - 10https://gerrit.wikimedia.org/r/967250 (https://phabricator.wikimedia.org/T295726) (owner: 10Ejegg) [16:51:17] (03CR) 10CI reject: [V: 04-1] PayPal: Tag rather than discard GiveLively audit rows [wikimedia/fundraising/tools] - 10https://gerrit.wikimedia.org/r/967250 (https://phabricator.wikimedia.org/T295726) (owner: 10Ejegg) [16:52:12] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [16:57:12] RECOVERY - check_mysql on frdb2003 is OK: Uptime: 1032681 Threads: 5 Questions: 1044254257 Slow queries: 422 Opens: 7361 Open tables: 1500 Queries per second avg: 1011.207 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 0 https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [16:59:20] hmm, tools? [17:00:23] wonder what's up with that test that fails only in gate-and-submit [17:01:33] (03PS1) 10Ejegg: Merge branch 'master' into deployment [wikimedia/fundraising/SmashPig] (deployment) - 10https://gerrit.wikimedia.org/r/967964 [17:01:35] (03CR) 10Ejegg: [C: 03+2] Merge branch 'master' into deployment [wikimedia/fundraising/SmashPig] (deployment) - 10https://gerrit.wikimedia.org/r/967964 (owner: 10Ejegg) [17:01:37] (03CR) 10Jgleeson: [C: 03+2] "This is much better! thanks" [wikimedia/fundraising/tools] - 10https://gerrit.wikimedia.org/r/967947 (owner: 10Ejegg) [17:01:54] (03CR) 10Ejegg: "recheck" [wikimedia/fundraising/tools] - 10https://gerrit.wikimedia.org/r/967250 (https://phabricator.wikimedia.org/T295726) (owner: 10Ejegg) [17:02:04] (03Merged) 10jenkins-bot: Merge branch 'master' into deployment [wikimedia/fundraising/SmashPig] (deployment) - 10https://gerrit.wikimedia.org/r/967964 (owner: 10Ejegg) [17:02:45] (03Merged) 10jenkins-bot: PayPal: Tag rather than discard GiveLively audit rows [wikimedia/fundraising/tools] - 10https://gerrit.wikimedia.org/r/967250 (https://phabricator.wikimedia.org/T295726) (owner: 10Ejegg) [17:02:49] (03Merged) 10jenkins-bot: Use constants for T-codes [wikimedia/fundraising/tools] - 10https://gerrit.wikimedia.org/r/967947 (owner: 10Ejegg) [17:12:12] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [17:17:12] RECOVERY - check_mysql on frdb2003 is OK: Uptime: 1033881 Threads: 5 Questions: 1046396206 Slow queries: 422 Opens: 7371 Open tables: 1500 Queries per second avg: 1012.105 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 0 https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [17:22:44] (03PS1) 10Ejegg: Merge branch 'master' into deploy [wikimedia/fundraising/tools] (deploy) - 10https://gerrit.wikimedia.org/r/967967 [17:22:47] (03CR) 10Ejegg: [C: 03+2] Merge branch 'master' into deploy [wikimedia/fundraising/tools] (deploy) - 10https://gerrit.wikimedia.org/r/967967 (owner: 10Ejegg) [17:23:15] (03Merged) 10jenkins-bot: Merge branch 'master' into deploy [wikimedia/fundraising/tools] (deploy) - 10https://gerrit.wikimedia.org/r/967967 (owner: 10Ejegg) [17:25:23] !log standalone (IPN listener) SmashPig upgraded from e27dfbce to c5b12dc3 [17:25:26] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [17:26:35] !log fundraising python tools upgraded from e56ae8ae to 9e84c689 [17:26:37] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [17:27:12] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [17:28:22] 10Fundraising Sprint This LAN is your LAN, 10Fundraising-Backlog: Issue with Paypal donations made on GiveLively for events - https://phabricator.wikimedia.org/T295726 (10Ejegg) OK, this is deployed with the corrected behavior, adding the no_thank_you and the appeal fields rather than dropping them. [17:32:12] RECOVERY - check_mysql on frdb2003 is OK: Uptime: 1034781 Threads: 5 Questions: 1047794517 Slow queries: 422 Opens: 7378 Open tables: 1501 Queries per second avg: 1012.576 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 0 https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [17:42:12] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [17:47:12] RECOVERY - check_mysql on frdb2003 is OK: Uptime: 1035681 Threads: 5 Questions: 1049288241 Slow queries: 422 Opens: 7385 Open tables: 1502 Queries per second avg: 1013.138 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 0 https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [18:18:49] 10Fundraising-Backlog: Matching EFT imports - not creating employer/employee relationship - https://phabricator.wikimedia.org/T349550 (10MDemosWMF) [18:21:10] (03CR) 10Ejegg: "Logic looks good! I think the test fails when it selects a different contact ID with the same email to create the activity. When I tried c" [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/967509 (https://phabricator.wikimedia.org/T349277) (owner: 10Damilare Adedoyin) [18:33:47] (03PS4) 10Ejegg: Update calculation of WMF Donor fields to exclude fields for removal [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/966655 (https://phabricator.wikimedia.org/T347724) (owner: 10Eileen) [18:36:18] (03CR) 10Ejegg: [C: 03+2] "Looks good! I suppose some day we'll want to make those tests use dynamic field names so they don't fail on some year roll-over." [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/966655 (https://phabricator.wikimedia.org/T347724) (owner: 10Eileen) [18:38:23] (03PS2) 10Damilare Adedoyin: Add Activity to contact profile when snoozed. [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/967509 (https://phabricator.wikimedia.org/T349277) [18:38:38] (03CR) 10CI reject: [V: 04-1] Add Activity to contact profile when snoozed. [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/967509 (https://phabricator.wikimedia.org/T349277) (owner: 10Damilare Adedoyin) [18:40:04] (03PS3) 10Damilare Adedoyin: Add Activity to contact profile when snoozed. [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/967509 (https://phabricator.wikimedia.org/T349277) [18:40:37] (03PS11) 10Wfan: Add declineMonthlyConvert as param for post Monthly Convert donation api [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/963970 (https://phabricator.wikimedia.org/T347606) [18:42:13] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [18:42:28] (03CR) 10CI reject: [V: 04-1] Add declineMonthlyConvert as param for post Monthly Convert donation api [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/963970 (https://phabricator.wikimedia.org/T347606) (owner: 10Wfan) [18:42:40] 10Fundraising Sprint This LAN is your LAN, 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 10Recurring-Donations, 10Patch-For-Review: Send recurring payment notifications to the donations queue - https://phabricator.wikimedia.org/T240581 (10jgleeson) a:05Ejegg→03jgleeson [18:47:04] (03PS1) 10Wfan: Add wmf_civicrm_remove_recurring_token to handle recurring token delete from donation queue [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/967975 (https://phabricator.wikimedia.org/T347606) [18:47:13] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [18:47:28] (03PS12) 10Wfan: Add declineMonthlyConvert as param for post Monthly Convert donation api [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/963970 (https://phabricator.wikimedia.org/T347606) [18:48:23] (03CR) 10Ejegg: [C: 04-1] "Can we do this without the change to Civi core Merger.php? Maybe in a Resolver class over in the deduper extension?" [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/967066 (owner: 10Wfan) [18:50:35] (03PS4) 10Ejegg: Create new field for Adyen Shopper Reference [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/966557 (https://phabricator.wikimedia.org/T349107) [18:50:37] (03PS4) 10Ejegg: Copy invoice_id to processor_contact_id [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/966579 (https://phabricator.wikimedia.org/T349107) [18:50:39] (03PS3) 10Ejegg: Store and retrieve ShopperReference from new field [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/966590 (https://phabricator.wikimedia.org/T349107) [18:51:26] (03CR) 10Wfan: Use latest cid is_opt_id option as default (031 comment) [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/967066 (owner: 10Wfan) [18:52:05] (03Merged) 10jenkins-bot: Update calculation of WMF Donor fields to exclude fields for removal [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/966655 (https://phabricator.wikimedia.org/T347724) (owner: 10Eileen) [18:52:13] RECOVERY - check_mysql on frdb2003 is OK: Uptime: 1039581 Threads: 5 Questions: 1054545293 Slow queries: 434 Opens: 7411 Open tables: 1505 Queries per second avg: 1014.394 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 0 https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [18:54:10] (03CR) 10Ejegg: [C: 04-1] "We just don't want to go back to local hacks on Civi core. If you think it's useful, please make a pull request upstream." [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/967066 (owner: 10Wfan) [19:00:16] (03CR) 10Ejegg: [C: 04-1] "I notice is_opt_out is included in the defaults for the BooleanYesResolver, in the deduper_resolver_bool_prefer_yes setting." [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/967066 (owner: 10Wfan) [19:04:23] Clamping @ mount laguna https://usercontent.irccloud-cdn.com/file/jMl3xOum/1698087735.JPG [19:05:04] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: Acoustic suppressed emails 2023-10-19 - https://phabricator.wikimedia.org/T349358 (10Cstone) Update for what happened on Friday: Elliott created a temp table with all the affected emails, we created a script to undo the unsubscribes based on the suppresse... [19:16:51] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10MediaWiki-Docker: Upgrade to PHP 8 locally - https://phabricator.wikimedia.org/T349204 (10greg) p:05Triage→03Medium [19:20:43] wfan: now THAT'S glamping! [19:26:29] 10Fundraising Sprint Istanbool (not Constantidouble), 10Fundraising-Backlog, 10Epic: Scope contribution tracking - https://phabricator.wikimedia.org/T182030 (10XenoRyet) [19:26:38] 10Fundraising Sprint Dinosaur Cookies co-existed with Gingerbread People, 10Fundraising Sprint This LAN is your LAN, 10Fundraising-Backlog, 10MW-1.42-notes (1.42.0-wmf.2; 2023-10-24): investigate: Record user agent in contribution_tracking - https://phabricator.wikimedia.org/T182039 (10XenoRyet) 05Open→... [19:27:01] 10Fundraising Sprint This LAN is your LAN, 10Fundraising-Backlog: Create fundraise-up working log directory - https://phabricator.wikimedia.org/T348778 (10XenoRyet) 05Open→03Resolved [19:27:30] 10Fundraising Sprint This LAN is your LAN, 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: Individual Engage File Import Duplicates - https://phabricator.wikimedia.org/T347362 (10XenoRyet) 05Open→03Resolved [19:27:32] 10Fundraising Sprint This LAN is your LAN, 10Fundraising-Backlog: Issue with Paypal donations made on GiveLively for events - https://phabricator.wikimedia.org/T295726 (10Ejegg) @Jsimmons or @jkim_wikimedia would one of you be able to create a test $1 PayPal donation via GiveLively, to test whether this is wor... [19:27:43] 10Fundraising Sprint This LAN is your LAN, 10Fundraising-Backlog: Create custom field for external identifier - https://phabricator.wikimedia.org/T349015 (10XenoRyet) 05Open→03Resolved [19:28:31] 10Fundraising Sprint This LAN is your LAN, 10Fundraising-Backlog, 10FR-donorservices: Unable to transfer donations from one CID to another after accidental CID merge. - https://phabricator.wikimedia.org/T330539 (10XenoRyet) 05Open→03Resolved [19:28:38] (03Abandoned) 10Jgleeson: WIP: Handle Paypal not sending over donor email in GetExpressCheckoutDetails call [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/965537 (https://phabricator.wikimedia.org/T348760) (owner: 10Jgleeson) [19:29:02] 10Fundraising Sprint This LAN is your LAN, 10Fundraising-Backlog: AMEX rejected transactions through Ingenico are to be ported to Adyen - https://phabricator.wikimedia.org/T338523 (10XenoRyet) [19:29:28] 10Fundraising Sprint This LAN is your LAN, 10Fundraising-Backlog, 10MW-1.42-notes (1.42.0-wmf.1; 2023-10-17): Implement payment content if no client data return from client side for Venmo - https://phabricator.wikimedia.org/T347771 (10XenoRyet) 05Open→03Resolved [19:29:43] 10Fundraising Sprint This LAN is your LAN, 10Fundraising-Backlog: Create FundraiseUp Audit module in CiviCRM - https://phabricator.wikimedia.org/T346620 (10XenoRyet) [19:29:45] 10Fundraising Sprint This LAN is your LAN, 10Fundraising-Backlog: Handle contact update from Fundraiseup - https://phabricator.wikimedia.org/T347882 (10XenoRyet) 05Open→03Resolved [19:30:26] 10Fundraising Sprint This LAN is your LAN, 10Fundraising-Backlog, 10MW-1.41-notes (1.41.0-wmf.30; 2023-10-10): Change transaction descriptor to omit phone number reference - https://phabricator.wikimedia.org/T336779 (10XenoRyet) 05Open→03Resolved [19:30:56] 10Fundraising Sprint This LAN is your LAN, 10Fundraising-Backlog: Create FundraiseUp Audit module in CiviCRM - https://phabricator.wikimedia.org/T346620 (10XenoRyet) 05Open→03Resolved [19:31:50] 10Fundraising Sprint This LAN is your LAN, 10Fundraising-Backlog, 10FR-tech-data-integrity: Making Gift Coding Changes to gifts in July - https://phabricator.wikimedia.org/T344012 (10XenoRyet) [19:32:13] 10Fundraising Sprint This LAN is your LAN, 10Fundraising-Backlog: Create FundraiseUp Audit module in CiviCRM - https://phabricator.wikimedia.org/T346620 (10XenoRyet) [19:32:16] 10Fundraising Sprint This LAN is your LAN, 10Fundraising-Backlog: Make sure we don't send thank you emails for Fundraise Up donors - https://phabricator.wikimedia.org/T347616 (10XenoRyet) 05Open→03Resolved [19:33:31] 10Fundraising Sprint This LAN is your LAN, 10Fundraising-Backlog, 10FR-dlocal: dlocal refund and script to batch refund csv files - https://phabricator.wikimedia.org/T334311 (10XenoRyet) 05Open→03Resolved [19:34:00] 10Fundraising Sprint This LAN is your LAN, 10Fundraising-Backlog: Recurring Gift Coding - https://phabricator.wikimedia.org/T345920 (10XenoRyet) 05Open→03Resolved [19:34:13] 10Fundraising Sprint This LAN is your LAN, 10Fundraising-Backlog, 10FR-tech-data-integrity: Making Gift Coding Changes to gifts in July - https://phabricator.wikimedia.org/T344012 (10XenoRyet) 05Open→03Resolved [19:34:48] 10Fundraising-Backlog, 10Wikipedia-iOS-App-Backlog, 10iOS Release FY2023-24: As a donor I want to be able to make an easy and convenient donation via Apple Pay in the Wikipedia app - https://phabricator.wikimedia.org/T288285 (10XenoRyet) [19:35:06] 10Fundraising Sprint This LAN is your LAN, 10Fundraising-Backlog, 10Wikipedia-iOS-App-Backlog, 10MW-1.42-notes (1.42.0-wmf.1; 2023-10-17), and 2 others: fr-tech task: Create appDonate donation API method - https://phabricator.wikimedia.org/T344774 (10XenoRyet) 05Open→03Resolved [19:35:16] 10Fundraising Sprint This LAN is your LAN, 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 10FR-Civi-Dedupe: Can we speed up deduper query? - https://phabricator.wikimedia.org/T333909 (10XenoRyet) [19:37:37] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: https://apple-pay-gateway.apple.com SSL certificate has expired - https://phabricator.wikimedia.org/T348972 (10XenoRyet) [19:37:44] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: https://apple-pay-gateway.apple.com SSL certificate has expired - https://phabricator.wikimedia.org/T348972 (10XenoRyet) 05Open→03Resolved [19:38:23] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10FR-Smashpig: Explicitly set manualCapture in case Adyen capture settings are not as expected - https://phabricator.wikimedia.org/T345955 (10XenoRyet) 05Open→03Resolved [19:38:44] 10fundraising-tech-ops: Fundraising environment support for Debian 12 (Bookworm) - https://phabricator.wikimedia.org/T344290 (10Jgreen) [19:39:00] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10FR-Smashpig: Missing gateway_txn_id from donations message sent via RECURRING_CONTRACT - https://phabricator.wikimedia.org/T347305 (10XenoRyet) 05Open→03Resolved [19:39:18] 10Fundraising Tech - Chaos Crew: venmo recurring charge bug - https://phabricator.wikimedia.org/T348789 (10XenoRyet) 05Open→03Resolved [19:39:32] 10Fundraising Tech - Chaos Crew, 10MW-1.41-notes (1.41.0-wmf.29; 2023-10-03): Fiscal Number not saved for monthly convert payments - https://phabricator.wikimedia.org/T345346 (10XenoRyet) 05Open→03Resolved [19:39:38] hahaha nice sprint name eh [19:40:03] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: Acoustic suppressed emails 2023-10-19 - https://phabricator.wikimedia.org/T349358 (10XenoRyet) 05Open→03Resolved [19:40:58] AndyRussG|vol: :) it's a good one [19:40:59] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: Add CSP for Fundraiseup on DonateWiki - https://phabricator.wikimedia.org/T345379 (10XenoRyet) 05Open→03Resolved [19:41:50] yeaaaaaaaah [19:42:15] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10FR-donorservices: iDeal recurring donation continued after cancellation - https://phabricator.wikimedia.org/T335140 (10XenoRyet) 05Open→03Resolved [19:43:40] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10FR-donorservices: Indian donor charged twice for second installment of recurring donation - https://phabricator.wikimedia.org/T348258 (10XenoRyet) 05Open→03Resolved [19:44:09] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: Matching import - duplicate contribution error - https://phabricator.wikimedia.org/T345665 (10XenoRyet) 05Open→03Resolved [19:44:12] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: Engage DAF import- duplicate issue - https://phabricator.wikimedia.org/T345773 (10XenoRyet) 05Open→03Resolved [19:45:20] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10FR-donorservices: email addresses in Adyen donor name fields - https://phabricator.wikimedia.org/T326986 (10XenoRyet) 05Open→03Resolved [19:45:33] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Handle Adyen refund IPNs for non-USD donations - https://phabricator.wikimedia.org/T347422 (10XenoRyet) 05Open→03Resolved [19:45:55] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10FR-donorservices, 10MW-1.42-notes (1.42.0-wmf.1; 2023-10-17): Donation amount in Civi does not match the donation amount received at dLocal - https://phabricator.wikimedia.org/T346101 (10XenoRyet) 05Open→03Resolved [19:46:41] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10Patch-For-Review: CiviCRM gid profile error - https://phabricator.wikimedia.org/T349091 (10XenoRyet) 05Open→03Resolved [19:51:29] 10Fundraising Sprint This LAN is your LAN, 10Fundraising-Backlog, 10Patch-For-Review: Data Axle project - New fields in Civi - https://phabricator.wikimedia.org/T336890 (10MDemosWMF) Hi @Eileenmcnaughton - thanks for the questions! I reviewed some of our previous notes based on past discussions and I think w... [20:02:53] 10Fundraising Sprint This LAN is your LAN, 10Fundraising-Backlog: Issue with Paypal donations made on GiveLively for events - https://phabricator.wikimedia.org/T295726 (10JSimmons) @Ejegg I can submit a test donation. These pages remain live post-event. [20:08:35] (03PS6) 10Wfan: Add api to remove recuring payment token then delete customer from venmo vault for one-time donor [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/963853 (https://phabricator.wikimedia.org/T347606) [20:12:54] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Slow query killer for CiviCRM - https://phabricator.wikimedia.org/T340773 (10Jgreen) a:03Jgreen [20:21:58] 10Fundraising-Backlog: Unexpected $0 auths on donor statements - https://phabricator.wikimedia.org/T348715 (10MBeat33) We got two more tickets today, for a total of 16. Several donors asked BMO to confirm the PSP, but BMO said they were unable to. Four of the affected cards were previously canceled. [20:27:13] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [20:32:10] RECOVERY - check_mysql on frdb2003 is OK: Uptime: 1045581 Threads: 5 Questions: 1059355556 Slow queries: 443 Opens: 7446 Open tables: 1505 Queries per second avg: 1013.174 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 0 https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [21:46:11] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: Tools for Analyzing MySQL Slow Query Log - https://phabricator.wikimedia.org/T349565 (10jgleeson) [21:46:21] wfan: ^ [21:46:39] Cool thanks Jack :) [22:26:39] 10Fundraising-Backlog: Greece: Set Adyen with post-payment monthly convert as Default - https://phabricator.wikimedia.org/T349122 (10HNordeenWMF) @AKanji-WMF Pre-test is March 27, campaign May 28! [22:30:39] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: Tools for Analyzing MySQL Slow Query Log - https://phabricator.wikimedia.org/T349565 (10jgleeson) I went the bash/awk script route, but I don't think we can efficiently parse the slow query log this way due to its size. I managed to get an ordered list of... [23:36:02] 10Fundraising Sprint This LAN is your LAN, 10Fundraising-Backlog, 10MW-1.41-notes (1.41.0-wmf.30; 2023-10-10): Change transaction descriptor to omit phone number reference - https://phabricator.wikimedia.org/T336779 (10AKanji-WMF) the phone number reference has now been removed from the transaction descriptor. [23:41:57] 10Fundraising Sprint This LAN is your LAN, 10Fundraising-Backlog, 10FR-donorservices, 10Patch-For-Review: Deduper and legacy merging overwriting issue - https://phabricator.wikimedia.org/T345206 (10AnnWF) @Eileenmcnaughton Please see if we want to update upstream or there is no need to fix this since you m... [23:49:41] 10Fundraising Sprint This LAN is your LAN, 10Fundraising-Backlog, 10FR-donorservices, 10Patch-For-Review: Deduper and legacy merging overwriting issue - https://phabricator.wikimedia.org/T345206 (10Eileenmcnaughton) @SHust we probably need to clarify this a bit There are 2 scenarios where you dedupe 1)... [23:57:20] (03CR) 10Eileen: "A coupld of thoughts" [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/967509 (https://phabricator.wikimedia.org/T349277) (owner: 10Damilare Adedoyin)