[00:05:45] (PS8) Awight: [WIP] GlobalCollect WX audit module [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/199653 (https://phabricator.wikimedia.org/T86090) (owner: Katie Horn) [00:12:04] eileen: Strange, I just turned on logging locally, got all the Initialization records, but nothing happens when I edit things. The trigger patch must be defaulted to not run automatically... [00:20:11] awight: sorry reconnected [00:20:17] np! [00:20:31] Sorry for spamming you :) [00:21:15] no that's cool [00:21:38] so last thing first... [00:22:11] that is really wierd that you are getting the column 'note' on civicrm_contribution [00:22:38] are you using trigger_create that you generated - or the one I checked into git that relates to prod? [00:23:12] I'm not totally certain, the modification time may have been from my checkout rather than being created locally. [00:23:16] It must be the prod one. [00:23:42] Yeah OK - so I copied a file to civicrm/sql/trigger_create.mysql - that generated somewhere else [00:23:46] I guess the logging setting is irreversible, but is there a simple hack for reversing the setting at least? [00:23:49] hmm [00:24:00] the problem with introspection... [00:24:16] if you are on the latest master & run updb you should have a setting in your civicrm_settings table [00:25:14] logging_no_trigger_permission [00:25:56] That's set to 1 for me. [00:26:11] Which is fine, I'm glad to test the more productiony code path [00:26:11] hmm ok [00:26:56] the sql should be created in your ConfigAndLog dir [00:27:26] you won't have that civicrm_contribution.note file in your local because it shouldn't be on prod either - but it seems it is [00:27:47] No sql was created [00:27:47] ConfigAndLog is in templates_c [00:28:01] hmm - odd that it won't reset you to 'no' [00:28:27] No errors... [00:29:45] fyi, [00:29:45] ERROR 1054 (42S22) at line 7025: Unknown column 'coupon_code' in 'NEW' [00:29:52] Want me to make a task for these? [00:30:52] is that because you are trying to run the file in sql/create_trigger.sql? [00:31:06] that will only work on staging & master because your tables will be different [00:31:19] aargh [00:31:27] e.g they have diff custom field ids [00:31:31] I see--yeah just hit those [00:31:36] & don't have the fields that shouldn't be on master [00:31:45] but you should be able to generate your own file [00:32:06] that's working locally for me - so I'm not sure sure what the difference is [00:32:15] perhaps the generated file should have that stuff in a header, -- Generated on Hostname, path X, version Y etc [00:33:23] Do I have to hack civicrm_domain to disable logging? [00:33:39] try drush cvapi setting.create logging=0 [00:33:48] woot! thank you [00:34:09] [error_code] => no such table [00:34:09] there is a ticket in the backlog for figuring out a dev way to set up triggers [00:34:23] can you add debug=1 to the end of it? [00:34:55] wow, it still doesn't say which table [00:36:07] probably you need to delete all the triggers you just created before anything at all will work :-) [00:36:17] (PM'd) [00:36:32] hehehe [00:36:39] yep - is there a trigger for that civicrm_settings table? [00:38:11] ftw: mysql -u root -p --skip-column-names civicrm -e 'SHOW TRIGGERS;' | cut -f1 | sed -r 's/(.*)/DROP TRIGGER IF EXISTS \1;/' | mysql -u root -p civicrm [00:38:30] success, excellent [00:38:36] now, to reenable logging... [00:39:01] huh. the Misc settings panel still says Logging: Yes [00:39:14] awight: you are a whiz throwing that command together - it always hurts my brain [00:39:22] rerun drush cvapi setting.create logging=0 [00:39:32] "logging";s:1:"1"; [00:39:38] eh I copied from stackoverflow [00:40:32] Did this a few times: drush cvapi setting.create logging=0 [00:40:38] Yet still: drush cvapi setting.getvalue name=logging [00:40:38] 1 [00:40:50] sigh [00:41:29] can you look in civicrm_setting & just delete that row? [00:42:20] hehehehe: update civicrm_domain set config_backend=replace(config_backend, '"logging";s:1:"1"', '"logging";s:1:"0"'); [00:42:23] ftw [00:43:11] rats, reenabling through the prefs panel still gave me "changes saved" with no alert about my new triggers sql [00:43:53] hmm odd - try truncating civicrm_cache & deleting all setting related rows in civicrm_setting [00:45:38] Oooh, deleting all settings was bad for my Civi's health [00:45:43] I think I misread u there [00:46:24] hey! I have all my triggers, seems the user had permissions. [00:46:34] well... that's all I need for now :) [00:46:54] I'll play with the log_civicrm_email and probably get my special effect that way [00:47:18] awight: opps I meant all logging related settings - not setting related [00:47:20] !! [00:47:20] cos it's like one line of SQL. Too bad about the caring & sharing ;) [00:48:19] :-) [00:50:51] whew, resource URL is all it took to make the UI usable again [00:51:06] :-) [00:52:31] Something creepy to share: my log_civicrm_email just inserted duplicate primary id 48, after it already had 765 rows. [00:52:49] This could be fallout from switching to innodb? [00:53:58] oh, sorry--looks like id actually refers to civicrm_email.id [00:54:38] yeah - no autoincrement on that table [00:54:57] that makes sense [00:55:28] cool. it's easy to query, I just pull out all email addresses associated with a contact, then subtract the active ones. Thanks again! [00:56:24] Fundraising Sprint Ghostbusting , Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Patch-For-Review: Changing email address in Civi should be exported to Silverpop - https://phabricator.wikimedia.org/T122411#2185690 (awight) Eileen has a nice workaround for this, we just query log_civicrm_email... [00:57:51] ok - hopefully that's more manageable than storing another email on record…. maybe [00:58:23] I think I'm already convinced that this is a great way to go... [00:58:30] cool [00:58:41] We should squeeze everything we can win from those SCD tables [00:58:49] :-) [00:59:42] I have a bunch of commits nearly ready to review on the change log side of things [00:59:57] I feel like maybe I should hurry along while you are interested :-) [01:00:01] great, please ping me if it doesn't look like I'm reviewing [01:00:06] nah, it's not like that [01:00:23] it can be hard to get your head into [01:00:31] I just didn't realize there was CR piling up, cos I'm too lazy to scan the dashboards [01:00:38] nah - all local still [01:00:50] I mean, last week... [01:00:53] the thing is I have it all queued up in the core PR queue [01:01:02] great! [01:01:15] & It's kind of a case or figuring out what timing I go with [01:01:39] The extra effort to upstream everything is obviously more than worthwhile [01:01:57] ie. get it reviewed there first in case I need to change or vice versa. I think there is one ticket that might be contentious upstream [01:02:40] Huh, I hadn't really thought about that--I usually just push things through on our end, then lament a bit if the upstream is rejected [01:02:49] ... which is how we got into this mess ;) [01:03:06] :-) [01:03:22] yeah I try to do it in parallel where I can [01:03:43] aww man, everyone left in the office started coughing horrifically... time to go! [01:03:48] :-) [01:03:59] pollen in the A/C... [01:04:12] see ya tomorrow [01:04:27] see ya [04:56:50] (PS1) Eileen: NFC preliminary tidy up for CRM-18332 [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/282085 [04:56:52] (PS1) Eileen: CRM-18332 add first cut of api for revert actions [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/282086 [04:56:54] (PS1) Eileen: CRM-18360 Expose logging data through GET api [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/282087 [04:56:56] (PS1) Eileen: CRM-18193 Make log_date optional for revert / retrieving changes where uniqueID is in play [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/282088 [04:56:58] (PS1) Eileen: CRM-18193 remove arbitrary setting of log_date when not provided. [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/282089 [04:57:00] (PS1) Eileen: Sync Logging_Schema with upstream incl comma from CRM-17685 [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/282090 (https://phabricator.wikimedia.org/T131223) [04:57:02] (PS1) Eileen: CRM-18366 Fix contact logging detail to show all related changes & revert all related changes [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/282091 [04:57:04] (PS1) Eileen: CRM-18193 do not require log_date [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/282092 [04:57:06] (PS1) Eileen: CRM-18193 do not pass log_date_id to detail report if the log_conn_id is sufficient [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/282093 [04:57:08] (PS1) Eileen: CRM-18215 Fix grouping so that Merge activities are not sometimes lost [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/282094 [04:57:10] (PS1) Eileen: CRM-18214 Add link to detail report for contact merge activities, with oid if applicable [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/282095 [05:01:32] (PS2) Eileen: CRM-18214 Add link to detail report for contact merge activities, with oid if applicable. [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/282095 [05:05:05] Fundraising Sprint Freshmaking, Fundraising Sprint Ghostbusting , Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Unplanned-Sprint-Work: Improve the change log report - https://phabricator.wikimedia.org/T130164#2186081 (Eileenmcnaughton) I just pushed up a whole chain starting here - https... [05:06:00] Fundraising Sprint Elevator Maintenance 2016, Fundraising Sprint Freshmaking, Fundraising Sprint Ghostbusting , Fundraising-Backlog: Civi: batch import of refunds, problem transaction: currency switched - https://phabricator.wikimedia.org/T127979#2186083 (Eileenmcnaughton) Note I moved this back t... [07:05:51] (Abandoned) Awight: [WIP] Stub contact save hook [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/281891 (https://phabricator.wikimedia.org/T122411) (owner: Awight) [07:50:50] (PS1) Awight: [WIP] Unsubscribe old emails; fix is_primary bug [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/282106 (https://phabricator.wikimedia.org/T122411) [08:11:18] (PS1) Awight: Comment about query performance [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/282108 [08:29:52] (PS2) Awight: [WIP] Unsubscribe old emails; fix is_primary bug [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/282106 (https://phabricator.wikimedia.org/T122411) [14:25:43] (CR) AndyRussG: "ext.centralNotice.bannerController.mobiledevice and ext.centralNotice.bannerController.lib are still being set for the mobile site via the" [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/280715 (owner: Paladox) [15:02:54] Fundraising Sprint Ghostbusting , Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Patch-For-Review: Changing email address in Civi should be exported to Silverpop - https://phabricator.wikimedia.org/T122411#2186937 (awight) @Eileenmcnaughton This patch is waiting on logging in production, now.... [15:04:34] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Turn logging on on live - https://phabricator.wikimedia.org/T132056#2186938 (awight) [15:04:42] Fundraising Sprint Freshmaking, Fundraising Sprint Ghostbusting , Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Finalise sql & process for turning logging on on live - https://phabricator.wikimedia.org/T130163#2186952 (awight) [15:04:44] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Turn logging on on live - https://phabricator.wikimedia.org/T132056#2186938 (awight) [15:04:56] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Turn logging on on live - https://phabricator.wikimedia.org/T132056#2186938 (awight) [15:04:58] Fundraising Sprint Ghostbusting , Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Patch-For-Review: Changing email address in Civi should be exported to Silverpop - https://phabricator.wikimedia.org/T122411#2186953 (awight) [15:10:16] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: CiviCRM SQL is out of sync with code version - https://phabricator.wikimedia.org/T132057#2186961 (awight) [17:16:08] Fundraising Sprint Ghostbusting , Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Only subscribe primary emails, secondary addresses should be suppressed - https://phabricator.wikimedia.org/T131979#2187479 (CCogdill_WMF) I'm only seeing like 680 new records on the suppression list today, definitel... [17:17:48] cwd: XenoRyet: morning! know of any DI code desirous of review? [17:18:14] Na, I don't have anything in review right now. [17:18:23] Hopefully I will later today though. [17:18:31] hmmm [17:25:27] Fundraising Sprint Ghostbusting , Fundraising-Backlog, Unplanned-Sprint-Work, FR-Ingenico: Require email on iDEAL form - https://phabricator.wikimedia.org/T96074#2187529 (Ejegg) Is this fixed with @awight's latest deploy? [17:30:48] ejegg: ^ any DI review I could do? [17:30:52] XenoRyet: K thx... [17:34:39] AndyRussG: I don't think I have anything, let me ses [17:34:41] *see [17:35:14] yeah, no donation interface, just crm and smashpig [17:35:47] hm, cwd I see you rebased the smashpig astropay lookup thing [17:37:31] ah yeah i was looking at that [17:37:33] aarg I sort of remember.... which one was that? [17:37:34] must have got distracted [17:37:45] ah sorry misread [17:46:43] (CR) Cdentinger: AstroPay: look up method and submethod together (1 comment) [wikimedia/fundraising/SmashPig] - https://gerrit.wikimedia.org/r/281534 (owner: Ejegg) [18:18:10] Fundraising-Backlog: SPRINT J (5/11 to 5/25) GOAL: Continue Paypal, dedupe exact matches? - https://phabricator.wikimedia.org/T132083#2187758 (DStrine) [18:26:44] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Fr-WMF-Audit: Some Ingenico refunds & cancels not reaching Civi - https://phabricator.wikimedia.org/T130129#2187800 (DStrine) [18:26:56] Fundraising Sprint Asbestos Removal 2016, Fundraising Sprint Bloodletting 2016, Fundraising Sprint Cat Herding, Fundraising Sprint Dirt Farming, and 5 others: Some Ingenico donations not in Civi - https://phabricator.wikimedia.org/T122730#2187802 (DStrine) [18:27:05] Fundraising Sprint Elevator Maintenance 2016, Fundraising Sprint Freshmaking, Fundraising-Backlog, Unplanned-Sprint-Work, and 2 others: Worldpay refunds not reaching Civi - https://phabricator.wikimedia.org/T129265#2187803 (DStrine) [18:28:12] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, FR-Smashpig, FR-Worldpay, Fr-WMF-Audit: Add 'Cancelled' type for refund messages - https://phabricator.wikimedia.org/T129714#2187807 (DStrine) [19:00:17] !log updated paymentswiki fraud filter settings [19:00:21] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log, Master [19:31:06] (PS1) Ejegg: Make SessionVelocity log like a fraud filter [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/282229 (https://phabricator.wikimedia.org/T126812) [19:32:35] (CR) jenkins-bot: [V: -1] Make SessionVelocity log like a fraud filter [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/282229 (https://phabricator.wikimedia.org/T126812) (owner: Ejegg) [19:36:00] (PS2) Ejegg: Make SessionVelocity log like a fraud filter [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/282229 (https://phabricator.wikimedia.org/T126812) [19:48:11] (PS1) Ejegg: Run SessionVelocity for Adyen [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/282231 (https://phabricator.wikimedia.org/T126812) [19:52:27] Fundraising Sprint Ghostbusting , Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Patch-For-Review: Changing email address in Civi should be exported to Silverpop - https://phabricator.wikimedia.org/T122411#2187964 (Eileenmcnaughton) I expect so [19:54:57] Fundraising-Backlog, MediaWiki-extensions-CentralNotice: CentralNotice: PHPUnit and QUnit tests for controls on campaigns list - https://phabricator.wikimedia.org/T132090#2187965 (AndyRussG) [20:00:13] Going to be like one min late to grooming. [20:01:30] (PS2) Ejegg: Run SessionVelocity for Adyen [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/282231 (https://phabricator.wikimedia.org/T126812) [20:03:56] XenoRyet: and AndyRussG meeting? [20:04:02] OMW [20:21:32] Fundraising Sprint Ghostbusting , Fundraising-Backlog, FR-Ingenico: Failure to regenerate Order ID on iDEAL form - https://phabricator.wikimedia.org/T131983#2188070 (DStrine) p:Normal>High [20:25:09] Fundraising Sprint Ghostbusting , Fundraising-Backlog, MediaWiki-extensions-DonationInterface, Unplanned-Sprint-Work, FR-Ingenico: iDEAL cancel returns donor to Thank You page - https://phabricator.wikimedia.org/T131904#2188094 (DStrine) p:Triage>High [20:30:56] Fundraising-Backlog, MediaWiki-extensions-DonationInterface: Preserve SOME info on gateway switch - https://phabricator.wikimedia.org/T131881#2188121 (DStrine) p:Triage>High [20:33:23] Fundraising-Backlog, Hovercards, MediaWiki-extensions-CentralNotice: Measure impact of HoverCards on Central Notice interaction - https://phabricator.wikimedia.org/T131366#2165081 (AndyRussG) [20:36:02] Fundraising-Backlog, MediaWiki-extensions-CentralNotice, MobileFrontend: Measure impact of mobile web link preview on Central Notice interaction - https://phabricator.wikimedia.org/T131373#2188148 (AndyRussG) [20:36:28] Fundraising-Backlog, MediaWiki-extensions-CentralNotice, MobileFrontend: Avoid z-index conflict with mobile web link preview & Central Notice and friends - https://phabricator.wikimedia.org/T131372#2188150 (AndyRussG) [20:39:06] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Change JPMorgan Import Field Values - https://phabricator.wikimedia.org/T131802#2178970 (awight) @LeanneS Our code used to match the column headers, so this means that they've changed their format in the last year or so. Can we make an attempt to ask... [20:40:10] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, MediaWiki-extensions-DonationInterface: Latest DonationInterface unusable under CRM - https://phabricator.wikimedia.org/T131798#2188158 (DStrine) p:Triage>Normal [20:56:45] Fundraising Sprint Ghostbusting , Fundraising-Backlog, MediaWiki-extensions-CentralNotice, Unplanned-Sprint-Work: CentralNotice: Make a plan for moving stuff out of cookies - https://phabricator.wikimedia.org/T131319#2162834 (DStrine) [21:01:39] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Change JPMorgan Import Field Values - https://phabricator.wikimedia.org/T131802#2188226 (LeanneS) @awight the relationship is managed by Finance so we'd have to make the request to Meron. These column headers have been used since I started last June tho... [21:50:11] Fundraising Sprint Ghostbusting , Fundraising-Backlog, Wikimedia-Fundraising, Unplanned-Sprint-Work, and 2 others: Mobile donation form: error entering valid email address NL-iDEAL - https://phabricator.wikimedia.org/T131323#2188401 (MBeat33) Thanks, @awight - donors like #217429 who got this erro... [21:52:41] Fundraising Sprint Ghostbusting , Fundraising-Backlog, Wikimedia-Fundraising, Unplanned-Sprint-Work, and 2 others: Mobile donation form: error entering valid email address NL-iDEAL - https://phabricator.wikimedia.org/T131323#2188412 (awight) Thanks for the good news! [21:53:45] Fundraising Sprint Ghostbusting , Fundraising-Backlog, Unplanned-Sprint-Work, FR-Ingenico: Require email on iDEAL form - https://phabricator.wikimedia.org/T96074#2188416 (awight) [22:10:15] Fundraising Sprint Ghostbusting , Fundraising-Backlog, Unplanned-Sprint-Work, FR-Ingenico: Failure to regenerate Order ID on iDEAL form - https://phabricator.wikimedia.org/T131983#2185087 (Ejegg) a:Ejegg [22:28:49] Well someone in my family (not me) is having fun just hanging out, playing minecraft and farting like there's no tomorrow [22:29:11] I guess it's just something a person has to do once in a while [22:30:21] Especially on a rainy day [22:30:55] Especially on a rainy day the day after having eaten order-in butter chicken [22:33:19] (PS1) Ejegg: WIP For cash, rtbt, ew, refresh order ID on repeats [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/282295 (https://phabricator.wikimedia.org/T131983) [22:38:05] (PS1) Ejegg: Minimalist iDEAL order id refresh fix [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/282297 (https://phabricator.wikimedia.org/T131983) [22:38:26] ^^ two different options for the iDEAL order ID refresh [22:38:32] any preferences? [22:38:43] * mwalker waves [22:38:47] hi mwalker ! [22:38:58] Still working on the Jetsons-mobile? [22:39:10] heh; yep; it's even flying [22:39:15] nice! [22:39:26] would *you* ride in it yet? [22:39:26] I know! it hasn't been all a complete waste [22:42:33] Blocked-on-Fundraising-Tech, Wikimedia-Fundraising, Operations, Traffic, HTTPS: links.email.donate.wikimedia.org should offer HTTPS - https://phabricator.wikimedia.org/T74514#2188594 (CCogdill_WMF) Closing the loop on this, finally! We no longer need to support Silverpop's domains (mtk41 or mkt4... [22:48:37] Fundraising Sprint Ghostbusting , Fundraising-Backlog, Unplanned-Sprint-Work: Astropay: "go back" (volver) sometimes takes user to the TY page - https://phabricator.wikimedia.org/T131401#2188653 (Ejegg) Just got an email saying some work on the AP side is done - will investigate! [22:52:25] oh, I weas about to let this room know he was here, but he already announced :) [22:53:17] they're being quiet today [22:53:40] we emerge from hibernation around October [23:13:30] mwalker: Greetings from the four-wheeled past! [23:14:33] Oh good, K4-713 has the IRC again. ^ There is an alien on the line for u [23:14:49] mwalker: !!! [23:14:56] O HAI. [23:15:17] hehe! [23:15:22] Hey K4; how's portland? [23:15:42] The dream of the 1890s is indeed alive. [23:15:46] :D [23:16:14] I have been here for... about four days now. I think my blood pressure dropped by 1/3rd or something. [23:16:44] impressive [23:16:44] K4-713: that might just happen any time one leaves east Oakland [23:17:05] dstrine: Oh, my blood pressure dropped going *in* to Oakland from SF, too. [23:17:07] Every day. [23:17:17] oh for sure [23:17:32] I have yet to be yelled at by a stranger on the street. [23:17:44] So weird. [23:17:55] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Change JPMorgan Import Field Values - https://phabricator.wikimedia.org/T131802#2188797 (awight) @LeanneS Is the "n" in "Account name" a lowercase? Thought I would confirm because the other headers are title case. We can certainly change our column n... [23:17:56] Is that a Oakland thing? [23:17:59] mwalker: How the heck have you been? [23:18:11] AndyRussG: It's a... Bay Area thing, as far as I can tell. [23:18:19] Hmmm [23:18:32] not horrible; I managed to burn myself out at the current job so I'm currently on vacation [23:18:39] basically the same old me [23:18:44] possibly a bit fatter though [23:18:51] mwalker: I was about to say something about "old habits". :p [23:19:18] I'm definitely fatter. [23:19:35] Jolly as @#^%$$. [23:19:52] (PS1) Awight: New column headers for JP Morgan [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/282298 (https://phabricator.wikimedia.org/T131802) [23:20:54] I can confirm all that ;) [23:21:27] * AndyRussG has hidden his bathroom scale [23:21:48] mwalker: You were saying you're building a new desk--does that mean you're moving, too? [23:21:51] (CR) jenkins-bot: [V: -1] New column headers for JP Morgan [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/282298 (https://phabricator.wikimedia.org/T131802) (owner: Awight) [23:22:14] nope; I'm still in the same old apt [23:22:20] I was just getting tired of the drafting table [23:22:28] so I built a new one out of pipe [23:22:40] which was a mistake because custom cut pipe is a lot more expensive than I thought it was going to be [23:22:46] and I didn't ask how much before I told them to do it [23:23:49] If you have to ask how much it costs, you can't afford it. [23:24:20] (cos, JP Morgan) [23:25:28] it's just one of those unfortunate things where of course I can afford it; I just could of done something a lot cheaper [23:26:15] speaking of; what are you doing with your old house k4? renting it to poor unfortunate fools> [23:27:19] That thing was ship shape. It clearly could reach escape velocity. [23:27:20] and... how is mari awight? [23:27:40] * mwalker imagines K4 just lifting the house out of the ground and driving up I-5 with it [23:28:33] Thanks! She is incredibly busy, we use her to find borrowed items and remember things that happened. [23:28:47] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Patch-For-Review: Change JPMorgan Import Field Values - https://phabricator.wikimedia.org/T131802#2188809 (LeanneS) Sorry about that! It is "Account Name" with a capital N. Thanks @awight [23:29:01] (PS1) Ejegg: Maintenance script to get AstroPay payment status [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/282300 (https://phabricator.wikimedia.org/T131401) [23:29:22] mwalker: Heh... The house will be sold in... 5 days or something. [23:29:39] (PS2) Awight: New column headers for JP Morgan [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/282298 (https://phabricator.wikimedia.org/T131802) [23:29:40] And by that I mean, the title will move and I will get paaaaaaaid. [23:29:53] woohoo [23:30:23] *high five* [23:30:25] freedom! [23:30:50] mwalker: I ended up selling to a friend, who begged me not to put it out on the market. We both feel like we were seriously ripping the other off. [23:31:03] awight, remembering things? that sounds like me when I was small; taking things apart before the parents were like "crap, we needed that!" [23:31:07] Fundraising Sprint Ghostbusting , Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Unplanned-Sprint-Work, Patch-For-Review: Change JPMorgan Import Field Values - https://phabricator.wikimedia.org/T131802#2188813 (awight) @LeanneS Nice--it's not every day that a hunch pans out! I have a fi... [23:31:15] :p [23:31:54] sounds like the sale worked itself all out then; if someone was happy it clearly wasn't fair [23:32:00] or something... [23:32:09] K4-713: :D that's great, I hadn't heard that detail. Keep it in the family! [23:33:03] Fundraising Sprint Ghostbusting , Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Unplanned-Sprint-Work, Patch-For-Review: Change JPMorgan Import Field Values - https://phabricator.wikimedia.org/T131802#2188816 (LeanneS) Good hunch! That's great. I should receive the latest report next wee... [23:33:31] Yeah, it was all really... easy. And now I get to be out of debt for the first time since my bicycle accident in 2009. [23:33:58] A turkey on every table [23:34:00] you're not launching yourself right back into buying another house? [23:34:07] I am, actually. [23:34:09] before all the rest of us move up north to escape the bay? [23:34:48] Yep. I am definitely part of the problem. :) [23:35:23] I've been thinking I need to beat everyone to the punch and move back to alaska [23:35:29] ccogdill: Hi! I've been meaning to ask you, what is Contact ID used for, in the Silverpop Unsubscribes file? [23:35:29] Oh man. [23:35:35] mwalker: Good idea. [23:35:45] in the unsubscribe file? nothing [23:35:53] mwalker: cos it will warm up to negative 20 over the next decade? [23:35:58] mwalker: Get that land before it becomes the only place on Earth with liquid water. [23:36:02] it has a few uses in the main database update [23:36:06] mwalker! hi :) [23:36:43] ccogdill: ah, erm in fact that column isn't even in the unsubscribes, is it? I was looking at a temporary table, I see... [23:37:01] haha makes sense [23:37:30] * awight shuffles notes upside-down in an attempt to decipher [23:38:07] * mwalker has forgotten all about this stuff and is glad :) [23:38:38] awight, heh; actually it's already there; anchorage got less snow this winter than places like minneapolis [23:38:42] So healthy to forget. [23:39:16] mwalker: sadness. Summer blizzards it is, then [23:41:19] well this is what i have to show for today https://github.com/caseydentinger/modseclog/blob/master/modseconds.sh [23:42:24] the siren song of bash [23:43:31] mwalker: Personally, I want to head for Antarctica. [23:43:45] there was an awesome job posting down there for a sysadmin [23:43:50] I'm still kicking myself for not applying [23:44:01] ... [23:44:37] I wonder how many sysadmins they have on that continent. [23:45:41] (PS3) Awight: [DO NOT MERGE] Unsubscribe old emails; fix is_primary bug [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/282106 (https://phabricator.wikimedia.org/T122411) [23:45:53] not many... for mcmurdo apparently only two [23:46:06] here was the job posting if you want to amuse yourself: https://ghgcorp.applicantpro.com/jobs/287067.html [23:47:19] cwd: That's a scorching hot script. I'm still staring at "tac" [23:47:32] i could learn to like the weather, but Exchange 2003... [23:50:13] cwd wow, there are an infinitude of ways people poll files for changes in scripts [23:50:37] so heinous. why do i bash [23:52:21] would anyone mind if i took at least the morning off tomorrow? i am suddenly several home depot trips away from a working shower. [23:52:46] sounds like a priority [23:53:05] (CR) XenoRyet: [C: 2] New column headers for JP Morgan [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/282298 (https://phabricator.wikimedia.org/T131802) (owner: Awight) [23:53:19] Eew, glad we aren't smelling one another too regularly, either [23:53:24] it's been a long time coming [23:55:26] an old house is a lot like an old code base. everything you peel back reveals sedimentary workarounds from previous care takers. [23:56:16] (Merged) jenkins-bot: New column headers for JP Morgan [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/282298 (https://phabricator.wikimedia.org/T131802) (owner: Awight) [23:58:04] In the case of a shower; I'm afraid you mean that literally [23:58:41] Fundraising-Backlog, MediaWiki-extensions-DonationInterface: 'Try again' links lead to bad ffname logspam - https://phabricator.wikimedia.org/T132119#2188876 (Ejegg)