Since CiviCRM 5.42, the entity_table field in CiviCRM tables will be derived from CiviCRM option group. This has caused most of the extension to break. So if you have an extension and have code that stores value in entity_table which is not part of option list present in Civi core install the system will throw error. This extension avoids the fatal error by defining the entity table list with all the entities present in the system.
This extension by default supports only few entities mentioned below
- Case
- Activity
- Grant
- Contribution
- Membership
- OptionValue
Incase you need to have support for all the entities set below line in your civicrm.settings.php file
define('MISSINGOPTIONVALUES_INLCUDE_ALL_CIVI_TABLES', TRUE);
- If you have not already done so, setup Extensions Directory
- Go to Administer >> System Settings >> Directories
- Set an appropriate value for CiviCRM Extensions Directory. For example, for Drupal, [civicrm.files]/ext/
- In a different window, ensure the directory exists and is readable by your web server process.
- Click Save.
- If you have not already done so, setup Extensions Resources URL
- Go to Administer >> System Settings >> Resource URLs
- Beside Extension Resource URL, enter an appropriate values such as [civicrm.files]/ext/
- Click Save.
- Install Missing option values extension
- Go to Administer >> Customize Data and Screens >> Manage Extensions.
- Click on Add New tab.
- If Missing option values is not in the list of extensions, manually download it and unzip it into the extensions direction setup above, then return to this page.
- Beside Missing option values, click Download.
- Review the information, then click Download and Install.
This extension has been developed and is being maintained by Pradeep Nayak.