| • NNichols | |
| Oct 21 2019, 5:35 PM |
| F30873257: image.png | |
| Oct 21 2019, 5:35 PM |
| F30873259: image.png | |
| Oct 21 2019, 5:35 PM |
When trying to update these drop downs from the summary screen OR the prospect tab we are receiving an error message. We were attempting to do this on record ID
6340635
UPDATE: Cannot make any changes to the prospect tab. When trying to add text to the bio fields and save the triangle just keeps spinning.
@Eileenmcnaughton yes. I still cannot add or change anything on the prospect tab. We were also trying to change some drop down options this morning and that is also not working.
It looks like a custom field was deleted - 'Prior WMF Giving' - however, the triggers are still trying to update that data - causing the error. I need @Jgreen or @Dwisehaupt to help me reload them
@NNichols @RLewis it's OK for you guys to create custom fields or disable them but not delete them. If you were ever told this it would be so long ago I imagine you would have forgotten
I added this https://phabricator.wikimedia.org/T236111 as a follow up on the preventative side
Change 545092 had a related patch set uploaded (by Eileen; owner: Eileen):
[wikimedia/fundraising/crm@master] Updated triggers for civicrm_value_1_prospect_5.mysql
Change 545103 had a related patch set uploaded (by Eileen; owner: Eileen):
[wikimedia/fundraising/crm@master] Administrative triggers update.
Change 545092 merged by jenkins-bot:
[wikimedia/fundraising/crm@master] Updated triggers for civicrm_value_1_prospect_5.mysql
Change 545103 merged by jenkins-bot:
[wikimedia/fundraising/crm@master] Administrative triggers update.
@Jgreen @Dwisehaupt - could one of you load this triggers file - under webroot
sites/all/modules/wmf_civicrm/scripts/civicrm_value_1_prospect_5.mysql
A s a matter of 'some urgency' - a column was deleted from civicrm_value_1_prospect_5.mysql resulting in the table being unwritable - this affects the UI and could potentially cause a dedupe to crash although we haven't seen that happen. Other queues don't write to it
This should not require an outage as
I logged https://phabricator.wikimedia.org/T236111 to address the (low) risk of this happening again.
@DStrine I've upped this to 'unbreak now' as there is something actively broken. We discussed on IRC & it seemed like it didn't merit disturbing Jeff or Dallas after hours but ideally first thing when they start their day . I think the file to load should be safe enough to 'just do'
Mentioned in SAL (#wikimedia-fundraising) [2019-10-22T01:12:50Z] <eileen> disabled dedupe job pending T236096 deploy
@Eileenmcnaughton Yes this was totally me. I was attempting to change some dropdowns and disable some fields (must have deleted instead) I saw your other ticket. I'm totally in support of taking away our option to delete!