Page MenuHomePhabricator

Cannot add or change anything on the prospect tab
Closed, ResolvedPublic2 Story Points

Description

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.

Details

Related Gerrit Patches:
wikimedia/fundraising/crm : masterAdministrative triggers update.
wikimedia/fundraising/crm : masterUpdated triggers for civicrm_value_1_prospect_5.mysql

Event Timeline

NNichols created this task.Oct 21 2019, 5:35 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptOct 21 2019, 5:35 PM
NNichols renamed this task from Cannot update drop downs on prospect tab to Cannot add or change anything on the prospect tab.Oct 21 2019, 6:15 PM
NNichols updated the task description. (Show Details)

@NNichols is this ongoing? Just trying to rule out a load issue

@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

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

https://gerrit.wikimedia.org/r/545092

Change 545103 had a related patch set uploaded (by Eileen; owner: Eileen):
[wikimedia/fundraising/crm@master] Administrative triggers update.

https://gerrit.wikimedia.org/r/545103

Eileenmcnaughton set the point value for this task to 2.

Change 545092 merged by jenkins-bot:
[wikimedia/fundraising/crm@master] Updated triggers for civicrm_value_1_prospect_5.mysql

https://gerrit.wikimedia.org/r/545092

Change 545103 merged by jenkins-bot:
[wikimedia/fundraising/crm@master] Administrative triggers update.

https://gerrit.wikimedia.org/r/545103

@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

  1. it's only one table
  2. it's already unwritable / broken & has been for about 12 hours at this point
  3. none of the queues write to this table - hence it not burning down the house already.

I logged https://phabricator.wikimedia.org/T236111 to address the (low) risk of this happening again.

Eileenmcnaughton triaged this task as Unbreak Now! priority.Oct 21 2019, 11:55 PM
Restricted Application added subscribers: Pcoombe, Liuxinyu970226. · View Herald TranscriptOct 21 2019, 11:55 PM

@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!

@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'

@Eileenmcnaughton: Trigger refresh is done!

@NNichols should be ok again now

Yes thank you

Eileenmcnaughton closed this task as Resolved.Tue, Oct 29, 7:03 PM