[07:25:59] (CR) Nikerabbit: [C: 2] Add special page alias to alias file [extensions/ContributionReporting] - https://gerrit.wikimedia.org/r/336064 (owner: Umherirrender) [07:27:06] (Merged) jenkins-bot: Add special page alias to alias file [extensions/ContributionReporting] - https://gerrit.wikimedia.org/r/336064 (owner: Umherirrender) [17:41:00] (PS1) AndyRussG: [WIP] Purge banner content from front-end cache on banner save [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/336237 (https://phabricator.wikimedia.org/T154954) [17:42:16] dstrine: hi! fyi i just uploaded an initial version of the patch for purging banner content from Varnish [17:42:44] I still have just one kink to work out, but it's ready for initial review [17:52:59] Fundraising Sprint Baudelaire Bowdlerizer, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Slow log in - looks like it's drupal cron - https://phabricator.wikimedia.org/T155084#3002649 (CaitVirtue) 37 second load time this morning, in the office. [18:00:31] fr-tech: Victory uber allies! [18:00:31] -- discuss. [18:03:13] hola from bogota [18:03:29] working out my data plan, on for real soon! [18:04:46] ejegg: wheeee! ¡¡Qué bien!! [18:05:04] I have to be afk-ish for like 1.5 hrs... basksoon [18:24:07] * cwd rubs eyes [18:24:12] ejegg: awesome [18:47:26] fundraising-tech-ops, Operations, ops-eqiad: decommission the old pay-lvs1001/pay-lvs1002 boxes - https://phabricator.wikimedia.org/T156284#3002796 (Jgreen) a:Jgreen>None [19:09:50] ugh, I think I didn't get the right plan... [19:10:53] overhelpful cell company employee was sending the initiation message from my phone and clicked the 'never allow' button when it asked to send to short codes [19:11:09] which I guess is impossible to revoke because of a bug in Android 6.0.1 [19:11:27] so they sent the message from another phone [19:12:17] but a little while after I started using it I got a text saying my 10MB were done... I was supposed to have 2GB [19:12:43] so... what's everyone working on, fr-tech? [19:17:46] Fundraising Sprint Autotune Earphones, Fundraising Sprint Baudelaire Bowdlerizer, Fundraising Sprint Costlier Alternative, Fundraising-Backlog, and 3 others: Create an import method for matching gifts and payroll deductions - https://phabricator.wikimedia.org/T115044#3002946 (LeanneS) @Eileenmcna... [19:48:46] ejegg[m]: heh welcome to metered internet hell [19:49:27] ack. They had some decent monthly plans too, but they wouldn't let me do them for just 2 months [19:49:57] it's kind of a fun adventure to critically analyze network usage [19:50:47] anyway, the library I'm at now is blocking VPN and SSH, so that's not going to let me get much done [19:51:12] ha [19:51:15] fascists! [19:51:20] but I can review stuff in gerrit! [19:53:06] oh hey, here's a thing to use the main mediawiki cache for IP velocity storage: https://gerrit.wikimedia.org/r/#/c/335868/ [19:53:30] That'll let us kill memcache and put it all in Redis if we want ^^^ [19:53:59] going to continue with that line for caching iDEAL stuff [19:54:36] ah nice [19:58:14] guh, right, can't upload to gerrit en la biblioteca. shoot, I guess I should hit the phone store again to make sure I'm not burning all my credit on the per-KB rates. [19:59:01] maybe you can tor everything [19:59:20] hah [19:59:26] or some sort of proxy [20:00:05] i'm gonna set up a tor exit node in longmont next time i'm up there [20:00:10] on my fiber connection [20:09:58] ejegg[m]: here in Mx you can get quite decent pay-as-you go plans, including data. You have to ask specifically... [20:11:31] ejegg[m]: I'd be surprised if there aren't cafés with decent connections about... Here there are many fancy-ish shopping centers with internet, too [20:11:45] * AndyRussG speculates about a country he's never been to [20:16:13] fr-tech Here's the WIP patch for varnish purge of banner content: https://gerrit.wikimedia.org/r/#/c/336237/ [20:16:52] The main issue I'm facing is that the it's a URL, but we need a title object to be able to get good URLs for mobile from within a desktop request [21:09:47] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Can't add more info to the prospect tab - https://phabricator.wikimedia.org/T157382#3003341 (CaitVirtue) [21:10:05] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Can't add more info to the prospect tab - https://phabricator.wikimedia.org/T157382#3003353 (CaitVirtue) p:Triage>Normal [21:20:06] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Can't add more info to the prospect tab - https://phabricator.wikimedia.org/T157382#3003375 (Eileenmcnaughton) Bad news - there is a character limit. Good news - you can edit it. I just edited the limit on the Biography field here civicrm/admin/custom... [21:43:03] cwd - I think my staging problem is that the civi DB got copied over a little before the drupal db (or backed up) - does that sound right? The max contribution_id in contribution_tracking is higher than the max id in civicrm_contribution [21:43:27] so I think I can just delete some entries from contribution_tracking to bring it in line [21:44:30] eileen1: ah interesting, i think those dbs dumps come from a cron job? [21:44:53] sounds likely they'd be from different times [21:44:56] ok - well - most operations I would never even be aware of it [21:45:45] if you can stomach manually syncing them up then go for it, lemme see if i can identify their origins [21:45:47] but I just happen to be testing something where it causes an issue - but I'll fix by sql [21:46:11] nah - I'll just delete all rows in contribution_tracking with id > max(contribution_id) [21:47:10] ok makes sense [21:47:22] 956 rows affected [21:47:31] eileen1: i am just finding the right triggers file to make them on staging [21:48:03] don't worry about it - I'll do it - I need to check the updated triggers file into git anyway [21:48:24] but basically the most recent file in ConfigAndLog dir will always be good [21:48:57] eileen1: that's what i was wondering. the last one we ran on live is from 2/2 [21:49:04] but i see more recent ones in there now [21:49:28] do you have rw to those dbs on staging? [21:49:35] dev_* [21:49:44] yeah - it creates them whenever the db would refresh the triggers [21:49:52] it doesn't mean anything has changed [21:49:59] gotcha [21:50:04] but, the most recent is always the …. most recent [21:51:00] on live I just changed the length of a custom data field per https://phabricator.wikimedia.org/T157382 & it generated a new file [21:51:23] but, that change does not change the triggers (in fact it doesn't even change the table - but on another field I think it would) [21:52:09] in that case it changes the value of something that is like a meta-table right? [21:52:31] yeah - well if it were a var char field it would change the field in mysql [21:52:49] but for note I think it is only stored in civicrm_custom_field & applied at the ui [21:54:31] ok so the new trigger file should be identical to the old? [21:55:20] I would think so [21:55:58] eileen1: i notice the newest one is 8kb vs older ones which are >1mb [21:56:58] does civicrm_value_1_prospect_5 ring a bell? [21:57:40] yeah - that is the table I just edited [21:57:50] newest one with the word trigger in it? [21:58:06] yep [21:58:10] note the ones in git I tend to have edited down a bit [21:58:13] is this on staging/ [21:58:27] eileen1: ah no sorry i was looking on live [21:59:53] newest one on staging is old [22:00:35] hmm - that is odd - that file is what you would see if logging was off [22:00:52] * cwd braces self [22:01:18] it feels like a bug - but not one that would affect us [22:01:28] a bug in trigger export? [22:01:47] yeah - well on a normal site that trigger sql would have been run [22:02:04] actually no [22:02:13] it only updates the triggers on that one table [22:02:18] yeah [22:02:21] but it doesn't nuke any [22:02:37] if you turn logging on & off or edit a field it normally creates a full file dropping & recreating [22:02:55] but obviously here it is just doing that one table [22:03:15] is that the one you just changed in the UI? [22:03:22] but, we don't need to run it as we have not added or dropped any fields [22:03:36] yes - it's that table [22:04:06] if I had made a material change then the log table would have been changed in that process - but the triggers only care if you add or delete fields [22:04:07] so that file should be a no-op? [22:05:01] ah yeah i see what you mean [22:05:22] manually lists the schema [22:05:43] it seems like you could query for the schema, but that's probably an unacceptable performance hit [22:14:57] schema queries can be OK or not - there is a page somewhere saying things like 'if you query this table you must include this column' [22:20:48] interesting [22:21:25] eileen1: i have to go to the grocery store but i will be back on in a while [22:21:33] do you need anything before i run off? [22:21:58] nope [22:22:20] ok, ttyl! [22:47:37] (PS1) Ejegg: WIP look up iDEAL banks, cache in Memcache [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/336333 (https://phabricator.wikimedia.org/T128692) [22:55:21] eileen1: do you have any opinion of the PSR6 caching interface? [22:56:28] hmm I'm not up with it [22:56:35] PSR is good in general... [22:58:22] k, just trying to reconcile the two different directions I'm going with the iDEAL stuff. [22:58:38] You could bounce some ideas off Tim Otten [22:58:46] he is the Civi top dev [22:58:58] (responsible for the good things about civi not the stuff we hate) [22:58:59] ah, nothing worth bothering him about [22:59:19] & I know he follows the psr stuff quite closely because he got a change into one of them (the logging one) [23:01:14] (CR) jerkins-bot: [V: -1] WIP look up iDEAL banks, cache in Memcache [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/336333 (https://phabricator.wikimedia.org/T128692) (owner: Ejegg) [23:03:20] cool, what did he change in the logging interface? [23:30:54] Fundraising-Analysis, Wikimedia-Fundraising-CiviCRM: CiviCRM log is showing errors relating to importing bounces - https://phabricator.wikimedia.org/T157397#3003686 (Eileenmcnaughton)