[00:04:09] Fundraising Sprint Asbestos Removal 2016, Fundraising Sprint Bloodletting 2016, Fundraising Sprint Cat Herding, Fundraising Sprint Dirt Farming, and 4 others: Civi exports timing out - https://phabricator.wikimedia.org/T120892#2074249 (JCuriel) Hi Eileen. On a test run, I just tried exporting 95,0... [00:07:23] hey friends - a reminder that this is closing EOD if you're interested: https://office.wikimedia.org/wiki/ED_transition [00:07:50] Fundraising Sprint Asbestos Removal 2016, Fundraising Sprint Bloodletting 2016, Fundraising Sprint Cat Herding, Fundraising Sprint Dirt Farming, and 4 others: Civi exports timing out - https://phabricator.wikimedia.org/T120892#2074252 (Eileenmcnaughton) @JCuriel What is the criteria for the export... [00:08:58] Fundraising Sprint Asbestos Removal 2016, Fundraising Sprint Bloodletting 2016, Fundraising Sprint Cat Herding, Fundraising Sprint Dirt Farming, and 4 others: Civi exports timing out - https://phabricator.wikimedia.org/T120892#2074254 (Eileenmcnaughton) by mapping I mean - when export fields are y... [00:13:11] Fundraising Sprint Asbestos Removal 2016, Fundraising Sprint Bloodletting 2016, Fundraising Sprint Cat Herding, Fundraising Sprint Dirt Farming, and 4 others: Civi exports timing out - https://phabricator.wikimedia.org/T120892#2074263 (JCuriel) I tried pulling all donors from New York state from J... [00:30:26] (PS1) Ejegg: Remove obsolete Amazon FPS audit [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/274029 [00:31:17] Fundraising Sprint Asbestos Removal 2016, Fundraising Sprint Bloodletting 2016, Fundraising Sprint Cat Herding, Fundraising Sprint Dirt Farming, and 4 others: Civi exports timing out - https://phabricator.wikimedia.org/T120892#2074322 (Eileenmcnaughton) On retrying that I find the addition of the... [01:07:27] we're falling like flies [01:41:25] (PS1) Eileen: CRM-18125 remove country_id from filter where state_province_id is present [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/274048 [01:50:44] Fundraising Sprint Dirt Farming, Fundraising-Backlog, Wikimedia-Fundraising, FR-Ingenico: 'continue' button on the iDeal donation form not working - https://phabricator.wikimedia.org/T125470#1988189 (cwdent) After fiddling with this form for a bit the only one that consistently doesn't work for me... [01:50:55] Fundraising Sprint Dirt Farming, Fundraising-Backlog, Wikimedia-Fundraising, FR-Ingenico: 'continue' button on the iDeal donation form not working - https://phabricator.wikimedia.org/T125470#2074585 (cwdent) a:cwdent [03:18:02] (PS2) Eileen: CRM-18125 remove country_id from filter where state_province_id is present [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/274048 (https://phabricator.wikimedia.org/T120892) [06:24:36] (PS1) Eileen: CRM-17748 Expose options['result_buffering'] to CRM_Core_DAO [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/274060 (https://phabricator.wikimedia.org/T120892) [06:26:23] (PS1) Eileen: Return more rows per query and use unbuffered query to manage the memory [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/274061 (https://phabricator.wikimedia.org/T120892) [06:27:32] (PS1) Eileen: Stop bypassing caching for state_province abbreviation [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/274062 (https://phabricator.wikimedia.org/T120892) [06:28:09] Fundraising Sprint Asbestos Removal 2016, Fundraising Sprint Bloodletting 2016, Fundraising Sprint Cat Herding, Fundraising Sprint Dirt Farming, and 4 others: Civi exports timing out - https://phabricator.wikimedia.org/T120892#2074816 (Eileenmcnaughton) Following on from that I found some speed is... [08:43:44] Fundraising-Backlog, MediaWiki-extensions-CentralNotice, Easy: BUG: Campaign date fields cannot be edited as text - https://phabricator.wikimedia.org/T97159#2074941 (NeerajBattan) {F3462976} I am not able to edit the year in the end date. [09:30:06] Fundraising-Backlog, Wikimedia-Fundraising, MediaWiki-extensions-CentralNotice, Epic, and 3 others: Replace Special:RecordImpression with something that is not a special page - https://phabricator.wikimedia.org/T45250#2075021 (Nemo_bis) [09:42:42] Fundraising-Backlog, Epic: Migrate images, etc. from Sahar's hosting to WMF - https://phabricator.wikimedia.org/T90810#1068085 (Nemo_bis) Adding a guess at the meaning of "Sahar" based on https://gerrit.wikimedia.org/r/#/c/112613/ , https://www.mediawiki.org/wiki/Wikimedia_Engineering/Report/2014/January... [09:43:05] Fundraising-Backlog, Epic: Migrate images, etc. from Sahar Massachi's hosting to WMF - https://phabricator.wikimedia.org/T90810#2075045 (Nemo_bis) [11:53:47] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Reactivate Civi Login for Engage User - https://phabricator.wikimedia.org/T127375#2075352 (Jgreen) Open>Resolved [12:10:28] Fundraising Sprint Dirt Farming, Fundraising-Backlog, fundraising-tech-ops, Patch-For-Review: Make dedupe reversible step 1 of 5 test turning on logging on Staging to see how it performs. - https://phabricator.wikimedia.org/T127133#2075387 (Jgreen) [13:11:49] Fundraising Sprint Dirt Farming, Fundraising-Backlog, fundraising-tech-ops, Patch-For-Review: Make dedupe reversible step 1 of 5 test turning on logging on Staging to see how it performs. - https://phabricator.wikimedia.org/T127133#2075519 (Jgreen) Ok I loaded up the trigger.mysql query batch, see... [14:40:05] Fundraising Sprint Dirt Farming, Fundraising-Backlog: Civi: search by date+amount range is inoperative - https://phabricator.wikimedia.org/T127836#2075717 (MBeat33) Wow, that's super fast now - thank you @Eileenmcnaughton !! [14:59:57] Fundraising Sprint Asbestos Removal 2016, Fundraising Sprint Bloodletting 2016, Fundraising Sprint Cat Herding, Fundraising Sprint Dirt Farming, Fundraising-Backlog: Some Globalcollect donations not in Civi - https://phabricator.wikimedia.org/T122730#2075754 (MBeat33) Thanks, @cwdent - All the... [15:50:13] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Civi: error when cancelling recurring Ingenico donations - https://phabricator.wikimedia.org/T128389#2075963 (MBeat33) [16:06:16] Fundraising-Backlog, MediaWiki-extensions-CentralNotice, Easy: BUG: Campaign date fields cannot be edited as text - https://phabricator.wikimedia.org/T97159#2076007 (Nemo_bis) > I am not able to edit the year in the end date. Only CentralNotice admins can edit anything there. You need to make a wiki... [16:29:49] Fundraising Sprint Dirt Farming, Fundraising-Backlog, Unplanned-Sprint-Work: Civi: search by date+amount range is inoperative - https://phabricator.wikimedia.org/T127836#2055432 (DStrine) [16:30:18] Fundraising-Backlog, MediaWiki-extensions-CentralNotice, Easy: BUG: Campaign date fields cannot be edited as text - https://phabricator.wikimedia.org/T97159#2076071 (NeerajBattan) I have a wiki can you tell me the link for a campaign management form in the wiki that I am running on my system? [16:32:19] Fundraising-Backlog, MediaWiki-extensions-CentralNotice, Easy: BUG: Campaign date fields cannot be edited as text - https://phabricator.wikimedia.org/T97159#2076075 (NeerajBattan) or the file that is related to this? [17:25:34] Fundraising Sprint Dirt Farming, Fundraising-Backlog, Unplanned-Sprint-Work: Civi: search by date+amount range is inoperative - https://phabricator.wikimedia.org/T127836#2076285 (Eileenmcnaughton) Open>Resolved [17:28:26] (PS2) Eileen: Stop bypassing caching for state_province abbreviation [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/274062 (https://phabricator.wikimedia.org/T120892) [17:46:54] (CR) Ejegg: [C: 2] "Looks good, caches negative as well as positive results." [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/274062 (https://phabricator.wikimedia.org/T120892) (owner: Eileen) [17:53:05] (CR) Eileen: "This is after turning on archive logs - it's probably a bigger hit than I expected with just archives :-(" [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/273179 (https://phabricator.wikimedia.org/T127133) (owner: Eileen) [17:53:48] had to restart my year-old weechat process [17:53:50] that was sad [18:25:07] ejegg: "No processors available" is a catch all right? seeing it in the log for the ideal breakage with a GC error code we don't have in the map [18:25:15] 400880 [18:28:53] yeah, I think it is [18:34:34] ejegg: do you have the login for here? https://payment-services.ingenico.com/int/en/ogone/support/login [18:35:43] or K4-713 ... i wonder if you have any fond memories of this "IDEAL" thing [18:36:28] Fond? [18:36:31] it's a yo dawg i heard you like payment processor resellers situation [18:36:39] *hourglass spins* [18:39:55] cwd: Yeah, so... I don't recall any fondness. What's up? :p [18:41:17] oh...it's just broken [18:41:28] hah [18:41:33] How so? [18:41:38] it appears that it's just this one bank [18:41:40] I did make the thing work at several points. [18:41:42] Aaaha. [18:41:44] "Friesland Bank" [18:42:03] when i choose that one the front end chokes, i see "no processors available" in the log [18:42:13] but the error doesn't make it to the browser [18:42:38] So, first thing with IDEAL is to check the mountain of "this bank isn't working right now" emails we get, and see if that one is in there. [18:43:03] cwd I've got a login that works on the old address anyway [18:43:13] Also, there's a request somewhere, that returns all the banks that are currently available. [18:43:34] We certainly aren't using that with every donation request, and we definitely shouldn't. [18:43:40] Because requests cost money. [18:43:56] But, if we memcached the results for 10 minutes across the cluster or something... [18:44:14] ...we might be able to serve a more reasonable dropdown based on, you know... what actually works in their system. [18:44:29] yep that'd be good [18:44:43] However... [18:44:45] https://payments.wikimedia.org/index.php/Special:GlobalCollectGateway?title=Special%3AGlobalCollectGateway&ffname=rtbt-ideal-noadd&language=en&country=NL&amountGiven=&frequency=onetime&uselang=en [18:45:12] I am not sure I want to say on record that I have confidence that their available bank request is actually reflective of reality in any given minute. [18:45:17] people have reported varying degrees of breakitude here...but i consistently see just Friesland being broken [18:45:34] Maybe they are just not very good. [18:45:35] inasmuch as all the others forward me to dutch banks [18:45:48] * awight makes legal grunting noises [18:46:06] Hey: We are not responsible for third parties being able to stay... on. [18:46:13] I think it says that somewhere official. [18:46:19] hehehe that's right, show me the contract [18:46:52] Uptime variability issues. [18:47:21] They didn't always send us 50 emails a day saying that banks had gone off the air. [18:47:46] Which... isn't to say that wasn't baked in from the beginning. Perhaps they just started telling us about it. [18:47:54] Maybe we can use those emails to trigger the "get bank availability" script [18:48:07] meh. every 10 minutes is even better. [18:48:32] I'd rather just have it look every hour or something, than have it be triggered by something that they have no obligation to do consistently. [18:48:37] +1 [18:48:55] wait a minute, this isn't an iframe? [18:49:00] Though, I'd love to call them and pretend we built a system to read those things. [18:49:01] * cwd has to rethink everything [18:49:05] cwd: Nope! It's all us! [18:49:08] TOTAL CONTROL [18:49:27]
lawl [18:50:00] In the same way that the American South calls every soda a coke, all payments used to be paypal. [18:50:21] and class="greenBackground". cos that was the color years ago [18:50:22] hehe [18:50:31] class="classicCoke" [18:50:39] nyuk nyuk nyuk [18:50:41] Band Aid is actually just a sterile healing strip. [18:50:59] there are a lot of good ones [18:51:03] Moxie [18:51:06] Q-tip [18:51:08] is a brand name [18:51:41] https://upload.wikimedia.org/wikipedia/en/3/3a/Moxie_logo.jpg [18:51:56] Also, all restaurants are Taco Bell. In... just a few years, now. [18:52:01] watch out for that kid [18:52:08] it's like al capone joined the smiths [18:56:42] damn. 2,000 unread emails thanks to my interdepartmental ignoration [18:56:57] plus dramastorm [18:57:16] * awight reaches for "bankruptcy" chute lever [19:10:20] i guess we could just turn off Friesland [19:23:22] Fundraising-Backlog, Wikimedia-Fundraising: Ingenico: BPay donation form shows blank screen after 'Continue' - https://phabricator.wikimedia.org/T127863#2076963 (atgo) [20:06:46] Fundraising Sprint Dirt Farming, Fundraising-Backlog, Wikimedia-Fundraising, FR-Ingenico: IDEAL not working for a few banks - https://phabricator.wikimedia.org/T112533#2077156 (DStrine) [20:06:48] Fundraising Sprint Dirt Farming, Fundraising-Backlog, Wikimedia-Fundraising, FR-Ingenico: 'continue' button on the iDeal donation form not working - https://phabricator.wikimedia.org/T125470#2077158 (DStrine) [20:08:14] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, fundraising-tech-ops: [Possibly a duplicate ticket] Upcoming SSL cert expirations - https://phabricator.wikimedia.org/T128489#2077167 (DStrine) [20:15:18] Fundraising-Backlog, Continuous-Integration-Config, FR-Smashpig: SmashPig CI should run phpunit tests - https://phabricator.wikimedia.org/T127879#2077221 (awight) [20:19:47] Fundraising-Backlog, FR-Smashpig, Technical-Debt: SmashPig should mock queues for tests - https://phabricator.wikimedia.org/T127880#2077277 (awight) [20:24:25] Fundraising-Backlog: Civi: batch import of refunds, problem transaction: currency switched - https://phabricator.wikimedia.org/T127979#2060277 (atgo) @mbeat33 is this the only transaction that looks bad? [20:25:38] Fundraising-Backlog: UKFC Payment investigation - https://phabricator.wikimedia.org/T125887#2077304 (awight) [20:30:38] Fundraising-Analysis, DBA: Consider installing pt-deadlock-logger - https://phabricator.wikimedia.org/T128011#2077341 (Jgreen) a:Eileenmcnaughton We're currently running with autocommit=on so I don't ~think~ deadlocks should be an issue, but I could be wrong. At any rate show engine innodb status does... [20:36:08] Fundraising-Backlog: Enabling Offline BT for Poland (and Other countries) - https://phabricator.wikimedia.org/T127715#2077363 (Ppena) Just updating this ticket with the main countries that would benefit from having a functional offline BT option for DS and WTG: Spain Portugal Japan Italy France Poland Israe... [20:45:54] Fundraising-Backlog: Civi: batch import of refunds, problem transaction: currency switched - https://phabricator.wikimedia.org/T127979#2077376 (MBeat33) @atgo I spot checked about 25, including ones in COP and other currencies, and haven't found any more like this one. [21:16:37] Hi folks, there are a bunch of commits I'd like feedback on if anyone has time for review: https://gerrit.wikimedia.org/r/#/q/owner:Ejegg+status:open+-age:1month,n,z [21:44:12] awight: if you have any time for CR, there's a bunch I'd like feedback on [22:03:11] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Tables to go? Premiums & trxn_id - https://phabricator.wikimedia.org/T122029#2077628 (Jgreen) Since they're not part of civi/drupal, and have not been modified since 2011 I dropped the tables. They're in permanent backups on the off chance they're actua... [22:03:55] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Tables to go? Premiums & trxn_id - https://phabricator.wikimedia.org/T122029#2077636 (Jgreen) Open>Resolved [22:12:53] (PS1) Krinkle: Use RequestContext instead of $wgLang [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/274298 [22:14:38] (CR) jenkins-bot: [V: -1] Use RequestContext instead of $wgLang [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/274298 (owner: Krinkle) [22:37:19] (PS2) Krinkle: Use RequestContext instead of $wgLang [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/274298 [22:39:08] (CR) jenkins-bot: [V: -1] Use RequestContext instead of $wgLang [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/274298 (owner: Krinkle) [22:46:35] (PS3) Krinkle: Use RequestContext instead of $wgLang [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/274298 [22:48:14] (CR) jenkins-bot: [V: -1] Use RequestContext instead of $wgLang [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/274298 (owner: Krinkle) [22:50:03] ejegg: Need any CR? [22:50:27] that would be great, thanks! [22:50:45] https://gerrit.wikimedia.org/r/#/q/owner:Ejegg+status:open+-age:1month,n,z [22:50:51] Just start from the top? hehe ok [22:51:17] (PS3) Awight: Don't show single-value currency dropdown [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/271689 (https://phabricator.wikimedia.org/T124327) (owner: Ejegg) [22:51:47] heh, yeah, a couple aren't too important, but those should be trivial [22:52:40] This is a whole new machine, unfortunately... my laptop died the day I started doing Ed Program stuff! [22:52:49] aw man... [22:52:50] Beginner's mind. [22:53:07] hadn't it just died a few weeks prior to that too? [22:54:09] no, this was the only singularity [22:54:31] Maybe cwd|afk? He likes to jack his motorcycle up with ASUSi [22:55:20] ah yeah, laptop problems all around [22:55:41] mine's just refusing to wake from slumber every few days despite furious poking [22:56:24] gargg [23:00:06] awight: what did you end up with? [23:00:15] (PS4) Krinkle: Use RequestContext instead of $wgLang [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/274298 [23:01:35] (CR) jenkins-bot: [V: -1] Use RequestContext instead of $wgLang [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/274298 (owner: Krinkle) [23:05:19] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, fundraising-tech-ops: [Possibly a duplicate ticket] Upcoming SSL cert expirations - https://phabricator.wikimedia.org/T128489#2077937 (CaitVirtue) Update: Jeff and Leanne had a call with Engage last week and Jeff noted that there are other users wh... [23:06:05] (PS5) Krinkle: Use RequestContext instead of $wgLang [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/274298 [23:06:15] (PS6) Krinkle: Use RequestContext instead of $wgLang [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/274298 [23:10:57] cwd: same laptop :( [23:11:04] it doesn't even hold my bicycle up [23:11:12] s/same/identical/ [23:14:10] hehehe, round 2 [23:18:41] my little sister's in town, so I'm going to go have dinner with her & my mom [23:18:45] i'll check back in later [23:18:46] awesome! [23:18:52] I might have one thing CR'd :) [23:18:58] heh, thanks! [23:26:09] awight: which one are you looking at? so's not to duplicate efforts [23:27:53] cwd: I'm on https://gerrit.wikimedia.org/r/#/c/271689/ [23:27:59] But haven't started yet... [23:28:08] I'll keep you posted as anything actually happens. [23:28:33] Our stack is so elaborate, and of course vagrant NFS isn't working for me [23:28:34] word [23:29:04] yeah i never bother with NFS in that context [23:29:10] or really any context where i can avoid it [23:29:22] When it works, it's great [23:29:47] the alternative is a pain, cos editing from within the VM doesn't make changes to the host filesystem, plus weird permissions glitches [23:30:42] ah yeah, when i've developed in there i've just made patches and cp to /vagrant [23:30:52] * cwd rube [23:31:28] good discipline! [23:35:15] man did apt-get upgrade ever trash my system [23:35:32] you mixing repos or something? [23:35:36] Fundraising Sprint Dirt Farming, Fundraising-Backlog, fundraising-tech-ops, Patch-For-Review: Make dedupe reversible step 1 of 5 test turning on logging on Staging to see how it performs. - https://phabricator.wikimedia.org/T127133#2078124 (Eileenmcnaughton) Hi @Jgreen I can't see the triggers! I... [23:35:47] no, but i'm running stretch [23:35:56] which has been totally stable until today [23:36:05] ha. [23:42:03] dang Jeff ran that trigger script .. but the triggers are nowhere to be seen - only the tables & now he has left [23:42:24] (& the performance hit turned out to be something else … me leaving debugging on) [23:43:00] eileen: I think the triggers will be invisible to us [23:43:19] hmm - ok - but I don't see evidence of them working either :-( [23:43:22] hrm [23:43:38] well, compare show triggers for the other civi stuff, which we know is working [23:44:34] you mean you think there are other triggers that are working & we can't see them either? [23:44:52] yep [23:44:56] it's sort of dreadful [23:46:20] but is the price we pay for not having to hold mysql root passwords [23:46:34] phone_numeric fn isn't working SELECT * FROM civicrm_phone ORDER BY id DESC LIMIT 1\G [23:46:39] d'oh. [23:46:47] we might have skipped that one [23:47:15] That sounds vaguely familiar [23:49:02] I guess the question is 'if I update a phone number via the api does the modified_date on the contactupdate' [23:50:17] I do remember that exact function/trigger tripping us up during the 4.4 upgrade, and we did... something unethical here [23:50:41] cwd: hehe, I'm in a race to provision by hand before vagrant can finish [23:51:10] awight: which stack? [23:51:17] just paymentswiki [23:51:23] but I have no web server :D [23:51:28] been in Railsville [23:52:04] i have the nginx confs and stuff if you need em [23:52:46] may send flares up in a few [23:53:00] I'm hand-picking from yet another puppet thing I did [23:53:26] I don't think the modified_date triggers are working [23:53:55] aha! I just read your debugging note [23:53:57] Great news!