Saturday, December 14, 2013

Drupal Database Problem - Inno DB Error

Instead of your Drupal Site you are faced with this Error Message.

PDOException: SQLSTATE[42000]: Syntax error or access violation: 1286 Unknown table engine 'InnoDB': SELECT expire, value FROM {semaphore} WHERE name = :name; Array ( [:name] => variable_init ) in lock_may_be_available() (line 167 of /var/www/includes/lock.inc).

This can happen after restarting sql and blocking of the InnoDB.

One solution is to remove ib_logfiles from /var/lib/mysql and restart mysql.