[00:01:39] (03PS3) 10Ejegg: Adyen audit: variant can change method [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/867722 (https://phabricator.wikimedia.org/T323658) [00:02:30] dwisehaupt: I'm just updating the logging doc & Tim had in there that we haven't truncated civicrm_activity.details ever - I think that is inaccurate & you did it the maintenance window before last (am running a query to find out but 'crawling a query' seems more the case so thought asking might be quicker :-) [00:08:28] i think we did too, but we have had a bunch of times where we thought about truncating but never did. [00:18:19] hmm - my query is still running :-) [00:18:30] select count(*), max(activity_date_time) FROM civicrm_activity WHERE details IS NULL and activity_type_id = 6; [00:24:19] 33 mins [00:24:39] & I'm not sure the answer is useful [00:28:26] ug - wrong activity_type_id [01:51:53] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 10fundraising-tech-ops: Do a prune on detail data for activity records of type thank you - https://phabricator.wikimedia.org/T325123 (10Eileenmcnaughton) [02:23:37] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Suppression list logic - sanity check - https://phabricator.wikimedia.org/T325125 (10Eileenmcnaughton) [02:45:57] (03CR) 10Ejegg: [C: 04-1] "This code is looking pretty good! Just one quibble with setting the FinalStatus to failed when the ACK comes back with an error. I think o" [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/857150 (https://phabricator.wikimedia.org/T322570) (owner: 10Wfan) [03:34:55] 10Fundraising-Backlog, 10FR-Docker: Docker dev setup: scope out use cases, requirements and command-line UI for breaking out setup.sh into smaller scripts - https://phabricator.wikimedia.org/T287028 (10AndyRussG) Here's a proposal for the command-line interface. Let's have a single base command, say, `frdev`,... [06:45:02] (03CR) 10CI reject: [V: 04-1] Localisation updates from https://translatewiki.net. [extensions/DonationInterface] (REL1_38) - 10https://gerrit.wikimedia.org/r/867776 (owner: 10L10n-bot) [06:45:40] (03CR) 10CI reject: [V: 04-1] Localisation updates from https://translatewiki.net. [extensions/FundraisingEmailUnsubscribe] (REL1_38) - 10https://gerrit.wikimedia.org/r/867787 (owner: 10L10n-bot) [08:13:22] (03CR) 10Nikerabbit: [V: 03+2] Localisation updates from https://translatewiki.net. [extensions/DonationInterface] (REL1_38) - 10https://gerrit.wikimedia.org/r/867776 (owner: 10L10n-bot) [08:13:43] (03CR) 10Nikerabbit: [V: 03+2] Localisation updates from https://translatewiki.net. [extensions/FundraisingEmailUnsubscribe] (REL1_38) - 10https://gerrit.wikimedia.org/r/867787 (owner: 10L10n-bot) [09:37:25] 10Fundraising Sprint Turtles that are robotic that destroy the whole world with their foot theory, 10Fundraising Sprint Undefined, 10Fundraising Sprint Wibbly Wobbly Timey Wimey, 10Fundraising-Backlog, and 5 others: SSL cert for links.email.wikimedia.org - https://phabricator.wikimedia.org/T188561 (10Vgutie... [14:10:09] 10Fundraising Sprint Turtles that are robotic that destroy the whole world with their foot theory, 10Fundraising Sprint Undefined, 10Fundraising Sprint Wibbly Wobbly Timey Wimey, 10Fundraising-Backlog, and 5 others: SSL cert for links.email.wikimedia.org - https://phabricator.wikimedia.org/T188561 (10DBu-WM... [15:27:06] (03PS13) 10Damilare Adedoyin: IP Velocity Filter: Increase count after first run [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/859168 (https://phabricator.wikimedia.org/T323544) (owner: 10AndyRussG) [15:29:15] (03CR) 10CI reject: [V: 04-1] IP Velocity Filter: Increase count after first run [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/859168 (https://phabricator.wikimedia.org/T323544) (owner: 10AndyRussG) [15:31:50] (03PS14) 10Damilare Adedoyin: IP Velocity Filter: Increase count after first run [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/859168 (https://phabricator.wikimedia.org/T323544) (owner: 10AndyRussG) [15:41:54] 10Fundraising Sprint Turtles that are robotic that destroy the whole world with their foot theory, 10Fundraising Sprint Undefined, 10Fundraising Sprint Wibbly Wobbly Timey Wimey, 10Fundraising-Backlog, and 5 others: SSL cert for links.email.wikimedia.org - https://phabricator.wikimedia.org/T188561 (10EWilfo... [15:56:46] (03PS8) 10Wfan: Handle errors in PayPal GetExpressCheckoutDetails [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/857150 (https://phabricator.wikimedia.org/T322570) [15:57:14] (03CR) 10CI reject: [V: 04-1] Handle errors in PayPal GetExpressCheckoutDetails [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/857150 (https://phabricator.wikimedia.org/T322570) (owner: 10Wfan) [15:59:49] 10Fundraising-Backlog: Write up medium term project outline for ESI+CentralNotice - https://phabricator.wikimedia.org/T325191 (10greg) p:05Triage→03High [16:00:10] 10Fundraising-Backlog: Write up medium term project outline for ESI+CentralNotice - https://phabricator.wikimedia.org/T325191 (10greg) a:03AndyRussG Assigning to Andy per skip-level. [16:00:19] (03PS9) 10Wfan: Handle errors in PayPal GetExpressCheckoutDetails [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/857150 (https://phabricator.wikimedia.org/T322570) [16:02:51] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10fr-donorservices: Civi not showing Endowment donations under the 'last donation date' field - https://phabricator.wikimedia.org/T324050 (10SHust) @Eileenmcnaughton, I tried the fishing net search on CID 51936080 to find its dupe, and I noticed that th... [16:03:07] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10fr-donorservices: Civi not showing Endowment donations under the 'last donation date' field - https://phabricator.wikimedia.org/T324050 (10SHust) 05Resolved→03Open [16:11:36] greg-g: ^ thx for making the ESI task :) [16:11:41] on it now [16:15:17] AndyRussG: ty! I didn't want to ask you to do phantom work :) [16:15:51] greg-g: :) [16:19:59] 10Fundraising Sprint Turtles that are robotic that destroy the whole world with their foot theory, 10Fundraising Sprint Undefined, 10Fundraising Sprint Wibbly Wobbly Timey Wimey, 10Fundraising-Backlog, and 6 others: SSL cert for links.email.wikimedia.org - https://phabricator.wikimedia.org/T188561 (10Vgutie... [18:35:47] 10Fundraising Sprint Turtles that are robotic that destroy the whole world with their foot theory, 10Fundraising Sprint Undefined, 10Fundraising Sprint Wibbly Wobbly Timey Wimey, 10Fundraising-Backlog, and 6 others: SSL cert for links.email.wikimedia.org - https://phabricator.wikimedia.org/T188561 (10Vgutie... [18:53:36] 10Fundraising Sprint Turtles that are robotic that destroy the whole world with their foot theory, 10Fundraising Sprint Undefined, 10Fundraising Sprint Wibbly Wobbly Timey Wimey, 10Fundraising-Backlog, and 6 others: SSL cert for links.email.wikimedia.org - https://phabricator.wikimedia.org/T188561 (10EWilfo... [19:46:59] 10Fundraising-Backlog, 10fundraising-tech-ops, 10FR-Tech-Analytics: Fundraising superset may need the request length tuned - https://phabricator.wikimedia.org/T324067 (10Dwisehaupt) a:05Dwisehaupt→03None Getting some inconsistencies when testing this and it isn't worth breaking superset during en6c. Loo... [19:50:48] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 10fundraising-tech-ops: Do a prune on detail data for activity records of type thank you - https://phabricator.wikimedia.org/T325123 (10Dwisehaupt) Added to the list for the next maintenance window: https://collab.wikimedia.org/wiki/2023-01-downtime-mai... [20:05:21] (03PS1) 10Wfan: Add dlocal smart field script and api key [wikimedia/fundraising/dev] - 10https://gerrit.wikimedia.org/r/868160 (https://phabricator.wikimedia.org/T324271) [20:26:32] (03PS1) 10Wfan: Render smartfield ui to the dlocal gateway page [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/868161 (https://phabricator.wikimedia.org/T324271) [20:28:33] (03CR) 10CI reject: [V: 04-1] Render smartfield ui to the dlocal gateway page [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/868161 (https://phabricator.wikimedia.org/T324271) (owner: 10Wfan) [20:32:48] (03PS2) 10Wfan: Render smartfield ui to the dlocal gateway page [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/868161 (https://phabricator.wikimedia.org/T324271) [20:37:39] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Analyse 'anonymous' no thankyou records - https://phabricator.wikimedia.org/T325042 (10Eileenmcnaughton) [20:39:44] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Analyse 'anonymous' no thankyou records - https://phabricator.wikimedia.org/T325042 (10Eileenmcnaughton) [20:40:30] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Analyse 'anonymous' no thankyou records - https://phabricator.wikimedia.org/T325042 (10Eileenmcnaughton) [20:41:00] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Analyse 'anonymous' no thankyou records - https://phabricator.wikimedia.org/T325042 (10Eileenmcnaughton) [20:44:43] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Analyse 'anonymous' no thankyou records - https://phabricator.wikimedia.org/T325042 (10Eileenmcnaughton) [20:46:40] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Analyse 'anonymous' no thankyou records - https://phabricator.wikimedia.org/T325042 (10Eileenmcnaughton) [21:00:30] dwisehaupt: is there any way of knowing if there was replication lag at a specific time? [21:00:42] yeah. it should show up in the metrics. [21:01:00] we capture that on all replicas so it would show up for each host that may see it. [21:01:56] https://frmon.wikimedia.org/d/Pq1YNMviz/fundraising-overview?orgId=1&refresh=1m&viewPanel=2 is the graph that has all the hosts and replication lag numbers. [21:07:11] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Analyse 'anonymous' no thankyou records - https://phabricator.wikimedia.org/T325042 (10Eileenmcnaughton) [21:12:26] 10Fundraising Sprint Wibbly Wobbly Timey Wimey, 10Fundraising-Backlog, 10FR-dlocal: Add technical diagram of dlocal integration interactions - https://phabricator.wikimedia.org/T324621 (10jgleeson) Smart Fields with Redirect 3d-Secure https://docs.dlocal.com/docs/3d-secure#redirect-3d-secure {F35864885} [21:13:00] (03PS1) 10Eileen: Bolser up found check [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/868171 (https://phabricator.wikimedia.org/T325042) [21:13:59] (03PS2) 10Eileen: Bolster up found check [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/868171 (https://phabricator.wikimedia.org/T325042) [21:16:16] 10Fundraising Sprint Wibbly Wobbly Timey Wimey, 10Fundraising-Backlog, 10FR-dlocal: Add technical diagram of dlocal integration interactions - https://phabricator.wikimedia.org/T324621 (10jgleeson) Smart Fields with Optional 3d-Secure https://docs.dlocal.com/docs/3d-secure#optional-3d-secure {F35864892} [21:21:36] (03PS3) 10Wfan: Render smartfield ui to the dlocal gateway page [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/868161 (https://phabricator.wikimedia.org/T324271) [21:27:15] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Analyse 'anonymous' no thankyou records - https://phabricator.wikimedia.org/T325042 (10Eileenmcnaughton) @LeanneS @MDemosWMF we are following up some theories here - but in the meantime if we remove the anonymous from those who have them the email should... [21:30:24] (03PS3) 10Ejegg: Bolster up found check [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/868171 (https://phabricator.wikimedia.org/T325042) (owner: 10Eileen) [21:30:30] (03CR) 10Ejegg: [C: 03+2] Bolster up found check [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/868171 (https://phabricator.wikimedia.org/T325042) (owner: 10Eileen) [21:44:48] (03Merged) 10jenkins-bot: Bolster up found check [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/868171 (https://phabricator.wikimedia.org/T325042) (owner: 10Eileen) [21:46:03] (03PS1) 10Eileen: Merge branch 'master' of ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/868174 [21:47:24] (03CR) 10Eileen: [C: 03+2] Merge branch 'master' of ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/868174 (owner: 10Eileen) [21:55:15] !log civicrm upgraded from a65bc00a to a1c2630a [21:55:17] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [21:55:47] 10Fundraising Sprint Turtles that are robotic that destroy the whole world with their foot theory, 10Fundraising Sprint Undefined, 10Fundraising Sprint Wibbly Wobbly Timey Wimey, 10Fundraising-Backlog, and 5 others: SSL cert for links.email.wikimedia.org - https://phabricator.wikimedia.org/T188561 (10greg)... [22:07:30] 10Fundraising Sprint Wibbly Wobbly Timey Wimey, 10Fundraising-Backlog: Jimmy Tweet stats - https://phabricator.wikimedia.org/T325029 (10jgleeson) @Pcoombe do you know where the "fr-redir" banner is being set by chance? I was assuming it might have been a placeholder for redirected traffic but wanted to confirm... [22:23:21] (03CR) 10Cstone: [C: 03+2] "Looks good!" [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/867722 (https://phabricator.wikimedia.org/T323658) (owner: 10Ejegg) [22:23:53] (03Merged) 10jenkins-bot: Adyen audit: variant can change method [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/867722 (https://phabricator.wikimedia.org/T323658) (owner: 10Ejegg) [22:27:30] ejegg: plot twist - a lot actually don't have emails - so we were assuming they mostly DID [22:33:06] (03CR) 10Ejegg: "Some initial feedback" [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/868161 (https://phabricator.wikimedia.org/T324271) (owner: 10Wfan) [22:34:19] (03PS1) 10Eileen: Change messaging for when no email is found [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/868186 (https://phabricator.wikimedia.org/T325042) [22:34:46] (03CR) 10Ejegg: [C: 04-1] "one thing to remove" [wikimedia/fundraising/dev] - 10https://gerrit.wikimedia.org/r/868160 (https://phabricator.wikimedia.org/T324271) (owner: 10Wfan) [22:35:07] Thanks ejegg: for the commends, on that [22:38:03] (03PS2) 10Wfan: Add dlocal smart field script and api key [wikimedia/fundraising/dev] - 10https://gerrit.wikimedia.org/r/868160 (https://phabricator.wikimedia.org/T324271) [22:38:14] (03CR) 10Wfan: Add dlocal smart field script and api key (031 comment) [wikimedia/fundraising/dev] - 10https://gerrit.wikimedia.org/r/868160 (https://phabricator.wikimedia.org/T324271) (owner: 10Wfan) [22:40:06] sure thing wfan :) [22:40:33] oho eileen, that's actually a bit reassuring [22:40:40] and thank you for the review cstone [22:40:48] i'll get to tagging versions [22:44:24] ejegg: ok so not many contacts in the last 30 days - the plan is to change the message slightly (https://gerrit.wikimedia.org/r/868186 ) & then monitor after next imports [22:49:05] Aha - ejegg I missed a beat - the contribution was imported to the email-less 57825115 & then later merged to the email-with 239539 [22:50:50] so yeah - mystery solved [22:51:48] what we COULD do is some extra work on merge to remove 'no email' from the thank you thing when merging - although these are odd balls as non-email contacts are only merged manually [22:52:37] (03PS1) 10Ejegg: Update SmashPig version and own version number [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/868188 [22:52:40] (03CR) 10Ejegg: [C: 03+2] Update SmashPig version and own version number [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/868188 (owner: 10Ejegg) [23:05:37] (03Merged) 10jenkins-bot: Update SmashPig version and own version number [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/868188 (owner: 10Ejegg) [23:06:36] (03PS4) 10Wfan: Render smartfield ui to the dlocal gateway page [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/868161 (https://phabricator.wikimedia.org/T324271) [23:09:07] (03PS1) 10Eileen: Remove anonymous email check [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/868195 [23:09:11] (03PS1) 10Ejegg: Update SmashPig and DonationInterface [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/868196 [23:09:17] (03CR) 10Ejegg: [C: 03+2] Update SmashPig and DonationInterface [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/868196 (owner: 10Ejegg) [23:13:23] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 10Patch-For-Review: Analyse 'anonymous' no thankyou records - https://phabricator.wikimedia.org/T325042 (10Eileenmcnaughton) OK - there are a couple of things I missed in the first round so this is waaay less mysterious than I thought 1) almost all th... [23:14:25] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: I ain't got nobody - https://phabricator.wikimedia.org/T325254 (10Eileenmcnaughton) [23:14:57] (03PS5) 10Wfan: Render smartfield ui to the dlocal gateway page [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/868161 (https://phabricator.wikimedia.org/T324271) [23:15:18] (03PS2) 10Eileen: Remove anonymous email check [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/868195 (https://phabricator.wikimedia.org/T325254) [23:22:41] (03Merged) 10jenkins-bot: Update SmashPig and DonationInterface [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/868196 (owner: 10Ejegg) [23:27:06] (03PS1) 10Ejegg: Update SmashPig and DLocal [wikimedia/fundraising/crm/vendor] - 10https://gerrit.wikimedia.org/r/868200 [23:27:10] (03CR) 10Ejegg: [C: 03+2] Update SmashPig and DLocal [wikimedia/fundraising/crm/vendor] - 10https://gerrit.wikimedia.org/r/868200 (owner: 10Ejegg) [23:27:43] (03PS1) 10Ejegg: Merge branch 'master' into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/868201 [23:27:48] (03CR) 10Ejegg: [C: 03+2] Merge branch 'master' into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/868201 (owner: 10Ejegg) [23:38:42] (03PS10) 10Ejegg: Handle errors in PayPal GetExpressCheckoutDetails [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/857150 (https://phabricator.wikimedia.org/T322570) (owner: 10Wfan) [23:39:20] (03Merged) 10jenkins-bot: Update SmashPig and DLocal [wikimedia/fundraising/crm/vendor] - 10https://gerrit.wikimedia.org/r/868200 (owner: 10Ejegg) [23:39:22] (03CR) 10Ejegg: [C: 03+2] Handle errors in PayPal GetExpressCheckoutDetails [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/857150 (https://phabricator.wikimedia.org/T322570) (owner: 10Wfan) [23:39:58] (03Merged) 10jenkins-bot: Handle errors in PayPal GetExpressCheckoutDetails [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/857150 (https://phabricator.wikimedia.org/T322570) (owner: 10Wfan) [23:43:05] ok, gonna deploy those library updates to crm [23:44:53] !log civicrm upgraded from a1c2630a to 98b48b9a [23:44:55] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log