After pressing the delete button the following message appeared:

The website encountered an unexpected error. Please try again later.

How can I solve this problem?

when deleting field The system log says:

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table '[name].field_deleted_data_5' doesn't exist: SELECT field_deleted_data_50.entity_type AS entity_type, field_deleted_data_50.entity_id AS entity_id, field_deleted_data_50.revision_id AS revision_id, field_deleted_data_50.bundle AS bundle FROM {field_deleted_data_5} field_deleted_data_50 WHERE (field_deleted_data_50.deleted = :db_condition_placeholder_0) AND (field_deleted_data_50.bundle = :db_condition_placeholder_1) LIMIT 10 OFFSET 0; Array ( [:db_condition_placeholder_0] => 1 [:db_condition_placeholder_1] => patient_info ) in field_sql_storage_field_storage_query() (line 577 of C:\xampp\htdocs[name]\modules\field\modules\field_sql_storage\field_sql_storage.module

  • are you close error message try to open error message to know the error
    – Ahmed
    Apr 1, 2012 at 17:16
  • no just when delete some node it's show up Apr 1, 2012 at 17:21
  • What does the log say? Apr 1, 2012 at 18:42
  • 1
    Have you deleted any tables in the database? Perhaps some with names beginning with field_deleted_data_?
    – Clive
    Apr 1, 2012 at 19:02
  • i already deleted some tables fields, maybe yes i deleted. can i just import this table from fresh drupal 7 engine ? Apr 1, 2012 at 19:09

1 Answer 1


It sounds like your problem is that you have delete a field on your node, which makes Drupal rename the table storing the field data to field_deleted_data_ID. The error you are getting is that one of such tables is missing, and the delete fails since the query to delete the data creates a SQL error.

I know of two ways to solve this.

  • Recreate the table deleted.
  • Delete the field info from field_config and possibly field_config_instance.
  • I'm running into this problem months after the delete happened without knowing the details around that delete event. Any sense what the sql would be to recreate the table? It seems this would work, but what IS a working structure that could make Drupal happy again. Regarding deleting the field info from those two tables...how would you figure out which field?
    – greggles
    Dec 14, 2012 at 17:47
  • 1
    @greggles deleted fields have deleted = 1 in field_config
    – googletorp
    Dec 14, 2012 at 23:15
  • So, interestingly enough I have records in field_config and field_config_instance that both look like partially deleted data. BUT...the field_names in one don't match the field_names in the other. Is that somewhat to be expected? Thanks for your help!
    – greggles
    Feb 20, 2013 at 19:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.