I'm rebuilding (after Drupalgeddon) and I have a table that's gone missing... somehow.

It's being used to build Views displays for the homepage and so the homepage isn't loading at all. Which is obviously undesirable...


PDOException: SQLSTATE[42S02]: Base table or view not found: 
1146 Table 'drupal.field_data_field_brief_summary' doesn't 
SELECT t.* FROM {field_data_field_brief_summary} t 
(entity_type = :db_condition_placeholder_0) 
AND (entity_id IN (:db_condition_placeholder_1, 
:db_condition_placeholder_2, :db_condition_placeholder_3)) 
AND (language IN (:db_condition_placeholder_4)) 
AND (deleted = :db_condition_placeholder_5) 
ORDER BY delta ASC; Array ( 
[:db_condition_placeholder_0] => node 
[:db_condition_placeholder_1] => 1026 
[:db_condition_placeholder_2] => 1051 
[:db_condition_placeholder_3] => 1095 
[:db_condition_placeholder_4] => und 
[:db_condition_placeholder_5] => 0 ) 
in field_sql_storage_field_storage_load() 
(line 392 of C:\projects\drupal\modules\field

I used the Drush field listing function as described here Is there a listing of Drupal fields? or more specifically, the drush field-info fields command in the comment below the chosen answer. Which displays, amongst many others:

field_brief_summary    text_long

So I think it's there. But the tables field_data_field_brief_summary and field_revision_field_brief_summary are clearly not in the database when I check.

What does on do in this situation? I need field_data_field_brief_summary (and version) back, and I have a copy of it in the version I'm using to rebuild from, but it should be there and I'm wary of trusting that I can just use a MySQL statement to CREATE and INSERT INTO when it's something implicit in the Drupal CMS.

  • If your table is missing, do you expect there can be any other solution than to restore it from backup?
    – Mołot
    Nov 14 '14 at 10:14
  • Yes, after all I didn't delete it - so my assumption is that a mysterious process removed it for me. I tried registry rebuild too, but that's not brought it back. I should say I am currently trying to do a MySQL CREATE and INSERT INTO
    – ja_him
    Nov 14 '14 at 10:20
  • But whatever deleted it, MySQL does not support any kind of undelete. If it's not there, it is not there, simple as that. Either you have backups, or you have a problem.
    – Mołot
    Nov 14 '14 at 10:21
  • 1
    Restoring single table from backups will interfere less than using your site with said table missing... usually. It is difficult and broad topic. If you can, take snapshots of your site during the process.
    – Mołot
    Nov 14 '14 at 10:26
  • 1
    Yes and I suspected it would be, Molot and thanks - I will do. Why can I not do the operations direct in MySQL, program?
    – ja_him
    Nov 14 '14 at 10:26

Your Answer

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

Browse other questions tagged or ask your own question.