Strange error: Can't open file: 'cache.MYI'.

jibbajabbaboy - July 15, 2004 - 20:42

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

» Login or register to post comments

corrupted table

marky - July 16, 2004 - 00:25

repair it.

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

/marky

Thanks, Marky

jibbajabbaboy - July 16, 2004 - 14:11

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.

TRUNCATE worked for me, but

pkreemer - November 8, 2005 - 03:41

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

Just happened to me.

noid - October 17, 2005 - 21:40

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. :)

i had the same problem

kyanos - May 26, 2006 - 13:55

but the repair form phpmyadmin fix it
thks

Had same problem. 'Repair'

Zach Harkey - May 1, 2008 - 14:44

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