[01:45:16] PROBLEM - check_mysql on frdev1001 is CRITICAL: SLOW_SLAVE CRITICAL: Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 1202 [01:50:10] PROBLEM - check_mysql on frdev1001 is CRITICAL: SLOW_SLAVE CRITICAL: Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 1502 [01:52:19] Wikimedia-Fundraising-Banners: Early QA: Japan Banners - https://phabricator.wikimedia.org/T255813 (jbolorinos-ctr) [01:52:21] Wikimedia-Fundraising-Banners: Desktop Small - https://phabricator.wikimedia.org/T255896 (jbolorinos-ctr) Open→Invalid p:Triage→Medium Closing as invalid since there is no need to separate out QA testing tasks into sub-tasks [01:54:03] Wikimedia-Fundraising-Banners: RML Options not available on Ja banners - https://phabricator.wikimedia.org/T255893 (jbolorinos-ctr) Open→Resolved Thanks for the quick fix @Pcoombe! Fix verified {F31904506} Closing this now [01:54:05] Wikimedia-Fundraising-Banners: Early QA: Japan Banners - https://phabricator.wikimedia.org/T255813 (jbolorinos-ctr) [01:55:10] PROBLEM - check_mysql on frdev1001 is CRITICAL: SLOW_SLAVE CRITICAL: Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 1802 [01:57:17] Wikimedia-Fundraising-Banners: Early QA: Japan Banners - https://phabricator.wikimedia.org/T255813 (jbolorinos-ctr) Thanks for the update @Tskaff! @CDenes_WMF is there any estimate when the translations will be input on the JP banners? Ideally I'd appreciate the translations being input by the 28th at the... [02:00:16] PROBLEM - check_mysql on frdev1001 is CRITICAL: SLOW_SLAVE CRITICAL: Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 2102 [02:04:46] ACKNOWLEDGEMENT - check_mysql on frdev1001 is CRITICAL: SLOW_SLAVE CRITICAL: Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 2102 Dwisehaupt Silverpop export running [02:07:52] Wikimedia-Fundraising-Banners: [M Sm] Missing comma on donation amounts in older versions of Safari - https://phabricator.wikimedia.org/T256347 (jbolorinos-ctr) [02:08:35] Wikimedia-Fundraising-Banners: [M Sm] Missing comma on donation amounts in older versions of Safari - https://phabricator.wikimedia.org/T256347 (jbolorinos-ctr) p:Triage→Medium [02:13:31] Wikimedia-Fundraising-Banners: [All Controls] Missing comma on donation amounts in older versions of Safari - https://phabricator.wikimedia.org/T256347 (jbolorinos-ctr) [02:14:25] Wikimedia-Fundraising-Banners: [All Controls] Missing comma on donation amounts in older versions of Safari - https://phabricator.wikimedia.org/T256347 (jbolorinos-ctr) [02:25:16] RECOVERY - check_mysql on frdev1001 is OK: Uptime: 2629358 Threads: 3 Questions: 78918296 Slow queries: 161882 Opens: 1299621 Flush tables: 1 Open tables: 200 Queries per second avg: 30.014 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 0 [02:45:55] Wikimedia-Fundraising-Banners: Early QA: Japan Banners - https://phabricator.wikimedia.org/T255813 (CDenes_WMF) Hi John! You can find our schedule in the Asana [[ https://app.asana.com/0/1135745996980656/list | project ]] 'banner project management'. The banner coding will be happening within July 9-14, so y... [02:50:10] PROBLEM - check_mysql on frdev1001 is CRITICAL: SLOW_SLAVE CRITICAL: Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 1273 [02:51:40] ACKNOWLEDGEMENT - check_mysql on frdev1001 is CRITICAL: SLOW_SLAVE CRITICAL: Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 1273 Dwisehaupt More Silverpop export queries [02:55:16] RECOVERY - check_mysql on frdev1001 is OK: Uptime: 2631158 Threads: 3 Questions: 78937217 Slow queries: 161945 Opens: 1299645 Flush tables: 1 Open tables: 199 Queries per second avg: 30.000 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 0 [03:02:57] (PS1) Eileen: Silverpop refactor - reduce queries to build country & language [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/607652 [03:21:32] (Abandoned) Eileen: WIP address query [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/607101 (owner: Eileen) [03:36:10] (PS1) Eileen: Formatting only [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/607655 [03:40:37] (CR) DannyS712: [C: -1] Silverpop refactor - reduce queries to build country & language (1 comment) [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/607652 (owner: Eileen) [03:43:59] (CR) Eileen: Silverpop refactor - reduce queries to build country & language (1 comment) [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/607652 (owner: Eileen) [03:45:26] (PS2) Eileen: Silverpop refactor - reduce queries to build country & language [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/607652 [03:45:34] (Abandoned) Eileen: Formatting only [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/607655 (owner: Eileen) [04:05:30] (PS1) Eileen: Add index to civicrm_country.iso_code. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/607657 (https://phabricator.wikimedia.org/T253152) [04:08:52] (CR) jerkins-bot: [V: -1] Add index to civicrm_country.iso_code. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/607657 (https://phabricator.wikimedia.org/T253152) (owner: Eileen) [04:56:26] (PS10) Eileen: Filter matching gift policies on type [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/605340 (https://phabricator.wikimedia.org/T249924) (owner: Ejegg) [04:58:24] (CR) Eileen: [C: +2] "I looked through this and the actual change is pretty simple. Frustratingly I could only test it through the tests as viscosity full tunne" [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/605340 (https://phabricator.wikimedia.org/T249924) (owner: Ejegg) [05:11:16] PROBLEM - check_procs on fran1001 is CRITICAL: PROCS CRITICAL: 1002 processes [05:12:40] ACKNOWLEDGEMENT - check_procs on fran1001 is CRITICAL: PROCS CRITICAL: 1002 processes Dwisehaupt Known [05:15:50] (Merged) jenkins-bot: Filter matching gift policies on type [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/605340 (https://phabricator.wikimedia.org/T249924) (owner: Ejegg) [05:35:30] (PS7) Eileen: Matching gifts fetcher factory, beef up interface [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/605637 (https://phabricator.wikimedia.org/T249924) (owner: Ejegg) [05:37:29] (CR) jerkins-bot: [V: -1] Matching gifts fetcher factory, beef up interface [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/605637 (https://phabricator.wikimedia.org/T249924) (owner: Ejegg) [05:38:34] (CR) Eileen: Matching gifts fetcher factory, beef up interface (1 comment) [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/605637 (https://phabricator.wikimedia.org/T249924) (owner: Ejegg) [05:44:32] (CR) Eileen: "recheck" [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/605637 (https://phabricator.wikimedia.org/T249924) (owner: Ejegg) [05:45:10] (CR) Eileen: [C: +2] "I made one minor comment - but it is non-blocking. I stepped through the code & all changes make sense" [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/605637 (https://phabricator.wikimedia.org/T249924) (owner: Ejegg) [05:51:41] (Merged) jenkins-bot: Matching gifts fetcher factory, beef up interface [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/605637 (https://phabricator.wikimedia.org/T249924) (owner: Ejegg) [05:52:02] (PS6) Eileen: Normalize values returned from SSBInfo [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/607141 (https://phabricator.wikimedia.org/T249924) (owner: Ejegg) [06:23:55] (CR) Eileen: [C: +2] "woot - I got the viscosity working & got to test this on a real live fetch - looks solid" [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/607141 (https://phabricator.wikimedia.org/T249924) (owner: Ejegg) [06:24:11] (PS9) Eileen: New MatchingGiftPolicies api action 'sync' using job [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/605638 (https://phabricator.wikimedia.org/T249924) (owner: Ejegg) [06:35:14] (PS2) Eileen: Add index to civicrm_country.iso_code. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/607657 (https://phabricator.wikimedia.org/T253152) [06:36:44] (PS3) Eileen: Add index to civicrm_country.iso_code. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/607657 (https://phabricator.wikimedia.org/T253152) [06:57:57] (CR) Eileen: "I picked up one thing that causes a bug" (1 comment) [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/605638 (https://phabricator.wikimedia.org/T249924) (owner: Ejegg) [07:15:53] (PS3) Eileen: Add matching gift employer export [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/607633 (https://phabricator.wikimedia.org/T250328) (owner: Ejegg) [07:24:10] (CR) Eileen: "A couple more things I spotted - mostly seems pretty good though. I'm a fan of adding comment blocks for IDE-support & there are a few pla" (4 comments) [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/605638 (https://phabricator.wikimedia.org/T249924) (owner: Ejegg) [07:27:54] (CR) Eileen: New MatchingGiftPolicies api action 'sync' using job (1 comment) [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/605638 (https://phabricator.wikimedia.org/T249924) (owner: Ejegg) [07:30:57] (CR) Eileen: [C: +2] "I'm not quite sure how you plan to use this but it definitely does what it says it does & the code is pretty straight forward & makes sens" [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/607633 (https://phabricator.wikimedia.org/T250328) (owner: Ejegg) [07:32:01] (CR) jerkins-bot: [V: -1] Add matching gift employer export [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/607633 (https://phabricator.wikimedia.org/T250328) (owner: Ejegg) [10:11:13] RECOVERY - check_procs on fran1001 is OK: PROCS OK: 437 processes [10:21:14] Wikimedia-Fundraising-Banners: [All Controls] Missing comma on donation amounts in older versions of Safari - https://phabricator.wikimedia.org/T256347 (Pcoombe) p:Medium→Lowest This is because we normally use the built-in `Intl.NumberFormat` method in `frb.formatCurrency`, but it isn't supported bef... [10:33:46] Wikimedia-Fundraising-Banners: Add non-breaking space between ₹ and amount for Indian Rupee - https://phabricator.wikimedia.org/T256288 (Pcoombe) Open→Resolved a:Pcoombe [English Wikipedia](https://en.wikipedia.org/wiki/Indian_rupee) also writes it without a space, although I couldn't find any di... [13:37:25] Fundraising Sprint Lazy Loading Life, Fundraising Sprint M 2020, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, FR-Email: Q4 19/20 investigate export and upload issues with the silverpop export - https://phabricator.wikimedia.org/T253152 (KHaggard) Ah ok, yeah I believe they are independ... [14:17:48] Fundraising Sprint Lazy Loading Life, Fundraising Sprint M 2020, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, FR-Email: Q4 19/20 investigate export and upload issues with the silverpop export - https://phabricator.wikimedia.org/T253152 (CCogdill_WMF) Yeah to put a fine point on it, we... [14:57:08] (PS2) Mepps: Update Japanese thank you email and subject. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/607573 (owner: Cstone) [14:57:12] (CR) Mepps: [C: +2] Update Japanese thank you email and subject. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/607573 (owner: Cstone) [14:58:04] (PS2) Mepps: Create Japanese recurring notification html and subject templates. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/607623 (owner: Cstone) [14:58:09] (CR) Mepps: [C: +2] Create Japanese recurring notification html and subject templates. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/607623 (owner: Cstone) [15:06:04] (CR) Mepps: [C: +2] Add to, rather than rebuild the suppression list. [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/607156 (https://phabricator.wikimedia.org/T253152) (owner: Eileen) [15:06:17] (Merged) jenkins-bot: Update Japanese thank you email and subject. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/607573 (owner: Cstone) [15:06:19] (Merged) jenkins-bot: Create Japanese recurring notification html and subject templates. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/607623 (owner: Cstone) [15:06:42] (CR) Mepps: [C: +2] Add to, rather than rebuild the suppression list. (1 comment) [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/607156 (https://phabricator.wikimedia.org/T253152) (owner: Eileen) [15:06:49] (CR) Mepps: [C: +2] Move suppression list generation queries to separate file. [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/607145 (https://phabricator.wikimedia.org/T256073) (owner: Eileen) [15:07:02] fundraising-tech-ops: modify pc_log_archiver to add hostname to the target filename on log rotation - https://phabricator.wikimedia.org/T256318 (Jgreen) p:Triage→Medium a:Jgreen [15:08:03] (Merged) jenkins-bot: Move suppression list generation queries to separate file. [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/607145 (https://phabricator.wikimedia.org/T256073) (owner: Eileen) [15:08:08] (Merged) jenkins-bot: Add to, rather than rebuild the suppression list. [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/607156 (https://phabricator.wikimedia.org/T253152) (owner: Eileen) [15:14:17] tzag fr-tech! [15:14:25] tzag jgleeson! [15:14:34] hi jgleeson! [15:14:35] :) [15:16:25] hellllo [15:16:50] Howdy [15:17:02] helloes [15:18:26] * XenoRyet is up early for the paid API office hour [15:18:49] Fundraising Sprint M 2020, Fundraising-Backlog: Create job to update/generate employer dataset for usage within paymentswiki - https://phabricator.wikimedia.org/T251201 (jgleeson) Ok great. Thanks for doing the heavy lifting on the CSV generation part! [15:19:40] They have a pretty cool provisional code name for it: They're have an acronym that gets to OK API, which folks seem to be shortening to Okapi https://en.wikipedia.org/wiki/Okapi [15:25:03] and hello cstone, mepps, and XenoRyet ! [15:26:41] Fundraising Sprint M 2020, Fundraising-Backlog: Missing "unsubscribe" link in automatic recurring failure email - https://phabricator.wikimedia.org/T256162 (DStrine) I think it will be a few weeks before we get new copy so we should add the link if it is easy. @CCogdill_WMF there is a direct link to acou... [15:29:02] (PS1) Mepps: Edit recurring failed message template to include acoustic unsubscribe link [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/607817 (https://phabricator.wikimedia.org/T256162) [15:30:20] Fundraising Sprint M 2020, Fundraising-Backlog, Patch-For-Review: Missing "unsubscribe" link in automatic recurring failure email - https://phabricator.wikimedia.org/T256162 (mepps) My patch uses the acoustic link because the fancy payments one requires data about the contribution and contact. We can... [15:31:07] (CR) Mepps: "Note that I'm using the completely generic acoustic address for now, also with no mailing id." [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/607817 (https://phabricator.wikimedia.org/T256162) (owner: Mepps) [15:50:38] hi fr-tech mepps ejegg jgleeson XenoRyet cstone [15:51:01] hello AndyRussG [15:51:05] I'm feeling under the weather as of yesterday evening, so I may take it easy or even not work btw [15:51:42] howdy AndyRussG [15:51:49] :) [15:51:51] oh noes, hope you feel better soon [15:52:46] Thanks! It feels like a little cold, but I've been like super tired, I slept a ton, and also have like a little bit of a sore throat, so probably best to be cautious I guess [15:55:07] hi AndyRussG and feel better! [15:55:33] cstone jgleeson thanks! :) [15:56:14] Fundraising Sprint M 2020, Fundraising-Backlog, Patch-For-Review: Missing "unsubscribe" link in automatic recurring failure email - https://phabricator.wikimedia.org/T256162 (CCogdill_WMF) I'm fine with using the Acoustic link as long as it works for y'all in testing. [16:12:31] oh dang AndyRussG, get some rest! [16:13:25] ejegg: thanks! :) [16:31:07] Yea, rest up, no point in taking chances these days. [16:31:54] Fundraising Sprint M 2020, Fundraising-Backlog, Patch-For-Review: Missing "unsubscribe" link in automatic recurring failure email - https://phabricator.wikimedia.org/T256162 (mepps) Thanks @CCogdill_WMF! [16:43:47] XenoRyet: yeah thanks :) [16:46:02] Fundraising Sprint M 2020, Fundraising-Backlog: Removing asterisks in payment page card number field - https://phabricator.wikimedia.org/T254032 (mepps) a:mepps [16:47:40] Fr-tech: I moved standup to 10:00 after the Advancement salon today, but David and I have another meeting we'll be in, so go ahead and do standup without us. Ping me on anything that you need from me. [16:50:17] fr-tech K so I am taking a sick day, won't be at meetings. Two points to suggest for standup, though: [16:52:23] - Last week at the Analytics check-in we said we'd talk about how to help review FR Analytics code... oh however it looks like that meeting is cancelled this week! So I guess not urgent after all [16:52:28] - Sprint naming! [16:54:01] AndyRussG: M has a James Bond feel to it [16:54:32] She's well thought of in British Film :) [16:54:50] she? [16:54:56] Fundraising Sprint M 2020, Fundraising-Backlog: Removing asterisks in payment page card number field - https://phabricator.wikimedia.org/T254032 (mepps) So if we have no placeholder, this happens: {F31905555} Here's how it looks for visa with Michael's suggestion: {F31905560} [16:55:15] M is the head of MI6 in the James Bond movies [16:55:53] Played by Dame Judi Dench lately [16:56:02] ahhhh right! [16:56:04] yep. [16:56:27] the one person who keeps bond in check [16:56:33] I'm going ahead and throwing a few ideas in there... I guess feeling feverish actually helps for this task [17:07:51] Fundraising Sprint M 2020, Fundraising-Backlog: Removing asterisks in payment page card number field - https://phabricator.wikimedia.org/T254032 (mepps) One more option: {F31905575} [17:09:56] Fundraising Sprint M 2020, Fundraising-Backlog: Removing asterisks in payment page card number field - https://phabricator.wikimedia.org/T254032 (mepps) The placeholder carries over to other credit cards. The downside is AmEx is a different format. [17:30:51] Fundraising-Backlog, donate.wikimedia.org: Up-to-date Safari users getting unsupported browser errors - https://phabricator.wikimedia.org/T236243 (Pcoombe) Open→Resolved Closing this since it seemed to be transient and hasn't recurred. [17:36:11] (CR) Jgleeson: "Hey mepps, so the PrevNext Cache setting I mentioned can be set via the CiviCRM UI here http://crm.local.wmftest.net:8080/civicrm/admin/se" [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/602185 (owner: Jgleeson) [17:54:52] Fundraising-Backlog: New Ingenico API key required before July 29,2020 - https://phabricator.wikimedia.org/T256408 (Reedy) [18:00:05] (CR) Mepps: "Thanks Jgleeson!" [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/602185 (owner: Jgleeson) [18:01:04] Fundraising Sprint M 2020, Fundraising-Backlog: Removing asterisks in payment page card number field - https://phabricator.wikimedia.org/T254032 (DStrine) @mepps and @MBeat33 the whole reason we are trying to do this is to show that no numbers have been auto-filled by the browser. I would be inclined to... [18:23:08] fundraising-tech-ops: modify pc_log_archiver to add hostname to the target filename on log rotation - https://phabricator.wikimedia.org/T256318 (Jgreen) Open→Resolved [18:36:53] Fundraising-Backlog, MobileFrontend, WMF-Design, Design, and 2 others: Mobile web donate link - https://phabricator.wikimedia.org/T219793 (Jdlrobson) a:Jdlrobson→Edtadros [19:32:55] (PS10) Ejegg: New MatchingGiftPolicies api action 'sync' using job [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/605638 (https://phabricator.wikimedia.org/T249924) [19:32:57] (PS4) Ejegg: Add matching gift employer export [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/607633 (https://phabricator.wikimedia.org/T250328) [19:34:21] fundraising-tech-ops: Determine reason for daily increasing proc count on fran1001 - https://phabricator.wikimedia.org/T256420 (Dwisehaupt) [19:36:05] (CR) Ejegg: "PS10 just reorganizes the existing code into something more testable and object oriented. Will address Eileen's comments in the next one." [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/605638 (https://phabricator.wikimedia.org/T249924) (owner: Ejegg) [19:39:21] fundraising-tech-ops: Determine reason for daily increasing proc count on fran1001 - https://phabricator.wikimedia.org/T256420 (Dwisehaupt) Temporarily bumping the alert threshold to 3000 while we find the root cause. ` [frack::puppet] 9e777eba Adjust nagios check_procs alert upward to 3000 ` [19:39:59] (CR) jerkins-bot: [V: -1] Add matching gift employer export [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/607633 (https://phabricator.wikimedia.org/T250328) (owner: Ejegg) [19:41:28] (CR) jerkins-bot: [V: -1] New MatchingGiftPolicies api action 'sync' using job [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/605638 (https://phabricator.wikimedia.org/T249924) (owner: Ejegg) [19:42:55] (PS11) Ejegg: New MatchingGiftPolicies api action 'sync' using job [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/605638 (https://phabricator.wikimedia.org/T249924) [19:42:57] (PS5) Ejegg: Add matching gift employer export [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/607633 (https://phabricator.wikimedia.org/T250328) [19:43:14] oh, I guess that export api doesn't actually depend on the sync stuff [19:43:18] could unchain those [20:05:27] Fundraising Sprint M 2020, Fundraising-Backlog: Removing asterisks in payment page card number field - https://phabricator.wikimedia.org/T254032 (mepps) That works for me @Dstrine, but I'll do what @MBeat33 and you suggest. [20:07:41] Fundraising Sprint M 2020, Fundraising-Backlog: Removing asterisks in payment page card number field - https://phabricator.wikimedia.org/T254032 (mepps) Also [[ https://ux.stackexchange.com/questions/106902/credit-card-field-placeholder-text | this is the thread ]] I consulted on this, in case anyone has... [20:11:02] (Abandoned) Jgleeson: Revert "Silverpop employer_name, slight simplification on the query" [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/607546 (owner: Jgleeson) [20:12:31] Fundraising Sprint M 2020, Fundraising-Backlog: Removing asterisks in payment page card number field - https://phabricator.wikimedia.org/T254032 (MBeat33) Clearly what we need is an ABC test of **** //versus// 1234 //versus// 0000, with a pop up for AmEx users translated into all languages and - just kid... [20:13:36] Fundraising-Backlog: Asterisks in card # field make donors think their number is autofilled - https://phabricator.wikimedia.org/T242809 (MBeat33) Open→Resolved a:MBeat33 Marking resolved as a duplicate of {T254032} [20:15:23] Fundraising Sprint M 2020, Fundraising-Backlog: Removing asterisks in payment page card number field - https://phabricator.wikimedia.org/T254032 (mepps) One other option: {F31905757} [20:17:06] Fundraising Sprint Lazy Loading Life, Fundraising Sprint M 2020, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Fix new recurrings to be created with a Pending status - https://phabricator.wikimedia.org/T254941 (mepps) @Eileenmcnaughton has this been deployed? [20:21:00] Fundraising Sprint M 2020, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Patch-For-Review: Create CiviCRM API to export data for employer autocomplete - https://phabricator.wikimedia.org/T250328 (mepps) I see this was +2ed by Eileen. [20:31:12] Fundraising Sprint M 2020, Fundraising-Backlog: Removing asterisks in payment page card number field - https://phabricator.wikimedia.org/T254032 (MBeat33) Thanks, @mepps Personally I think the 0000s may be more intuitive than a single # (and #s in groups of 4 might look like numbers have been entered a... [20:36:22] Fundraising Sprint M 2020, Fundraising-Backlog: Removing asterisks in payment page card number field - https://phabricator.wikimedia.org/T254032 (DStrine) Hi all. We're going to go with zeroes unless someone wants to vote for the latest options @mepps shows which is just a # sign. If I don't hear anythin... [20:39:28] (CR) Mepps: "I must be missing something but I don't see the email_map table being used in update_table which is confusing me" [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/607401 (owner: Eileen) [20:41:09] Fundraising Sprint M 2020, Fundraising-Backlog: Removing asterisks in payment page card number field - https://phabricator.wikimedia.org/T254032 (EMartin) I agree with Michael. +1 Zero's work. [20:41:37] ejegg: I've run into a problem trying to update the MG extension. It's seeing this error when trying to apply the db updates https://stackoverflow.com/questions/1814532/1071-specified-key-was-too-long-max-key-length-is-767-bytes [20:41:52] the fix is to set the varchat to 255 although it looks like you've already done that [20:42:01] so currently digging around that [20:42:09] (CR) Mepps: "Oops ignore previous comment" [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/607401 (owner: Eileen) [20:45:01] (CR) Mepps: [C: +1] "This looks pretty good to me but I have two small comments on the comments. Also I'm not totally sure I'm wrapping my head around it all." (2 comments) [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/607401 (owner: Eileen) [20:46:44] Fundraising-Backlog, MobileFrontend, WMF-Design, Design, and 2 others: Mobile web donate link - https://phabricator.wikimedia.org/T219793 (Jdlrobson) [20:46:51] (CR) Jgleeson: "I'm runnin into this error with mysql/mariadb when trying to apply the extension upgrade:" [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/605638 (https://phabricator.wikimedia.org/T249924) (owner: Ejegg) [20:47:10] Fundraising-Backlog, MobileFrontend, WMF-Design, Design, and 2 others: Mobile web donate link - https://phabricator.wikimedia.org/T219793 (Jdlrobson) a:Edtadros→Jdlrobson after design review with Alex - it's in the wrong place. [20:47:24] Fundraising Sprint Lazy Loading Life, Fundraising Sprint M 2020, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, fundraising-tech-ops: Test CiviCRM on new box - https://phabricator.wikimedia.org/T254940 (Jgreen) >>! In T254940#6253571, @Ejegg wrote: > @Jgreen it would be nicer if they sha... [20:47:45] (CR) Mepps: "Hmm even with the prevnext change I'm still getting: Tests: 494, Assertions: 4586, Errors: 4, Failures: 57, Risky: 1." [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/602185 (owner: Jgleeson) [20:47:52] Wikimedia-Fundraising-CiviCRM, fundraising-tech-ops: refactor civi1001 archive_sync jobs to also keep civi1001 and civi2001 audit data in sync - https://phabricator.wikimedia.org/T256317 (Jgreen) Open→Resolved a:Jgreen [20:47:54] Fundraising Sprint Lazy Loading Life, Fundraising Sprint M 2020, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, fundraising-tech-ops: Test CiviCRM on new box - https://phabricator.wikimedia.org/T254940 (Jgreen) [20:48:06] Wikimedia-Fundraising-CiviCRM, fundraising-tech-ops: refactor civi1001 archive_sync jobs to also keep civi1001 and civi2001 audit data in sync - https://phabricator.wikimedia.org/T256317 (Jgreen) p:Triage→Medium [20:48:44] ejegg: the export api action still works [20:49:34] jgleeson great! [20:49:47] oh, weird about that key though [20:49:52] hmm, which key would that be? [20:50:30] unique index [20:50:40] I wonder if they id needs a max length [20:50:46] the* [20:52:13] nope [20:57:51] (CR) Mepps: "It installed okay for me, but I wasn't updating. I haven't gotten to look at more than that." [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/605638 (https://phabricator.wikimedia.org/T249924) (owner: Ejegg) [20:58:56] ejegg: is the default collation on your civicrm db utf8 or utf8mb4 [20:59:26] Fundraising-Backlog, MobileFrontend, WMF-Design, Design, and 2 others: Mobile web donate link - https://phabricator.wikimedia.org/T219793 (alexhollender) [20:59:29] hmm, lemme see [20:59:41] Fundraising Sprint Lazy Loading Life, Fundraising Sprint M 2020, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, FR-Email: Q4 19/20 investigate export and upload issues with the silverpop export - https://phabricator.wikimedia.org/T253152 (KHaggard) @Eileenmcnaughton I think if you deploy... [21:01:07] ejegg: if I set the default collation to utf8 it works [21:01:17] jgleeson looks like I have utf8mb4 [21:01:23] oh weird [21:01:28] which index was the problem? [21:02:13] https://gerrit.wikimedia.org/r/#/c/wikimedia/fundraising/crm/+/605638/11/sites/default/civicrm/extensions/matching-gifts/sql/create_job_progress.sql@5 [21:02:41] checkout this reply to the problem on stackoverflow https://stackoverflow.com/questions/1814532/1071-specified-key-was-too-long-max-key-length-is-767-bytes#comment69152704_1814594 [21:05:04] so wait, 767 bytes is mysql 5.6 and prior [21:06:54] oh, for mariadb it depends on the innodb page size [21:06:57] https://mariadb.com/kb/en/innodb-limitations/ [21:07:07] (CR) Jgleeson: "so I had to change my default collation for the civicrm db to 'utf8' from 'uft8mb4' after reading this https://stackoverflow.com/questions" [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/605638 (https://phabricator.wikimedia.org/T249924) (owner: Ejegg) [21:07:07] jgleeson: try select @@innodb_page_size; [21:08:01] ejegg: '16384' [21:09:10] huh, I've got the smae [21:09:12] same [21:09:20] so... the index key length should be longer [21:11:16] Fundraising-Backlog, MobileFrontend, WMF-Design, Design, and 3 others: Mobile web donate link - https://phabricator.wikimedia.org/T219793 (Jdlrobson) [21:18:25] ejegg: looks like mepps didn't run into it and she's on the same setup as me I think so it might be some weirdness at my end [21:47:55] jgleeson: when you tried to upgrade did the UI just say unknown error? [21:51:23] cstone: the UI upgrade thingy timeout I think [21:52:09] but in the logs it was showing the mysql error mentioned in my first comment on this patch https://gerrit.wikimedia.org/r/#/c/wikimedia/fundraising/crm/+/605638/ [21:52:16] i clicked away thinking I had a different issue but maybe it was the same [21:52:33] timed out* [21:53:11] I put some notes about it in my end of day, I also ran into another issue that I'm gonna investigate tomorrow. I'm heading off now, have a good rest of your day! o/ [21:53:20] have a good evening! [22:21:30] Fundraising Sprint Lazy Loading Life, Fundraising Sprint M 2020, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, FR-Email: Q4 19/20 investigate export and upload issues with the silverpop export - https://phabricator.wikimedia.org/T253152 (Eileenmcnaughton) @KHaggard I can't deploy them w... [22:23:44] I'm gonna put up a patch that makes the mapping for silverpop the same as before (with place holders for the removed fields) so we can deploy what is merged [22:30:13] (PS1) Eileen: Revert changes to final export mapping so deploy is unblocked [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/607894 (https://phabricator.wikimedia.org/T253152) [22:31:11] If I can get a merge on ^^ I can deploy the merged export stuff & ejegg I think I can then run the job on staging as a test? But I need to make sure we don't update twice? Ideally I would compare something ? [22:31:33] note merged changes so far primarily affect suppression list generation - switching to incremental [22:33:12] (PS2) Eileen: Revert changes to final export mapping so deploy is unblocked [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/607894 (https://phabricator.wikimedia.org/T253152) [22:36:36] Fundraising Sprint Lazy Loading Life, Fundraising Sprint M 2020, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Fix new recurrings to be created with a Pending status - https://phabricator.wikimedia.org/T254941 (Eileenmcnaughton) @mepps yep - just checked Author: Elliott Eggleston Fundraising Sprint Kavascript: the chill new language, Fundraising Sprint Lazy Loading Life, Fundraising Sprint M 2020, Fundraising-Backlog, and 2 others: Civi: annual summary email - add tax deductibility language - https://phabricator.wikimedia.org/T242001 (Eileenmcnaughton) Looks like this we... [22:39:24] (PS6) Eileen: Add matching gift employer export [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/607633 (https://phabricator.wikimedia.org/T250328) (owner: Ejegg) [23:23:52] Wikimedia-Fundraising-Banners: [Dsk Lg + Dsk Sm] Hover text appearing on Close icon for RML - https://phabricator.wikimedia.org/T256439 (jbolorinos-ctr) [23:24:35] Wikimedia-Fundraising-Banners: [Dsk Lg + Dsk Sm] Hover text appearing on Close icon for RML - https://phabricator.wikimedia.org/T256439 (jbolorinos-ctr) [23:24:37] (CR) Eileen: [C: +2] "I ran this on staging & tested and the unsubscribe link worked. There is no link in the text only version - but I don't think we send that" [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/607817 (https://phabricator.wikimedia.org/T256162) (owner: Mepps) [23:24:50] Wikimedia-Fundraising-Banners: [Dsk Lg + Dsk Sm] Hover text appearing on Close icon for RML - https://phabricator.wikimedia.org/T256439 (jbolorinos-ctr) p:Triage→Low [23:26:44] Fundraising Sprint Lazy Loading Life, Fundraising Sprint M 2020, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Fix new recurrings to be created with a Pending status - https://phabricator.wikimedia.org/T254941 (Eileenmcnaughton) Open→Resolved a:Eileenmcnaughton [23:28:26] (CR) Eileen: Add to, rather than rebuild the suppression list. (1 comment) [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/607156 (https://phabricator.wikimedia.org/T253152) (owner: Eileen) [23:37:52] oops eileen just seeing this now [23:38:09] probably late there now... [23:39:16] revert should be easy review! [23:40:22] oh, I see, it's commenting out things [23:40:55] yep - the discussion with Katie on mapping changes is a bit confusing [23:41:24] but I think it's better for now to comment any changes that affect the mapping so the rest isn't blocked on thattt [23:55:49] ok eileen [23:56:00] should we use the standard -- instead # there? [23:56:07] we're using -- in other places [23:56:24] hmm - I can change if you want - these should be gone next week tho