[SOLVED][Drupal Errors] Drupal Sessions Table Crashed

By | 11th Dec 2012 | 1 min read

Many Drupal users have encountered a Crashed Drupal Sessions table with the error mesage similar to "Table './dbname/sessions' is marked as crashed and should be repaired query: sess_write UPDATE sessions SET uid = 0, cache = 0, hostname = '67.195.112.119', session = 'localizer_contentlanguages|s:20:\"a:1:{s:3:\"eng\";i:1;}\";', timestamp = 1277138140 WHERE sid = '2cdf7dd30bd3ce06f5b9576d7da5a232' in /home/domain/public_html/includes/database.mysql.inc on line 174" If you are facing this error message in your Drupal site then read on to know how to fix it.

Although a crashed Drupal table is a rare occurrence it can be a nuisance when it does happen. Follow the steps below to fix it.

  • Go to phpMyAdmin of you site
  • Select the Sessions table
  • Next select the Repair table
  • If that does not work then select the Sessions table again
  • Next choose the "Empty" table option
  • If selected, this will truncate the table and cause all data in the sessions table to be be lost
  • The only problem is that all users have to login again.

Hope that helps.

The easiest way to solve a Drupal issue is to hand it to the Drupal experts. We can provide a wide range of Drupal services to help you maintain and manage your Drupal websites. Get in touch with us to know more.