[00:27:58] Fundraising Sprint Baudelaire Bowdlerizer, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Slow log in - looks like it's drupal cron - https://phabricator.wikimedia.org/T155084#3003920 (CaitVirtue) Load time at 4:26pm PST, in the office, 46 seconds @Eileenmcnaughton Is this useful? Should I kee... [00:33:40] Fundraising Sprint Baudelaire Bowdlerizer, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Slow log in - looks like it's drupal cron - https://phabricator.wikimedia.org/T155084#3003930 (Eileenmcnaughton) I think you can stop for now - I am experience faster load on some screens now but am also ex... [01:57:03] Fundraising Sprint Costlier Alternative, Fundraising Sprint Waiting for Godot, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Patch-For-Review: Slow query: core civicrm affecting one of the scheduled jobs - https://phabricator.wikimedia.org/T153128#3004125 (Eileenmcnaughton) [01:57:49] Fundraising Sprint Costlier Alternative, Fundraising Sprint Waiting for Godot, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Patch-For-Review: Slow query: core civicrm affecting one of the scheduled jobs - https://phabricator.wikimedia.org/T153128#2870636 (Eileenmcnaughton) I've pulled... [02:00:18] eileen1: don't see any triggers on staging, you want me to import those? [02:02:24] i can just run the same file i ran on live [02:02:29] yep you can [02:02:29] if'n you fancy [02:02:52] yeah - would be good to get them on there now I guess [02:03:03] cool, i'll do that now [02:20:29] eileen1: ok those are restored, also i notice staging civi looks up to date now, did you git pull by any chance? [02:21:17] jeff said something about perms going crazy [02:21:23] and they do indeed look crazy [02:21:26] but working [02:24:10] cool [02:24:26] I did git pull & have a patch on staging [02:24:41] there is a performance issue blocking me - but it is in civi code not us [02:24:48] so I'm code wrangling to fix it [02:25:10] just relocating since kids are home & it is too stinking hot to work in the house anyway [02:28:07] (PS2) Cdentinger: Use mediawiki cache for IP Velocity [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/335868 (owner: Ejegg) [02:34:22] (CR) Cdentinger: [C: 2] "Great simplification, and appreciate the automated test cause this is a hard thing to test interactively, but hey it's the slow season so " [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/335868 (owner: Ejegg) [02:35:16] !log imported triggers into staging civi [02:35:19] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [02:36:30] (Merged) jenkins-bot: Use mediawiki cache for IP Velocity [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/335868 (owner: Ejegg) [07:18:58] (CR) Nikerabbit: [C: 2] Add special page alias to alias file [extensions/ContributionTracking] - https://gerrit.wikimedia.org/r/336065 (owner: Umherirrender) [07:22:33] (Merged) jenkins-bot: Add special page alias to alias file [extensions/ContributionTracking] - https://gerrit.wikimedia.org/r/336065 (owner: Umherirrender) [12:57:46] Wikimedia-Fundraising-Campaigns (FY Q3 Jan-Mar 2017), Wikimedia-CentralNotice-Administration (Q1-2017): WMF Fundraising - 16/17 - Sweden (February 7) - https://phabricator.wikimedia.org/T156815#3005180 (Jseddon) [12:57:50] Wikimedia-Fundraising-Campaigns (FY Q3 Jan-Mar 2017), Wikimedia-CentralNotice-Administration (Q1-2017): WMF Fundraising - 2016-17 - Norway (Feb 21 - Mar 21) - https://phabricator.wikimedia.org/T157117#3005194 (Jseddon) [12:57:53] Wikimedia-Fundraising-Campaigns (FY Q3 Jan-Mar 2017), Wikimedia-CentralNotice-Administration (Q1-2017): WMF Fundraising - 2016-17 - Denmark (Feb 21 - Mar 21) - https://phabricator.wikimedia.org/T157118#3005196 (Jseddon) [12:59:10] Wikimedia-Fundraising-Campaigns (FY Q3 Jan-Mar 2017), Wikimedia-CentralNotice-Administration (Q1-2017): WMF Fundraising - 16/17 - Sweden (7 Feb - 7 Apr) - https://phabricator.wikimedia.org/T156815#2986766 (Jseddon) [12:59:33] Wikimedia-Fundraising-Campaigns (FY Q3 Jan-Mar 2017), Wikimedia-CentralNotice-Administration (Q1-2017): WMF Fundraising - 2016-17 - Norway (21 Feb - 21 Mar) - https://phabricator.wikimedia.org/T157117#2996153 (Jseddon) [15:23:15] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, FR-Adyen, FR-Smashpig: Deal with chargeback reversals - https://phabricator.wikimedia.org/T157456#3005802 (Ejegg) [16:14:13] going to check out a co-working space here [17:55:52] all set up in a co-working space! [17:56:38] ejegg: ¡excelente! [17:56:50] Felicidades :( [17:56:52] :) [17:57:12] (sorry mistyped the smiley, hitting the wrong parenthesis!) [17:59:45] opposite day smileys [17:59:51] heh [18:00:31] fr-tech: God runs electromagnetics by wave theory on Monday, Wednesday, and Friday, [18:00:31] and the Devil runs them by quantum theory on Tuesday, Thursday, and Saturday. [18:00:31] -- William Bragg [18:00:31] -- discuss. [18:05:42] so, fr-tech, anyone want to help figure out how to let SmashPig use caching without depending on Mediawiki? [18:09:57] ejegg: sure! [18:10:17] So, in the fr-tech hangout? [18:10:17] Cool, I'll hop in the chat and see how well that works [18:10:20] yep [18:10:22] K! [18:43:05] fundraising-tech-ops, Operations, ops-ulsfo: upgrade backup4001 hard disk array - https://phabricator.wikimedia.org/T157473#3006447 (RobH) [18:45:15] (PS1) Eileen: CRM-19811 fix contribution search to not use LOWER() on default fields (e.g. creditnote_id). [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/336455 (https://phabricator.wikimedia.org/T153128) [18:45:17] (PS1) Eileen: CRM-19980, CRM-19881 - Fix slow queries due to LOWER on contact name fields [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/336456 (https://phabricator.wikimedia.org/T153128) [19:09:59] oh boy, more Civi performance enhancements! [19:31:44] AndyRussG: meeting? [19:32:01] dstrine: yep! [20:10:53] ejegg: those LOWERs suck but I don't want to remove them all at once [20:11:12] caution sounds like the way to go [20:12:02] finally getting back to reviewing your benevity import as well, sorry for the delay! [20:27:36] ejegg: no hang off it [20:27:47] I'm not getting a complete import into staging as yet [20:28:26] & I think I should demo to leanne too before we finalise [20:29:02] Jeff_Green: cwd|afk script I wanted to run on prod the other day takes just under 2 mins so I feel I can run it with no replication lag [20:29:32] eileen1: this is to add indexes? [20:29:44] no - just data fixing [20:32:45] ah, ok [20:33:20] eileen1: its ok with me if you want to run it [20:33:58] (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/336469 [20:34:37] (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/336469 (owner: Eileen) [20:39:23] this should be a 2 second review if anyone wants to do it … https://gerrit.wikimedia.org/r/#/c/335272/ [20:39:53] back in a bit! [20:41:41] (CR) Ejegg: [C: 2] "Searching with any case still works locally, unit test added upstream looks good." [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/336455 (https://phabricator.wikimedia.org/T153128) (owner: Eileen) [20:42:03] (CR) Ejegg: [C: 2] "Looking good!" [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/336456 (https://phabricator.wikimedia.org/T153128) (owner: Eileen) [20:44:59] (Merged) jenkins-bot: Merge branch 'master' of https://gerrit.wikimedia.org/r/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - https://gerrit.wikimedia.org/r/336469 (owner: Eileen) [20:48:00] (Merged) jenkins-bot: CRM-19811 fix contribution search to not use LOWER() on default fields (e.g. creditnote_id). [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/336455 (https://phabricator.wikimedia.org/T153128) (owner: Eileen) [20:48:02] (Merged) jenkins-bot: CRM-19980, CRM-19881 - Fix slow queries due to LOWER on contact name fields [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/336456 (https://phabricator.wikimedia.org/T153128) (owner: Eileen) [20:51:08] (PS1) Eileen: CiviCRM submodule update [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/336477 [20:51:16] thanks ejegg - I'll deploy those now [20:51:26] cool! [20:51:44] (CR) Eileen: [C: 2] "Self-review. Submodule update" [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/336477 (owner: Eileen) [20:53:57] ejegg: do you want to approve this too https://gerrit.wikimedia.org/r/#/c/335272/ ? [20:54:38] (PS2) Ejegg: Git Ignore cache directory [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/335272 (owner: Eileen) [20:54:47] heh, that was easy [20:55:26] :-) [20:56:53] eileen1: sure, lmk if you need help running the sql? [20:58:28] (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/336481 [20:59:18] cwd nah - just a drush comman [20:59:19] d [20:59:46] oh right on [21:00:44] (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/336481 (owner: Eileen) [21:02:02] !log Update CiviCRM from e45da6dc2cfaa48da8807ab9a571810c119e3233 to 7b36996e87387bb4982cc6937dc8bcbc7952eaf2 [21:02:06] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [21:02:50] (CR) Cdentinger: [C: 2] Add source fields to arrays, not just objects [wikimedia/fundraising/SmashPig] - https://gerrit.wikimedia.org/r/335741 (owner: Ejegg) [21:04:48] (Merged) jenkins-bot: Add source fields to arrays, not just objects [wikimedia/fundraising/SmashPig] - https://gerrit.wikimedia.org/r/335741 (owner: Ejegg) [22:08:55] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, FR-Adyen, FR-Smashpig: Deal with chargeback reversals - https://phabricator.wikimedia.org/T157456#3007470 (ggellerman) p:Triage>Normal [22:11:53] Fundraising-Backlog, FR-PayPal-ExpressCheckout: Make recurring queue consumer understand new PayPal recurring messages - https://phabricator.wikimedia.org/T157074#3007474 (Ejegg) p:Triage>High [22:12:18] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Can't add more info to the prospect tab - https://phabricator.wikimedia.org/T157382#3003341 (ggellerman) @CaitVirtue @RLewis @LeanneS Could you please try editing the different fields and let us know if you can add more characters? Thanks! [22:16:25] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: CiviCRM log is showing errors relating to importing bounces - https://phabricator.wikimedia.org/T157397#3007486 (Eileenmcnaughton) [22:19:53] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: CiviCRM log is showing errors relating to importing bounces - https://phabricator.wikimedia.org/T157397#3007512 (ggellerman) p:Triage>Normal [22:20:15] Fundraising Sprint Costlier Alternative, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Unplanned-Sprint-Work: CiviCRM log is showing errors relating to importing bounces - https://phabricator.wikimedia.org/T157397#3003686 (ggellerman) [22:21:57] Fundraising Sprint Costlier Alternative, Fundraising-Backlog, Recurring-Donations, Patch-For-Review: Move gateway-specific normalizations out of recurring.module - https://phabricator.wikimedia.org/T107372#1493395 (Ejegg) a:Ejegg [22:25:30] Fundraising Sprint Baudelaire Bowdlerizer, Fundraising Sprint Costlier Alternative, Fundraising-Backlog, FR-Ingenico, MediaWiki-extensions-DonationInterface: Spike: determine whether to use SDK for Ingenico Connect - https://phabricator.wikimedia.org/T152649#3007537 (Ejegg) We decided to try... [22:33:35] Fundraising Sprint Baudelaire Bowdlerizer, Fundraising-Backlog: fill out PCI SAQ-A form for 2017 - https://phabricator.wikimedia.org/T155779#3007579 (ggellerman) [23:49:36] Fundraising Sprint Autotune Earphones, Fundraising Sprint Baudelaire Bowdlerizer, Fundraising Sprint Costlier Alternative, Fundraising Sprint Waiting for Godot, and 4 others: Figure out why new recurring entries are creating duplicate emails of the ... - https://phabricator.wikimedia.org/T152475#3007753 [23:50:02] Fundraising Sprint Autotune Earphones, Fundraising Sprint Baudelaire Bowdlerizer, Fundraising Sprint Costlier Alternative, Fundraising Sprint Waiting for Godot, and 4 others: Figure out why new recurring entries are creating duplicate emails of the ... - https://phabricator.wikimedia.org/T152475#2849607