By Schamess on

My site, which is running 4.6.2, crashed yesterday. I get the following error.

Fatal error: Got error 134 from table handler query: SELECT u.*, s.* FROM users u INNER JOIN sessions s ON u.uid = s.uid WHERE s.sid = '78d986b406b999e09157196b4128cd5b' AND u.status < 3 LIMIT 0, 1 in /home/andrew/public_html/includes/database.mysql.inc on line 66

No page on the site will come up - accessing the site just yields this error message.

Any suggestions on how to restore the site? Ways to fix this other than deleting the database and restoring with a backup? (My last backup is about ten days old, so I'd lose some info).

I was adding feeds to the aggregator a day or two previously. There are lots of feeds and the aggregator was running quite slowly. Don't know if that's related? Can't think what else I might have done. The site was running just fine previously.

Thanks very much for help!

(I searched the forums and google but couldn't find anything very specific re this error)

Site is on an Apache server, mysql database.

Comments

kbahey’s picture

kbahey commented

The table has some corruption at the database level.

Use phpmyadmin to do check/repair. Or do it from the comand line if you know how to.

--
Drupal development and customization: 2bits.com
Personal: Baheyeldin.com

--
Drupal performance tuning and optimization, hosting, development, and consulting: 2bits.com, Inc. and Twitter at: @2bits
Personal blog: Ba

Schamess’s picture

Schamess commented

Thanks, I much appreciate the answer. Will see what I can do with phpmyadmin.

Andrew Schamess