[00:08:59] (PS3) Eileen: Copy existing full build for export stats to rebuild file [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/612694 [00:18:20] that matching gifts job is failing on 'invalid string; - not super descriptive [00:30:15] crap [00:30:31] ok, it's done the loop at least [00:31:04] I bet it's JSON-encoding the subsidiary list [00:31:09] and there's a weird character [00:31:32] let's see, we should be able to find the first unprocessed company ID in the job progress table [00:31:46] I also want to fix for when the online_resources array is empty [00:31:52] it's currently logging warnings [00:46:39] fr-tech https://twitter.com/sharifshameem/status/1282676454690451457 [00:47:10] ^ ThE eNd Of tHe (cOdIng) wOrlD aS wE kNow iT [00:48:24] haha, that's great [00:49:16] the giraffes are subpar [00:49:51] Give it 10 years [00:50:03] https://www.technologyreview.com/2020/07/20/1005454/openai-machine-learning-language-generator-gpt-3-nlp/ [01:29:07] I want access to this UI generator just to run some of the "clients from hell" comments through it [01:29:07] Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Fix Matching Gift policy sync - https://phabricator.wikimedia.org/T257963 (Ejegg) Running this again it hang on company_id 15000857. The bad string comes from when we are trying to find a matching company b... [01:30:18] ohh yes [01:30:32] or this video: https://youtu.be/BKorP55Aqvg [01:57:25] (PS1) Eileen: Upgrade to 5.27.2 [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/614911 [01:57:27] (PS1) Eileen: Remaining wmf hacks reapplied [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/614912 (https://phabricator.wikimedia.org/T254205) [02:02:17] (CR) jerkins-bot: [V: -1] Upgrade to 5.27.2 [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/614911 (owner: Eileen) [02:13:15] dstrine: omg that video is insane [02:15:23] Fundraising Sprint Lazy Loading Life, Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, and 3 others: Q4 FY2019/20 investigate export and upload issues with the silverpop export - https://phabricator.wikimedia.org/T253152 (Eileenmcnaught... [02:18:20] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, fundraising-tech-ops, Patch-For-Review: Fix stuck recurring contributions, add alarm - https://phabricator.wikimedia.org/T258013 (MBeat33) Thank you, @Ejegg we could probably divide the list among DS agents and just use the Send Failure Notifica... [02:25:38] (CR) Eileen: [C: +2] "I tested this & it works well - the only thing I would note, which I don't think is blocking, is code style." [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/612949 (https://phabricator.wikimedia.org/T257001) (owner: Mepps) [02:29:13] (CR) jerkins-bot: [V: -1] Upgrade org.wikimedia.forgetme to store deleted email ids [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/612949 (https://phabricator.wikimedia.org/T257001) (owner: Mepps) [02:29:39] (CR) Eileen: [C: +2] "recheck" [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/612949 (https://phabricator.wikimedia.org/T257001) (owner: Mepps) [02:30:35] (CR) jerkins-bot: [V: -1] Upgrade org.wikimedia.forgetme to store deleted email ids [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/612949 (https://phabricator.wikimedia.org/T257001) (owner: Mepps) [02:31:19] (CR) Eileen: [C: +2] "recheck" [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/612949 (https://phabricator.wikimedia.org/T257001) (owner: Mepps) [02:38:21] (PS1) Eileen: Merge branch 'master' of https://gerrit.wikimedia.org/r/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - https://gerrit.wikimedia.org/r/614914 [02:38:40] (CR) Eileen: [C: +2] Merge branch 'master' of https://gerrit.wikimedia.org/r/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - https://gerrit.wikimedia.org/r/614914 (owner: Eileen) [02:43:18] !log civicrm revision changed from 7f1e7d8e38 to cc5d17fbaf, config revision is 23460676f6 [02:43:22] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [02:52:13] Fundraising Sprint Lazy Loading Life, Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, and 3 others: Add silverpop privacy delete routine - https://phabricator.wikimedia.org/T257001 (Eileenmcnaughton) @mepps I just deployed this - my i... [03:20:23] Fundraising-Backlog, FR-Ingenico: Ingenico: server timeout message for successful contribs? 7/21/2020 - https://phabricator.wikimedia.org/T258462 (MBeat33) [03:23:12] Fundraising-Backlog, FR-Ingenico: Ingenico: server timeout message for successful contribs? 7/21/2020 - https://phabricator.wikimedia.org/T258462 (MBeat33) [03:34:57] (PS3) Eileen: Add modified_date to silverpop_export and filter final view on it. [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/614853 (https://phabricator.wikimedia.org/T253152) [03:42:07] (CR) Eileen: Extract running of queries to a function (3 comments) [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/610663 (https://phabricator.wikimedia.org/T253152) (owner: Eileen) [04:11:20] Fundraising-Backlog, FR-Ingenico: Ingenico: server timeout message for successful contribs? 7/21/2020 - https://phabricator.wikimedia.org/T258462 (Ejegg) Dang - could this have anything to do with the TY page switchover? It loads fine for me, but I notice that the DNS resolution for donate.wikipedia.org... [04:38:19] Fundraising-Backlog, FR-Ingenico: Ingenico: server timeout message for successful contribs? 7/21/2020 - https://phabricator.wikimedia.org/T258462 (Ejegg) Just looked briefly so far, and donors 1 and 2 have multiple lines in the logs showing a redirect to the new TY page, meaning everything was successful... [06:36:32] (PS6) Eileen: Move diacritics resolve to the deduper extension [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/613010 (https://phabricator.wikimedia.org/T256316) [06:36:34] (PS2) Eileen: Move casing to deduper extennsion [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/613016 (https://phabricator.wikimedia.org/T256316) [06:36:36] (PS1) Eileen: Reformat code- primarily array format style [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/614918 (https://phabricator.wikimedia.org/T256316) [06:36:38] (PS1) Eileen: General IDE-driven cleanup on test class [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/614919 (https://phabricator.wikimedia.org/T256316) [06:43:20] (CR) jerkins-bot: [V: -1] General IDE-driven cleanup on test class [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/614919 (https://phabricator.wikimedia.org/T256316) (owner: Eileen) [06:43:57] Fundraising-Backlog, FR-Ingenico: Ingenico: server timeout message for successful contribs? 7/21/2020 - https://phabricator.wikimedia.org/T258462 (krobinson) #768065 / CID 11090563 It's possible we have just found an example of one of these who used PayPal. I'm not 100% sure it's the same error, but it... [06:45:07] (PS2) Eileen: General IDE-driven cleanup on test class [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/614919 (https://phabricator.wikimedia.org/T256316) [06:45:09] (PS1) Eileen: Add new shell wmf-civicrm extension [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/614920 [12:39:27] Fundraising-Backlog, FR-Ingenico: Ingenico: server timeout message for successful contribs? 7/21/2020 - https://phabricator.wikimedia.org/T258462 (Pcoombe) I tried the TY page from Japan using a VPN, and it looked fine [12:42:54] Fundraising-Backlog, FR-Ingenico: Ingenico: server timeout message for successful contribs? 7/21/2020 - https://phabricator.wikimedia.org/T258462 (krobinson) Not sure if this is related, but as you mentioned DNS, @Ejegg - we may have a screenshot: #768146. This one was via Adyen, NL donor. It doesn't... [13:31:34] Fundraising Sprint Lazy Loading Life, Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, and 3 others: Q4 FY2019/20 investigate export and upload issues with the silverpop export - https://phabricator.wikimedia.org/T253152 (KHaggard) Awe... [13:49:51] Fundraising-Backlog, FR-Ingenico: Ingenico: server timeout message for successful contribs? 7/21/2020 - https://phabricator.wikimedia.org/T258462 (Pcoombe) Ah, something is redirecting mobile devices to the .m.wikipedia.org domain. I can reproduce on my phone. [14:18:30] Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, fundraising-tech-ops: map out a civicrm.log_% table data expiration/delete strategy - https://phabricator.wikimedia.org/T257232 (Jgreen) >>! In T257232#6320720, @mepps wrote: > What's the definition of done on this task? I see a merged p... [14:25:27] Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog: Fix jsonlint failure affecting CiviCRM CI Job - https://phabricator.wikimedia.org/T258224 (jgleeson) a:jgleeson [14:27:46] Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, fundraising-tech-ops: map out a civicrm.log_% table data expiration/delete strategy - https://phabricator.wikimedia.org/T257232 (mepps) My understanding was that we'd discussed a year for the log tables but the only question was whether... [14:29:06] tzag fr-tech [14:30:45] Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, fundraising-tech-ops: map out a civicrm.log_% table data expiration/delete strategy - https://phabricator.wikimedia.org/T257232 (Jgreen) >>! In T257232#6322876, @mepps wrote: > My understanding was that we'd discussed a year for the log... [14:32:25] PROBLEM - check_recurring_contrib_processing on frdb1002 is CRITICAL: CRITICAL recurring_contrib_processing=783 [critical =500] [14:33:09] tzag mepps [14:34:41] hi jgleeson [14:35:33] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, fundraising-tech-ops, Patch-For-Review: Fix stuck recurring contributions, add alarm - https://phabricator.wikimedia.org/T258013 (Jgreen) >>! In T258013#6321346, @Dwisehaupt wrote: > Icinga alarm added to check_fundraising_job where other recurr... [14:37:04] Fundraising-Backlog, FR-Ingenico: Ingenico: server timeout message for successful contribs? 7/21/2020 - https://phabricator.wikimedia.org/T258462 (mepps) For now, I've rolled back the thankyou page going to donate.wikipedia.org. [14:37:25] PROBLEM - check_recurring_contrib_processing on frdb1002 is CRITICAL: CRITICAL recurring_contrib_processing=783 [critical =500] [14:38:24] Fundraising-Backlog, Wikimedia-Fundraising-Banners: Hover text is offset significantly from form - https://phabricator.wikimedia.org/T258287 (DStrine) @jbolorinos-ctr I have a personal dell laptop running the same version of windows home and chrome and I cannot reproduce this. I have checked the url you... [14:38:29] Fundraising-Backlog, FR-Ingenico: Ingenico: server timeout message for successful contribs? 7/21/2020 - https://phabricator.wikimedia.org/T258462 (MBeat33) Thank you @mepps and @Pcoombe [14:39:15] ACKNOWLEDGEMENT - check_recurring_contrib_processing on frdb1002 is CRITICAL: CRITICAL recurring_contrib_processing=783 [critical =500] Jeff_Green Yup, we know. [15:00:52] Fundraising-Backlog, FR-Q2-FY2020-21-cleanup-list: Make easy on/off switch for Monthly covert - https://phabricator.wikimedia.org/T250918 (DStrine) [15:06:59] Fundraising Sprint Lazy Loading Life, Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog: Fr-tech engineer should take on chores this sprint - https://phabricator.wikimedia.org/T254938 (mepps) Moving to done since the sprint is almost ove... [15:08:14] Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, FR-Ingenico: Ingenico: server timeout message for successful contribs? 7/21/2020 - https://phabricator.wikimedia.org/T258462 (DStrine) [15:08:47] Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, FR-Ingenico: Ingenico: server timeout message for successful contribs? 7/21/2020 - https://phabricator.wikimedia.org/T258462 (mepps) Traffic has a patch up for this. We'll just need to wait for them to deploy it. https://gerrit.wikimedia... [15:20:28] Wikimedia-Fundraising-Banners: 2020-07-21 enIN pre-test: mobile small batch - https://phabricator.wikimedia.org/T258283 (jbolorinos-ctr) Screenshot Test Results - Mobile: - Control: https://app.crossbrowsertesting.com/public/i15b74a2dc92badb/screenshots/z03841c17eb965cc2611 [16:08:31] Fundraising-Backlog, Wikimedia-Fundraising-Banners: Hover text is offset significantly from form - https://phabricator.wikimedia.org/T258287 (spatton) p:Triage→Low [16:12:41] tzag fr-tech [16:13:09] tzag AndyRussG [16:14:44] cstone: :) [16:16:01] hi AndyRussG [16:16:19] ejegg: :) [16:17:58] mepps so this is the line breaking the matching gifts sync: https://phabricator.wikimedia.org/diffusion/WFCH/browse/master/api/v3/utils.php$872 [16:18:20] the name of the company in question starts with 'Select' [16:18:32] * ejegg facepalm [16:19:50] bobby tables's cousin select? [16:20:48] https://issues.civicrm.org/jira/browse/CRM-16913 [16:21:25] haha [16:21:25] Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, fundraising-tech-ops: map out a civicrm.log_% table data expiration/delete strategy - https://phabricator.wikimedia.org/T257232 (mepps) My understanding is that we have a lot of flexibility here. I'm pretty sure we could choose either 1... [16:22:13] nice, the relevant xkcd was copied into the bug comments [16:24:06] ahh ejegg this reminds me of when someone had the last name NULL [16:24:36] saboteur... [16:24:49] (or just scottish) [16:25:22] lol [16:25:27] ah no, irish: https://www.houseofnames.com/null-family-crest [16:26:37] so I guess this is an opportunity to get more familiar with apiv4 [16:26:42] shouldn't take more than an hr [16:26:45] :) [16:26:48] or two [16:27:17] The podcast "reply all" had an episode where they discovered that the firmware in some car audio systems broke in weird and amazing ways when a user played "99% invisible" because it had the % sign in the name [16:28:21] format strings [16:30:14] ejegg maybe there shoudl be a task? [16:30:41] or it looks like there is one [16:30:45] or justhmm, more work on the 'fix' ticket? [16:30:52] s/hmm,// [16:31:12] that works ejegg :) [16:31:33] if you want to pair in half an hour on it ejegg i'll be around [16:42:18] cool! [16:42:48] I think I may have just switched the search over, but the create will be slightly more involved [16:43:01] fr-tech we're getting some consistent reports that amex isn't working for india donors. some transactions were just attempted a few minutes ago. Would anyone be able to check logs or see if you seen any errors on your end? [16:45:19] (PS1) Ejegg: Avoid warning when no 'online_resources' in MG sync [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/615261 (https://phabricator.wikimedia.org/T257963) [16:45:24] sure i'm poking around dstrine [16:45:41] thanks mepps ! I started a task: https://phabricator.wikimedia.org/T258509 [16:48:07] (PS1) Ejegg: MG sync: use API v4 to find organizations [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/615262 (https://phabricator.wikimedia.org/T257963) [16:51:30] back in a sec, rebooting [16:54:48] Fundraising-Backlog: AMEX cards not working for india donors - https://phabricator.wikimedia.org/T258509 (mepps) Hmm so with amex I'm seeing: ` Jul 21 16:14:05 payments1003 astropay_gateway: 81407443:81407443.1 Sending donor details for 81407443.1 to pending queue Jul 21 16:15:04 payments1002 astropay_gate... [16:55:03] (CR) jerkins-bot: [V: -1] MG sync: use API v4 to find organizations [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/615262 (https://phabricator.wikimedia.org/T257963) (owner: Ejegg) [16:59:09] Wikimedia-Fundraising-Banners: Banner remains visible after user enters a valid email and clicks submit - https://phabricator.wikimedia.org/T253147 (jbolorinos-ctr) Open→Declined [16:59:11] Wikimedia-Fundraising-Banners: [CANDIDATE] QA for 'RML options' banner - https://phabricator.wikimedia.org/T253054 (jbolorinos-ctr) [17:00:29] Fundraising-Backlog: AMEX cards not working for india donors - https://phabricator.wikimedia.org/T258509 (mepps) I see the url returned correctly for the amex transaction too. [17:02:52] oh hmm, custom fields are accessed differently in apiv4 [17:03:01] I can only assume it's an improvement [17:04:47] it IS! [17:08:15] (PS2) Ejegg: MG sync: use API v4 to find organizations [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/615262 (https://phabricator.wikimedia.org/T257963) [17:14:32] It certainly reads cleaner. [17:14:36] (CR) jerkins-bot: [V: -1] MG sync: use API v4 to find organizations [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/615262 (https://phabricator.wikimedia.org/T257963) (owner: Ejegg) [17:16:08] Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, fundraising-tech-ops: map out a civicrm.log_% table data expiration/delete strategy - https://phabricator.wikimedia.org/T257232 (Jgreen) >>! In T257232#6323282, @mepps wrote: > My understanding is that we have a lot of flexibility here.... [17:16:16] Fundraising-Backlog: AMEX cards not working for india donors - https://phabricator.wikimedia.org/T258509 (mepps) @DStrine @MBeat33 do we know if they got this message before or after getting redirected or before? Also both these transactions got the same risk score so it should not be fraud related. [17:16:25] Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, fundraising-tech-ops: map out a civicrm.log_% table data expiration/delete strategy - https://phabricator.wikimedia.org/T257232 (Jgreen) [17:16:27] Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, fundraising-tech-ops: map out a civicrm.log_% table data expiration/delete strategy - https://phabricator.wikimedia.org/T257232 (mepps) That sounds good to me @Jgreen. [17:16:37] Wikimedia-Fundraising-Banners: Banner remains visible after user enters a valid email and clicks submit - https://phabricator.wikimedia.org/T253147 (jbolorinos-ctr) Closing as 'Declined' since this isn't needed at the time, if this variant is revisited in the future will file new enhancement as needed. @spa... [17:18:57] Fundraising-Backlog: AMEX cards not working for india donors - https://phabricator.wikimedia.org/T258509 (EMartin) Why is it that I see that Praveen cleared an AMEX transaction yesterday: 81380244.2? Are we certain he didn't hit a velocity filter? Dlocal is saying it is working ok but they are checking with... [17:24:36] Fundraising-Backlog: AMEX cards not working for india donors - https://phabricator.wikimedia.org/T258509 (mepps) @EMartin That txn # is one that went through correctly right? [17:26:28] Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, fundraising-tech-ops: map out a civicrm.log_% table data expiration/delete strategy - https://phabricator.wikimedia.org/T257232 (Dwisehaupt) I support the rolling 550 day mark. That gives one full calendar year plus coverage to get a ful... [17:28:06] fr-tech looks like cdanis and the traffic team deployed the fix to the varnish caches about 20 minutes ago [17:28:14] saying that it should take effect in 30 min [17:28:40] so in 10 min or so we can test on our phones and try restoring the new TY url [17:30:11] ejegg: yay! [17:35:00] Fundraising-Backlog: AMEX cards not working for india donors - https://phabricator.wikimedia.org/T258509 (mepps) @EMartin I've checked a couple amex txns that didn't get to the thank you page and I'm seeing an IP Velocity Filter of 0. [17:36:04] mepps are they saying AMEX donors didn't get to the TY page? Could it be the same mobile problem? [17:41:40] ejegg: should be live everywhere now, btw [17:42:53] cdanis: thanks so much! :) :) [17:43:10] awesome cdanis [17:43:33] fr-tech if I'm gonna fiddle with silverpop export, and I work with civi in vagrant, that's where I should look at silverpop, too, I guess? [17:44:03] AndyRussG: the silverpop export is mostly under the 'tools' repo [17:44:10] it's written in python [17:44:18] ejegg: right, but doesn't it take stuff from civi to export? [17:44:30] I see in the tools readme instructions for a test db [17:45:07] Oh looks like that's just for running tests, not development work [17:46:45] yeah, it does export the info from the civicrm db [17:47:21] ejegg: so that's why I should also work on it in vagrant, no? [17:47:40] oh sure, yep [17:47:50] ejegg: okok cool thanks! [17:51:45] Fundraising-Backlog: AMEX cards not working for india donors - https://phabricator.wikimedia.org/T258509 (mepps) 81407747 is another one where I don't see the donor getting to the thank you page. I also don't see an error page record. [17:59:54] ejegg have we restored the thank you url? [18:06:50] Wikimedia-Fundraising-Banners: Remove hover text from banners - https://phabricator.wikimedia.org/T258517 (jbolorinos-ctr) [18:07:03] Wikimedia-Fundraising-Banners: Remove hover text from banners - https://phabricator.wikimedia.org/T258517 (jbolorinos-ctr) p:Triage→Lowest [18:18:38] mepps not yet, let's test on our phones from our various locales first! [18:19:52] ok, working for me in mobile android & FF [18:21:47] nice ejegg! [18:22:15] Can anyone else confirm from other regions? [18:22:30] do you need to do anything special to get it to show up? [18:22:47] checking now [18:22:54] just go directly to donate.wikipedia.org/wiki/Thank_You on the phone [18:23:13] and make sure it doesn't redirect to donate.m.wikipedia.org [18:23:31] works over this side of the water! [18:23:34] ok cool looks good on android chrome [18:23:35] great! [18:23:48] OK, I'll restore that [18:27:04] !log restored new URL for TY page in payments-wiki settings [18:27:08] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [18:27:14] ok, gonna grab lunch [18:54:28] Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, FR-Ingenico: Ingenico: server timeout message for successful contribs? 7/21/2020 - https://phabricator.wikimedia.org/T258462 (jrobell) Thank you for working on a fix for this, fr-tech team! From my understanding, the issue came from fixi... [19:01:54] Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, FR-Ingenico: Ingenico: server timeout message for successful contribs? 7/21/2020 - https://phabricator.wikimedia.org/T258462 (Ejegg) > Is there a step in the QA process that we could add in order to avoid this type of issue to come up ag... [19:02:59] Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog: Fix jsonlint failure affecting CiviCRM CI Job - https://phabricator.wikimedia.org/T258224 (DStrine) Open→Resolved [19:03:45] Fundraising Sprint Lazy Loading Life, Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, and 2 others: Add silverpop privacy delete routine - https://phabricator.wikimedia.org/T257001 (DStrine) Open→Resolved [19:03:48] Fundraising Sprint Lazy Loading Life, Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, and 3 others: Q4 FY2019/20 investigate export and upload issues with the silverpop export - https://phabricator.wikimedia.org/T253152 (DStrine) [19:03:58] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, fundraising-tech-ops: Fix stuck recurring contributions, add alarm - https://phabricator.wikimedia.org/T258013 (jrobell) @Jgreen Icinga alarm added to check_fundraising_job where other recurring alerts are triggered. I have found a way to have it no... [19:04:48] Fundraising-Backlog, Epic: Epic: matching gifts HEP integration (was employer field V2) - https://phabricator.wikimedia.org/T228765 (DStrine) [19:05:27] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, fundraising Sprint Grep works IRL, and 4 others: TY pages in a subdomain of wikipedia and set hide banner cookie - https://phabricator.wikimedia.org/T251780 (DStrine) Open→Resolved [19:05:30] Fundraising-Backlog, fundraising Sprint Grep works IRL, MediaWiki-extensions-CentralNotice, Epic: EPIC: Find alternative to Special:HideBanners cookies to mitigate the loss of 3rd-party cookie support - https://phabricator.wikimedia.org/T244699 (DStrine) [19:06:20] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, Patch-For-Review: Japanese MC 2nd Upsell Email - https://phabricator.wikimedia.org/T255227 (DStrine) Open→Resolved [19:06:43] Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog: New Ingenico API key required before July 29,2020 - https://phabricator.wikimedia.org/T256408 (DStrine) Open→Resolved [19:07:42] Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, fundraising-tech-ops: map out a civicrm.log_% table data expiration/delete strategy - https://phabricator.wikimedia.org/T257232 (Eileenmcnaughton) I think some tables have more value for old data than others - notably contact & email data [19:11:00] Fundraising-Backlog, Epic: Epic: matching gifts HEP integration (was employer field V2) - https://phabricator.wikimedia.org/T228765 (DStrine) [19:11:02] Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, MW-1.35-notes (1.35.0-wmf.41; 2020-07-14): In the DonationInterface form, handle case in which a user clicks on an employer from the dropdown, then types the name of an employer not on the list - https://phabricator.wikimedia.org/T256838 (... [19:11:58] Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog: Payments Wiki form variant w/ PAN field explanation text - https://phabricator.wikimedia.org/T257844 (DStrine) Open→Resolved [19:12:31] Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, Patch-For-Review: Update silverpop ftp upload script to push up new matching gifts csv - https://phabricator.wikimedia.org/T257000 (DStrine) Open→Resolved [19:13:02] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog: Japanese TY Email - https://phabricator.wikimedia.org/T254052 (DStrine) Open→Resolved [19:21:44] Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, fundraising-tech-ops: map out a civicrm.log_% table data expiration/delete strategy - https://phabricator.wikimedia.org/T257232 (Jgreen) >>! In T257232#6323826, @Eileenmcnaughton wrote: > I think some tables have more value for old data... [19:44:07] Wikimedia-Fundraising-Banners: [Mobile Lg + Sm][Android] No spacing between currency symbol and amount in main copy and PTF text - https://phabricator.wikimedia.org/T258411 (Pcoombe) @spatton @jbolorinos-ctr @EWilfong_WMF Okay, hopefully this fix works consistently. I've tested repeatedly on my device and... [19:47:41] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, fundraising-tech-ops: Fix stuck recurring contributions, add alarm - https://phabricator.wikimedia.org/T258013 (MBeat33) David and Dylan confirmed the alerts will take the form of Icinga failmails sent to the fr-tech list, which I'm on, so that work... [19:48:39] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, fundraising-tech-ops: Fix stuck recurring contributions, add alarm - https://phabricator.wikimedia.org/T258013 (MBeat33) also, @Ejegg do you know when you might be able to generate the list of CIDs? [19:51:19] fundraising-tech-ops: Migrate DjangoBannerStats processing and database to fundraising analytics cluster - https://phabricator.wikimedia.org/T258526 (Jgreen) [19:55:13] Fundraising-Backlog, fundraising-tech-ops, FR-Tech-Analytics: investigate moving non-essential databases (faulkner, pgehres, fredge) off of fundraising database cluster - https://phabricator.wikimedia.org/T255456 (Jgreen) [19:55:44] Fundraising-Backlog, fundraising-tech-ops, FR-Tech-Analytics: investigate moving non-essential databases (faulkner, pgehres, fredge) off of fundraising database cluster - https://phabricator.wikimedia.org/T255456 (Jgreen) Open→Resolved p:Triage→Medium a:Jgreen Investigation is com... [19:55:46] Fundraising-Backlog, fundraising-tech-ops, Epic: Epic: fundraising database approaching data partition capacity - https://phabricator.wikimedia.org/T241083 (Jgreen) [19:56:24] Fundraising Sprint Lazy Loading Life, Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, FR-Email: Small number of contacts being inappropriately put on the suppression list - https://phabricator.wikimedia.org/T256522 (Eileenmcnaughton) a:Eil... [19:56:48] Fundraising-Backlog: Fr-tech shores list - https://phabricator.wikimedia.org/T258527 (DStrine) [19:57:48] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, FR-Q2-FY2020-21-cleanup-list, FR-Email: Silverpop export: move the suppression list to a different job - https://phabricator.wikimedia.org/T256073 (Eileenmcnaughton) a:Eileenmcnaughton→None [19:58:28] Fundraising Sprint Lazy Loading Life, Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog: Fr-tech engineer should take on chores this sprint - https://phabricator.wikimedia.org/T254938 (DStrine) Open→Resolved [19:59:14] fundraising-tech-ops: Migrate DjangoBannerStats processing and database to fundraising analytics cluster - https://phabricator.wikimedia.org/T258526 (Jgreen) [x] configured nfs mount fran1001 -> frban1001 for access to impression logs [x] disabled 'pgehres' database replication to frdb1003 [x] installed Djan... [19:59:34] Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, FR-Ingenico: Ingenico: server timeout message for successful contribs? 7/21/2020 - https://phabricator.wikimedia.org/T258462 (DStrine) Open→Resolved [19:59:44] fundraising-tech-ops: Migrate DjangoBannerStats processing and database to fundraising analytics cluster - https://phabricator.wikimedia.org/T258526 (Jgreen) Next step is to migrate users to frdb1003/pgehres database. [19:59:59] Fundraising-Backlog: Fr-tech chores list - https://phabricator.wikimedia.org/T258527 (DStrine) [20:00:17] fundraising-tech-ops: Migrate DjangoBannerStats processing and database to fundraising analytics cluster - https://phabricator.wikimedia.org/T258526 (Jgreen) p:Triage→Medium [20:01:49] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog: Create job to update/generate employer dataset for usage within paymentswiki - https://phabricator.wikimedia.org/T251201 (jgleeson) Open→Resolved [20:01:51] Fundraising-Backlog, Epic: Epic: matching gifts HEP integration (was employer field V2) - https://phabricator.wikimedia.org/T228765 (jgleeson) [20:03:09] Fundraising-Backlog, fundraising-tech-ops: Plan for FY20-21 Q1 civicrm outage to upgrade civi1001 to Debian Buster - https://phabricator.wikimedia.org/T257985 (Jgreen) [20:03:11] Fundraising-Backlog, fundraising-tech-ops, Patch-For-Review: figure out Buster package for python3-mysql.connector for use with fruec - https://phabricator.wikimedia.org/T246823 (Jgreen) [20:03:13] fundraising-tech-ops, Patch-For-Review: rack/setup/install civi2001.frack.codfw.wmnet - https://phabricator.wikimedia.org/T242270 (Jgreen) [20:04:14] Fundraising-Backlog, fundraising-tech-ops: Plan for FY20-21 Q1 civicrm outage to upgrade civi1001 to Debian Buster - https://phabricator.wikimedia.org/T257985 (Jgreen) [20:07:06] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, fundraising Sprint Grep works IRL, and 4 others: TY pages in a subdomain of wikipedia and set hide banner cookie - https://phabricator.wikimedia.org/T251780 (Krinkle) Serving the same wi... [20:07:38] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, fundraising-tech-ops: Fix stuck recurring contributions, add alarm - https://phabricator.wikimedia.org/T258013 (Dwisehaupt) @jrobell @MBeat33 The icinga alert is a second layer of alerting on top of any failmails. It is currently set to send email a... [20:11:08] Fundraising-Backlog: Solving for Indian donors that don't have a PAN but want to donate - https://phabricator.wikimedia.org/T258086 (DStrine) [20:13:50] Wikimedia-Fundraising-Banners: [Mobile Lg + Sm][Android] No spacing between currency symbol and amount in main copy and PTF text - https://phabricator.wikimedia.org/T258411 (EWilfong_WMF) @Pcoombe - Confirming that you fix looks looks good to me in Browserstack testing. And IMO, the slight font weight chan... [20:14:31] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, fundraising-tech-ops: Fix stuck recurring contributions, add alarm - https://phabricator.wikimedia.org/T258013 (MBeat33) Many thanks for the clarification, @Dwisehaupt [20:18:22] (PS1) Ejegg: WIP try to tokenize monthlyConvert without recur flag [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/615297 (https://phabricator.wikimedia.org/T248626) [20:21:04] (CR) jerkins-bot: [V: -1] WIP try to tokenize monthlyConvert without recur flag [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/615297 (https://phabricator.wikimedia.org/T248626) (owner: Ejegg) [20:21:59] Fundraising-Backlog, Patch-For-Review: Move to 'Tokenize Parameter Field' for one-time tokens on initial recurring transactions - https://phabricator.wikimedia.org/T248626 (DStrine) [20:31:05] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Re-reun dedupe from 0 - https://phabricator.wikimedia.org/T245559 (Eileenmcnaughton) Open→Resolved a:Eileenmcnaughton We did this [20:32:32] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint Nyan cats for everyone, Fundraising Sprint O 2020, Fundraising-Backlog: Adyen recurring double recurring records in civi - https://phabricator.wikimedia.org/T257067 (DStrine) [20:32:34] Fundraising Sprint O 2020, Fundraising-Backlog: Fr-tech chores list - https://phabricator.wikimedia.org/T258527 (DStrine) [20:32:36] Fundraising Sprint O 2020, Fundraising-Backlog: AMEX cards not working for india donors - https://phabricator.wikimedia.org/T258509 (DStrine) [20:32:38] Fundraising Sprint O 2020, Fundraising-Backlog: Solving for Indian donors that don't have a PAN but want to donate - https://phabricator.wikimedia.org/T258086 (DStrine) [20:32:40] Fundraising Sprint Nyan cats for everyone, Fundraising Sprint O 2020, Fundraising-Backlog, FR-Ingenico: Convert the rest of old ingenico recurring to new - https://phabricator.wikimedia.org/T257172 (DStrine) [20:32:42] Fundraising Sprint Nyan cats for everyone, Fundraising Sprint O 2020, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Patch-For-Review: Fix Matching Gift policy sync - https://phabricator.wikimedia.org/T257963 (DStrine) [20:32:44] Fundraising Sprint Nyan cats for everyone, Fundraising Sprint O 2020, Fundraising-Backlog: Process to transfer MG employers data file between civi1001 and frpm1001 - https://phabricator.wikimedia.org/T256825 (DStrine) [20:32:46] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint Nyan cats for everyone, Fundraising Sprint O 2020, Fundraising-Backlog: Missing "unsubscribe" link in automatic recurring failure email - https://phabricator.wikimedia.org/T256162 (DStrine) [20:32:48] Fundraising Sprint Nyan cats for everyone, Fundraising Sprint O 2020, Fundraising-Backlog, FR-Q2-FY2020-21-cleanup-list: Duplicate donations with the same contribution tracking id - https://phabricator.wikimedia.org/T256037 (DStrine) [20:32:50] Fundraising Sprint Nyan cats for everyone, Fundraising Sprint O 2020, Fundraising-Backlog, FR-Civi-Dedupe, Patch-For-Review: Civi Dedupe: enable Deduper to handle multiple email addresses - https://phabricator.wikimedia.org/T256316 (DStrine) [20:32:54] Fundraising Sprint O 2020, Fundraising-Backlog, FR-Tech-Analytics, MediaWiki-extensions-CentralNotice: Banner history logger records incorrect status code following campaign fallback - https://phabricator.wikimedia.org/T255810 (DStrine) [20:32:58] Fundraising Sprint Lazy Loading Life, Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint Nyan cats for everyone, Fundraising Sprint O 2020, and 4 others: Q4 FY2019/20 investigate export and upload issues with the silverpop export - https://phabricator.wikimedia.org/T253152 (DStrine) [20:33:00] Fundraising Sprint O 2020, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, FR-Civi-Dedupe: Dedupe resolvable conflict -fix script to handle Casing with other things - https://phabricator.wikimedia.org/T242156 (DStrine) [20:33:02] Fundraising Sprint O 2020, Fundraising-Backlog, Patch-For-Review: Move to 'Tokenize Parameter Field' for one-time tokens on initial recurring transactions - https://phabricator.wikimedia.org/T248626 (DStrine) [20:33:04] Fundraising Sprint Nyan cats for everyone, Fundraising Sprint O 2020, Fundraising Sprint X-rays, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: rework fredge search to include new fields and general debug - https://phabricator.wikimedia.org/T239967 (DStrine) [20:33:06] Fundraising Sprint O 2020, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Readonly DB connection available to turn on - https://phabricator.wikimedia.org/T237350 (DStrine) [20:33:08] Fundraising Sprint Nyan cats for everyone, Fundraising Sprint O 2020, Fundraising-Backlog, fundraising-tech-ops: map out a civicrm.log_% table data expiration/delete strategy - https://phabricator.wikimedia.org/T257232 (DStrine) [20:35:44] Fundraising Sprint Lazy Loading Life, Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint Nyan cats for everyone, Fundraising Sprint O 2020, and 4 others: Q4 FY2019/20 investigate export and upload issues with the silverpop export - https://phabricator.wikimedia.org/T253152 (Eileenmc... [21:04:31] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, fundraising-tech-ops: Fix stuck recurring contributions, add alarm - https://phabricator.wikimedia.org/T258013 (jrobell) Great! Thank you! [21:15:42] Wikimedia-Fundraising-Banners: [Mobile Lg + Sm][Android] No spacing between currency symbol and amount in main copy and PTF text - https://phabricator.wikimedia.org/T258411 (jbolorinos-ctr) Screenshot Test Results mobile: - Mobile Large: https://app.crossbrowsertesting.com/public/i15b74a2dc92badb/screenshots... [21:16:35] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, fundraising-tech-ops: Fix stuck recurring contributions, add alarm - https://phabricator.wikimedia.org/T258013 (Ejegg) @MBeat33 OK, those files have been updated with CIDs (and a direct URL in the last column). Looks like one of our 3-digit CID dono... [21:21:02] Wikimedia-Fundraising-Banners: [Mobile Lg + Sm][Android] No spacing between currency symbol and amount in main copy and PTF text - https://phabricator.wikimedia.org/T258411 (jbolorinos-ctr) @Pcoombe everything looks good after reviewing the screenshot tests, so looks like we can close this as resolved now! :) [21:32:38] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, fundraising-tech-ops: Fix stuck recurring contributions, add alarm - https://phabricator.wikimedia.org/T258013 (MBeat33) Thanks, @Ejegg I d/l-ed both files but I don't see the URL column, I just get email firstname lastname language code and date -... [21:34:25] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, fundraising-tech-ops: Fix stuck recurring contributions, add alarm - https://phabricator.wikimedia.org/T258013 (Ejegg) Oops, my file manager was waiting to confirm that I wanted to replace 'em. Sorry about that - they're actually updated now! [21:37:02] Fundraising Sprint Octopus hugs, Fundraising-Backlog: AMEX cards not working for india donors - https://phabricator.wikimedia.org/T258509 (EMartin) Here is the AMEX transaction that cleared. Looking back at the prior campaign test, I see that only 27 out of 167 AMEX transactions got approved. This coul... [21:37:08] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, fundraising-tech-ops: Fix stuck recurring contributions, add alarm - https://phabricator.wikimedia.org/T258013 (MBeat33) Got them now, thanks! [21:58:55] Fundraising Sprint Octopus hugs, Fundraising-Backlog: AMEX cards not working for india donors - https://phabricator.wikimedia.org/T258509 (EMartin) I wanted to note here that AMEX was less than 1% of prior test volumes. It also had low approval rates at 13% in prior tests. The behavior may be typical of...