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 '12 at 17:16
  • no just when delete some node it's show up – Abdulrahman Apr 1 '12 at 17:21
  • What does the log say? – whitefleaCH Apr 1 '12 at 18:42
  • 1
    Have you deleted any tables in the database? Perhaps some with names beginning with field_deleted_data_? – Clive Apr 1 '12 at 19:02
  • i already deleted some tables fields, maybe yes i deleted. can i just import this table from fresh drupal 7 engine ? – Abdulrahman Apr 1 '12 at 19:09

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 '12 at 17:47
  • 1
    @greggles deleted fields have deleted = 1 in field_config – googletorp Dec 14 '12 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 '13 at 19:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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