Fatal error when running site audit reports and on config synchronization administration page.
Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'coe_widget__field_coe_widget_icon.field_coe_widget_icon_value' in 'where clause': SELECT COUNT(*) AS expression FROM (SELECT 1 AS expression FROM {coe_widget} base_table INNER JOIN {coe_widget_field_data} coe_widget_field_data ON coe_widget_field_data.id = base_table.id INNER JOIN {coe_widget__field_coe_widget_icon} coe_widget__field_coe_widget_icon ON coe_widget__field_coe_widget_icon.entity_id = base_table.id WHERE (coe_widget_field_data.type = :db_condition_placeholder_0) AND (coe_widget__field_coe_widget_icon.field_coe_widget_icon_value IS NOT NULL) GROUP BY base_table.vid, base_table.id) subquery; Array ( [:db_condition_placeholder_0] => coe_widget_point_of_pride ) in Drupal\site_audit\Plugin\SiteAuditCheck\ContentFieldInstances->calculateScore() (line 96 of /var/www/web/modules/contrib/site_audit/src/Plugin/SiteAuditCheck/ContentFieldInstances.php).
Install site_audit module on a site using fontawesome_icon module that is also using fontawesome_icon fields.
Add a switch case for '$field . "_icon_name"' for fontawesome entity field type.
Needs review
Code
Patch originally created by jasonblanda →
Update status.
This patch is working for us, So would be great to consider it.