[SOLVED][Drupal Errors] Drupal Sessions Table Crashed
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.
Reference: http://drupal.org/node/833762
