[01:49:37] (PS1) Eileen: CRM-17700 allow contribution get to bypass permissions [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/258918 (https://phabricator.wikimedia.org/T121284) [01:55:17] (PS1) Eileen: T121284 fix direct_mail field check [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/258919 (https://phabricator.wikimedia.org/T121284) [01:55:19] (PS1) Eileen: Add tests for campaign field check. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/258920 (https://phabricator.wikimedia.org/T121284) [01:55:54] (CR) jenkins-bot: [V: -1] Add tests for campaign field check. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/258920 (https://phabricator.wikimedia.org/T121284) (owner: Eileen) [02:25:07] Fundraising Sprint Zapp, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Unplanned-Sprint-Work, Patch-For-Review: Need to see UTM Source/UTM Campaign in Civi - https://phabricator.wikimedia.org/T121284#1876937 (Eileenmcnaughton) The scripts transfer the information from the utm_campaign fie... [02:50:50] Fundraising Sprint Zapp, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Unplanned-Sprint-Work, Patch-For-Review: Need to see UTM Source/UTM Campaign in Civi - https://phabricator.wikimedia.org/T121284#1876945 (Eileenmcnaughton) Here is the query & result for those appeals that have been co... [03:11:22] (PS2) Eileen: Fix direct_mail field check [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/258919 (https://phabricator.wikimedia.org/T121284) [03:41:56] (PS1) Eileen: Fix filter on receive_date in gateway report. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/258922 (https://phabricator.wikimedia.org/T121154) [03:41:58] (PS1) Eileen: Remove unnecessary function from gateway report [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/258923 (https://phabricator.wikimedia.org/T121154) [03:42:33] (CR) jenkins-bot: [V: -1] Remove unnecessary function from gateway report [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/258923 (https://phabricator.wikimedia.org/T121154) (owner: Eileen) [04:20:32] Fundraising Sprint Zapp, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Unplanned-Sprint-Work, Patch-For-Review: Need to see UTM Source/UTM Campaign in Civi - https://phabricator.wikimedia.org/T121284#1876977 (atgo) Hey @eileenmcnaughton, does this mean that the team will need to run sql q... [04:25:21] Fundraising Sprint Zapp, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Unplanned-Sprint-Work, Patch-For-Review: Need to see UTM Source/UTM Campaign in Civi - https://phabricator.wikimedia.org/T121284#1876978 (Eileenmcnaughton) So, I do have a habit of putting lots of info on tickets :-)... [14:42:41] Fundraising-Backlog: Other amount in WMF donation form: error message unclear - https://phabricator.wikimedia.org/T118741#1877666 (MBeat33) The donor in #189016 on 12/13 got the minimum amount error message after selecting 10 USD. They're using an Apple iPhone 6s on iOS 9.1 {F3087009} [15:52:54] Fundraising Tech Backlog, Fundraising-Backlog, Easy: Do not log CC exp date - https://phabricator.wikimedia.org/T86234#1877827 (Haritha28) a:Haritha28>None [16:06:04] Fundraising Sprint Zapp, Fundraising-Backlog: mobile donation form: expiration date error - https://phabricator.wikimedia.org/T120053#1877853 (MBeat33) The donor in ZD #189354 on 12/14 received this error, using the latest Safari browser on the latest Mac OS X version. Java is enabled. [17:23:52] Fundraising-Backlog: Silverpop unsubscribe import doesn't run on weekends; runs 4 times on Mondays - https://phabricator.wikimedia.org/T121415#1878085 (CCogdill_WMF) NEW [17:36:55] (PS1) Ejegg: Update drupal submodule [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/259026 [17:40:01] morning ejegg! can you confirm or deny my suspicion that smashpig deletes the audit files after queuing the jobs? [17:40:20] cwd lemme see... [17:40:29] you know where to find the code? [17:40:34] looks like it saves them to /tmp [17:40:52] i've just been looking at the logs [17:41:20] cwd download location is configurable in config.php [17:41:37] civi's config file? [17:41:44] nope, SmashPig's [17:42:00] oh, so i didn't see one of those besides the default [17:42:17] yah, it definitely deletes the file afterward. That's dumb, it's not like we're worried about disk space [17:42:36] Let's give it an archive location too [17:47:51] (PS1) Ejegg: Archive Adyen audit files rather than deleting [wikimedia/fundraising/SmashPig] - https://gerrit.wikimedia.org/r/259028 [17:50:18] cwd totally untested, but it oughtta be trivial ^^ [18:01:48] (PS1) Ejegg: Don't hardcode 'amazon' smashpig config node [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/259031 [18:04:39] (CR) Cdentinger: Archive Adyen audit files rather than deleting (1 comment) [wikimedia/fundraising/SmashPig] - https://gerrit.wikimedia.org/r/259028 (owner: Ejegg) [18:06:46] (CR) Ejegg: Archive Adyen audit files rather than deleting (1 comment) [wikimedia/fundraising/SmashPig] - https://gerrit.wikimedia.org/r/259028 (owner: Ejegg) [18:14:11] Fundraising Sprint Zapp, Fundraising-Backlog: mobile donation form: expiration date error - https://phabricator.wikimedia.org/T120053#1878346 (atgo) @mbeat33 this sounds like it's not a mobile browser - can you confirm? Do we need to change the scope of this task? This is still a GC task, so we need to f... [18:15:38] Fundraising Sprint William Shatner, Fundraising Sprint X-Ray Spex, Fundraising Sprint Yo La Tengo, Fundraising Sprint Zapp, and 2 others: Track email clickthroughs on donate wiki - https://phabricator.wikimedia.org/T114010#1878355 (Ejegg) @CCogdill_WMF almost got that worked out! The data is on a... [18:16:11] atgomez: re: impressions, everything should work as expected, so it's just up to FR to decide what level of impressions they want [18:17:52] (CR) Cdentinger: [C: 2] Don't hardcode 'amazon' smashpig config node [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/259031 (owner: Ejegg) [18:17:52] atgomez: I'm curious to hear generally how things are going on the mobile campaign, in terms of actual donations... to figure out if we should be still looking for some unknown error happening there [18:23:40] Did everyone drop from that meeting or was it just me? [18:27:35] Oh, was there supposed to be another big en standup today? [18:27:47] It seems to have disappeared from my calendar [18:28:01] eh, seemed a lot more like the normal FR one [18:29:07] ejegg: cwd i wouldn't worry about it [18:29:17] unless there's actively stuff going on [18:29:17] ah cool, thanks atgomez [18:29:23] and by stuff i mean technical issues [18:34:00] Fundraising Sprint Zapp, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Unplanned-Sprint-Work, Patch-For-Review: Need to see UTM Source/UTM Campaign in Civi - https://phabricator.wikimedia.org/T121284#1878421 (atgo) Ok, let me confirm my understanding here, mostly for @caitvirtue and @ccog... [18:34:37] Fundraising Sprint Zapp, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Unplanned-Sprint-Work, Patch-For-Review: Need to see UTM Source/UTM Campaign in Civi - https://phabricator.wikimedia.org/T121284#1878422 (Eileenmcnaughton) yep [18:35:07] oh right - yeah I looked in my calendar & figured it was not on today [18:35:19] eileen: don't worry about it :) [18:35:46] is the standup in my calendar on? It's in 2.5 hours [18:36:05] yes the tech standup [18:36:57] cool [18:39:09] (CR) Eileen: Fix direct_mail field check (1 comment) [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/258919 (https://phabricator.wikimedia.org/T121284) (owner: Eileen) [18:40:05] If anyone has a chance to review this one https://gerrit.wikimedia.org/r/#/c/258919/ it is the fix for configured campaigns not going in [18:40:28] I'll take a look eileen [18:40:37] thanks ejegg [18:41:24] I'm not sure how best to the backfill update query though. I was going to do it through an update in the module. But the issue is that it does a query calling on both drupal & civi DBs & I'm not sure the DB user has permissions for that [18:42:37] hmm, i feel like that join has to exist someplace. Lemme see [18:49:41] eileen: hmm, maybe that doesn't actually happen anywhere! Are you trying to insert an option value for each of the 4,600 utm_campaigns? [18:50:21] ejegg: no - to add the values that should have been inserted but weren't to the contact direct mail custom field [18:51:05] aren't those the utm_campaign values from contribution_tracking? [18:51:11] yep [18:51:21] so ticket is this https://phabricator.wikimedia.org/T121284 [18:51:31] it seems atgomez is only interested in 2 campaigns [18:51:41] Ah, gotcha [18:52:15] & there are only about 600 missing bits of data - so a select query + php api job would also work [18:52:41] Ah, fun... [18:52:52] this comment is basically the main part https://phabricator.wikimedia.org/T121284#1876945 [18:54:17] hmm - did you see that failmail that just came in? That's not a good error [18:54:41] eileen: those are the only 2 that i saw from your pasting? [18:55:01] eileen: blecch, unknown DB error [18:55:11] oops. i totally misread that. [18:55:23] atgomez: ok - so there is a long list of utm_campaigns (somewhere in that ticket ) but I'm not which they actually want [18:55:36] ha yeah the comments were hidden [18:55:37] ejegg: [18:55:42] * atgomez reads again [18:55:44] those errors are not good [18:56:01] my first feeling is it might be a jeff_green thing? [18:56:15] what did I break? [18:56:31] eileen: possibly - I'm trying to find more info than just 'db error' [18:56:37] ohh - I didn't realise you'd get it when not here [18:56:52] there are a couple of db errors in the failmail just now [18:57:18] (where do we go to get the logs for those?) [19:00:23] mysql itself looks like it's configured to log to db1025:/var/log/mysql/error.log but that file has no content [19:00:40] yipes! [19:01:20] I wouldn't be surprised that it's not logging query errors [19:01:22] there should be a CiviCRM log somewhere that would have the error when it gives an error like that [19:02:05] that would be on barium, and also central logged to indium:/var/log/remote/* if civi is using syslog [19:02:08] eileen: I think we had to hack something in to core to get the details of most db errors, and we chucked that part during the 4.6 upgrade [19:02:42] ok - but CiviCRM has it's own log (usually under files/civicrm/ConfigAndLog [19:02:50] all I can see in remote/error is the same 'DB Error: unknown error' [19:03:15] ah, I think the Civi log is in remote/fundraising-drupal [19:03:23] does that have the stuff you expect? [19:03:25] that sort of error would normally leave a backtrace in the civi log [19:03:26] Woah guys. [19:03:40] I just ran a query that took over five minutes last week, and it took 17 seconds. [19:03:59] Did somebody rub down the civi db with cheetah blood or something? [19:04:06] oh yeah, I just deleted most of the db for kicks :) [19:04:13] rofl... [19:04:21] ...well, it didn't touch my data. It was all... accurate. [19:04:34] was that a direct query? [19:04:45] Jeff_Green: been doing some index tuning or hardware upgrades? [19:06:46] ejegg: that doesn't look like the civicrm log - it would dump a backtrace on that error [19:06:58] (you probably have the log locally) [19:08:33] ejegg: nope, haven't touched the database machine in several days [19:08:56] oh but there was a cheetah blood spill at the datacenter [19:10:49] Fundraising Sprint Zapp, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Unplanned-Sprint-Work, Patch-For-Review: Need to see UTM Source/UTM Campaign in Civi - https://phabricator.wikimedia.org/T121284#1878587 (atgo) ok I've been talking to @awight. So the longer list is all the campaigns t... [19:13:01] Happy Monday awight ! [19:13:09] ejegg: Mornoon! [19:13:17] Fundraising Sprint Zapp, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Unplanned-Sprint-Work, Patch-For-Review: Need to see UTM Source/UTM Campaign in Civi - https://phabricator.wikimedia.org/T121284#1878589 (CCogdill_WMF) I'm staying out of this decision and leaving it to @caitvirtue. Th... [19:13:54] Do you know if we ditched some DB error log patches on the way to 4.6? [19:14:39] The latest failmail's blame line is an unhelpful 'DB error: Unknown error' [19:14:45] ejegg: yes, we did [19:14:49] and logs don't seem to have much more [19:15:15] It was not gonna merge. The thought was that we would readd that functionality where it emerged that we needed it again [19:15:22] Fundraising Sprint The Pogues, Fundraising-Backlog, Astropay, FR-Astropay, and 2 others: AstroPay adapter is spamming cc-limbo queue - https://phabricator.wikimedia.org/T107787#1878606 (DStrine) [19:15:24] Fundraising Sprint Queen, Fundraising Sprint The Pogues, Fundraising-Backlog, Astropay, and 4 others: AstroPay donors all sent to fail page - https://phabricator.wikimedia.org/T108059#1878605 (DStrine) [19:15:26] Fundraising Sprint The Pogues, Fundraising-Backlog, Astropay, FR-Astropay, and 2 others: Add 'loading' indicator to AstroPay form - https://phabricator.wikimedia.org/T107321#1878610 (DStrine) [19:15:28] Fundraising Sprint The Pogues, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Astropay, and 2 others: AstroPay audit parse failure - https://phabricator.wikimedia.org/T107673#1878608 (DStrine) [19:15:30] Fundraising Sprint ODB, Fundraising Sprint The Pogues, Fundraising-Backlog, Astropay, and 3 others: Update Brazil fiscal number to CPF - https://phabricator.wikimedia.org/T106137#1878614 (DStrine) [19:15:32] Fundraising Sprint The Pogues, Fundraising-Backlog, Astropay, FR-Astropay, and 2 others: Parse AstroPay error codes / description and display appropriate messages to donor - https://phabricator.wikimedia.org/T106053#1878615 (DStrine) [19:15:34] Fundraising-Backlog, Astropay, FR-Astropay: Add AstroPay to FundraiserLandingPage for Brazil - https://phabricator.wikimedia.org/T106052#1878617 (DStrine) [19:15:52] awight: cool, I wonder if now is that time [19:16:13] ejegg: Unknown error is a sad thing from inside the pear DB lib, all we need to do is take the raw db error number and surface it in the error string [19:16:17] please do! [19:18:16] just so you know - if we add the parameter debug=1 to an api call then any error that emerges contains more detail [19:18:27] include the sql it was trying to run when it failed [19:18:28] thx! [19:18:44] another note about that, please be careful not to email db passwords [19:18:45] oh nice! [19:19:04] I don't think it adds that on anymore [19:19:23] awight: looks like it was wmf-api.patch [19:20:19] does that basically do the same thing as adding debug=1? [19:21:12] eileen: where utils.php catches the PEAR_Exception, that patch digs into the original exceptions to get to the bottom of the issue [19:22:42] https://gerrit.wikimedia.org/r/99286/ [19:24:11] ejegg: One easy way to test a patch for this issue would be to remove a simple error code from the DB/mysql.php module, like "duplicate row" or something. [19:25:25] ejegg: this is where civi adds handling if debug param is set https://github.com/civicrm/civicrm-core/blob/master/Civi/API/Kernel.php#L312 [19:25:34] ah, thanks! [19:28:03] eileen: odd, I don't see where getExtraData comes from! [19:28:26] Also, looks like those method_exists checks are looking at the wrong variable! [19:29:00] is this the same DB_Error? https://pear.php.net/manual/en/package.database.db.db-error.php [19:29:06] ejegg: the getExtraData depends on the type of exception thrown [19:29:23] civi might be throwing an API exception [19:29:38] which I think eventually extends PEAR [19:29:44] ah, gotcha [19:29:46] eileen: but ejegg has a point, that we check method_exists on $e but call the method on $error [19:30:19] yeah [19:31:54] the getUserData part is the more useful part - perhaps that's why no-one has noticed the other not working :-) [19:46:20] Now for something cute [19:46:36] My colleague in NZ has a nestcam … live https://www.youtube.com/watch?v=JKlW9DHOFYg&feature=youtu.be [19:47:27] Aww [19:48:51] awesome [19:50:00] Fundraising Sprint William Shatner, Fundraising Sprint X-Ray Spex, Fundraising Sprint Yo La Tengo, Fundraising Sprint Zapp, and 2 others: Track email clickthroughs on donate wiki - https://phabricator.wikimedia.org/T114010#1878851 (Ejegg) Oh man, looks like we've been pulling 100% of the hits from... [19:50:31] Heh, mom showed up. [19:50:47] Or dad, I can't tell with birds. [19:51:00] Fundraising Sprint William Shatner, Fundraising Sprint X-Ray Spex, Fundraising Sprint Yo La Tengo, Fundraising Sprint Zapp, and 2 others: Track email clickthroughs on donate wiki - https://phabricator.wikimedia.org/T114010#1878861 (CCogdill_WMF) That makes sense, @K4-713 suggested donate wiki was... [19:52:49] eileen: cute!! [19:53:26] :-) [20:01:31] I'm gonna try to catch the rest of "BROWNBAG: Discovery/Editing/Reading Showcase" [20:21:14] Fundraising Sprint Zapp, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Unplanned-Sprint-Work, Patch-For-Review: Need to see UTM Source/UTM Campaign in Civi - https://phabricator.wikimedia.org/T121284#1878997 (Eileenmcnaughton) a:Eileenmcnaughton [20:22:23] Fundraising Sprint Zapp, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Unplanned-Sprint-Work, Patch-For-Review: Need to see UTM Source/UTM Campaign in Civi - https://phabricator.wikimedia.org/T121284#1874602 (Eileenmcnaughton) I'm putting this in review because this patch https://gerrit.... [20:33:49] Fundraising-Backlog: Get composer.json in crm deployable - https://phabricator.wikimedia.org/T117898#1879026 (cwdent) [20:33:49] Fundraising Sprint William Shatner, Fundraising Sprint X-Ray Spex, Fundraising Sprint Yo La Tengo, Fundraising Sprint Zapp, and 3 others: Build Frig: tools to help update our deployment branches - https://phabricator.wikimedia.org/T116820#1879025 (cwdent) [20:44:00] Fundraising-Backlog: Deploy config files from git - https://phabricator.wikimedia.org/T121443#1879056 (cwdent) NEW a:cwdent [20:44:11] Fundraising-Backlog: Deploy config files from git - https://phabricator.wikimedia.org/T121443#1879065 (cwdent) [20:44:13] Fundraising Sprint William Shatner, Fundraising Sprint X-Ray Spex, Fundraising Sprint Yo La Tengo, Fundraising Sprint Zapp, and 3 others: Build Frig: tools to help update our deployment branches - https://phabricator.wikimedia.org/T116820#1879064 (cwdent) [20:51:43] Fundraising Sprint Yo La Tengo, Fundraising Sprint Zapp, Fundraising-Backlog, MediaWiki-extensions-DonationInterface, and 2 others: Globalcollect Status 25/404 errors - https://phabricator.wikimedia.org/T120030#1879087 (awight) a:awight>None [21:06:33] Fundraising Sprint Zapp, Fundraising-Backlog, MediaWiki-extensions-CentralNotice, Unplanned-Sprint-Work: Impressions are looking weird for mobile campaign - https://phabricator.wikimedia.org/T121042#1879140 (DStrine) a:AndyRussG [21:14:13] Fundraising Sprint Zapp, Fundraising-Backlog, Epic, FR-Adyen: [epic] Adyen 1 hour test - https://phabricator.wikimedia.org/T118201#1794232 (cwdent) [21:15:39] Fundraising Sprint Zapp, Fundraising-Backlog, Epic, FR-Adyen: [epic] Adyen 1 hour test - https://phabricator.wikimedia.org/T118201#1879169 (cwdent) a:cwdent [21:16:20] Fundraising Sprint Zapp, Fundraising-Backlog, Epic, FR-Adyen: [epic] Adyen 1 hour test - https://phabricator.wikimedia.org/T118201#1879173 (cwdent) Open>Resolved We did this on Friday. Adyen is not campaign ready but the test went fine. [21:16:21] Fundraising-Backlog, Epic: [epic] Get Adyen back up - https://phabricator.wikimedia.org/T90748#1879175 (cwdent) [21:16:58] Fundraising Sprint Zapp, Fundraising-Backlog, Epic, FR-Adyen: [epic] Adyen 1 hour test - https://phabricator.wikimedia.org/T118201#1879178 (cwdent) [21:16:59] Fundraising Sprint X-Ray Spex, Fundraising Sprint Yo La Tengo, Fundraising Sprint Zapp, Fundraising-Backlog, FR-Adyen: Adyen: retest internally with real credit cards - https://phabricator.wikimedia.org/T118293#1879177 (cwdent) Open>Resolved [21:18:33] Fundraising Sprint X-Ray Spex, Fundraising Sprint Yo La Tengo, Fundraising Sprint Zapp, Fundraising-Backlog, FR-Adyen: Adyen: retest internally with real credit cards - https://phabricator.wikimedia.org/T118293#1879184 (cwdent) [21:18:51] Fundraising Sprint Zapp, Fundraising-Backlog, Epic, FR-Adyen: [epic] Adyen 1 hour test - https://phabricator.wikimedia.org/T118201#1794232 (cwdent) [21:18:53] Fundraising Sprint Yo La Tengo, Fundraising Sprint Zapp, Fundraising-Backlog, MediaWiki-extensions-DonationInterface, FR-Adyen: Fix CSS on Adyen form - https://phabricator.wikimedia.org/T117897#1879185 (cwdent) Open>Resolved [22:07:59] Fundraising Sprint Zapp, Fundraising-Backlog: mobile donation form: expiration date error - https://phabricator.wikimedia.org/T120053#1879274 (MBeat33) I've asked the donor in #189354 to confirm their device, and also if they specified a month first, per Sal's suggestion. [22:22:55] Fundraising Sprint Yo La Tengo, Fundraising Sprint Zapp, Fundraising-Backlog, MediaWiki-extensions-DonationInterface, Patch-For-Review: Create a state dropdown for Mustache forms - https://phabricator.wikimedia.org/T119585#1879318 (cwdent) @awight T120992 has a small start on doing some for rea... [22:28:38] (PS1) Eileen: CRM-17691 do not use default return properties from search screen [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/259158 (https://phabricator.wikimedia.org/T120892) [22:28:40] (PS1) Eileen: Free the DAO, if it comes back it's yours [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/259159 (https://phabricator.wikimedia.org/T120892) [22:28:41] (PS1) Eileen: CRM-17691 when doing a query to retrieve ids for export ... only retrieve the ids [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/259160 (https://phabricator.wikimedia.org/T120892) [22:28:43] (PS1) Eileen: CRM-17691 add the campaign id to selector even though it ? is not used? [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/259161 (https://phabricator.wikimedia.org/T121284) [22:28:59] (PS2) Cdentinger: WIP mustache l10n [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/258099 (https://phabricator.wikimedia.org/T120992) [22:31:12] Fundraising Sprint William Shatner, Fundraising Sprint X-Ray Spex, Fundraising Sprint Yo La Tengo, Fundraising Sprint Zapp, and 2 others: Track email clickthroughs on donate wiki - https://phabricator.wikimedia.org/T114010#1879366 (Ejegg) @awight, the plan is to add contact_id and link_id columns... [22:31:22] (CR) jenkins-bot: [V: -1] WIP mustache l10n [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/258099 (https://phabricator.wikimedia.org/T120992) (owner: Cdentinger) [22:31:39] Hope that proposal seems as simple to you as it does to me awight ^^^ [22:31:52] Don't think it's that big a change [22:33:57] ejegg: Great! Will donatewiki_unique be populated by a trigger, or directly inserted by the Django script? [22:34:37] probably the django script, unless there are other things dumping data into _raw [22:38:10] Fundraising Sprint Yo La Tengo, Fundraising Sprint Zapp, Fundraising-Backlog, MediaWiki-extensions-DonationInterface, Patch-For-Review: Create a state dropdown for Mustache forms - https://phabricator.wikimedia.org/T119585#1879401 (cwdent) [22:39:29] Fundraising Sprint Yo La Tengo, Fundraising Sprint Zapp, Fundraising Tech Backlog, Fundraising-Backlog, and 2 others: Spike [2 hours]: QuickSurveys deployment process - https://phabricator.wikimedia.org/T119632#1879405 (jhobs) a:jhobs [22:40:50] ejegg: happily, no [22:41:12] (CR) Cdentinger: "recheck" [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/258099 (https://phabricator.wikimedia.org/T120992) (owner: Cdentinger) [22:41:29] cool, I'll avoid the triggers then. It'll be fine to insert into _unique a big batch at a time [22:43:53] Fundraising Sprint Yo La Tengo, Fundraising Sprint Zapp, Fundraising-Backlog, MediaWiki-extensions-DonationInterface, Patch-For-Review: Create a state dropdown for Mustache forms - https://phabricator.wikimedia.org/T119585#1879421 (awight) @cwdent I'm happy with any degree of provisional wedgin... [22:47:11] (CR) Awight: add state dropdown to mustache form (1 comment) [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/258075 (owner: Cdentinger) [22:48:59] i'm going to head home, back in a bit [22:56:42] awight: so just looking at wmf_civicrm.install - I see a number of examples of switching to the civicrm db - but none of then getting the db prefix for the drupal db - is there one you were thinking of? [22:59:02] eileen1: I don't think anything does this yet, but it would be: global $databases['default']['default']['database'] [22:59:11] ok [23:03:50] http://qz.com/572623/this-simple-negotiation-tactic-brought-195-countries-to-consensus-in-the-paris-climate-talks/ [23:04:00] "indaba" story I mentioned ^ [23:07:08] (PS1) Ejegg: Add contact_id and link_id to raw LP stats [wikimedia/fundraising/tools/DjangoBannerStats] - https://gerrit.wikimedia.org/r/259178 (https://phabricator.wikimedia.org/T114010) [23:08:39] nice [23:09:30] awight: ^^ that patch just adds the columns and starts collecting data. I'll add the uniques table and do the counts in the next patch, but I thought it would be nice to start collecting data ASAP [23:12:43] ehh, contact_id doesn't need that much space [23:13:14] oh, and I should truncate [23:16:15] (PS2) Ejegg: Add contact_id and link_id to raw LP stats [wikimedia/fundraising/tools/DjangoBannerStats] - https://gerrit.wikimedia.org/r/259178 (https://phabricator.wikimedia.org/T114010) [23:16:41] Fundraising Sprint X-Ray Spex, Fundraising Sprint Yo La Tengo, Fundraising Sprint Zapp, Fundraising-Backlog, FR-GlobalCollect: Do not show donation form error message: "No processors available" - https://phabricator.wikimedia.org/T117872#1879495 (awight) [23:20:13] Fundraising Sprint X-Ray Spex, Fundraising Sprint Yo La Tengo, Fundraising Sprint Zapp, Fundraising-Backlog, FR-GlobalCollect: Do not show donation form error message: "No processors available" - https://phabricator.wikimedia.org/T117872#1879504 (awight) [23:22:48] Fundraising-Backlog, MediaWiki-extensions-DonationInterface: Highlight "investigation required" errors - https://phabricator.wikimedia.org/T121458#1879507 (awight) NEW [23:27:33] (CR) Awight: "Do we need the indexes?" (2 comments) [wikimedia/fundraising/tools/DjangoBannerStats] - https://gerrit.wikimedia.org/r/259178 (https://phabricator.wikimedia.org/T114010) (owner: Ejegg) [23:29:54] (PS2) Cdentinger: add state dropdown to mustache form [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/258075 (https://phabricator.wikimedia.org/T119585) [23:32:27] (PS1) Eileen: Add script to fill missing appeal data [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/259185 [23:32:42] (CR) jenkins-bot: [V: -1] Add script to fill missing appeal data [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/259185 (owner: Eileen) [23:33:25] Fundraising-Backlog, MediaWiki-extensions-CentralNotice: CentralNotice extension should have a calendar - https://phabricator.wikimedia.org/T35650#1879528 (Jseddon) [23:33:52] how do we update motd - I notice the date is wrong on it [23:35:13] eileen: hehe. Email jgreen [23:35:25] cool [23:35:47] (PS1) Awight: Make the generic error message human-readable [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/259186 (https://phabricator.wikimedia.org/T117872) [23:36:12] MBeat: ^ You might want to take a look at the new language, too [23:36:26] thx, will do [23:36:27] I'd love to make it even more readable, if anyone has suggestions? [23:36:41] (CR) Ejegg: Add contact_id and link_id to raw LP stats (2 comments) [wikimedia/fundraising/tools/DjangoBannerStats] - https://gerrit.wikimedia.org/r/259178 (https://phabricator.wikimedia.org/T114010) (owner: Ejegg) [23:38:15] (PS3) Ejegg: Add contact_id and link_id to raw LP stats [wikimedia/fundraising/tools/DjangoBannerStats] - https://gerrit.wikimedia.org/r/259178 (https://phabricator.wikimedia.org/T114010) [23:38:29] Fundraising Sprint X-Ray Spex, Fundraising Sprint Yo La Tengo, Fundraising Sprint Zapp, Fundraising-Backlog, and 2 others: Do not show donation form error message: "No processors available" - https://phabricator.wikimedia.org/T117872#1879540 (awight) [23:39:09] Fundraising Sprint X-Ray Spex, Fundraising Sprint Yo La Tengo, Fundraising Sprint Zapp, Fundraising-Backlog, and 2 others: Do not show donation form error message: "No processors available". Fix UI and plug holes. - https://phabricator.wikimedia.org/T117872#1879542 (awight) [23:39:36] MBeat: sorry, I don't know if you've messed with that code review interface before. Here's the substance: https://gerrit.wikimedia.org/r/#/c/259186/1/gateway_common/i18n/interface/en.json,unified [23:40:13] thx, it was Greek-ey to me [23:40:27] hehe. yeah it's impenetrable to us as well [23:42:43] I need to chauffeur, see you in a few hours! [23:43:23] Fundraising-Backlog, FR-GlobalCollect: GlobalCollect error 430339: INVALID_MERCHANT_OR_SERVICE_PROVIDER - https://phabricator.wikimedia.org/T120728#1879550 (awight) [23:43:25] Fundraising Sprint X-Ray Spex, Fundraising Sprint Yo La Tengo, Fundraising Sprint Zapp, Fundraising-Backlog, and 2 others: Do not show donation form error message: "No processors available". Fix UI and plug holes. - https://phabricator.wikimedia.org/T117872#1879549 (awight) [23:49:58] Fundraising-Backlog, MediaWiki-extensions-CentralNotice: Central Notice - Campaign Overlap warning - https://phabricator.wikimedia.org/T121459#1879557 (Jseddon) NEW a:Jseddon [23:54:02] hey eileen [23:54:05] and awight [23:54:09] hey [23:54:56] i'm talking to caitlin v [23:55:33] cool [23:55:45] so… they use the "appeal" tag for a number of different things as you noticed [23:56:16] yep [23:56:56] & what we want is the things they want passed through added / enabled at this url civicrm/admin/custom/group/field?reset=1&action=browse&gid=7 [23:57:32] that's not a url? [23:57:37] civicrm.org [23:58:01] anyway, they've been using a manual tag for engage, etc. [23:58:16] for the same appeal [23:58:42] atgomez: that;s after the hostname [23:58:46] ie. on prod [23:58:46] ok [23:59:04] what do you mean by manual tag [23:59:43] atgomez: Meeting? [23:59:48] K4-713: 1 min [23:59:53] eileen: yes, those tags [23:59:57] k