[00:08:58] (03PS1) 10Eileen: Make our master mailing & mailing_job have id =1 [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/962733 (https://phabricator.wikimedia.org/T346194) [00:11:43] (03PS1) 10Eileen: Big but simple update to use one mailing_job for thank yous [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/962734 (https://phabricator.wikimedia.org/T346194) [00:38:57] ok, sounds good eileen [00:39:40] !log fundraising civicrm upgraded from c1b28287 to 995a3d5b [00:39:42] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [00:53:33] grumble... two rows in that file with the same ingenico token are of course mapped to different adyen tokens [00:58:50] so each of those adyen tokens is maybe only good for the corresponding amount [00:59:17] and each one has its own shopperReference, which we're stashing in recur.invoice_id [00:59:22] (which needs to be unique) [00:59:58] so... we sometimes have to map a single ingenico token to TWO adyen tokens [01:01:38] and we have to consult contribution_tracking - or do a like search on the contribution.invoice_id [01:02:20] so... what do we do [01:02:50] maybe keep it simple when there is only one contribution_recur row for the token? [01:20:10] ughh [01:20:44] for the big import i can't actually depend on all the identical ingenico tokens being in the same batch [01:20:51] so wtf do I do? [01:21:30] make an extra copy of the token row before updating the original? [01:32:22] ahh the multiple recurring peeps? [01:53:39] yeah... [01:54:09] i was sure adyen would use the same token for each recurring [01:54:25] but no, they somehow distinguish between two tokenizations of the same credit card [01:54:37] even though ingenico only had a single token string for both [02:11:49] (03PS4) 10Cstone: Add submitPayment api [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/959068 (https://phabricator.wikimedia.org/T344774) [02:13:34] (03CR) 10CI reject: [V: 04-1] Add submitPayment api [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/959068 (https://phabricator.wikimedia.org/T344774) (owner: 10Cstone) [02:19:57] (03PS5) 10Cstone: Add submitPayment api [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/959068 (https://phabricator.wikimedia.org/T344774) [02:21:33] (03CR) 10CI reject: [V: 04-1] Add submitPayment api [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/959068 (https://phabricator.wikimedia.org/T344774) (owner: 10Cstone) [02:30:31] actually i'm lucky that the tiny csv had an example of this and I didn't have to discover it after trying to run the giant one. [02:40:51] (03CR) 10Cstone: Create Fundraiseup Audit Processor (031 comment) [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/959346 (https://phabricator.wikimedia.org/T346620) (owner: 10Damilare Adedoyin) [02:53:57] (03PS1) 10Ejegg: Deal with 1:many token migration [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/962745 (https://phabricator.wikimedia.org/T338523) [03:44:32] (03PS1) 10Eileen: Remove mailing jobs that have now been orphaned. [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/962750 (https://phabricator.wikimedia.org/T346194) [04:28:28] (03PS2) 10Eileen: WIP - Remove mailing jobs that have now been orphaned. [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/962750 (https://phabricator.wikimedia.org/T346194) [07:00:22] (03PS1) 10Damilare Adedoyin: Create function to handle negative transactions in order to be able to override it for some processors. [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/962943 (https://phabricator.wikimedia.org/T346620) [07:01:13] (03PS21) 10Damilare Adedoyin: Create Fundraiseup Audit Processor [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/959346 (https://phabricator.wikimedia.org/T346620) [07:01:35] (03PS22) 10Damilare Adedoyin: Create Fundraiseup Audit Processor [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/959346 (https://phabricator.wikimedia.org/T346620) [07:02:04] (03PS23) 10Damilare Adedoyin: Create Fundraiseup Audit Processor [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/959346 (https://phabricator.wikimedia.org/T346620) [07:02:43] (03PS24) 10Damilare Adedoyin: Create Fundraiseup Audit Processor [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/959346 (https://phabricator.wikimedia.org/T346620) [07:04:10] (03CR) 10Damilare Adedoyin: "Thanks Christine for the CR! I've moved the changes to this patch: https://gerrit.wikimedia.org/r/c/wikimedia/fundraising/crm/+/962943/1" [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/959346 (https://phabricator.wikimedia.org/T346620) (owner: 10Damilare Adedoyin) [07:09:58] 10Fundraising Sprint Spacebar Oddity ๐Ÿ‘พ, 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: Individual Engage File Import Duplicates - https://phabricator.wikimedia.org/T347362 (10Damilare) @MDemosWMF please can you share the import ID for this as well. [07:10:46] 10Fundraising Sprint Spacebar Oddity ๐Ÿ‘พ, 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: Individual Engage File Import Duplicates - https://phabricator.wikimedia.org/T347362 (10Damilare) Thanks @jgleeson, please can you help this new file as well. [07:34:56] (03CR) 10CI reject: [V: 04-1] Localisation updates from https://translatewiki.net. [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/962961 (owner: 10L10n-bot) [07:37:48] (03CR) 10Raimond Spekking: [C: 03+2] "false positive" [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/962961 (owner: 10L10n-bot) [10:37:47] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10FR-Email: Civi to Acoustic Export: Job Status Failed - https://phabricator.wikimedia.org/T347965 (10ppenloglou) [13:37:24] (03PS1) 10Ejegg: Break contribution_tracking insert out of normalize fn [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/963056 (https://phabricator.wikimedia.org/T346620) [13:37:34] let's see if that passes ^^^ [13:37:50] I don't THINK we want to call it from the subscr_start normalize path [13:38:00] ah, I probably need to add the extra call to some tests [13:42:45] (03CR) 10Ejegg: "Since there are no logs for fundraiseup, wouldn't it be easier to just write a simple override for log_hunt_and_send in the override proce" [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/962943 (https://phabricator.wikimedia.org/T346620) (owner: 10Damilare Adedoyin) [13:44:18] (03CR) 10Ejegg: "I wonder if we can avoid more special cases in the main code path. I tried breaking the contribution_tracking bit out of the normalization" [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/959346 (https://phabricator.wikimedia.org/T346620) (owner: 10Damilare Adedoyin) [13:55:32] (03CR) 10CI reject: [V: 04-1] Break contribution_tracking insert out of normalize fn [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/963056 (https://phabricator.wikimedia.org/T346620) (owner: 10Ejegg) [14:02:02] (03PS2) 10Ejegg: Break contribution_tracking insert out of normalize fn [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/963056 (https://phabricator.wikimedia.org/T346620) [14:49:34] 10Fundraising Sprint Spacebar Oddity ๐Ÿ‘พ, 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: Individual Engage File Import Duplicates - https://phabricator.wikimedia.org/T347362 (10MDemosWMF) Hi @Damilare, how do I find the import ID? I only see the import log: {F37926377} [14:58:22] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10FR-Email: Civi to Acoustic Export: Job Status Failed - https://phabricator.wikimedia.org/T347965 (10KHaggard) Awesome ticket, @ppenloglou Thanks for logging this. I'm running the jobs that Jack sent over now. [15:02:39] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10FR-Email: Civi to Acoustic Export: Job Status Failed - https://phabricator.wikimedia.org/T347965 (10jgleeson) Hi! Thanks for logging this. The underlying cause of the export job failing on the WMF side is being tracked here {T347997} [15:26:44] (03CR) 10Ejegg: [C: 04-1] "Actually, even if you don't use this for FRUP, this is a good code change! I think you just need to pass the $remaining array in with an &" [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/962943 (https://phabricator.wikimedia.org/T346620) (owner: 10Damilare Adedoyin) [15:40:42] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10FR-Email: Civi to Acoustic Export: Job Status Failed - https://phabricator.wikimedia.org/T347965 (10KHaggard) All four data jobs for Oct 3rd have completed successfully. We will proceed with scheduling emails again. > Contact Source Name: _all_Wiki... [15:42:37] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10FR-Email: Civi to Acoustic Export: Job Status Failed - https://phabricator.wikimedia.org/T347965 (10KHaggard) 05Openโ†’03Resolved a:03KHaggard [16:35:40] 10Fundraising-Backlog: Venmo report miss refund transactions at that day of generate report - https://phabricator.wikimedia.org/T348025 (10AnnWF) [16:42:07] (03PS2) 10Damilare Adedoyin: Create function to handle negative transactions in order to be able to override it for some processors. [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/962943 (https://phabricator.wikimedia.org/T346620) [16:42:22] (03PS25) 10Damilare Adedoyin: Create Fundraiseup Audit Processor [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/959346 (https://phabricator.wikimedia.org/T346620) [16:50:23] 10Fundraising-Backlog: Venmo report miss refund transactions at that day of generate report - https://phabricator.wikimedia.org/T348025 (10AnnWF) Updated the daily report generate from last 24 hrs to 25 hrs at process-control, should be enough for this situation, and will see if we want to add a weekly check also. [17:00:01] (03CR) 10CI reject: [V: 04-1] Create Fundraiseup Audit Processor [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/959346 (https://phabricator.wikimedia.org/T346620) (owner: 10Damilare Adedoyin) [17:26:38] (03CR) 10Ejegg: Create function to handle negative transactions in order to be able to override it for some processors. (031 comment) [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/962943 (https://phabricator.wikimedia.org/T346620) (owner: 10Damilare Adedoyin) [17:28:03] (03CR) 10Ejegg: [C: 03+2] "SQL looks good. Pretty cool to have this ease of batching!" [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/961691 (https://phabricator.wikimedia.org/T344012) (owner: 10Eileen) [17:32:35] (03CR) 10Ejegg: [C: 03+2] "looks fine" [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/962708 (https://phabricator.wikimedia.org/T344012) (owner: 10Eileen) [17:42:13] (03PS6) 10Cstone: Add submitPayment api [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/959068 (https://phabricator.wikimedia.org/T344774) [17:43:56] (03CR) 10CI reject: [V: 04-1] Add submitPayment api [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/959068 (https://phabricator.wikimedia.org/T344774) (owner: 10Cstone) [17:44:45] (03PS7) 10Cstone: Add submitPayment api [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/959068 (https://phabricator.wikimedia.org/T344774) [17:46:01] (03Merged) 10jenkins-bot: First update in the financial type [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/961691 (https://phabricator.wikimedia.org/T344012) (owner: 10Eileen) [17:46:36] (03CR) 10CI reject: [V: 04-1] Add submitPayment api [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/959068 (https://phabricator.wikimedia.org/T344774) (owner: 10Cstone) [17:50:33] (03Merged) 10jenkins-bot: Update community gift & Benefactor gift [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/962708 (https://phabricator.wikimedia.org/T344012) (owner: 10Eileen) [17:53:02] (03PS8) 10Cstone: Add submitPayment api [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/959068 (https://phabricator.wikimedia.org/T344774) [17:54:54] (03CR) 10CI reject: [V: 04-1] Add submitPayment api [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/959068 (https://phabricator.wikimedia.org/T344774) (owner: 10Cstone) [17:55:20] 10Fundraising-Backlog, 10Data Engineering and Event Platform Team, 10Data-Engineering, 10MediaWiki-extensions-EventLogging, and 2 others: Determine which remaining legacy EventLogging schemas need to be migrated or decommissioned - https://phabricator.wikimedia.org/T282131 (10phuedx) [18:00:41] (03PS9) 10Cstone: Add submitPayment api [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/959068 (https://phabricator.wikimedia.org/T344774) [18:02:22] (03CR) 10Ejegg: [C: 03+2] Add code to 'fill' (INSERT) missing gift sources (campaign) data [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/962722 (https://phabricator.wikimedia.org/T344012) (owner: 10Eileen) [18:02:48] (03CR) 10Ejegg: [C: 03+2] Remove lingering references to Community Gift, Benefactor gift [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/962721 (https://phabricator.wikimedia.org/T344012) (owner: 10Eileen) [18:13:00] 10Fundraising Sprint Spacebar Oddity ๐Ÿ‘พ, 10Fundraising-Backlog, 10Patch-For-Review: AMEX rejected transactions through Ingenico are to be ported to Adyen - https://phabricator.wikimedia.org/T338523 (10Ejegg) @EMartin some good news, we got one successful transaction charged on a migrated AMEX token: https://... [18:19:12] (03Merged) 10jenkins-bot: Add code to 'fill' (INSERT) missing gift sources (campaign) data [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/962722 (https://phabricator.wikimedia.org/T344012) (owner: 10Eileen) [18:19:14] (03Merged) 10jenkins-bot: Remove lingering references to Community Gift, Benefactor gift [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/962721 (https://phabricator.wikimedia.org/T344012) (owner: 10Eileen) [18:21:14] 10Fundraising Sprint Spacebar Oddity ๐Ÿ‘พ, 10Fundraising-Backlog, 10Patch-For-Review: AMEX rejected transactions through Ingenico are to be ported to Adyen - https://phabricator.wikimedia.org/T338523 (10EMartin) @Ejegg I see the transaction in the Adyen console as well! {F37933929} [18:21:33] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: Silverpop/Acoustic export timing out after 10 hours - https://phabricator.wikimedia.org/T347997 (10jgleeson) a:03jgleeson [18:28:05] (03PS6) 10Jgleeson: WIP: Setup 2.0 [wikimedia/fundraising/dev] - 10https://gerrit.wikimedia.org/r/953984 [18:29:24] (03PS7) 10Jgleeson: WIP: Setup 2.0 [wikimedia/fundraising/dev] - 10https://gerrit.wikimedia.org/r/953984 [18:41:17] (03PS26) 10Damilare Adedoyin: Create Fundraiseup Audit Processor [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/959346 (https://phabricator.wikimedia.org/T346620) [18:50:06] (03PS3) 10Damilare Adedoyin: Create function to handle negative transactions in order to be able to override it for some processors. [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/962943 (https://phabricator.wikimedia.org/T346620) [18:50:12] (03CR) 10CI reject: [V: 04-1] Create Fundraiseup Audit Processor [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/959346 (https://phabricator.wikimedia.org/T346620) (owner: 10Damilare Adedoyin) [18:52:40] (03PS27) 10Damilare Adedoyin: Create Fundraiseup Audit Processor [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/959346 (https://phabricator.wikimedia.org/T346620) [19:43:37] (03PS1) 10Eileen: Merge branch 'master' of ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/963140 [19:43:47] (03CR) 10Eileen: [C: 03+2] Merge branch 'master' of ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/963140 (owner: 10Eileen) [19:44:32] (03Merged) 10jenkins-bot: Merge branch 'master' of ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/963140 (owner: 10Eileen) [19:50:26] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Handle Adyen non refund IPNs for non-USD donations - https://phabricator.wikimedia.org/T347422 (10AKanji-WMF) [19:50:29] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10FR-donorservices: After payment, Venmo redirected to default browser instead of browser used for payment - https://phabricator.wikimedia.org/T347420 (10AKanji-WMF) [19:50:31] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: Endowment donation not showing up in the pop-up when mousing over the Civi icon - https://phabricator.wikimedia.org/T346917 (10AKanji-WMF) [19:50:33] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: Add new diagram to dlocal docs covering the new 'Wallet disabled' flow - https://phabricator.wikimedia.org/T345752 (10AKanji-WMF) [19:50:35] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: Attempt id not resetting when testing repeatedly locally with dlocal - https://phabricator.wikimedia.org/T335601 (10AKanji-WMF) [19:50:37] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10FR-donorservices: iDeal recurring donation continued after cancellation - https://phabricator.wikimedia.org/T335140 (10AKanji-WMF) [19:50:39] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: Paypal Recurring trnx does not have payment_token_id for future charge - https://phabricator.wikimedia.org/T334902 (10AKanji-WMF) [19:50:42] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: CiviCRM unit test failing locally - https://phabricator.wikimedia.org/T333340 (10AKanji-WMF) [19:50:44] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10FR-Adyen: Better handle terse Adyen idempotency result - https://phabricator.wikimedia.org/T331319 (10AKanji-WMF) [19:50:46] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10FR-Adyen: Handle issuer timeouts via Adyen - https://phabricator.wikimedia.org/T331317 (10AKanji-WMF) [19:50:48] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: Get all fr-tech engineers added to the WMF Developer Account - https://phabricator.wikimedia.org/T329724 (10AKanji-WMF) [19:50:50] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: Add a time limit to contribution tracking queue consume - https://phabricator.wikimedia.org/T329600 (10AKanji-WMF) [19:50:52] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: Add gateway label to 'IP repeat count' grafana graph - https://phabricator.wikimedia.org/T327958 (10AKanji-WMF) [19:50:54] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10FR-donorservices: questions re: Civi Recur fail email Jan 2022 - https://phabricator.wikimedia.org/T326770 (10AKanji-WMF) [19:50:56] 10Fundraising Sprint Amazing grep, 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: Bus error 2: The bus strikes back - https://phabricator.wikimedia.org/T326013 (10AKanji-WMF) [19:50:58] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: Payments main cache backend is not using memcached - https://phabricator.wikimedia.org/T324693 (10AKanji-WMF) [19:51:00] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: Something is causing a lot of deadlocks in ConfigAndLog - https://phabricator.wikimedia.org/T320287 (10AKanji-WMF) [19:51:02] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10FR-Alerts: Update the frequency of smart-group cache refresh - https://phabricator.wikimedia.org/T321337 (10AKanji-WMF) [19:51:04] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10Documentation: Complete Adyen Checkout documentation to include donation statuses for all stages/permutations - https://phabricator.wikimedia.org/T316583 (10AKanji-WMF) [19:51:07] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: SmashPig::queue2civicrm find a completed dlocal payment mark as failed and removed from queue table - https://phabricator.wikimedia.org/T309799 (10AKanji-WMF) [19:51:09] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: Donor directed to "Thank You" page even though payment rejected - https://phabricator.wikimedia.org/T310383 (10AKanji-WMF) [19:51:11] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: ApplePay token amount-mismatch - https://phabricator.wikimedia.org/T324413 (10AKanji-WMF) [19:51:13] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Delete blank contacts - https://phabricator.wikimedia.org/T322887 (10AKanji-WMF) [19:51:15] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10Documentation: Document Donor Data Delivery Tool - https://phabricator.wikimedia.org/T323144 (10AKanji-WMF) [19:51:17] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: Adyen: Client side error on Safari even with successful donation - https://phabricator.wikimedia.org/T310737 (10AKanji-WMF) [19:51:19] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: import contact with 4 parts of addressee_display, find our if add suffix or middle name - https://phabricator.wikimedia.org/T326585 (10AKanji-WMF) [19:51:21] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10Documentation: Document which tables are hit by each process-control job - https://phabricator.wikimedia.org/T322243 (10AKanji-WMF) [19:51:23] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10Documentation: Documentation: Banner data flow and data stores - https://phabricator.wikimedia.org/T296222 (10AKanji-WMF) [19:51:25] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: DB Error 'No such field' when sorting Civi advanced search results by country - https://phabricator.wikimedia.org/T324288 (10AKanji-WMF) [19:51:27] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10MediaWiki-extensions-CentralNotice, 10MediaWiki-extensions-Translate: Canโ€™t mark CentralNotice translations as reviewed - https://phabricator.wikimedia.org/T308614 (10AKanji-WMF) [19:59:29] 10Fundraising Sprint Dinosaur Cookies co-existed with Gingerbread People, 10Fundraising-Backlog: investigate: Record user agent in contribution_tracking - https://phabricator.wikimedia.org/T182039 (10AKanji-WMF) @Cstone suggested this task was relevant to the current conversation we're having around attributio... [20:02:51] 10Fundraising Sprint Dinosaur Cookies co-existed with Gingerbread People, 10Fundraising-Backlog: investigate: Record user agent in contribution_tracking - https://phabricator.wikimedia.org/T182039 (10AKanji-WMF) Edit: ah, @Cstone found an existing task {T161539} - I'll pull this into triage for discussion. [20:16:01] (03PS1) 10Eileen: Remove receive_date FORCE index [wikimedia/fundraising/tools] - 10https://gerrit.wikimedia.org/r/963146 (https://phabricator.wikimedia.org/T347997) [20:17:14] jgleeson: ^^ [20:19:15] ty [20:22:02] ejegg: looks like this is the time when former-future-us-but-now-past-us thanks former-now-us-but-now-past-us for thinking about what fields future us might want in contribution tracking in the future - https://phabricator.wikimedia.org/T182039 [20:23:16] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: DB Error 'No such field' when sorting Civi advanced search results by country - https://phabricator.wikimedia.org/T324288 (10Eileenmcnaughton) Just flagging this is a really tough one to solve in code that is hopefully g... [20:32:25] ooh good find on the index eileen [20:33:14] I just tested it locally and couldn't really see a difference [20:33:19] but I guess it's worth trying [20:33:27] it still runs [20:35:08] (03CR) 10Jgleeson: [C: 03+2] "LGTM! let's give it a whirl" [wikimedia/fundraising/tools] - 10https://gerrit.wikimedia.org/r/963146 (https://phabricator.wikimedia.org/T347997) (owner: 10Eileen) [20:36:19] (03Merged) 10jenkins-bot: Remove receive_date FORCE index [wikimedia/fundraising/tools] - 10https://gerrit.wikimedia.org/r/963146 (https://phabricator.wikimedia.org/T347997) (owner: 10Eileen) [20:36:26] thanks eileen [20:38:30] I see a bunch of older tasks have been assigned to chaos crew - were you running out of work [20:44:52] the dedupe ones? [20:45:05] chaos seems pretty stacked atm [20:46:17] I just saw this go in - https://phabricator.wikimedia.org/T324288 [20:50:12] all the unchaosed chaosed got chaosed back in I think [20:50:32] total chaos [20:51:16] (03PS3) 10Eileen: WIP - Remove mailing jobs that have now been orphaned. [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/962750 (https://phabricator.wikimedia.org/T346194) [20:54:49] (03PS1) 10Eileen: Merge branch 'master' of ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/tools into deploy [wikimedia/fundraising/tools] (deploy) - 10https://gerrit.wikimedia.org/r/963154 [20:55:39] (03CR) 10Eileen: [C: 03+2] Merge branch 'master' of ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/tools into deploy [wikimedia/fundraising/tools] (deploy) - 10https://gerrit.wikimedia.org/r/963154 (owner: 10Eileen) [20:56:21] !log tools upgraded from 130ca87e to 2e19cd39 [20:56:23] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [20:56:32] chaos day [20:56:58] (03CR) 10Jgleeson: [C: 03+2] "found it!" [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/962097 (https://phabricator.wikimedia.org/T338523) (owner: 10Ejegg) [21:30:09] (03PS2) 10Eileen: Big but simple update to use one mailing_job for thank yous [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/962734 (https://phabricator.wikimedia.org/T346194) [21:30:11] (03PS4) 10Eileen: WIP - Remove mailing jobs that have now been orphaned. [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/962750 (https://phabricator.wikimedia.org/T346194) [21:30:13] (03PS1) 10Eileen: Make our master mailing & mailing_job have id =1 [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/963162 (https://phabricator.wikimedia.org/T346194) [22:09:16] (03PS2) 10Ejegg: Deal with 1:many token migration [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/962745 (https://phabricator.wikimedia.org/T338523) [22:09:18] (03PS1) 10Ejegg: Actually execute the recur update [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/963164 (https://phabricator.wikimedia.org/T338523) [22:19:58] (03PS2) 10Eileen: Move the mailing_data update we started into the new upgrader method [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/962728 (https://phabricator.wikimedia.org/T346194) [22:20:00] (03PS2) 10Eileen: Make our master mailing & mailing_job have id =1 [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/963162 (https://phabricator.wikimedia.org/T346194) [22:20:02] (03PS3) 10Eileen: Big but simple update to use one mailing_job for thank yous [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/962734 (https://phabricator.wikimedia.org/T346194) [22:20:04] (03PS5) 10Eileen: WIP - Remove mailing jobs that have now been orphaned. [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/962750 (https://phabricator.wikimedia.org/T346194) [22:20:06] (03PS1) 10Eileen: Fix upgrade to work locally (already running on prod) [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/963187 [23:00:43] (03PS6) 10Eileen: WIP - Remove mailing jobs that have now been orphaned. [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/962750 (https://phabricator.wikimedia.org/T346194) [23:05:15] 10Fundraising-Backlog, 10fundraising-tech-ops: Set up Community CiviCRM instance. - https://phabricator.wikimedia.org/T343486 (10Dwisehaupt) @Qgil Just wanted to drop a line and say that I am in the process of puppetizing the install for use in cloud services and then production. I am wondering if there has be... [23:06:32] (03PS2) 10Eileen: Fix upgrade to work locally (already running on prod) [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/963187 (https://phabricator.wikimedia.org/T344012) [23:06:34] (03PS3) 10Eileen: Move the mailing_data update we started into the new upgrader method [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/962728 (https://phabricator.wikimedia.org/T346194) [23:06:36] (03PS3) 10Eileen: Make our master mailing & mailing_job have id =1 [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/963162 (https://phabricator.wikimedia.org/T346194) [23:06:38] (03PS4) 10Eileen: Big but simple update to use one mailing_job for thank yous [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/962734 (https://phabricator.wikimedia.org/T346194) [23:06:40] (03PS7) 10Eileen: WIP - Remove mailing jobs that have now been orphaned. [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/962750 (https://phabricator.wikimedia.org/T346194) [23:06:42] (03PS1) 10Eileen: Add code comments cos it's way too unintuitive to remember [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/963190 (https://phabricator.wikimedia.org/T344012) [23:12:16] eileen: ^ best patch ever future us will appreciate [23:12:28] cstone: :-)