1

I'm not sure if the issue is what Demerit is suggesting (join limits), or one of database length limits. Your CiviCRM log should give a more detailed error. If you find the error, you can edit your question to include it for better help. I suspect you're hitting a database length limit. The solution depends on your version of MySQL/MariaDB, but I'm ...


1

See https://lab.civicrm.org/dev/core/-/issues/1191 and you can also try https://github.com/civicrm/civicrm-core/pull/18968 to see if it solves it for you.


1

You could create a custom field with the same name that you want for the option_group, then the option_group would have your friendly name and you can select this for your existing and new fields. You don't do anything else with the special custom field and you could hide it in a suitably named custom group. Better than editing the database I think.


1

You can use the same set of options for two different custom fields, all you need to do is when creating custom field click on 'Reuse an existing set', select the option from the drop down list and save.


1

Opening the editing link in a new tab or a new window works. Thanks to Pradeep Nayak for the suggestion and to Joe Bedford for pursuing this.


1

Could you clear CiviCRM cache and try again? Or try to open the options in new tab or window


Only top voted, non community-wiki answers of a minimum length are eligible