[00:09:29] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10fundraising-tech-ops: Tools for Analyzing MySQL Slow Query Log - https://phabricator.wikimedia.org/T349565 (10Dwisehaupt) `mariadb-dumpslow` is part of the `mariadb-client` package. If we install that on the logger role and it would pull in the follow... [01:16:43] 10Fundraising Sprint This LAN is your LAN, 10Fundraising-Backlog, 10Patch-For-Review: Data Axle project - New fields in Civi - https://phabricator.wikimedia.org/T336890 (10Eileenmcnaughton) @MDemosWMF I have added the (TS) to the existing fields that I believe to be targetsmart [01:25:01] (03CR) 10Ejegg: "looks like a good start. i wonder if we could save the customer id somewhere as processor_contact_id to avoid having to search. also not " [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/963853 (https://phabricator.wikimedia.org/T347606) (owner: 10Wfan) [01:30:49] (03CR) 10Ejegg: "Let's also mark this with an interface." [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/963853 (https://phabricator.wikimedia.org/T347606) (owner: 10Wfan) [01:39:08] (03PS8) 10Eileen: Add new DataAxle fields [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/966942 (https://phabricator.wikimedia.org/T336890) [01:40:23] (03PS1) 10Ejegg: Add OS and browser to contribution_tracking displays [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/968009 (https://phabricator.wikimedia.org/T182039) [01:42:10] (03PS9) 10Eileen: Add new DataAxle fields [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/966942 (https://phabricator.wikimedia.org/T336890) [01:47:24] (03PS10) 10Eileen: Add new DataAxle fields [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/966942 (https://phabricator.wikimedia.org/T336890) [01:50:08] (03PS11) 10Eileen: Add new DataAxle fields [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/966942 (https://phabricator.wikimedia.org/T336890) [02:07:20] (03PS12) 10Eileen: Add new DataAxle fields [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/966942 (https://phabricator.wikimedia.org/T336890) [06:16:26] 10Fundraising Sprint This LAN is your LAN, 10Fundraising-Backlog, 10MediaWiki-extensions-FundraiserLandingPage, 10donate.wikimedia.org: donate.wikimedia.org landing pages don't have descriptions in search engine results - https://phabricator.wikimedia.org/T254808 (10MSuijkerbuijk_WMF) Hi @Ejegg, Here's th... [07:40:34] (03CR) 10CI reject: [V: 04-1] Localisation updates from https://translatewiki.net. [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/968144 (owner: 10L10n-bot) [07:57:25] (03CR) 10Raimond Spekking: [C: 03+2] "false positive" [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/968144 (owner: 10L10n-bot) [10:05:24] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10FR-donorservices: URGENT: Recent Paypal donations without an email address in Civi! - https://phabricator.wikimedia.org/T348760 (10jgleeson) The latest is that we sent an email to PayPal on October 17th with some examples of the problem, and we're sti... [10:31:01] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10FR-donorservices: URGENT: Recent Paypal donations without an email address in Civi! - https://phabricator.wikimedia.org/T348760 (10jgleeson) @krobinson @Cstone I can see the email addresses for the donations affected from September are possibly being... [11:05:34] (03CR) 10Nikerabbit: [V: 03+2] Localisation updates from https://translatewiki.net. [extensions/DonationInterface] (REL1_40) - 10https://gerrit.wikimedia.org/r/966978 (owner: 10L10n-bot) [11:05:49] (03CR) 10Nikerabbit: [V: 03+2] Localisation updates from https://translatewiki.net. [extensions/DonationInterface] (REL1_41) - 10https://gerrit.wikimedia.org/r/966704 (owner: 10L10n-bot) [11:37:27] 10Fundraising-Backlog, 10FR-donorservices: "Typed card number does not match card brand" errors - https://phabricator.wikimedia.org/T349600 (10krobinson) [11:39:13] (03CR) 10Nikerabbit: [V: 03+2] Localisation updates from https://translatewiki.net. [extensions/DonationInterface] (REL1_35) - 10https://gerrit.wikimedia.org/r/967718 (owner: 10L10n-bot) [12:35:01] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10fundraising-tech-ops: Tools for Analyzing MySQL Slow Query Log - https://phabricator.wikimedia.org/T349565 (10jgleeson) thanks @Dwisehaupt. I'm surprised it needs all those additional packages because it should just be reading text files, but if we're... [12:37:11] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10FR-donorservices: "Typed card number does not match card brand" errors - https://phabricator.wikimedia.org/T349600 (10jgleeson) [13:21:11] 10Fundraising Sprint This LAN is your LAN, 10Fundraising-Backlog, 10MediaWiki-extensions-FundraiserLandingPage, 10donate.wikimedia.org: donate.wikimedia.org landing pages don't have descriptions in search engine results - https://phabricator.wikimedia.org/T254808 (10Ejegg) a:03Ejegg [13:25:32] 10Fundraising Sprint This LAN is your LAN, 10Fundraising-Backlog, 10MediaWiki-extensions-FundraiserLandingPage, 10donate.wikimedia.org: donate.wikimedia.org landing pages don't have descriptions in search engine results - https://phabricator.wikimedia.org/T254808 (10Ejegg) OK @MSuijkerbuijk_WMF, I'll add t... [13:35:29] (03PS1) 10Ejegg: Add description meta tag to Special:LandingPage [extensions/FundraiserLandingPage] - 10https://gerrit.wikimedia.org/r/968265 (https://phabricator.wikimedia.org/T254808) [13:35:55] Easy one for review there fr-tech ^^^ [13:36:05] looking [13:37:41] MW framework was pretty useful there with its $out->addMeta function [13:39:00] still no feedback on the ticket about varying the text based on some parameter, so I figure going with the simplest approach for now is OK - and just putting it in i18n files will get us translations free [13:39:18] ejegg: looks straightforward. Is you local donate wiki URL https://localhost:9010/index.php?title=Special:LandingPage&uselang=en&country=US [13:39:23] I'm getting Not Found [13:40:00] oh I know why [13:40:07] I've deleted it! ha [13:40:12] ah oops [13:40:28] shoot, and no routable version of donut [13:40:31] part of the upgrade stuff [13:40:38] I can reinstall [13:41:00] that's still on the todolist for https://gerrit.wikimedia.org/r/c/wikimedia/fundraising/dev/+/953984 [13:41:15] hehe, yep, i was just thinking of that [13:44:34] hmm [13:44:36] docker-compose stop [13:44:38] ERROR: The Compose file './docker-compose.yml' is invalid because: [13:44:40] Unsupported config option for services.civicrm: 'platform' [13:44:52] first time I've seen it complain about that option [13:44:57] platform: linux/amd64 [13:45:18] https://gerrit.wikimedia.org/r/c/wikimedia/fundraising/dev/+/955006 [13:47:10] https://github.com/docker/cli/issues/1050 [13:47:24] although I see version as 3.7 [13:48:13] oh weird [13:48:24] yeah, we added that recently [13:48:24] hmm ok it looks like this might not be supported https://github.com/docker/compose/pull/5985 [13:48:52] oh dang, really? [13:49:06] what am I using here? [13:49:07] "Closing this as it staled" [13:49:23] although that was in 2019 [13:49:23] oh i have docker-compose version 1.29.2 [13:49:43] it's the schema version [13:49:47] ah but the file format is 3.7 [13:49:48] right [13:49:59] so why doesn't my docker-compose complain? [13:50:03] jack@jack-ThinkPad:~/fundraising-dev$ docker-compose -v [13:50:05] docker-compose version 1.26.2, build eefe0d31 [13:50:14] try doing docker-compose down then up? [13:50:18] on master [13:50:52] I wonder if it's a bug elsewhere, something not being closed [13:51:15] oh hey, we should move to compose v2 sometime soon [13:51:17] From July 2023 Compose V1 stopped receiving updates. It's also no longer available in new releases of Docker Desktop. [13:51:38] it's happily bringing things back up [13:51:51] so.... i dunno [13:53:47] weird [13:54:10] added between 1.26 and 1.29 maybe? [13:54:34] chatgpt tells me it was added in schema 3.9 [13:54:42] hehe [13:54:47] but we're running 3.7 [13:54:52] but can you trust chatgpt? [13:55:13] yeah I'm googling it also [13:56:54] https://docs.docker.com/compose/compose-file/compose-versioning/#version-24 says it's in version 2.4 [13:57:12] lol and there is no version 3.9 yet [13:57:37] yeah I just noticed that too lol https://docs.docker.com/compose/compose-file/compose-file-v3/ [13:57:40] lyin bot [13:57:58] wth is going on here then [13:58:06] I'll debug that later and comment the option out for now [13:58:11] k [13:59:37] oh hey [13:59:43] I don't see platform in version 3 [13:59:48] but it is in version 2 [14:00:07] removed? [14:00:40] if you flick between https://docs.docker.com/compose/compose-file/compose-file-v3/ and https://docs.docker.com/compose/compose-file/compose-file-v2/ it disappears [14:02:03] "I apologize for the error in my initial response. The platform option was introduced in Docker Compose file format version 2.4, not version 3.9 as previously mentioned​1​. The version 2.4 of Docker Compose allowed for the specification of the platform parameter in service definitions, which is also used when performing a build for the service. " [14:02:05] ha! [14:02:10] lolol [14:02:25] Skynet isn't quite there yet [14:02:36] at least it's polite [14:05:07] got to go to a short appointment soon. Back in an hour or so. [14:05:28] it gets a pass this time because it does knock up pretty decent bed time stories for the kids with a few characters and a rough outline and setting buy yeah... it's not quite T-1000 yet [14:07:44] hmm PayPal uses those codes ... [14:26:25] 10Fundraising Sprint This LAN is your LAN, 10Fundraising-Backlog, 10MediaWiki-extensions-FundraiserLandingPage, 10donate.wikimedia.org, 10Patch-For-Review: donate.wikimedia.org landing pages don't have descriptions in search engine results - https://phabricator.wikimedia.org/T254808 (10EWilfong_WMF) Noti... [14:37:40] (03CR) 10Jgleeson: [C: 03+2] "This is working for me locally! thanks" [extensions/FundraiserLandingPage] - 10https://gerrit.wikimedia.org/r/968265 (https://phabricator.wikimedia.org/T254808) (owner: 10Ejegg) [14:51:13] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10FR-donorservices: URGENT: Recent Paypal donations without an email address in Civi! - https://phabricator.wikimedia.org/T348760 (10jgleeson) a:05jgleeson→03None [14:52: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 [14:57: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 [15:02: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 [15:07: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 [15:12: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 [15:17: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 [15:22: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 [15:27:13] RECOVERY - check_mysql on frdb2003 is OK: Uptime: 1113681 Threads: 5 Questions: 1157454556 Slow queries: 459 Opens: 7811 Open tables: 1508 Queries per second avg: 1039.305 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 653 https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [15:37: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 [15:39:18] (03Merged) 10jenkins-bot: Add description meta tag to Special:LandingPage [extensions/FundraiserLandingPage] - 10https://gerrit.wikimedia.org/r/968265 (https://phabricator.wikimedia.org/T254808) (owner: 10Ejegg) [15: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 [15:43:54] thanks for the review jgleeson ! [15:44:20] np! [15:46:47] 10Fundraising Sprint This LAN is your LAN, 10Fundraising-Backlog, 10MediaWiki-extensions-FundraiserLandingPage, 10donate.wikimedia.org, 10Patch-For-Review: donate.wikimedia.org landing pages don't have descriptions in search engine results - https://phabricator.wikimedia.org/T254808 (10Ejegg) The code ch... [15:47:13] RECOVERY - check_mysql on frdb2003 is OK: Uptime: 1114881 Threads: 5 Questions: 1159211458 Slow queries: 459 Opens: 7858 Open tables: 1542 Queries per second avg: 1039.762 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 [15:52:23] Cambrigde almost had a monorail: https://en.wikipedia.org/wiki/Meigs_Elevated_Railway [15:53:13] guy was just too attached to steam power, though. His aversion to electification drove away investors and the company that won the contract built the red line subterranean and electified [15:54:43] damilare: is this the only place I need to add the OS & Browser columns for the contribution_tracking views? https://gerrit.wikimedia.org/r/c/wikimedia/fundraising/crm/+/968009 [15:55:02] https://insidethemagic.net/wp-content/uploads/2014/09/monorailcolorWATER.jpg [15:55:17] checking [15:57:57] yes I think so [15:58:29] Are you still working on that patch ejegg? [16:00:41] it's ready to review damilare [16:04:24] cool, tnc [16:04:27] tnx [16:08:33] 10Wikimedia-Fundraising-Banners, 10Wikipedia-Android-App-Backlog: Netherlands fundraising messages for Android app - https://phabricator.wikimedia.org/T344519 (10JTannerWMF) 05Open→03Resolved a:03JTannerWMF [16:12:51] (03CR) 10Damilare Adedoyin: [C: 03+1] "Looks good ejegg, left a small comment about the field types." [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/968009 (https://phabricator.wikimedia.org/T182039) (owner: 10Ejegg) [16:15:59] (03CR) 10Ejegg: "Ah, OK, I'll switch back to a string. I'm truncating them to integers on the way in up at DonationInterface, but I guess it's better for t" [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/968009 (https://phabricator.wikimedia.org/T182039) (owner: 10Ejegg) [16:24:46] (03PS2) 10Ejegg: Add OS and browser to contribution_tracking displays [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/968009 (https://phabricator.wikimedia.org/T182039) [16:45:35] (03CR) 10Wfan: Add api to remove recuring payment token then delete customer from venmo vault for one-time donor (031 comment) [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/963853 (https://phabricator.wikimedia.org/T347606) (owner: 10Wfan) [16:50:49] (03CR) 10Damilare Adedoyin: [C: 03+2] Add OS and browser to contribution_tracking displays [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/968009 (https://phabricator.wikimedia.org/T182039) (owner: 10Ejegg) [16:53:45] thanks damilare [16:59:57] (03CR) 10Wfan: [C: 03+2] Create new field for Adyen Shopper Reference [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/966557 (https://phabricator.wikimedia.org/T349107) (owner: 10Ejegg) [17:01:02] thanks wfan [17:01:23] i'm just smoke-testing the follow-up patches to that one [17:02:15] so far so good, for getting the number into the new field from donations and recurring queue messages from payments, and for doing a nightly charge [17:02:37] i'm just checking if there's anything I need to worry about in IPNs [17:02:45] or audit stuffs [17:06:16] (03Merged) 10jenkins-bot: Add OS and browser to contribution_tracking displays [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/968009 (https://phabricator.wikimedia.org/T182039) (owner: 10Ejegg) [17:08:11] we should test recurring ideal a lot with that too ejegg [17:08:15] it has the weirdest recurring flow [17:08:34] yep, good call [17:08:49] I'll do one of those now [17:08:58] So for that, I DO need the routable IPNs [17:09:03] lemme hop onto ca-test [17:12:13] ok, successfully sent a test IPN [17:13:26] k, got two of those [17:13:35] from a recurring ideal [17:13:47] let's consume those queues and see that it ends up in the right place [17:16:32] (03Merged) 10jenkins-bot: Create new field for Adyen Shopper Reference [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/966557 (https://phabricator.wikimedia.org/T349107) (owner: 10Ejegg) [17:17:58] dang, seems to have discarded the adyen job??? [17:18:15] ugh, because the pending message wasn't there? [17:19:17] oh that was one with visa [17:19:22] ahh, message limit reached [17:19:31] ok, i had a lot of adyen jobs in the backlog [17:20:16] yeah i turned off a bunch of the things that cause ipns but i figured clearing them all out wouldnt help testing for future us so a bunch still happen automatically [17:25:06] ah right, once i turned on my proxy it delivered everyone's IPNs from... since I last had the proxy on [17:28:07] lemme just increase that message limit [17:30:29] i had it on yesterday so thats just one day hah [17:30:45] but i might not have ran the job to handle them though [17:34:03] oh i thought maybe it was keeping track per-endpoint [17:34:26] yeah, some of these are from july and august [17:35:04] theres reports i think and some recurrings? [17:35:40] phew, ok, about a thousand messages later I'm at the end of the queue [17:35:47] let's see if it got me that recurring row [17:37:21] (03PS1) 10Ejegg: Merge branch 'master' into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/968303 [17:37:39] (03CR) 10Ejegg: [C: 03+2] Merge branch 'master' into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/968303 (owner: 10Ejegg) [17:38:22] (03Merged) 10jenkins-bot: Merge branch 'master' into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/968303 (owner: 10Ejegg) [17:38:31] dang, no new recurring row [17:38:43] let me see what ended up in the damaged queue [17:39:51] well, I'll deploy that display fix and the new field for now [17:41:23] !log fundraising civicrm upgraded from 8e8ffec0 to 6cfae26a [17:41:26] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [17:47:24] 10Fundraising-Backlog: Sprint U - Priorities: - https://phabricator.wikimedia.org/T349655 (10AKanji-WMF) [18:12:43] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: Matching EFT imports - not creating employer/employee relationship - https://phabricator.wikimedia.org/T349550 (10XenoRyet) p:05Triage→03High [18:14:38] 10Fundraising-Backlog: Investigate Recurring on Credit/Debit for Brazil - https://phabricator.wikimedia.org/T349656 (10HNordeenWMF) [18:15:29] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10FR-donorservices: URGENT: Recent Paypal donations without an email address in Civi! - https://phabricator.wikimedia.org/T348760 (10Cstone) I think they are being backfilled by the 2nd recurring donation, I put the ones affected in a group called 2023-... [18:15:42] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10FR-donorservices: URGENT: Recent Paypal donations without an email address in Civi! - https://phabricator.wikimedia.org/T348760 (10Cstone) a:03Cstone [18:16:08] hmm damilare I'm still not seeing those columns in the contribution tracking sections under the contribution info [18:16:15] I wonder where else I need to change it [18:19:39] thanks cstone [18:19:59] yeah jgleeson of the 137 in that group 80 have emails now [18:20:01] ejegg: this is the searchkit for this, https://civicrm.wikimedia.org/civicrm/admin/search#/edit/983 [18:20:05] nice! [18:20:24] so i guess pointing even more to something on paypals end? [18:20:25] we may have to run an update for the extension [18:20:51] I should stop listening to LOTR music it's too distracting. I just spent 15 minutes watching the very emotional fall of gandalf on repeat :( [18:21:01] sorry this: https://civicrm.wikimedia.org/civicrm/admin/search#/edit/751 [18:21:42] ok, cool, i just updated that one [18:21:50] let's see if it shows up under a donation now [18:22:04] also, i see a couple columns with blank header names there - any idea what those are? [18:22:46] oh cstone, I asked Oscar if he knew about the "It's over 9000" thing and he looked at me like I'd asked him if he knew what the sun was [18:23:01] haha [18:23:16] #outoftouchprobs [18:23:36] not sure also [18:24:17] looks like it's empty [18:24:24] i mean just weren't chronically online in 2006? haha https://en.wikipedia.org/wiki/It%27s_Over_9000! [18:25:57] I'm learning every day ha [18:26:50] https://xkcd.com/1053/ [18:28:32] i was at nerd college so that didnt help [18:29:22] "You're one of today's lucky 10,000" haha [18:29:22] when this happened the campus was completely covered in it https://en.wikipedia.org/wiki/AACS_encryption_key_controversy [18:30:33] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 10FR-donorservices, 10Recurring-Donations: Update RecurringQueueConsumer to handle donation upgrade declines - https://phabricator.wikimedia.org/T335876 (10Ejegg) 05Open→03Resolved a:03Ejegg Looks like we did this at the same time we did the upg... [18:30:35] 10Fundraising-Backlog, 10FR-donorservices, 10Recurring-Donations, 10Epic: How can we enable upgrading of existing recurring donation amount? - https://phabricator.wikimedia.org/T325317 (10Ejegg) [18:34:44] is that house still a thing? https://en.wikipedia.org/wiki/Streisand_effect [18:34:49] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10FR-donorservices: "Typed card number does not match card brand" errors - https://phabricator.wikimedia.org/T349600 (10MBeat33) @EMartin @jgleeson because //"Typed card number doesn’t match card brand”// is such a specific message, would it be worth as... [18:40:25] LOL a fighter jet just buzzed here legit thought a building was collapsing or something [18:41:22] hah jgleeson I had no idea the origin of that was a house! [18:42:15] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10FR-donorservices: "Typed card number does not match card brand" errors - https://phabricator.wikimedia.org/T349600 (10jgleeson) @MBeat33, We generate the text in the error message after Adyen sends us an error code on the front end related to this pro... [18:49:14] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10FR-donorservices: "Typed card number does not match card brand" errors - https://phabricator.wikimedia.org/T349600 (10MBeat33) Ah got it, thanks for the helpful info. [18:51:39] (03CR) 10Jgleeson: "testing 1 2 1" [wikimedia/fundraising/dev] - 10https://gerrit.wikimedia.org/r/731834 (owner: 10Jgleeson) [18:52:15] 10Fundraising Sprint This LAN is your LAN, 10Fundraising-Backlog: Issue with Paypal donations made on GiveLively for events - https://phabricator.wikimedia.org/T295726 (10Ejegg) 05Open→03Resolved Awesome, glad to hear it @JSimmons . [19:10:02] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: Paypal Audit Import Bug: 'thankyou_date' flag likely being set by mistake - https://phabricator.wikimedia.org/T349539 (10AKanji-WMF) p:05Triage→03Medium [19:12:39] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: Paypal Audit Import Bug: 'thankyou_date' flag likely being set by mistake - https://phabricator.wikimedia.org/T349539 (10AKanji-WMF) p:05Medium→03Low [19:13:50] 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 (10AKanji-WMF) p:05Triage→03Medium [19:24:33] 10Fundraising-Backlog: Investigate Recurring on Credit/Debit for Brazil - https://phabricator.wikimedia.org/T349656 (10HNordeenWMF) [19:31:34] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 10FR-WMF-Audit: Update Civi record with additional data from audit files - https://phabricator.wikimedia.org/T152249 (10AKanji-WMF) @EMartin @ERoden-WMF flagging this task for discussion - we're wondering how valuable having raw fee data coming into Civ... [19:33:43] 10Fundraising-Backlog, 10fundraising-tech-ops: process control jobs now running wiredness - https://phabricator.wikimedia.org/T349242 (10AKanji-WMF) 05Open→03Resolved a:03AKanji-WMF discussed in triage; working as designed; resolving [19:34:47] 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 (10SHust) @Eileenmcnaughton The issue is 100% with this scenario **'If 2 is the problem you are trying to solve... [19:35:28] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: endowment fiscal & calendar year totals are transposed - https://phabricator.wikimedia.org/T349160 (10AKanji-WMF) Pulling into Sprint U/maintenance window [19:36:37] 10Fundraising-Backlog, 10fundraising-tech-ops: FR-Tech FY2324Q2 maintenance window - https://phabricator.wikimedia.org/T337579 (10Dwisehaupt) [19:36:41] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Prevent future us from hating now-us - change table name - https://phabricator.wikimedia.org/T349158 (10AKanji-WMF) Let's not hate ourselves, let's bring it into sprint U for maintenance window [19:39:09] 10Fundraising-Backlog, 10fundraising-tech-ops: FR-Tech FY2324Q2 maintenance window - https://phabricator.wikimedia.org/T337579 (10Dwisehaupt) [19:41:45] 10Fundraising-Backlog: SmashPig Charge Recurring Donations failed with code 1 - https://phabricator.wikimedia.org/T342327 (10AKanji-WMF) 05Open→03Resolved a:03AKanji-WMF discussed @ triage; doesn't seem to be persisting; closing [19:43:42] (03PS1) 10Ejegg: Add GR as supported in Adyen [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/968349 (https://phabricator.wikimedia.org/T349122) [19:47:51] 10Fundraising Sprint Gondwanaland Reunification Engine, 10Fundraising Sprint Homebrew Hadron Collider, 10Fundraising Sprint Ivory Tower Defense Games, 10Fundraising Sprint Judgement Suspenders, and 5 others: NULL referrers in contribution_tracking - https://phabricator.wikimedia.org/T161539 (10AKanji-WMF)... [19:48:05] 10Fundraising Sprint Gondwanaland Reunification Engine, 10Fundraising Sprint Homebrew Hadron Collider, 10Fundraising Sprint Ivory Tower Defense Games, 10Fundraising Sprint Judgement Suspenders, and 5 others: NULL referrers in contribution_tracking - https://phabricator.wikimedia.org/T161539 (10AKanji-WMF)... [19:49:48] 10Fundraising-Backlog, 10FR-Smashpig: Merge DonorDetails.customerId with PaymentDetailResponse.processorContactID - https://phabricator.wikimedia.org/T348991 (10AKanji-WMF) Needs coordination between donationswiki/smashpig potentially Civi - don't necessarily want to touch during BE as it impacts Venmo. [19:54:39] 10Fundraising-Backlog: Edit configuration to send explicit Ingenico requests to Adyen - https://phabricator.wikimedia.org/T345461 (10AKanji-WMF) [20:00:22] 10Fundraising-Backlog, 10fundraising-tech-ops: Make the full list of languages available to custom fields on Community CiviCRM instance - https://phabricator.wikimedia.org/T343488 (10Dwisehaupt) [20:00:57] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 10FR-WMF-Audit: Update Civi record with additional data from audit files - https://phabricator.wikimedia.org/T152249 (10EMartin) @AKanji-WMF @ERoden-WMF My instinct is that this sort of data should be picked up in a finance application and analyzed ther... [20:01:14] 10Fundraising-Backlog: Update contact on CiviCRM when FRUP donor updates their email through donor portal - https://phabricator.wikimedia.org/T349663 (10Damilare) [20:24:40] 10Fundraising Sprint U TEMP, 10Fundraising-Backlog: Sprint U - Priorities: - https://phabricator.wikimedia.org/T349655 (10AKanji-WMF) [20:24:42] 10Fundraising Sprint U TEMP, 10Fundraising-Backlog: Suppress Paypal Grant CID to avoid duplicate db recording - https://phabricator.wikimedia.org/T349392 (10AKanji-WMF) [20:24:45] 10Fundraising Sprint U TEMP, 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: endowment fiscal & calendar year totals are transposed - https://phabricator.wikimedia.org/T349160 (10AKanji-WMF) [20:24:47] 10Fundraising Sprint U TEMP, 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Prevent future us from hating now-us - change table name - https://phabricator.wikimedia.org/T349158 (10AKanji-WMF) [20:24:49] 10Fundraising Sprint U TEMP, 10Fundraising-Backlog: Import and verify small batch of Ingenico tokens from Adyen CSVs - https://phabricator.wikimedia.org/T348771 (10AKanji-WMF) [20:24:52] 10Fundraising Sprint U TEMP, 10Fundraising-Backlog, 10Patch-For-Review: Greece: Set Adyen with post-payment monthly convert as Default - https://phabricator.wikimedia.org/T349122 (10AKanji-WMF) [20:24:54] 10Fundraising Sprint U TEMP, 10Fundraising-Backlog: Confirm all Ingenico Tokens made it across to Adyen - https://phabricator.wikimedia.org/T348770 (10AKanji-WMF) [20:24:57] 10Fundraising Sprint U TEMP, 10Fundraising-Backlog, 10Patch-For-Review: Store Adyen ShopperReference (processor_contact_id) in new custom field - https://phabricator.wikimedia.org/T349107 (10AKanji-WMF) [20:24:59] 10Fundraising Sprint U TEMP, 10Fundraising-Backlog: Upgrade recur amount when donor upgrades their recurring in Fundraiseup - https://phabricator.wikimedia.org/T348544 (10AKanji-WMF) [20:25:01] 10Fundraising Sprint U TEMP, 10Fundraising-Backlog: Frontend Import of Fundraiseup Chargeback - https://phabricator.wikimedia.org/T347881 (10AKanji-WMF) [20:25:03] 10Fundraising Sprint U TEMP, 10Fundraising-Backlog: Fundraising Sprint T - Priorities - https://phabricator.wikimedia.org/T348408 (10AKanji-WMF) [20:25:05] 10Fundraising Sprint U TEMP, 10Fundraising-Backlog: Bug with new Recurring Financial Types - https://phabricator.wikimedia.org/T345919 (10AKanji-WMF) [20:25:08] 10Fundraising Sprint U TEMP, 10Fundraising-Backlog, 10Patch-For-Review: Implement deletePaymentMethodFromVault to clean venmo vault - https://phabricator.wikimedia.org/T347606 (10AKanji-WMF) [20:25:10] 10Fundraising Sprint U TEMP, 10Fundraising-Backlog, 10Patch-For-Review: Removing some WMF donor fields - https://phabricator.wikimedia.org/T347724 (10AKanji-WMF) [20:25:17] 10Fundraising Sprint U TEMP, 10Fundraising-Backlog: Edit configuration to send explicit Ingenico requests to Adyen - https://phabricator.wikimedia.org/T345461 (10AKanji-WMF) [20:25:29] 10Fundraising Sprint U TEMP, 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 10Patch-For-Review: Rationalise our mailing table data & related code so we can safely run civimail without insane queries - https://phabricator.wikimedia.org/T346194 (10AKanji-WMF) [20:25:33] 10Fundraising Sprint U TEMP, 10Fundraising-Backlog, 10FR-donorservices: Permission changed for DR agents - https://phabricator.wikimedia.org/T343899 (10AKanji-WMF) [20:25:37] 10Fundraising Sprint U TEMP, 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Civi's preview of receipt: Recurring donations displayed as one-time - https://phabricator.wikimedia.org/T342081 (10AKanji-WMF) [20:25:41] 10Fundraising Sprint U TEMP, 10Fundraising-Backlog: Data Axle Project - Re-import to Civi - https://phabricator.wikimedia.org/T341902 (10AKanji-WMF) [20:25:45] 10Fundraising Sprint U TEMP, 10Fundraising-Backlog, 10FR-donorservices, 10Patch-For-Review: Deduper and legacy merging overwriting issue - https://phabricator.wikimedia.org/T345206 (10AKanji-WMF) [20:25:49] 10Fundraising Sprint U TEMP, 10Fundraising-Backlog: Send browser data to Adyen on CC transactions so we can optionally toggle on/off 3DS on demand - https://phabricator.wikimedia.org/T341299 (10AKanji-WMF) [20:25:53] 10Fundraising Sprint U TEMP, 10Fundraising-Backlog, 10Patch-For-Review: All Ingenico/Worldline active tokens will be migrated to Adyen - https://phabricator.wikimedia.org/T344645 (10AKanji-WMF) [20:26:01] 10Fundraising Sprint U TEMP, 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Bad query on civicrm mailing dash board - https://phabricator.wikimedia.org/T335071 (10AKanji-WMF) [20:26:05] 10Fundraising Sprint U TEMP, 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Civi - Increase limit on email sends to 2000 / enable CiviMail - https://phabricator.wikimedia.org/T335296 (10AKanji-WMF) [20:26:09] 10Fundraising Sprint U TEMP, 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Clean up old TY CiviMail records - https://phabricator.wikimedia.org/T335070 (10AKanji-WMF) [20:26:13] 10Fundraising Sprint U TEMP, 10Fundraising-Backlog, 10Patch-For-Review: Auto-Rescue Audit processing updates - https://phabricator.wikimedia.org/T340159 (10AKanji-WMF) [20:26:17] 10Fundraising Sprint U TEMP, 10Fundraising-Backlog, 10Patch-For-Review: Data Axle project - New fields in Civi - https://phabricator.wikimedia.org/T336890 (10AKanji-WMF) [20:26:23] 10Fundraising Sprint U TEMP, 10Fundraising-Backlog, 10FR-dlocal, 10MediaWiki-extensions-DonationInterface, and 2 others: Remove old AstroPay code from DonationInterface - https://phabricator.wikimedia.org/T326594 (10AKanji-WMF) [20:26:29] 10Fundraising Sprint U TEMP, 10Fundraising-Backlog, 10MediaWiki-extensions-FundraiserLandingPage, 10donate.wikimedia.org, 10MW-1.42-notes (1.42.0-wmf.3; 2023-10-31): donate.wikimedia.org landing pages don't have descriptions in search engine results - https://phabricator.wikimedia.org/T254808 (10AKanji-WM... [20:26:33] 10Fundraising Sprint U TEMP, 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: Matching EFT imports - not creating employer/employee relationship - https://phabricator.wikimedia.org/T349550 (10AKanji-WMF) [20:26:37] 10Fundraising Sprint U TEMP, 10Fundraising-Backlog, 10fundraising-tech-ops: FR-Tech FY2324Q2 maintenance window - https://phabricator.wikimedia.org/T337579 (10AKanji-WMF) [20:26:41] 10Fundraising Sprint U TEMP, 10Fundraising-Backlog, 10FR-Smashpig, 10FR-dlocal, 10Patch-For-Review: Remove old AstroPay code from SmashPig - https://phabricator.wikimedia.org/T326218 (10AKanji-WMF) [20:26:45] 10Fundraising Sprint U TEMP, 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 10Recurring-Donations, 10Patch-For-Review: Send recurring payment notifications to the donations queue - https://phabricator.wikimedia.org/T240581 (10AKanji-WMF) [20:39:00] (03PS1) 10Ejegg: Add index to payment_token.token [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/968352 [20:39:16] eileen: any reason not to add that index? ^^^ [20:39:51] ejegg: nah I don't think so - the indexes that cause issues are the ones with low cardinality [20:40:01] (03PS7) 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:40:07] k, cool. [20:41:03] I'm very curious to see how this graph changes upon deploying that: https://frmon.frdev.wikimedia.org/d/Pq1YNMviz/fundraising-overview?orgId=1&from=now-1h&to=now&viewPanel=33 [20:41:26] (03PS13) 10Wfan: Add declineMonthlyConvert as param for post Monthly Convert donation api [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/963970 (https://phabricator.wikimedia.org/T347606) [20:41:45] (03CR) 10Wfan: Add api to remove recuring payment token then delete customer from venmo vault for one-time donor (031 comment) [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/963853 (https://phabricator.wikimedia.org/T347606) (owner: 10Wfan) [20:56:53] ejegg: it would be good to talk in sprint planning about civimail - [20:58:03] tech talk, right? [20:58:05] sounds good [20:58:12] i've got to go pick up Tavi [20:58:20] yep tech talk [20:59:14] hopefully my dad will be able to help with her so i can be fully present at tech talk! my wife just remembered she also has an event [21:01:00] (03PS4) 10Damilare Adedoyin: Add Activity to contact profile when snoozed. [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/967509 (https://phabricator.wikimedia.org/T349277) [21:16:47] (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) [21:20:55] 10Fundraising-Backlog: Investigate Recurring on Credit/Debit for Brazil - https://phabricator.wikimedia.org/T349656 (10EMartin) Posting this here as well as Slack: The debit penetration in Brazil is sub 1%. I suggest it doesn't need its own flow. {F39971708} [21:26:53] 10Fundraising-Backlog: Check that Adyen supports countries we had available on Ingenico - https://phabricator.wikimedia.org/T349667 (10Cstone) [21:30:48] 10Fundraising-Backlog, 10MediaWiki-extensions-CentralNotice, 10WMDE-FUN-Team, 10WMDE-Fundraising-Tech, and 2 others: [Discussion] Prevent SEO decline due to Google "page experience": mid-June 2021 - https://phabricator.wikimedia.org/T280476 (10RHo) removing inactive/unrelated project tags [21:38:16] 10Fundraising-Backlog: Check that Adyen supports countries we had available on Ingenico - https://phabricator.wikimedia.org/T349667 (10Cstone) [21:41:55] 10Fundraising Sprint U TEMP, 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 10Recurring-Donations, 10Patch-For-Review: Send recurring payment notifications to the donations queue - https://phabricator.wikimedia.org/T240581 (10jgleeson) The first part of this task is to redirect PayPal recurring... [21:45:10] ejegg|skrun: there's some overlap with your notes in that but I wanted to do a brain dump before logging off ^^^^ [21:48:38] 10Fundraising-Backlog: Check that Adyen supports countries we had available on Ingenico - https://phabricator.wikimedia.org/T349667 (10Cstone) [21:49:01] After thinking about it more, separating the payment-import-specific code from updating the contribution recur records across two consumers will introduce new problems, so I've decided to go with consolidating all the current recurring payment import code over to the donations queue consumer. [21:49:24] that fun starts tomorow [21:49:28] with two rs [21:49:32] bye for now [22:11:34] 10Fundraising-Backlog: Check that Adyen supports countries we had available on Ingenico - https://phabricator.wikimedia.org/T349667 (10Cstone) [22:28:46] (03PS1) 10Ejegg: Remove stuff to revert unsubscribes [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/968364 [22:31:18] (03CR) 10Wfan: "recheck" [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/963853 (https://phabricator.wikimedia.org/T347606) (owner: 10Wfan) [22:32:35] (03CR) 10Wfan: "recheck" [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/963970 (https://phabricator.wikimedia.org/T347606) (owner: 10Wfan) [22:54:11] (03CR) 10Cstone: [C: 03+2] "they are reverted!" [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/968364 (owner: 10Ejegg) [23:12:44] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 10FR-WMF-Audit: Update Civi record with additional data from audit files - https://phabricator.wikimedia.org/T152249 (10ERoden-WMF) Thanks @EMartin I think it's okay to put it in Civi in a field we're not using to track revenue. We could then build out... [23:19:54] 10Fundraising Sprint U TEMP, 10Fundraising-Backlog, 10Patch-For-Review: Data Axle project - New fields in Civi - https://phabricator.wikimedia.org/T336890 (10ERoden-WMF) Thanks @MDemosWMF all that sounds correct to me. [23:20:59] cstone are your order IDs around 480021.1 ? [23:21:46] hmmm [23:21:54] i just rebuilt today but lemme see [23:22:07] probably though [23:22:10] o, i finally see some RecurringContracts around my ID rance [23:22:13] i was doing 44 for a while maybe i did 48 [23:22:22] k, re-running queue consumers [23:23:17] yeah ejegg i was using 48485 [23:23:20] in that range [23:24:35] cool cool. So I finally have rows in contribution_recur [23:25:12] though of course I had switched crm branches to get those token migration sql scripts, so I didn't test sending the shopper reference to the new table [23:25:17] but I'll do that after dinner [23:25:21] thanks for the help! [23:59:12] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 10FR-WMF-Audit: Update Civi record with additional data from audit files - https://phabricator.wikimedia.org/T152249 (10EMartin) @ERoden-WMF @AKanji-WMF I think it would have value. The adjustments are to do with intra-company transfers. If we want...