[00:06:09] ok - channged [00:06:12] (PS3) Eileen: Revert changes to final export mapping so deploy is unblocked [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/607894 (https://phabricator.wikimedia.org/T253152) [00:25:37] (CR) Ejegg: [C: +2] Revert changes to final export mapping so deploy is unblocked [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/607894 (https://phabricator.wikimedia.org/T253152) (owner: Eileen) [00:26:22] (Merged) jenkins-bot: Revert changes to final export mapping so deploy is unblocked [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/607894 (https://phabricator.wikimedia.org/T253152) (owner: Eileen) [00:26:34] thanks ejegg what should I do re testing it? Copy existing tables to staging then run with the change & compare? [00:27:00] (final testing - it has been tested but,... ) [00:27:23] also how do I know total time taken - e.g last night vs tonight [00:36:15] (PS1) Eileen: Merge branch 'master' of https://gerrit.wikimedia.org/r/wikimedia/fundraising/tools into deploy [wikimedia/fundraising/tools] (deploy) - https://gerrit.wikimedia.org/r/607908 [00:36:37] (CR) Eileen: [C: +2] Merge branch 'master' of https://gerrit.wikimedia.org/r/wikimedia/fundraising/tools into deploy [wikimedia/fundraising/tools] (deploy) - https://gerrit.wikimedia.org/r/607908 (owner: Eileen) [00:37:12] (Merged) jenkins-bot: Merge branch 'master' of https://gerrit.wikimedia.org/r/wikimedia/fundraising/tools into deploy [wikimedia/fundraising/tools] (deploy) - https://gerrit.wikimedia.org/r/607908 (owner: Eileen) [00:41:45] !log tools revision changed from c96813eda4 to aab96444df [00:41:48] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [00:47:29] eileen the total time should be easy to discern from the process-control logs [00:47:45] for testing you could make a copy of the old export before it gets deleted [00:47:53] ejegg: the log isn't on the live dir - remind me where it gets archived to? [00:47:58] and see if the diff is sane [00:48:03] hmmmm [00:48:23] I copied the 3 main tables from silverpop db on staging to dev_civicrm so I can compare) [00:48:30] oh cool [00:48:43] much more detailed comparisons than a file diff! [00:48:54] Yeah - also new columns [00:49:04] & of course some rows have legit changed... [00:49:50] so there is an archive folder for process-contrrol - I just don't knnow where [00:51:17] on frlog1001 [00:51:28] oh wait [00:51:32] did it go away [00:51:32] ? [00:51:42] ahh, I think the name changed [00:52:03] yeah, it was /srv/archive/civi1001/process-control [00:52:13] and now it's just /srv/archive/civi/process-control [00:54:48] eileen ^^ [00:54:56] ah thanks [00:57:34] ok - just shy of 4 hours to generate the outpt & 30 mins to upload [02:01:13] (PS12) Ejegg: New MatchingGiftPolicies api action 'sync' using job [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/605638 (https://phabricator.wikimedia.org/T249924) [02:01:15] (PS7) Ejegg: Add matching gift employer export [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/607633 (https://phabricator.wikimedia.org/T250328) [02:01:17] (PS1) Ejegg: Ensure matching gifts job table created on install [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/607915 [02:01:34] eileen: I think PS12 ^^ addresses all your comments [02:02:04] ejegg: ok cool - I will look once I can charge my laptop again - off to buy a new cable [02:02:11] and reorganizes the sync code to be potentially testable [02:02:16] cool [02:02:33] oh dang eileen, no charging is a bummer! [02:02:59] yep - at 1% now... and those queries are still going :-( I wanted to see that finishe first [02:03:10] (CR) jerkins-bot: [V: -1] Add matching gift employer export [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/607633 (https://phabricator.wikimedia.org/T250328) (owner: Ejegg) [02:03:28] (CR) jerkins-bot: [V: -1] Ensure matching gifts job table created on install [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/607915 (owner: Ejegg) [02:03:33] oops [02:15:18] (CR) Ejegg: "recheck" [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/607633 (https://phabricator.wikimedia.org/T250328) (owner: Ejegg) [02:15:26] (CR) Ejegg: "recheck" [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/607915 (owner: Ejegg) [02:17:06] (CR) jerkins-bot: [V: -1] Add matching gift employer export [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/607633 (https://phabricator.wikimedia.org/T250328) (owner: Ejegg) [02:18:26] (CR) jerkins-bot: [V: -1] Ensure matching gifts job table created on install [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/607915 (owner: Ejegg) [02:19:22] (CR) Ejegg: "recheck" [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/607633 (https://phabricator.wikimedia.org/T250328) (owner: Ejegg) [02:21:10] (CR) jerkins-bot: [V: -1] Add matching gift employer export [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/607633 (https://phabricator.wikimedia.org/T250328) (owner: Ejegg) [04:34:04] (PS4) Eileen: Silverpop export: refactor calculation of address and preferred_language [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/607401 [04:45:03] (PS5) Eileen: Silverpop export: refactor calculation of address and preferred_language [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/607401 [04:45:05] (PS2) Eileen: Add some timings [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/607624 [04:45:07] (PS3) Eileen: Silverpop refactor - reduce queries to build country & language [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/607652 [04:45:54] (CR) Eileen: "thanks mepps - yep it's kinda hard to grok!" (2 comments) [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/607401 (owner: Eileen) [04:48:40] (PS4) Eileen: Add index to civicrm_country.iso_code. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/607657 (https://phabricator.wikimedia.org/T253152) [04:51:34] (CR) jerkins-bot: [V: -1] Add index to civicrm_country.iso_code. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/607657 (https://phabricator.wikimedia.org/T253152) (owner: Eileen) [04:59:26] (CR) DannyS712: Silverpop refactor - reduce queries to build country & language (1 comment) [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/607652 (owner: Eileen) [05:40:54] (PS5) Eileen: Add index to civicrm_country.iso_code. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/607657 (https://phabricator.wikimedia.org/T253152) [07:01:33] Fundraising-Backlog, MediaWiki-extensions-CentralNotice, Operations, Traffic, and 2 others: Special:HideBanners is not really cacheable - https://phabricator.wikimedia.org/T256447 (tstarling) [07:12:44] Fundraising Sprint Lazy Loading Life, Fundraising Sprint M 2020, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, FR-Email: Q4 19/20 investigate export and upload issues with the silverpop export - https://phabricator.wikimedia.org/T253152 (Eileenmcnaughton) I deployed the speed improvemen... [07:16:03] Fundraising Sprint Lazy Loading Life, Fundraising Sprint M 2020, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, FR-Email: Q4 19/20 investigate export and upload issues with the silverpop export - https://phabricator.wikimedia.org/T253152 (Eileenmcnaughton) I also got these errors ... whi... [07:38:07] Fundraising Sprint Lazy Loading Life, Fundraising Sprint M 2020, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, FR-Email: Q4 19/20 investigate export and upload issues with the silverpop export - https://phabricator.wikimedia.org/T253152 (Eileenmcnaughton) File length yesterday & today -... [07:44:00] Fundraising Sprint Lazy Loading Life, Fundraising Sprint M 2020, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, FR-Email: Q4 19/20 investigate export and upload issues with the silverpop export - https://phabricator.wikimedia.org/T253152 (Eileenmcnaughton) hmm this one needs digging 2047... [12:30:55] Fundraising Sprint Lazy Loading Life, Fundraising Sprint M 2020, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, FR-Email: Q4 19/20 investigate export and upload issues with the silverpop export - https://phabricator.wikimedia.org/T253152 (KHaggard) Confirming the unsubscribe job uploaded... [12:58:57] Fundraising Sprint Lazy Loading Life, Fundraising Sprint M 2020, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, FR-Email: Q4 19/20 investigate export and upload issues with the silverpop export - https://phabricator.wikimedia.org/T253152 (KHaggard) The failed database import happened on... [14:01:59] Fundraising Sprint M 2020, Fundraising-Backlog: Removing asterisks in payment page card number field - https://phabricator.wikimedia.org/T254032 (Pcoombe) 0000s sounds good to me [15:19:10] (PS13) Ejegg: New MatchingGiftPolicies api action 'sync' using job [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/605638 (https://phabricator.wikimedia.org/T249924) [15:21:18] (CR) jerkins-bot: [V: -1] New MatchingGiftPolicies api action 'sync' using job [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/605638 (https://phabricator.wikimedia.org/T249924) (owner: Ejegg) [15:22:28] (CR) Ejegg: "recheck" [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/605638 (https://phabricator.wikimedia.org/T249924) (owner: Ejegg) [15:28:07] tzag fr-tech! [15:28:58] hi jgleeson! [15:29:18] hey hey [15:29:40] hi jgleeson ejegg [15:33:06] hey cstone :)P [15:33:07] Fundraising Sprint Lazy Loading Life, Fundraising Sprint M 2020, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, FR-Email: Q4 19/20 investigate export and upload issues with the silverpop export - https://phabricator.wikimedia.org/T253152 (jgleeson) >>! In T253152#6258633, @Eileenmcnaught... [15:33:08] -P [15:34:21] hi cstone! [15:35:31] fr-tech: morning. i'm going to be doing a dot upgrade on grafana. there may be a short blip as the package is reloaded. [15:36:41] hi fr-tech! [15:36:41] ok. all done. thanks for your patience. :) [15:37:10] fr-tech I uninstalled the matching gifts extension due to thinking I was missing some db tables cause of a backup I did and then tried to reinstall it and got DB Error: already exists [15:37:10] Is that a common thing? [15:37:36] hmmm I don't think so [15:38:15] hah okay I think I was actually running into the errors you ran into jgleeson just didnt realize it [15:38:46] I'm about to debug that now and see what's up. I guess you could manually drop the two matching gifts tables [15:39:18] did you see my response to your end of day I was getting that error [15:39:23] might be worth a comment on the patch just so ejegg can check if there's any clean up needed in the module uninstall logic [15:39:27] extension rather [15:40:44] cstone: I did see your reply thanks. I think I tried matching the array key as I noticed the first one was more wordy and it errored again but maybe I fixed the first issue and ran into the second one and just didn't notice it, which it sounds like ran into it also [15:41:09] I did notice on the sync patch the commit message says the civicrm_settings key isn't important or something of that nature [15:41:41] cstone argh, I got some errors too [15:42:22] jgleeson so the top-level array key just needs to exist [15:42:33] but it doesn't matter what the value is [15:42:35] pretty lame [15:43:06] $civicrm_settings['this can be anything']['this.matters_and_is_globally_unique'] [15:43:21] yeah I guessed as much from your comment [15:43:32] cstone ok, I need to figure out the best way to handle the install/uninstall I guess [15:44:25] what are the two tables called? I found one i deleted [15:44:43] I think this last patch I made isn't quite it: https://gerrit.wikimedia.org/r/607915 [15:45:08] cstone there's civicrm_matching_gift_job_progress and civicrm_value_matching_gift [15:45:24] thanks ejegg [15:56:26] Fundraising Sprint Lazy Loading Life, Fundraising Sprint M 2020, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, FR-Email: Q4 19/20 investigate export and upload issues with the silverpop export - https://phabricator.wikimedia.org/T253152 (KHaggard) Would it be possible for fr-tech to pus... [16:01:54] ejegg: are there any reasons why we would NOT want to run the silverpop export and upload outside of the usual schedule? Katie Haggard has asked if we can push it up again. I know the file size is unusually large so maybe that's a problem? [16:05:21] jgleeson we definitely don't want to do it when they're not expecting it [16:05:51] cstone when I was manually forcing the uninstall I also had to get rid of the custom fields on my own [16:06:11] did most of that in the db [16:06:51] with select * from civicrm_custom_group where name like '%match%'; [16:07:15] then delete from civicrm_custom_field where custom_group_id= [16:07:25] then delete from civicrm_custom_group where id= [16:10:10] woo thanks ejegg that was it [16:36:41] great! [16:41:43] Fundraising Sprint Lazy Loading Life, Fundraising Sprint M 2020, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, FR-Email: Q4 19/20 investigate export and upload issues with the silverpop export - https://phabricator.wikimedia.org/T253152 (Ejegg) @KHaggard OK, the file is re-uploaded! [16:51:10] ok cstone the error we both ran into looks like it's due to a missing getFullName method on the provider class [16:51:22] and just as I worked it out ejegg emailed us both saying it's fixed :) [16:51:45] ejegg: on the settings key [16:52:08] oops, yeah, I had getProviderName originally and changed it in 2 of the 3 places [16:52:39] I had to change my previous $civicrm_setting['Matching Gifts']['ssbinfo_credentials'] to $civicrm_setting['Matching Gifts']['matchinggifts.ssbinfo_credentials'] [16:52:46] oh wait, there's a settings key goofed? [16:52:48] nice jgleeson ejegg [16:52:50] the namespace [16:52:53] is new [16:52:57] ahh, yeah [16:53:41] lemme make sure it's all all consistent [16:54:19] yep, looks good [16:56:13] WD php: TypeError: Argument 2 passed to CRM_MatchingGifts_SsbinfoProvider::searchByCategory() must be of the type string, null given [16:56:20] brb! [16:56:32] jgleeson ooh, good catch [16:56:44] I guess I need to take out that type hint [16:58:00] (PS14) Ejegg: New MatchingGiftPolicies api action 'sync' using job [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/605638 (https://phabricator.wikimedia.org/T249924) [16:58:24] ok, ^^ should work without the matching categories [16:58:54] i didn't hit it locally because I had $civicrm_setting['Matching Gifts']['matchinggifts.ssbinfo_matched_categories'] set [17:16:39] thanks! [17:18:31] jgleeson im running into the utf8 issue you saw [17:19:05] or hmm since i changed it i still dont see the civicrm_matching_gift_job_progress table [17:20:06] It was happening when I was in the civi UI system->extensions and then it asked me to upgrade the db for an extension [17:20:36] yeah I couldnt get the upgrade to pop up so I tried uninstalling and reinstalling again but still not there [17:21:31] is there any errors in your latest /srv/org.wikimedia.civicrm-files/civicrm/ConfigAndLog/ log file? [17:21:35] are* [17:22:47] I fixed it by setting the default collation for the civicrm db to utf8 [17:24:06] i see the utf8 error from when i tried it yesterday but since i changed the collation I dont see the error again but also not the table [17:24:14] ahh [17:25:20] what does SELECT @@character_set_database, @@collation_database; show [17:26:01] well that answers that says mb4 what did i change then [17:26:03] thanks jgleeson [17:27:54] ALTER DATABASE civicrm CHARACTER SET utf8 COLLATE utf8_general_ci; should do it [17:29:00] while I was looking into that issue I kept seeing comments along the lines of this fr-tech: [17:29:02] Note: In MySQL you have to use utf8mb4 rather than utf8. Confusingly, utf8 is a flawed UTF-8 implementation from early MySQL versions which remains only for backward compatibility. The fixed version was given the name utf8mb4. [17:29:25] yeah I must have not actually run it, set up a trap for myself [17:29:37] cstone oh weird [17:29:45] so maybe we should stick with utf8mb4 and just get stuff to work with that [17:29:48] well we shouldn't force that bad encoding [17:29:50] yeah [17:32:27] ejegg: if I flip back to utf8mb4 and then run the following, it works for me: [17:32:28] CREATE TABLE civicrm_matching_gift_job_progress ( [17:32:30] job_id int not null, [17:32:32] company_id varchar(191) not null, [17:32:34] processed tinyint default 0, [17:32:36] unique (job_id, company_id) [17:32:38] ); [17:32:40] /191/ [17:36:13] so.... wierd, what was causing the issue then? [17:36:26] ohhh, with company id 191 [17:36:31] yup [17:36:40] well, I guess that ID is never actually going to be that long [17:36:47] I'll dial it all the way back to 127 [17:37:07] still don't know why it didn't break on my install [17:37:15] I got the 191 from this comment https://stackoverflow.com/questions/1814532/1071-specified-key-was-too-long-max-key-length-is-767-bytes#comment69152704_1814594 [17:37:43] ehh, i prefer even numbers [17:37:47] like 127 :) [17:38:58] (PS15) Ejegg: New MatchingGiftPolicies api action 'sync' using job [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/605638 (https://phabricator.wikimedia.org/T249924) [17:41:47] (PS16) Ejegg: New MatchingGiftPolicies api action 'sync' using job [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/605638 (https://phabricator.wikimedia.org/T249924) [17:41:59] ok, PS16 has a little bit of uninstall logic too [17:42:11] just gets rid of the job table [17:42:42] working ok a little bit of automated testing for the sync stuff, but no need to wait on that for review [17:42:51] I'd be happy to make it a follow-on patch [17:43:48] (CR) jerkins-bot: [V: -1] New MatchingGiftPolicies api action 'sync' using job [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/605638 (https://phabricator.wikimedia.org/T249924) (owner: Ejegg) [17:43:55] hmm [17:44:06] Fundraising Sprint Lazy Loading Life, Fundraising Sprint M 2020, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, FR-Email: Q4 19/20 investigate export and upload issues with the silverpop export - https://phabricator.wikimedia.org/T253152 (KHaggard) Awesome! thanks @Ejegg. The import job... [17:44:47] so weird that CI fails on emailing an admin password in drupal setup [17:44:58] (CR) Ejegg: "recheck" [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/605638 (https://phabricator.wikimedia.org/T249924) (owner: Ejegg) [17:46:39] so the matching gifts sync is working for me! [17:51:12] awesome jgleeson! [17:51:27] I'll keep plugging away at the uninstall in future patches [17:51:32] haha i can confirm the uninstall looks for my missing table :) [17:57:50] hmm now im getting an error on install [17:57:56] ALTER TABLE civicrm_value_matching_gift [17:57:56] ADD COLUMN `matching_gifts_provider_id` [17:58:04] but i dont think thta was changed in your last patch ejegg ? i dont see it [17:58:58] cstone no [17:59:08] so that's trying to add the custom field [17:59:45] it adds them one at a time, adding the columns as it goes [18:00:18] so the uninstall doesn't actually delete the custom fields [18:00:27] and I'm not sure if we actually would want it to [18:00:49] let me try this again maybe i missed deleting one [18:01:12] I think there must be a way to do it with a mgd file [18:01:28] looking for the doc on that [18:02:12] this situation i have it started making the custom fields but the civicrm_value_matching_gift isnt there [18:04:11] ok, I would just delete the civicrm_custom_field and civicrm_custom_group values then [18:04:33] I think it creates the table when it adds the civicrm_custom_group value [18:22:51] Fundraising Sprint M 2020, Fundraising-Backlog: Create job to update/generate employer dataset for usage within paymentswiki - https://phabricator.wikimedia.org/T251201 (jgleeson) @Ejegg do you see the //sync// and //export// processes running in tandem here or would there be a case to have the //sync//... [18:28:29] Wikimedia-Fundraising-Banners: Add non-breaking space between ₹ and amount for Indian Rupee - https://phabricator.wikimedia.org/T256288 (jbolorinos-ctr) Thanks Peter! I agree consistency is better, would we still need to update the payments wiki page though? Or is that donate wiki? In T255065 that was where... [18:53:51] Fundraising Sprint M 2020, Fundraising-Backlog: Create job to update/generate employer dataset for usage within paymentswiki - https://phabricator.wikimedia.org/T251201 (Ejegg) @jgleeson maybe the parent job runs the sync and then the export? [19:08:17] (PS1) Jgleeson: WIP: Command to diff matching gifts employer data file [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/608089 (https://phabricator.wikimedia.org/T251201) [19:13:28] have a good evening fr-tech! [19:13:55] have a good weekedn jgleeson|away [19:17:41] (CR) Cstone: "I finally got this to run, I did have to manually run the SQL to install the civicrm_matching_gift_job_progress table but after that it wa" [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/605638 (https://phabricator.wikimedia.org/T249924) (owner: Ejegg) [19:31:41] hmm cstone I tried adding the sql to the install fn in a separate patch [19:31:54] but I was getting some DB error:unknown error when I tried that [19:32:28] that was what i saw with the utf8 issue [19:32:58] fundraising-tech-ops: Determine reason for daily increasing proc count on fran1001 - https://phabricator.wikimedia.org/T256420 (Dwisehaupt) Rolled the prometheus processes collector to buster hosts to collect stats on total procs running and their states. ` [frack::puppet] 0f300450 Re-enable the proccesses... [19:36:51] ok, gonna try the ingenico audit from the upgraded civi box [19:37:05] might be really slow with the cross-dc db queries [20:31:08] hey ejegg cstone should I look at https://gerrit.wikimedia.org/r/c/wikimedia/fundraising/crm/+/605638? [20:31:39] AndyRussG: yes please! [20:32:10] before you look at it, can you please let me know if you have the matching gifts extension installed at all yet? [20:32:23] I'm curious what happens if you pull down that patch and then install [20:32:31] ejegg: no I haven't [20:32:33] rather than upgrade [20:32:36] oh cool [20:33:04] so after pulling that patch down, please go to the civicrm admin menu->system settings->extensions [20:33:13] then click install on the matching gifts one [20:33:18] https://gerrit.wikimedia.org/r/c/wikimedia/fundraising/crm/+/605638 ? [20:33:25] yep, the 'sync' one [20:33:31] okok [20:33:41] it adds another table, but in an 'upgrade' step rather than in the install step [20:34:21] K just gonna grab the latest version sion [20:34:23] then [20:35:49] whew, this audit is slow indeed [20:37:32] ejegg: hmmm I don't seem to be able to access normal vagrant civi [20:37:58] shoot, that'll make it hard to review [20:38:10] I could log in at http://crm.local.wmftest.net:8080 but it goes to some weird drupal ui [20:38:22] like with a green menu at the top [20:38:32] there's a link there that says "CiviCRM" [20:38:51] Oh weird now it worked! [20:39:23] Before it complained about some db error [20:40:34] ejegg: probably I should update other stuff somehwere? [20:40:56] oh hmm [20:41:08] so you can go to /civicrm/upgrade [20:41:18] and see if there's civi updates to be had [20:41:23] you can also drush updb [20:41:43] ah, and that might actually install the extension for you (the drush updb) [20:42:51] /civicrm/upgrade says "Upgrade CiviCRM to Version 5.26.beta1" and " The database will be upgraded from 5.18.0 to 5.26.beta1." [20:42:59] oh wow, yeah, you need that [20:43:09] that's a WAYS behind [20:43:13] ejegg: ok.... maybe I should switch back to master first? [20:43:23] to test the thing you wanted me to test? [20:43:37] no need to switch for this upgrade [20:43:52] okok [20:43:55] it's the drush updb that will install the extension for you [20:44:01] K I'll do the upgrade [20:44:26] but that's OK too, I just wanted to see someone install it from uninstalled to the current state [20:44:44] rather than installing the previous commits and then upgrading to the current one [20:44:56] Not sure if it worked [20:45:15] Now there's an unstyled screen that says "CiviCRM Upgrade Tasks []" with retry and skip buttons [20:45:31] hmm, odd [20:45:43] it's maybe running things in the background? [20:45:51] I think that's how their webui upgrader works [20:46:01] buttons don't do anything [20:46:23] vagrant vm cpu doesn't seem to be busy [20:46:57] ejegg: now went to http://crm.local.wmftest.net:8080/civicrm?reset=1 [20:47:08] there's a message that says "The mysql commands you need to run are stored in /vagrant/srv/org.wikimedia.civicrm/drupal/sites/default/files/civicrm/ConfigAndLog/CiviCRM.trigger5ef65e1f5a2a4389f54031f6ee9ab2b09642bc3fb7c18.sql" [20:47:12] ok, I guess it finished? [20:47:21] try going back to the upgrade page and see what it says [20:47:44] nope, same message as before [20:50:22] ejegg: sorry to be bothering you with this... didn't realize my vagrant civi was broken... are there instructions somewhere about how to bring it up-tp-date? also, surprised that doesn't happen with git [20:50:42] no worries! [20:50:50] btw on the update screen there's a long message with things it's telling me to upgrade manually [20:51:07] oh? like what? [20:51:49] ejegg: if you're not super busy and/or about to head out, we could do a quick screen-share/video call? (no worries if not) [20:53:27] sure thing AndyRussG [20:53:39] in what was to be today's standup? [20:54:30] I'm over in nsc-symi-ici [20:55:41] ejegg: thanks!!! k one sec! [20:56:55] ahh, the thing about the mysql commands you need to run might be a red herring [21:12:40] ejegg: AndyRussG im behind but I was trying to install it from scratch, well what i thought was scratch with that patch [21:15:50] ok, thanks cstone! [21:16:18] cstone do you remember anything about the fix for mepps's issue where vagrant-civi didn't load JS ? [21:16:26] yeah lets see [21:17:09] I had to change the path [21:17:24] something in the URL settings? [21:18:00] trying to see if I made i note i thought i did [21:18:59] yeah in civicrm.settings.php [21:19:07] I changed the $civicrm_root to [21:19:12] '/vagrant/srv/org.wikimedia.civicrm/drupal/sites/all/modules/civicrm'; [21:21:02] aha, yep, that was it! [21:21:04] thanks cstone [21:21:27] cstone: thanks!! [21:34:59] I'm going to head out on the lake, have a good weekend AndyRussG ejegg [21:37:31] (PS8) AndyRussG: Add matching gift employer export [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/607633 (https://phabricator.wikimedia.org/T250328) (owner: Ejegg) [21:55:04] Fundraising Sprint Lazy Loading Life, Fundraising Sprint M 2020, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, FR-Email: Q4 19/20 investigate export and upload issues with the silverpop export - https://phabricator.wikimedia.org/T253152 (Eileenmcnaughton) @jgleeson it still requires act... [22:00:53] have a good one cstone! [22:04:28] (PS9) Ejegg: Add matching gift employer export [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/607633 (https://phabricator.wikimedia.org/T250328) [22:05:11] (CR) Ejegg: "PS9: rebased onto master since it doesn't depend on sync." [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/607633 (https://phabricator.wikimedia.org/T250328) (owner: Ejegg) [22:17:16] ok. i'm off for a while. probably back after 0200 UTC to check in on the oddities seen with the analytics box after the buster db upgrade. [22:21:57] thx again ejegg! [22:23:39] see ya dwisehaupt [22:23:41] yw AndyRussG [22:45:13] :) [22:48:32] Fundraising Sprint Lazy Loading Life, Fundraising Sprint M 2020, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, FR-Email: Q4 19/20 investigate export and upload issues with the silverpop export - https://phabricator.wikimedia.org/T253152 (KHaggard) >>! In T253152#6256622, @CCogdill_WMF... [22:53:03] Fundraising Sprint Lazy Loading Life, Fundraising Sprint M 2020, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, FR-Email: Q4 19/20 investigate export and upload issues with the silverpop export - https://phabricator.wikimedia.org/T253152 (Eileenmcnaughton) @KHaggard so as I understand it...