[00:00:05] (PS2) Eileen: Make path relative [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/667966 (https://phabricator.wikimedia.org/T273822) [00:02:32] (CR) jerkins-bot: [V: -1] De-symlink sites folder [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/667727 (https://phabricator.wikimedia.org/T273822) (owner: Eileen) [00:13:31] (CR) jerkins-bot: [V: -1] Make path relative [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/667966 (https://phabricator.wikimedia.org/T273822) (owner: Eileen) [00:13:37] (PS5) Eileen: De-symlink sites folder [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/667727 (https://phabricator.wikimedia.org/T273822) [00:13:40] (Abandoned) Eileen: Update gitignore for sites move [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/667728 (https://phabricator.wikimedia.org/T273822) (owner: Eileen) [00:13:48] (Abandoned) Eileen: Make path relative [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/667966 (https://phabricator.wikimedia.org/T273822) (owner: Eileen) [00:14:25] Fundraising-Backlog, fundraising-tech-ops: Test silverpop export with utf8mb4 tables - https://phabricator.wikimedia.org/T276293 (Dwisehaupt) [00:16:08] (Abandoned) Eileen: Update path for autoload [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/667732 (owner: Eileen) [00:16:50] (CR) jerkins-bot: [V: -1] De-symlink sites folder [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/667727 (https://phabricator.wikimedia.org/T273822) (owner: Eileen) [00:16:54] (PS6) Eileen: De-symlink sites folder [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/667727 (https://phabricator.wikimedia.org/T273822) [00:17:50] (PS7) Eileen: De-symlink sites folder [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/667727 (https://phabricator.wikimedia.org/T273822) [00:21:57] !log replication restarted on frdb2001 after utf8mb4 conversion completed. [00:22:02] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [00:24:11] and replication is caught up. [00:27:18] Fundraising-Backlog, fundraising-tech-ops: Test silverpop export with utf8mb4 tables - https://phabricator.wikimedia.org/T276293 (Dwisehaupt) [00:28:07] (CR) jerkins-bot: [V: -1] De-symlink sites folder [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/667727 (https://phabricator.wikimedia.org/T273822) (owner: Eileen) [00:31:49] (PS8) Eileen: De-symlink sites folder [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/667727 (https://phabricator.wikimedia.org/T273822) [00:33:57] (PS9) Eileen: De-symlink sites folder [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/667727 (https://phabricator.wikimedia.org/T273822) [00:34:18] (PS10) Eileen: De-symlink sites folder [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/667727 (https://phabricator.wikimedia.org/T273822) [00:37:29] Fundraising-Backlog, fundraising-tech-ops: Fix our database to support emojis - convert tables to utf8mb4 - https://phabricator.wikimedia.org/T270218 (Dwisehaupt) [00:38:42] Fundraising-Backlog, fundraising-tech-ops: Fix our database to support emojis - convert tables to utf8mb4 - https://phabricator.wikimedia.org/T270218 (Dwisehaupt) frdb2001 completed. Timing was very similar to frdb2002 (25.6 hours). [00:49:08] Fundraising-Backlog, fundraising-tech-ops: Issue new SSL Client Certificate for jjoe - https://phabricator.wikimedia.org/T274962 (Dwisehaupt) Open→Resolved Certificate expired naturally and it can be reissued if need be in the future. [00:52:04] (CR) Cstone: [C: +2] "woohoo!" [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/667727 (https://phabricator.wikimedia.org/T273822) (owner: Eileen) [01:38:53] okok, deploying for real now [02:09:53] !log updated payments-wiki from 365bf54393 to 65dbf0ed9d [02:09:59] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [02:21:47] Fundraising-Backlog: Docker dev setup: process-control jobs config - https://phabricator.wikimedia.org/T276297 (AndyRussG) [02:21:57] (PS1) Ejegg: Merge branch 'master' into deployment [wikimedia/fundraising/crm] (deployment) - https://gerrit.wikimedia.org/r/667973 [02:22:14] (CR) Ejegg: [C: +2] Merge branch 'master' into deployment [wikimedia/fundraising/crm] (deployment) - https://gerrit.wikimedia.org/r/667973 (owner: Ejegg) [02:25:55] (PS4) Ejegg: Change logo in a hook [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/647266 (https://phabricator.wikimedia.org/T269717) [02:26:02] (PS3) Ejegg: Move Endowment-related MonthlyConvert logic into hook [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/647276 (https://phabricator.wikimedia.org/T269717) [02:26:32] AndyRussG: these two changes will move the rest of the endowment-specific logic into that hook class [02:27:03] i guess to help maintain some separation from the truly-only-useful-for-us code and the stuff that other orgs could conceivably use [02:27:40] ah okok [02:27:47] so if those get merged they would need additional lines in the docker settings file [02:28:39] ejegg hmm as well as lines in prod LocalSettings.php I guess? [02:28:57] yep yep [02:29:32] K gotcha [02:30:50] ejegg the slightly unfortunate bit of the change I made to your Docker LocalSettings change is I moved the hook setting [02:30:58] so it's now together with the rest of the DI settings [02:31:09] since on Docker it's organized into general MW settings and DI-specific settings [02:31:19] but now it's not in the same place on Docker as it is on prod [02:31:26] so harder to keep coordinated i guess [02:32:40] oh, we can move it on prod too [02:32:51] makes sense to keep it with DI stuff [02:34:07] once the current recurring charge run ends I'll deploy that change to the credit card statement line for CRM [02:35:01] ah okok cool [02:35:18] ejegg btw there is now more CRM de-symlinking in the pipeline [02:35:23] ok, two little follow-up tasks for tomorrow [02:35:35] yeah AndyRussG I'm just deploying up to the patch before that [02:37:00] right cool [02:37:04] 1) make sure we send 'es' to processors who accept language codes when we have 'es-419' locally [02:37:31] 2) update language of contact in civi when we find a matching (names, email) on import [02:37:58] hnnnn [02:38:01] *hmmm [02:38:10] I wonder if there are processors that can take es-419 [02:45:04] !log updated fundraising CiviCRM from e1dacbe348 to b13e70d968 [02:45:09] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [04:05:05] Fundraising Sprint Esperantoland, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Fr-drupal-upgrade-2021: Investigate project and create checklist of all steps needed for drupal upgrade - https://phabricator.wikimedia.org/T276107 (Eileenmcnaughton) We caught up today to talk about this but re... [04:13:38] Fundraising Sprint Corrugated super slide, Fundraising Sprint Downed power line jump rope, Fundraising Sprint Esperantoland, Fundraising-Backlog: Adding 2 new columns to Engage Reconciliation reports - https://phabricator.wikimedia.org/T271992 (Eileenmcnaughton) @MDemosWMF isn't column 2 in https... [04:31:34] Fundraising Sprint Corrugated super slide, Fundraising Sprint Downed power line jump rope, Fundraising Sprint Esperantoland, Fundraising-Backlog: Adding 2 new columns to Engage Reconciliation reports - https://phabricator.wikimedia.org/T271992 (Eileenmcnaughton) Just noting that of the 2 things I... [05:20:12] Fundraising Sprint Downed power line jump rope, Fundraising Sprint Esperantoland, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: try to recreate lybunt and sybunt reports in search kit - https://phabricator.wikimedia.org/T272063 (Eileenmcnaughton) I had this working but I broke it - where I... [05:22:05] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Updating multiple contribution - increase limit - https://phabricator.wikimedia.org/T276083 (Eileenmcnaughton) @RLewis I had good results updating a large number of activities from search kit (after I imported some for Jerry & messed up the date) - once... [10:01:00] Fundraising Sprint Downed power line jump rope, Fundraising Sprint Esperantoland, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Benevity Import Error - https://phabricator.wikimedia.org/T271416 (RLewis) @Eileenmcnaughton I got a new file now but I'm waiting for confirmation from finance on... [11:27:21] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Updating multiple contribution - increase limit - https://phabricator.wikimedia.org/T276083 (RLewis) @Eileenmcnaughton can we take a look at how to do this in the next Civi fortnightly, I tried to replicate this for donor advised funds, $5000 and over s... [14:35:18] Fundraising-Backlog: DLocal not loading on IE 11 - https://phabricator.wikimedia.org/T276333 (jbolorinos-ctr) [14:41:22] Fundraising-Backlog: Menu appears in EN on ES Other ways to give page - https://phabricator.wikimedia.org/T276335 (jbolorinos-ctr) [14:50:36] Wikimedia-Fundraising-Banners: Oversized buttons on nag in IE 11 - https://phabricator.wikimedia.org/T276337 (jbolorinos-ctr) [15:13:33] Wikimedia-Fundraising-Banners: Latin America Pre-test Banners QA - https://phabricator.wikimedia.org/T275446 (HNordeenWMF) [15:20:22] Fundraising-Backlog, fundraising-tech-ops, FR-Tech-Analytics: Superset user - kill query after 60-65 seconds - https://phabricator.wikimedia.org/T272080 (Jgreen) >>! In T272080#6875294, @EYener wrote: > I was thinking about this task the other day, and I don't think that killing running queries after... [16:03:57] Fundraising-Backlog, MediaWiki-extensions-CentralNotice: Code search index for CentralNotice is 7 months old - https://phabricator.wikimedia.org/T273176 (AndyRussG) [16:25:07] (CR) Jgleeson: [C: -1] "Working well for me but I feel like we could make the added CSS a little easier to manage." (1 comment) [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/647266 (https://phabricator.wikimedia.org/T269717) (owner: Ejegg) [16:26:07] thanks for the CR jgleeson! The heredoc string would be an easy fix... [16:26:15] fr-tech any news for scrum of scrums? [16:26:48] ejegg: hey thanks, nothing here :) [16:28:31] (CR) Jgleeson: [C: +1] "This looks good but I'll hold off on the +2 until you can look over the earlier parent patch." [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/647276 (https://phabricator.wikimedia.org/T269717) (owner: Ejegg) [16:28:47] nothing from me ejegg [16:28:50] np! [16:31:18] Fundraising Sprint Corrugated super slide, Fundraising Sprint Downed power line jump rope, Fundraising Sprint Esperantoland, Fundraising-Backlog: Adding 2 new columns to Engage Reconciliation reports - https://phabricator.wikimedia.org/T271992 (MDemosWMF) @Eileenmcnaughton That's true! We can use... [16:33:35] Fundraising-Backlog, Fr-drupal-upgrade-2021: Docker dev setup: process-control jobs config - https://phabricator.wikimedia.org/T276297 (DStrine) [16:36:03] Fundraising-Backlog: Menu appears in EN on ES Other ways to give page - https://phabricator.wikimedia.org/T276335 (DStrine) This is a donate wiki issue. [16:36:06] Fundraising-Backlog: Menu appears in EN on ES Other ways to give page - https://phabricator.wikimedia.org/T276335 (HNordeenWMF) After checking out other languages Ways to Give pages, it looks like that menu is always in English. My guess it was intentional, maybe too complex to translate all of the country n... [16:37:41] fr-tech I'm gonna have to miss the monthly tech meeting as it's a the beginning of a meeting vortex right over dinner time [16:38:00] if I miss anything good, feel free to mention it! :) thanks in advance [16:38:39] No worries. I think they record that one too if you want to get to it later. [16:39:03] It is an optional one too, so no sweat either way. [16:50:51] Fundraising-Backlog: DLocal not loading on IE 11 - https://phabricator.wikimedia.org/T276333 (DStrine) ie 11 is pretty much at the end of life. It's possible dlocal doesn't support it. @EMartin might want to ping them. https://en.wikipedia.org/wiki/Internet_Explorer_11 FYI @MBeat33 and @spatton @TSkaff @P... [17:15:35] !log stopping mysql replication on frdb2001 and starting utf8mb4 table alters under a root screen session [17:15:40] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [17:15:48] gah. typo in host. [17:16:24] !log correction for last log with correct host - stopping mysql replication on frdb1004 and starting utf8mb4 table alters under a root screen session [17:16:29] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [17:16:50] !log ran the following on frdb1004 to allow replication to continue after conversion to utf8mb4 charset: set global slave_type_conversions = ALL_NON_LOSSY; [17:35:55] Fundraising-Backlog: es-419 updates to payments wiki smallprint/links - https://phabricator.wikimedia.org/T276367 (HNordeenWMF) [17:40:12] Fundraising-Backlog: es-419 updates to payments wiki smallprint/links - https://phabricator.wikimedia.org/T276367 (HNordeenWMF) [17:48:12] Fundraising-Backlog: es-419 updates to payments wiki smallprint/links - https://phabricator.wikimedia.org/T276367 (HNordeenWMF) [17:55:55] Fundraising-Backlog: DLocal not loading on IE 11 - https://phabricator.wikimedia.org/T276333 (EMartin) Hello, I have reached out Dlocal for investigation on this. [18:05:01] Fundraising-Backlog: es-419 updates to payments wiki smallprint/links - https://phabricator.wikimedia.org/T276367 (HNordeenWMF) [18:21:38] ac [18:48:09] Wikimedia-Fundraising-Banners: [Dsk Sm] Bank Transfer button appears larger than other payment options on smaller screen sizes - https://phabricator.wikimedia.org/T275534 (Pcoombe) Open→Resolved Fixed in current best - [diff](https://meta.wikimedia.org/w/index.php?diff=prev&oldid=21177418) - and in t... [18:48:11] Wikimedia-Fundraising-Banners: QA Dsk Sm - EN - https://phabricator.wikimedia.org/T275528 (Pcoombe) [19:39:28] Fundraising-Backlog, fundraising-tech-ops: Issue new SSL Client Certificate for nisrael - https://phabricator.wikimedia.org/T274320 (Dwisehaupt) Certificate renewed and delivered via email. Password sent via SMS. [20:04:56] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, fr-donorservices: Most recent email address becomes primary email address, former email address is moved to “Other” - https://phabricator.wikimedia.org/T276391 (DStrine) [20:05:00] Fundraising Sprint Esperantoland, Fundraising-Backlog: Update exchange rates before Latin America Pre-test - https://phabricator.wikimedia.org/T275812 (HNordeenWMF) [20:05:37] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, FR-Civi-Dedupe, fr-donorservices: Most recent email address becomes primary email address, former email address is moved to “Other” - https://phabricator.wikimedia.org/T276391 (DStrine) [20:05:55] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, FR-Civi-Dedupe, Fr-drupal-upgrade-2021, fr-donorservices: Most recent email address becomes primary email address, former email address is moved to “Other” - https://phabricator.wikimedia.org/T276391 (DStrine) [20:11:09] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, FR-Civi-Dedupe: Dedupe - document for DS the various bits of handling that are in the dedupe code - https://phabricator.wikimedia.org/T276392 (Eileenmcnaughton) [20:18:25] Fundraising-Backlog: DLocal not loading on IE 11 - https://phabricator.wikimedia.org/T276333 (Ejegg) The error in the browser console on dlocal's site is 'Promise' is undefined. This is a pretty basic concept in modern javascript, though IE never got around to supporting it. I doubt they'll rewrite their cod... [20:48:06] dstrine select DISTINCT SUBSTRING_INDEX(email,'@',-1) from civicrm_email LIMIT 5; [20:48:51] just trying this to see how long it takes... [20:48:53] CREATE TABLE email_domains select SUBSTRING_INDEX(email,'@',-1) from civicrm_email; [20:48:54] eileen: thanks I wanted to figure that out for myself :P [20:48:58] sorry [20:49:21] it's ok but now I know substring_index that's pretty cool [20:51:03] create table makes a temp table right? a long time ago I was not able to make temp tables. [20:52:29] it was back with casey. it got to a point where he gave me some simple query to paste in and I was getting all sorts of weird errors that he couldn't explain and I never tried again after that [20:53:52] I gotta run to lunch. I've saved your suggestion for later [21:03:47] dstrine: actually that did complete so the table is there on the staging dev_civicrm db [21:04:08] but it's just raw [21:04:38] and literally gmil.com is second on the list [21:07:02] ejegg: are you about to discuss drupal? [21:17:09] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Migrate dash to use new oauth - civicrm or drupal extension/module - https://phabricator.wikimedia.org/T276394 (Eileenmcnaughton) [21:17:28] (PS1) Ejegg: Deleted non-custom es-419 messages [extensions/DonationInterface] (deployment) - https://gerrit.wikimedia.org/r/668197 (https://phabricator.wikimedia.org/T276367) [21:36:13] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Spike - do practice d8 installs locally to get our heads around it - https://phabricator.wikimedia.org/T276395 (Eileenmcnaughton) [21:36:54] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Spike - do practice d9 installs locally to get our heads around it - https://phabricator.wikimedia.org/T276395 (Eileenmcnaughton) [21:50:32] (PS1) Eileen: Merge branch 'master' of ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - https://gerrit.wikimedia.org/r/668206 [21:55:24] Fundraising Sprint Esperantoland, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Fr-drupal-upgrade-2021: Investigate project and create checklist of all steps needed for drupal upgrade - https://phabricator.wikimedia.org/T276107 (Eileenmcnaughton) We discussed this & added a couple of tasks... [22:15:56] Fundraising-Backlog, fundraising-tech-ops: Test silverpop export with utf8mb4 tables - https://phabricator.wikimedia.org/T276293 (Dwisehaupt) The silverpop DB has been backed up and then restored as dev_silverpop on frdb1001. dev_silverpop and all of it's tables were then converted to utf8mb4. It is read... [22:27:12] Fundraising-Backlog, fundraising-tech-ops: Test silverpop export with utf8mb4 tables - https://phabricator.wikimedia.org/T276293 (Dwisehaupt) Looking at the table space, everything has been converted to utf8mb4 except the two views: dev_silverpop.silverpop_export_view and dev_silverpop.silverpop_export_v... [23:41:30] (PS1) Ejegg: Deleted non-customized es-419 messages [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/668229 (https://phabricator.wikimedia.org/T276367) [23:42:31] dwisehaupt: how long are you about? [23:43:05] another 45-60 mins. need to shuttle a kid to dance after that. [23:56:15] (PS5) Ejegg: Change logo in a hook [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/647266 (https://phabricator.wikimedia.org/T269717) [23:56:52] dwisehaupt: OK - I have a deploy that could require your help - I'll pump it out [23:57:10] (CR) Eileen: [C: +2] Merge branch 'master' of ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - https://gerrit.wikimedia.org/r/668206 (owner: Eileen) [23:58:58] ah. the symlink one. sure thing.