[00:01:47] (Merged) jenkins-bot: Add day_of_month to thank you email test UI. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/609864 (owner: Cstone) [00:06:04] (PS1) Cstone: Merge branch 'master' into deployment [wikimedia/fundraising/crm] (deployment) - https://gerrit.wikimedia.org/r/609866 [00:07:05] (CR) Cstone: [C: +2] Merge branch 'master' into deployment [wikimedia/fundraising/crm] (deployment) - https://gerrit.wikimedia.org/r/609866 (owner: Cstone) [00:14:01] (CR) Cstone: [C: +2] "recheck" [wikimedia/fundraising/crm] (deployment) - https://gerrit.wikimedia.org/r/609866 (owner: Cstone) [00:22:08] !log civicrm revision changed from a48caf0f37 to d73ee2e73f [00:22:12] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [00:28:06] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising-Backlog: Japanese MC 2nd Upsell Email - https://phabricator.wikimedia.org/T255227 (Cstone) @CDenes_WMF The testmeister was missing the day of the month for the recurring notifications. I updated it so it will now send the date out correctly. The... [00:41:32] (PS1) Cstone: Add footer to the English and Japanese recurring notification emails. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/609874 [00:47:52] (PS1) Eileen: Prevent non-donors being exported to silverpop [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/609877 (https://phabricator.wikimedia.org/T253152) [00:48:09] ejegg: I dug into my worries about the inner join and I don't think it was enough [00:48:34] (CR) jerkins-bot: [V: -1] Prevent non-donors being exported to silverpop [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/609877 (https://phabricator.wikimedia.org/T253152) (owner: Eileen) [00:48:34] no? [00:48:40] the export_stat table itself has $0 donors in it - I put up ^^ but I think that needs merging now-ish [00:50:29] dang it failed - worked on staging but test... [00:52:46] hmm - no that fail makes sense.. [00:52:59] Running query #5: -- We don't want to suppress emails of Civi users. [00:53:02] yeah [00:53:55] oh wait, that's not the fail line [00:55:56] (PS1) Eileen: Prevent non-donors being exported to silverpop [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/609880 (https://phabricator.wikimedia.org/T253152) [00:56:38] (CR) jerkins-bot: [V: -1] Prevent non-donors being exported to silverpop [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/609880 (https://phabricator.wikimedia.org/T253152) (owner: Eileen) [00:57:54] This is my query [00:57:54] select email, first_name, last_name, c.id, created_date [00:57:54] FROm civicrm_contact c [00:57:54] LEFT JOIN wmf_donor d ON c.id = d.entity_id [00:57:54] INNER JOIN civicrm_email e ON e.contact_id = c.id [00:57:55] LEFT JOIN civicrm_group_contact gc ON gc.contact_id = c.id AND gc.group_id IN (310, 779) [00:57:55] LEFT JOIN civicrm_contribution cont ON cont.contact_id = c.id [00:57:56] LEFT JOIN civicrm_contribution cr ON cr.contact_id = c.id [00:57:56] LEFT JOIN civicrm_contribution_soft cs ON cs.contact_id = c.id [00:57:57] WHERE c.is_deleted = 0 AND ( lifetime_usd_total = 0 OR lifetime_usd_total IS NULL) [00:57:57] AND gc.id IS NULL [00:57:58] AND cont.id IS NULL [00:57:58] AND cr.id IS NULL [00:57:59] AND cs.id IS NULL [00:57:59] ORDER BY c.id DESC LIMIT 50; [00:59:57] hmm - I can't decide if I'm worrying about a real thing or not [01:00:22] if I look at 41438476 she was uploaded to silverpop right after being created [01:01:12] & that could only happen if we did upload non-donors... [01:05:35] !log turned on debug logging for Adyen SmashPig [01:05:38] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [01:11:31] ejegg: so logically if I look at 41438476 who is a a planned giving person created by Jason - the fact she was uploaded to silverpop must mean that we have been uploading non-donors unless they had some opt out [01:12:16] in which case I guess nothing has changed & I'm worrying about a non-thing [01:14:25] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: TS update import back into Civi - https://phabricator.wikimedia.org/T255805 (Eileenmcnaughton) This is now running - I just checked & 18k contacts have been processed [01:15:06] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: TS update import back into Civi - https://phabricator.wikimedia.org/T255805 (Eileenmcnaughton) I've left this in pending deployment as I guess 'done' is the job being disabled again [01:17:08] eileen right, we've been uploading them and I guess thinking they would be segmented out? [01:17:40] yeah that must be in [01:19:01] I'm thinking about running the full job again now - I hit some things last run - then it will fail in 2 hours but this job will be done that much sooner [01:20:04] - I still have a couple of speed-up ones queued https://gerrit.wikimedia.org/r/c/wikimedia/fundraising/tools/+/608991 [01:30:03] hmm, will that debug logging I just turned on do the trick? [01:31:19] shoot, that Adyen PaymentProvider class looks like it only debug-logs on errors [01:32:41] was there another US test after the one on 6/3? [01:33:04] hmm, not that I know of [01:33:17] I guess we can look for recurring subs with that payment processor id [01:34:21] its never been warm enough here for me to work outside at night before but its pretty great right now [01:36:47] Hmm, I see a pretty good spread of start dates [01:37:02] I got the adyen processor id with select * from civicrm_payment_processor where name like '%adyen%'; [01:37:12] then tried select day(start_date), month(start_date), count(*) from civicrm_contribution_recur where payment_processor_id=1 group by day(start_date), month(start_date); [01:37:43] the Israel banners were running that week too which had cc stuff coming in [01:37:54] and I see them from as far back as March 11th [01:38:12] Def a lot more on 6/3 and 6/4 [01:38:37] ah, nothing at all on the 6th though [01:39:01] But in any case I think we need to add a bit more debug logging in code for it to tell us what we want to know [01:40:32] theres a bunch from 5/6 though? or am i reading this wrong [01:47:17] bah bunbun escaped im gona go find him, have a good rest of your day everyone [01:48:36] good luck cstone ! [01:48:55] ah yeah, lots started 5/6 [03:08:20] (Abandoned) Eileen: Prevent non-donors being exported to silverpop [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/609880 (https://phabricator.wikimedia.org/T253152) (owner: Eileen) [03:08:37] (Abandoned) Eileen: Prevent non-donors being exported to silverpop [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/609877 (https://phabricator.wikimedia.org/T253152) (owner: Eileen) [03:09:52] (Abandoned) Eileen: Try to update unit tests [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/607166 (owner: Eileen) [03:48:49] Wikimedia-Fundraising-Banners: 2020-07-08 en6C pre-test: desktop small batch - https://phabricator.wikimedia.org/T256903 (jbolorinos-ctr) Screenshot test results - Desktop: - Control - https://app.crossbrowsertesting.com/public/i15b74a2dc92badb/screenshots/zb7ab247498bc495d198 - Mellow yellow - https://app.... [03:54:23] Wikimedia-Fundraising-Banners: 2020-07-08 en6C pre-test: desktop small batch - https://phabricator.wikimedia.org/T256903 (jbolorinos-ctr) I noticed the colors were not updated on the nags @spatton, is that by design? since we're only testing the colors on the main banner here? [03:55:57] Wikimedia-Fundraising-Banners: 2020-07-08 en6C pre-test: desktop small batch - https://phabricator.wikimedia.org/T256903 (jbolorinos-ctr) Aside from T247380, which is a known issue only affecting a small number of browsers, no new bugs found. These banners are READY TO TEST [03:59:11] Wikimedia-Fundraising-Banners: 2020-07-08 en6C pre-test: desktop large batch - https://phabricator.wikimedia.org/T256902 (jbolorinos-ctr) Aside from T250094, which is a known issue with Safari 9, only affecting a small number of browsers, no new bugs found. These banners are now READY TO TEST. [04:06:50] Wikimedia-Fundraising-Banners: 2020-07-08 en6C pre-test: desktop large batch - https://phabricator.wikimedia.org/T256902 (jbolorinos-ctr) Open→Resolved [04:06:52] Wikimedia-Fundraising-Banners: QA for en6C pre-test on July 8 - https://phabricator.wikimedia.org/T256901 (jbolorinos-ctr) [04:09:14] Wikimedia-Fundraising-Banners: 2020-07-08 en6C pre-test: mobile small batch - https://phabricator.wikimedia.org/T256910 (jbolorinos-ctr) Screenshot Test Results - Mobile: - Control - https://app.crossbrowsertesting.com/public/i15b74a2dc92badb/screenshots/zd0da69471279145bec7 - Salmon pink - https://app.cross... [04:10:32] (PS10) Eileen: Silverpop refactor - remove last UPDATE from the silverpop script [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/608991 (https://phabricator.wikimedia.org/T253152) [04:10:35] (PS10) Eileen: Silverpop - build main table incrementally [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/609238 (https://phabricator.wikimedia.org/T253152) [04:10:36] (PS1) Eileen: Remove exid from export_stat table. [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/609896 (https://phabricator.wikimedia.org/T253152) [04:10:41] Wikimedia-Fundraising-Banners: 2020-07-08 en6C pre-test: mobile small batch - https://phabricator.wikimedia.org/T256910 (jbolorinos-ctr) Open→Resolved a:jbolorinos-ctr No new bugs found, these banners are READY TO TEST [04:10:43] Wikimedia-Fundraising-Banners: QA for en6C pre-test on July 8 - https://phabricator.wikimedia.org/T256901 (jbolorinos-ctr) [04:21:16] Wikimedia-Fundraising-Banners: 2020-07-08 en6C pre-test: mobile large batch - https://phabricator.wikimedia.org/T256905 (jbolorinos-ctr) Open→Resolved No bugs to report, these banners are READY TO TEST! [04:21:18] Wikimedia-Fundraising-Banners: QA for en6C pre-test on July 8 - https://phabricator.wikimedia.org/T256901 (jbolorinos-ctr) [04:21:42] Wikimedia-Fundraising-Banners: 2020-07-08 en6C pre-test: desktop small batch - https://phabricator.wikimedia.org/T256903 (jbolorinos-ctr) a:jbolorinos-ctr [04:35:15] PROBLEM - check_mysql on frdev1001 is CRITICAL: SLOW_SLAVE CRITICAL: Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 1380 [04:40:11] RECOVERY - check_mysql on frdev1001 is OK: Uptime: 3674258 Threads: 5 Questions: 93542236 Slow queries: 201467 Opens: 1384543 Flush tables: 1 Open tables: 200 Queries per second avg: 25.458 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 0 [05:36:28] Fundraising Sprint Lazy Loading Life, Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, and 2 others: Add and delete fields from the _all_Wikimedia database (civi export to ESP) - https://phabricator.wikimedia.org/T252245 (Eileenmcnaughton) The job... [06:50:12] PROBLEM - check_mysql on frdev1001 is CRITICAL: SLOW_SLAVE CRITICAL: Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 1378 [06:55:12] PROBLEM - check_mysql on frdev1001 is CRITICAL: SLOW_SLAVE CRITICAL: Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 1678 [07:00:12] PROBLEM - check_mysql on frdev1001 is CRITICAL: SLOW_SLAVE CRITICAL: Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 1978 [07:05:12] RECOVERY - check_mysql on frdev1001 is OK: Uptime: 3682958 Threads: 2 Questions: 94163072 Slow queries: 201773 Opens: 1409687 Flush tables: 1 Open tables: 200 Queries per second avg: 25.567 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 0 [07:06:28] hopped on just in time for it to recover. back to sleep. [07:23:21] (CR) AndyRussG: "Thanks so much for adding the temp file path constant and the batch setting!" (2 comments) [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/608089 (https://phabricator.wikimedia.org/T251201) (owner: Jgleeson) [07:50:59] (CR) AndyRussG: "Woohoo, way to go! Thanks so much for digging in, and for making the changes we discussed on IRC :) Please see some more notes inline...! " (4 comments) [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/609810 (https://phabricator.wikimedia.org/T251780) (owner: Mepps) [12:36:28] Fundraising Sprint Lazy Loading Life, Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, and 2 others: Add and delete fields from the _all_Wikimedia database (civi export to ESP) - https://phabricator.wikimedia.org/T252245 (KHaggard) Thanks, @Eileen... [13:42:11] fundraising-tech-ops: procure and deploy new frmail server role - https://phabricator.wikimedia.org/T257245 (Jgreen) [13:42:52] fundraising-tech-ops: procure and deploy new frmail server role - https://phabricator.wikimedia.org/T257245 (Jgreen) [13:42:54] fundraising-tech-ops: break out fundraising outbound mail server to a separate host - https://phabricator.wikimedia.org/T245557 (Jgreen) [14:22:18] Wikimedia-Fundraising-Banners: 2020-07-08 en6C pre-test: desktop small batch - https://phabricator.wikimedia.org/T256903 (jbolorinos-ctr) Open→Resolved [14:22:21] Wikimedia-Fundraising-Banners: QA for en6C pre-test on July 8 - https://phabricator.wikimedia.org/T256901 (jbolorinos-ctr) [14:38:40] Wikimedia-Fundraising-Banners: Monthly Other amount (post-payment monthly convert) allows text only input - https://phabricator.wikimedia.org/T257321 (jbolorinos-ctr) [14:46:39] Fundraising-Backlog, Wikimedia-Fundraising-Banners: Monthly Other amount (post-payment monthly convert) allows text only input - https://phabricator.wikimedia.org/T257321 (DStrine) [15:11:56] Fundraising Sprint Lazy Loading Life, Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, and 2 others: Add and delete fields from the _all_Wikimedia database (civi export to ESP) - https://phabricator.wikimedia.org/T252245 (jgleeson) I was chatting... [15:44:08] (CR) Mepps: "Thanks! Unfortunately the mediawiki redirect is still not working as expected.." (3 comments) [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/609810 (https://phabricator.wikimedia.org/T251780) (owner: Mepps) [15:48:43] (PS4) Mepps: Allow redirect on Special:HideBanners on limited redirectUrl [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/609810 (https://phabricator.wikimedia.org/T251780) [15:56:09] (CR) Ejegg: "Looks like this is coming along nicely! Some suggestions inline." (3 comments) [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/609810 (https://phabricator.wikimedia.org/T251780) (owner: Mepps) [16:06:34] Wikimedia-Fundraising-Banners: QA for en6C pre-test on July 8 - https://phabricator.wikimedia.org/T256901 (jbolorinos-ctr) a:jbolorinos-ctr [16:11:58] (PS1) Ejegg: Format endow highest donation date for export [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/610108 [16:13:16] (CR) Jgleeson: [C: +2] Format endow highest donation date for export [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/610108 (owner: Ejegg) [16:14:17] (Merged) jenkins-bot: Format endow highest donation date for export [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/610108 (owner: Ejegg) [16:23:16] (CR) Jgleeson: "> Patch Set 8:" [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/608089 (https://phabricator.wikimedia.org/T251201) (owner: Jgleeson) [16:36:45] (CR) Jgleeson: "> Patch Set 8:" (2 comments) [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/608089 (https://phabricator.wikimedia.org/T251201) (owner: Jgleeson) [16:38:18] Fundraising-Backlog, FR-Ingenico: Ingenico refunds from 2020 not in Civi - https://phabricator.wikimedia.org/T251547 (MBeat33) [16:44:21] Fundraising-Backlog, FR-Ingenico: Ingenico refunds from 2020 not in Civi - https://phabricator.wikimedia.org/T251547 (MBeat33) Some refunds we performed in June for CID cid=26093476 also have not reached Civi: | order ID | refund date | 4005386853 | 6/24 | 4005641751 | 6/24 | 4005800519 | 6/24 These re... [16:45:34] (PS5) Mepps: Allow redirect on Special:HideBanners on limited redirectUrl [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/609810 (https://phabricator.wikimedia.org/T251780) [16:46:24] (CR) Mepps: "The only thing is it's not working correctly on non-logged in users, and it looks this we'll need to set the cache expiry in that case.." [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/609810 (https://phabricator.wikimedia.org/T251780) (owner: Mepps) [16:50:35] Fundraising-Backlog, Wikimedia-Fundraising-Banners: Monthly convert appears post-payment even when cvv is missing - https://phabricator.wikimedia.org/T257343 (jbolorinos-ctr) [16:55:52] (CR) Jgleeson: Command to check matching gifts employer data file (2 comments) [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/608089 (https://phabricator.wikimedia.org/T251201) (owner: Jgleeson) [16:57:22] Fundraising Sprint Lazy Loading Life, Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, and 2 others: Add and delete fields from the _all_Wikimedia database (civi export to ESP) - https://phabricator.wikimedia.org/T252245 (KHaggard) Addressed the b... [17:04:12] fundraising-tech-ops, Patch-For-Review: rack/setup/install civi2001.frack.codfw.wmnet - https://phabricator.wikimedia.org/T242270 (Jgreen) Open→Stalled [17:04:14] fundraising-tech-ops: 2019-2020 Q3 fundraising hardware refresh and capex - https://phabricator.wikimedia.org/T242257 (Jgreen) [17:04:18] Fundraising Sprint Lazy Loading Life, Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, fundraising-tech-ops: Test CiviCRM on new box - https://phabricator.wikimedia.org/T254940 (Jgreen) Open→Stalled [17:04:20] fundraising-tech-ops, Patch-For-Review: rack/setup/install civi2001.frack.codfw.wmnet - https://phabricator.wikimedia.org/T242270 (Jgreen) [17:04:59] Fundraising-Backlog, fundraising-tech-ops: Configure payments2xxx for MediaWiki 1.35 upgrade testing - https://phabricator.wikimedia.org/T256153 (Jgreen) Open→Stalled [17:05:01] Fundraising-Backlog, fundraising-tech-ops: Upgrade payments to MediaWiki 1.35 - https://phabricator.wikimedia.org/T254298 (Jgreen) [17:05:03] Fundraising-Backlog, fundraising-tech-ops, fr-tech-ops-okr: Upgrade payments servers to Debian Buster - https://phabricator.wikimedia.org/T256146 (Jgreen) Open→Stalled [17:05:05] Fundraising-Backlog, fundraising-tech-ops: Upgrade payments to MediaWiki 1.35 - https://phabricator.wikimedia.org/T254298 (Jgreen) [17:05:07] Fundraising-Backlog, fundraising-tech-ops, fr-tech-ops-okr: OKR 2019-2020 Q3: Support fundraising through maintaining infrastructure for payments and donor data - https://phabricator.wikimedia.org/T243019 (Jgreen) [17:05:12] fundraising-tech-ops: 2019-2020 Q3 fundraising hardware refresh and capex - https://phabricator.wikimedia.org/T242257 (Jgreen) Open→Stalled [17:05:14] Fundraising-Backlog, fundraising-tech-ops, fr-tech-ops-okr: OKR 2019-2020 Q3: Support fundraising through maintaining infrastructure for payments and donor data - https://phabricator.wikimedia.org/T243019 (Jgreen) [17:14:26] (PS9) Jgleeson: Command to check matching gifts employer data file [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/608089 (https://phabricator.wikimedia.org/T251201) [17:15:36] (CR) Jgleeson: "check out PS9 I think it gets us close! thanks again for all the feedback" [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/608089 (https://phabricator.wikimedia.org/T251201) (owner: Jgleeson) [17:16:50] back later! [17:19:09] (PS6) Mepps: Allow redirect on Special:HideBanners on limited redirectUrl [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/609810 (https://phabricator.wikimedia.org/T251780) [17:19:33] (CR) Mepps: "Ignore previous comments--this only doesn't work if you have read permissions turned off like I did." [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/609810 (https://phabricator.wikimedia.org/T251780) (owner: Mepps) [17:20:31] (CR) AndyRussG: [C: -1] "> Patch Set 5:" [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/609810 (https://phabricator.wikimedia.org/T251780) (owner: Mepps) [17:21:11] mepps: hey just to note, the -1 is to suggest we not merge until we've consulted with the Varnish folks about caching [17:21:24] not an opinion about the code at all! :) [17:21:34] See: https://phabricator.wikimedia.org/T256447 [17:26:39] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising-Backlog, fundraising Sprint Grep works IRL, MediaWiki-extensions-CentralNotice, Patch-For-Review: Implement redirect for hide banner cookie issue - https://phabricator.wikimedia.org/T251780 (mepps) This is currently waiting on a consu... [17:41:27] Fundraising-Backlog, Wikimedia-Fundraising-Banners: Monthly convert appears post-payment even when cvv is missing - https://phabricator.wikimedia.org/T257343 (DStrine) a:jbolorinos-ctr→None [17:58:03] Fundraising-Backlog: tweak process-control email template to be inbox friendlier - https://phabricator.wikimedia.org/T162687 (Jgreen) Open→Declined Closing this task since it didn't get picked up after three years. [17:58:45] Fundraising-Backlog, fundraising-tech-ops: map out a civicrm.log_% table data expiration/delete strategy - https://phabricator.wikimedia.org/T257232 (DStrine) [17:58:50] Fundraising-Backlog, MediaWiki-extensions-CentralNotice, Operations, Traffic, and 2 others: Special:HideBanners is not really cacheable - https://phabricator.wikimedia.org/T256447 (AndyRussG) Thanks @tstarling! As it turns out, current and upcoming browser restrictions on third-party cookies are... [18:03:17] fundraising-tech-ops: payments-listener server high availability - https://phabricator.wikimedia.org/T170318 (Jgreen) [18:05:17] Fundraising-Backlog, Wikimedia-Fundraising-Banners: Ingenico inconsistently accepts missing cvv cards - https://phabricator.wikimedia.org/T257343 (jbolorinos-ctr) [18:06:23] Fundraising Sprint Lazy Loading Life, Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising-Backlog: Flowchart all incoming data from non fundraising sources - https://phabricator.wikimedia.org/T254783 (mepps) @Ejegg I remember you'd planned to do a draft of this. Is that anywhere? [18:07:51] fundraising-tech-ops, fr-tech-ops-okr: Upgrade payments servers to Debian Buster - https://phabricator.wikimedia.org/T256146 (Jgreen) [18:08:34] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: TS update import back into Civi - https://phabricator.wikimedia.org/T255805 (CCogdill_WMF) Cool! So are we expecting this will take a few days to complete? Should we expect it in the email export by EOW... [18:10:33] Fundraising-Backlog, Wikimedia-Fundraising-Banners: Ingenico inconsistently accepts missing cvv cards - https://phabricator.wikimedia.org/T257343 (XenoRyet) I'm getting this CVV validation error when following the listed steps. {F31920089} [18:14:07] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising-Backlog, fundraising Sprint Grep works IRL, MediaWiki-extensions-CentralNotice, and 3 others: Implement redirect for hide banner cookie issue - https://phabricator.wikimedia.org/T251780 (AndyRussG) Adding Traffic and Operations tags to as... [18:15:07] Fundraising-Backlog, Wikimedia-Fundraising-Banners: Ingenico inconsistently accepts missing cvv cards - https://phabricator.wikimedia.org/T257343 (XenoRyet) This is the error I get following the above steps: {F31920095} [18:16:37] Fundraising-Backlog, Wikimedia-Fundraising-Banners: Monthly Other amount (post-payment monthly convert) allows text only input - https://phabricator.wikimedia.org/T257321 (jbolorinos-ctr) p:Triage→Low [18:19:58] Fundraising-Backlog: Create fundraising MediaWiki 1.35 payments deploy branch - https://phabricator.wikimedia.org/T257352 (Jgreen) [18:21:29] fundraising-tech-ops, fr-tech-ops-okr: Upgrade payments servers to Debian Buster - https://phabricator.wikimedia.org/T256146 (Jgreen) Stalled→Open [18:21:31] Fundraising-Backlog, fundraising-tech-ops: Upgrade payments to MediaWiki 1.35 - https://phabricator.wikimedia.org/T254298 (Jgreen) [18:21:33] Fundraising-Backlog, fundraising-tech-ops, fr-tech-ops-okr: OKR 2019-2020 Q3: Support fundraising through maintaining infrastructure for payments and donor data - https://phabricator.wikimedia.org/T243019 (Jgreen) [18:49:01] (PS1) Jgleeson: Send MatchingGifts*.csv along to silverpop ftp with the other exported files. [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/610137 (https://phabricator.wikimedia.org/T257000) [18:57:36] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising-Backlog, fundraising Sprint Grep works IRL, MediaWiki-extensions-CentralNotice, and 3 others: Implement redirect for hide banner cookie issue - https://phabricator.wikimedia.org/T251780 (MBeat33) Thanks to everyone working on this. I'd li... [18:58:07] (PS1) Jgleeson: Reset employer_id each time a new search starts [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/610140 (https://phabricator.wikimedia.org/T256838) [19:00:37] (CR) jerkins-bot: [V: -1] Reset employer_id each time a new search starts [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/610140 (https://phabricator.wikimedia.org/T256838) (owner: Jgleeson) [19:03:32] (PS2) Jgleeson: Reset employer_id each time a new search starts [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/610140 (https://phabricator.wikimedia.org/T256838) [19:08:34] (PS7) Mepps: Allow redirect on Special:HideBanners on limited redirectUrl [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/609810 (https://phabricator.wikimedia.org/T251780) [19:09:26] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: TS update import back into Civi - https://phabricator.wikimedia.org/T255805 (Eileenmcnaughton) @CCogdill_WMF I just checked and around ~200k of ~800k are in - we can up the schedule a bit if needed sinc... [19:18:46] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising-Backlog: Removing asterisks in payment page card number field - https://phabricator.wikimedia.org/T254032 (DStrine) Open→Resolved [19:20:50] Fundraising-Backlog, Wikimedia-Fundraising-Banners: Ingenico inconsistently accepts missing cvv cards - https://phabricator.wikimedia.org/T257343 (EWilfong_WMF) As another data point, I am able to submit a successful transaction with a valid CC number and expiration data WITHOUT entering a security code... [19:34:50] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising-Backlog, Patch-For-Review: Japanese MC 2nd Upsell Email - https://phabricator.wikimedia.org/T255227 (TSkaff) I just have you edit access @Cstone :) I see what you're referring to; so this: ご寄付は、あなたが中止を希望されるまで、毎月%%day%% 日前後に引き落とされます。 vs. th... [19:59:14] Fundraising-Backlog, Wikimedia-Fundraising-Banners: Ingenico inconsistently accepts missing cvv cards - https://phabricator.wikimedia.org/T257343 (spatton) In a single test on Chrome 83.0 on my desktop PC, using a Mastercard debit card, I get the error message as expected. {F31920194} [20:26:15] Fundraising Sprint Kavascript: the chill new language, Fundraising Sprint Lazy Loading Life, Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising-Backlog, and 2 others: Civi: annual summary email - add tax deductibility language - https://phabricator.wikimedia.org/T242001 (mepps) Open→... [20:26:28] Fundraising Sprint Lazy Loading Life, Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising-Backlog, FR-dlocal, and 2 others: Make PAN field default to upper case - https://phabricator.wikimedia.org/T255171 (DStrine) Open→Resolved [20:26:41] Fundraising Sprint Lazy Loading Life, Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising-Backlog, MediaWiki-extensions-CentralNotice: Prepare CN deploy 2020-06 - https://phabricator.wikimedia.org/T255476 (DStrine) Open→Resolved [20:26:49] Fundraising Sprint Just space out, Fundraising Sprint Kavascript: the chill new language, Fundraising Sprint Lazy Loading Life, Fundraising Sprint MySQL is YourSQL and WeSQL, and 3 others: CentralNotice: Deploy new regional geotargeting and banner template ... - https://phabricator.wikimedia.org/T252596 [20:27:27] Fundraising Sprint Heaven is a page on Wikipedia, Fundraising Sprint Ice cream cures everything, Fundraising Sprint Just space out, Fundraising Sprint Kavascript: the chill new language, and 5 others: Make Civi matching gifts extension store data in custom ... - https://phabricator.wikimedia.org/T249924 [20:27:29] Fundraising-Backlog, Epic: Epic: matching gifts HEP integration (was employer field V2) - https://phabricator.wikimedia.org/T228765 (DStrine) [20:27:43] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Create CiviCRM API to export data for employer autocomplete - https://phabricator.wikimedia.org/T250328 (DStrine) Open→Resolved [20:27:47] Fundraising-Backlog, Epic: Epic: matching gifts HEP integration (was employer field V2) - https://phabricator.wikimedia.org/T228765 (DStrine) [20:28:00] Fundraising-Backlog, Epic: Epic: matching gifts HEP integration (was employer field V2) - https://phabricator.wikimedia.org/T228765 (DStrine) [20:28:02] Fundraising Sprint Lazy Loading Life, Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising-Backlog, Patch-For-Review: Export Matching Gifts data to acoustic - https://phabricator.wikimedia.org/T254809 (DStrine) Open→Resolved [20:28:51] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: TS update import back into Civi - https://phabricator.wikimedia.org/T255805 (Eileenmcnaughton) a:Eileenmcnaughton [20:29:25] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising-Backlog, Patch-For-Review: Japanese MC 2nd Upsell Email - https://phabricator.wikimedia.org/T255227 (CDenes_WMF) Thank you, Thea. Confirming that is correct. Donor Services confirmed awhile back that the simplified version was OK for non-En... [20:30:19] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising-Backlog: Check on old Ingenico to new Ingenico test recurrings - https://phabricator.wikimedia.org/T256181 (Cstone) Open→Resolved [20:31:52] Fundraising-Backlog, fundraising-tech-ops: map out a civicrm.log_% table data expiration/delete strategy - https://phabricator.wikimedia.org/T257232 (Eileenmcnaughton) Just noting this https://docs.google.com/document/d/1PAHrjf1Z6iBrpqGR5xGQWW89c7aT1MZs7DogRerY3Kg/edit?usp=drive_web&ouid=1102433332378154... [20:33:21] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: add translations to generic email for failed recurring donations - https://phabricator.wikimedia.org/T255837 (CDenes_WMF) Hi @DStrine ! Could you please confirm we're good to move forward considering the above? Thank you :) Camille [20:40:59] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint N 2020, Fundraising-Backlog: Adyen recurring double recurring records in civi - https://phabricator.wikimedia.org/T257067 (DStrine) [20:41:01] Fundraising Sprint N 2020, Fundraising-Backlog, FR-Ingenico: Convert the rest of old ingenico recurring to new - https://phabricator.wikimedia.org/T257172 (DStrine) [20:41:04] Fundraising Sprint Lazy Loading Life, Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint N 2020, Fundraising-Backlog, and 2 others: Add silverpop privacy delete routine - https://phabricator.wikimedia.org/T257001 (DStrine) [20:41:08] Fundraising Sprint N 2020, Fundraising-Backlog, Patch-For-Review: Update silverpop ftp upload script to push up new matching gifts csv - https://phabricator.wikimedia.org/T257000 (DStrine) [20:41:11] Fundraising Sprint N 2020, Fundraising-Backlog: Process to transfer MG employers data file between civi1001 and frpm1001 - https://phabricator.wikimedia.org/T256825 (DStrine) [20:41:13] Fundraising Sprint Lazy Loading Life, Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint N 2020, Fundraising-Backlog, and 2 others: Small number of contacts being inappropriately put on the suppression list - https://phabricator.wikimedia.org/T256522 (DStrine) [20:41:15] Fundraising Sprint N 2020, Fundraising-Backlog, Patch-For-Review: In the DonationInterface form, handle case in which a user clicks on an employer from the dropdown, then types the name of an employer not on the list - https://phabricator.wikimedia.org/T256838 (DStrine) [20:41:19] Fundraising Sprint N 2020, Fundraising-Backlog: New Ingenico API key required before July 29,2020 - https://phabricator.wikimedia.org/T256408 (DStrine) [20:41:21] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint N 2020, Fundraising-Backlog: Missing "unsubscribe" link in automatic recurring failure email - https://phabricator.wikimedia.org/T256162 (DStrine) [20:41:23] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint N 2020, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: TS update import back into Civi - https://phabricator.wikimedia.org/T255805 (DStrine) [20:41:25] Fundraising Sprint Lazy Loading Life, Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint N 2020, Fundraising-Backlog, and 2 others: Test CiviCRM on new box - https://phabricator.wikimedia.org/T254940 (DStrine) [20:41:27] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint N 2020, Fundraising-Backlog: Japanese TY Email - https://phabricator.wikimedia.org/T254052 (DStrine) [20:41:29] Fundraising Sprint Lazy Loading Life, Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint N 2020, Fundraising-Backlog: Fr-tech engineer should take on chores this sprint - https://phabricator.wikimedia.org/T254938 (DStrine) [20:41:31] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint N 2020, Fundraising-Backlog, Patch-For-Review: Japanese MC 2nd Upsell Email - https://phabricator.wikimedia.org/T255227 (DStrine) [20:41:33] Fundraising Sprint N 2020, Fundraising Sprint X-rays, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Fredge search in Civi randomly scrambling search results - https://phabricator.wikimedia.org/T239967 (DStrine) [20:41:35] Fundraising Sprint Lazy Loading Life, Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint N 2020, Fundraising-Backlog, and 3 others: Q4 FY2019/20 investigate export and upload issues with the silverpop export - https://phabricator.wikimedia.org/T253152 (DStrine) [20:41:37] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint N 2020, Fundraising-Backlog, Patch-For-Review: Create job to update/generate employer dataset for usage within paymentswiki - https://phabricator.wikimedia.org/T251201 (DStrine) [20:41:39] Fundraising Sprint Lazy Loading Life, Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint N 2020, Fundraising-Backlog, and 3 others: Add and delete fields from the _all_Wikimedia database (civi export to ESP) - https://phabricator.wikimedia.org/T252245 (DStrine) [20:41:41] Fundraising Sprint N 2020, Fundraising-Backlog, fundraising-tech-ops: map out a civicrm.log_% table data expiration/delete strategy - https://phabricator.wikimedia.org/T257232 (DStrine) [20:41:44] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint N 2020, Fundraising-Backlog, fundraising Sprint Grep works IRL, and 4 others: Implement redirect for hide banner cookie issue - https://phabricator.wikimedia.org/T251780 (DStrine) [20:51:59] Fundraising Sprint Lazy Loading Life, Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint N 2020, Fundraising-Backlog, and 3 others: Add and delete fields from the _all_Wikimedia database (civi export to ESP) - https://phabricator.wikimedia.org/T252245 (KHaggard) Updating that the n... [21:11:02] (PS3) Jgleeson: Reset employer_id each time a new search starts [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/610140 (https://phabricator.wikimedia.org/T256838) [21:12:00] Fundraising Sprint Lazy Loading Life, Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, and 3 others: Add and delete fields from the _all_Wikimedia database (civi export to ESP) - https://phabricator.wikimedia.org/T252245 (Eileenmcnaught... [21:13:17] hmmm whitespace changes [21:13:20] grrr [21:14:06] (PS4) Jgleeson: Reset employer_id each time a new search starts [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/610140 (https://phabricator.wikimedia.org/T256838) [21:26:55] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, Patch-For-Review: Japanese MC 2nd Upsell Email - https://phabricator.wikimedia.org/T255227 (TSkaff) Hey @CDenes_WMF! I was just chatting with Christine on IRC and apparently** only** th... [21:27:37] Fundraising Sprint Lazy Loading Life, Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, and 3 others: Add and delete fields from the _all_Wikimedia database (civi export to ESP) - https://phabricator.wikimedia.org/T252245 (Eileenmcnaught... [21:45:17] (PS1) Cstone: Update Japanese thank you email. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/610178 [21:47:11] (CR) jerkins-bot: [V: -1] Update Japanese thank you email. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/610178 (owner: Cstone) [21:47:47] (CR) Cstone: "recheck" [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/610178 (owner: Cstone) [21:59:07] fundraising-tech-ops: encrypt fundraising database client->server communication - https://phabricator.wikimedia.org/T170321 (Dwisehaupt) [21:59:09] Fundraising-Backlog, fundraising-tech-ops, Patch-For-Review: figure out Buster package for python3-mysql.connector for use with fruec - https://phabricator.wikimedia.org/T246823 (Dwisehaupt) [22:05:13] PROBLEM - check_mysql on frdev1001 is CRITICAL: SLOW_SLAVE CRITICAL: Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 1228 [22:08:37] ACKNOWLEDGEMENT - check_mysql on frdev1001 is CRITICAL: SLOW_SLAVE CRITICAL: Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 1228 Dwisehaupt silverpop queries [22:10:41] Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, fundraising-tech-ops: map out a civicrm.log_% table data expiration/delete strategy - https://phabricator.wikimedia.org/T257232 (Ejegg) Eileen notes (in tech talk): We can purge deleted contacts from 2016-one year ago (we had only purged... [22:15:13] RECOVERY - check_mysql on frdev1001 is OK: Uptime: 3737558 Threads: 3 Questions: 100256199 Slow queries: 203748 Opens: 1566295 Flush tables: 1 Open tables: 200 Queries per second avg: 26.823 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 0 [22:18:08] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising-Backlog: Removing asterisks in payment page card number field - https://phabricator.wikimedia.org/T254032 (EMartin) YAY!! [22:18:11] (PS2) Cstone: Add footer to the English and Japanese recurring notification emails. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/609874 [22:20:15] (CR) Cstone: "recheck" [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/610178 (owner: Cstone) [22:26:32] (CR) Cstone: "recheck" [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/610178 (owner: Cstone) [22:51:20] Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, fundraising-tech-ops: map out a civicrm.log_% table data expiration/delete strategy - https://phabricator.wikimedia.org/T257232 (Eileenmcnaughton) We discussed the doc https://docs.google.com/document/d/1PAHrjf1Z6iBrpqGR5xGQWW89c7aT1MZs7... [22:58:56] Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, fundraising-tech-ops: map out a civicrm.log_% table data expiration/delete strategy - https://phabricator.wikimedia.org/T257232 (Eileenmcnaughton) @Jgreen given it's just a drop are you OK 'just dropping' the triggers on the non 'log-ver... [23:09:03] Wikimedia-Fundraising-Banners: QA: Orange banners for NL - https://phabricator.wikimedia.org/T257388 (TSkaff)