By jibbajabba on

Getting the strange error below on my host. Does this mean anything to anyone?

Fatal error: Can't open file: 'cache.MYI'. (errno: 144) query: SELECT data, created, headers FROM cache WHERE cid = '/' in /home/.yar/asilomar/iaslash.org/includes/database.mysql.inc on line 97

Comments

marky’s picture

marky commented

repair it.

phpMyAdmin can do this too if you have it available. ;)

/marky

jibbajabba’s picture

jibbajabba commented

Thanks, Marky. Repairing the table via phpMyAdmin didn't fix, however. Strange. Luckily it was just the cache table. I was able to drop and re-create the table, which worked out nicely.

pkreemer’s picture

pkreemer commented

TRUNCATE worked for me, but REPAIR didn't do anything. I did run repair after the truncate though.

noid’s picture

noid commented

Just happened to me. Was able to repair the cache table using phpmyadmin -- I can access the site again. Does anyone have any idea what causes this error? Thanks. :)

nsyll’s picture

nsyll commented

but the repair form phpmyadmin fix it
thks

zach harkey’s picture

zach harkey commented

Had same problem. 'Repair' seemed to work, then the problem returned so truncated the table and that seemed to do the trick.

-zach
--
harkey design

: z

joshmiller’s picture

joshmiller
he/him
Primary language English
Location Indianapolis, Indiana, USA
commented

This just happened to me while transitioning our Drupal database on Media Temple from their standard database to their MySQL GridContainer. Logging into PhpMyAdmin showed the table as "in use." I wonder if the table was so big it didn't get "copied" over correctly? Anyway, selecting the table and using PhpMyAdmin to tell MySQL to repair it fixed the problem. I'm not sure if you can truncate a table that is "in use," but I bet that would have worked as well.

Josh

nrixham’s picture

nrixham commented

is older than my son, and he's 4