Deleting and Adding Custom Fields

Question

I'm having trouble updating custom fields in CiviCRM 5.15.1/Drupal.

UPDATE: I believe this is occurring because I have too many custom fields in a custom group_id. I was able to reproduce this error twice: created a custom group, added custom fields to it. Once the number of custom fields reaches 93, I can no longer edit new or existing fields. When editing custom fields, I get the error:

DB Constraint Violation - custom_group_id should possibly be marked as mandatory for CustomField,create API. If so, please raise a bug report.

I cannot delete the custom field through civicrm (only phpmyadmin). When trying to edit the custom field, the logo spins forever. Also, when I try to access certain cases, I get an error "case_id is not valid : 1."

I know the issue is related to the custom fields/custom group because if I disable the custom group, I no longer have the case_id issue. Any ideas what is going on?

Answer 1

I do not think it is because you have too many custom fields but it might well be that something is not totally right in your data? Ideally you should compare the values in the civicrm_custom_group and civicrm_custom_field tables with the actual data holding tables (in your example civicrm_value_care_init_69) and check if that is all correct.

The error also suggest that there is a constraint, so you probably use a field type of contact entity reference somewhere? And perhaps that is not entirely correctly configured? It is hard to be sure with only the error message to go by :-)

Answer 2

It appears to be a bug, but temporary workaround fixes the issue (split the fields into two custom field groups).

Bug report can be found here: https://lab.civicrm.org/dev/core/issues/1330