Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
By ETENTION on
Hi
I'm getting following errors while removing fields from different entitites.
What seems weird here is the "naming convention" like "field_data_field_license0".
What is that suffix 0? I don't think that Drupal uses integers in column names.
Status message The field License name has been deleted from the Field collection field_collection_licenses content type.
Error messagePDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'field_data_field_license0.field_license_value' in 'where clause': SELECT field_data_field_license0.entity_type AS entity_type, field_data_field_license0.entity_id AS entity_id, field_data_field_license0.revision_id AS revision_id, field_data_field_license0.bundle AS bundle FROM {field_data_field_license} field_data_field_license0 WHERE (field_data_field_license0.field_license_value = :db_condition_placeholder_0) AND (field_data_field_license0.deleted = :db_condition_placeholder_1) ; Array ( [:db_condition_placeholder_0] => 3 [:db_condition_placeholder_1] => 0 ) in field_sql_storage_field_storage_query() (line 652 of \modules\field\modules\field_sql_storage\field_sql_storage.module
I'm using Drupal 7.54 and above error came when I removed a taxonomy field from a field collection entity.