0

I am using shared host and after some problems they restarted the server and my Drupal website shows the following error:

PDOException: SQLSTATE[42000]: Syntax error or access violation: 1286 Unknown table engine 'InnoDB': SELECT 

This is the full log

Error message

PDOException: SQLSTATE[42000]: Syntax error or access violation: 1286 Unknown table engine 'InnoDB': SELECT field_data_media_gallery_expose_block0.entity_type AS entity_type, field_data_media_gallery_expose_block0.entity_id AS entity_id, field_data_media_gallery_expose_block0.revision_id AS revision_id, field_data_media_gallery_expose_block0.bundle AS bundle FROM {field_data_media_gallery_expose_block} field_data_media_gallery_expose_block0 WHERE (field_data_media_gallery_expose_block0.media_gallery_expose_block_value = :db_condition_placeholder_0) AND (field_data_media_gallery_expose_block0.deleted = :db_condition_placeholder_1) AND (field_data_media_gallery_expose_block0.entity_type = :db_condition_placeholder_2) AND (field_data_media_gallery_expose_block0.bundle = :db_condition_placeholder_3) ; Array ( [:db_condition_placeholder_0] => 1 [:db_condition_placeholder_1] => 0 [:db_condition_placeholder_2] => node [:db_condition_placeholder_3] => media_gallery ) in field_sql_storage_field_storage_query() (line 577 of /home/fossisor/public_html/techiestuffs/modules/field/modules/field_sql_storage/field_sql_storage.module).

What is wrong with the database ?

closed as off-topic by kiamlaluno Oct 2 '13 at 12:48

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Questions on programming, PHP, SQL, etc. that do not relate directly to Drupal are off-topic here, but can be asked on Stack Overflow." – kiamlaluno
If this question can be reworded to fit the rules in the help center, please edit the question.

1

Sounds like your hosting provider does not support InnoDB. There are a few others like you, here is a discussion thread with some ideas on how to fix it http://drupal.org/node/1089724

  • but My other drupal sites in same host works great – Vivek R Feb 27 '12 at 13:29
  • 1
    Have you checked your other sites since the server restart? – Chapabu Feb 27 '12 at 16:06

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