Home » forums » Site Discussion

Site error relating to "cache.myi"

Not sure if your aware of it or if it happens to anyone else, but I'm getting the following error:

user error: Can't open file: 'cache.MYI'. (errno: 145)
query: SELECT data, created, headers FROM cache WHERE cid = 'menu:1642:en' in /home/vhost/ltu/www/includes/database.mysql.inc on line 66.

There's another error related to the cache but it's a huge single line error. It doesn't stop functionality of the site tho (that i can tell).

By Christopher Campbell at 2006-06-25 14:02 | Site Discussion | previous forum topic | next forum topic | other blogs | 8015 reads

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Happens to me too, also on

Happens to me too, also on the queries:

user error: Can't open file: 'cache.MYI'. (errno: 145)
query: UPDATE cache SET data = 'a:3:{s:10:\"path index\";a:136:{s:7:\"archive\";i:-1;s:11:\"admin/block\";i:-2;s:16:
\"admin/block/list\";i:-3;s:21:\"admin/block/configure\";i:-4;s:18:
\"admin/block/delete\";i:-5;s:15:\"admin/block/add\";i:-6;s:13:
\"admin/comment\";i:-7;s:18:\"admin/comment/edit\";i:-8;s:20:
\"admin/comment/delete\";i:-9;s:18:\"admin/comment/list\";i:-10;s:23:
\"admin/comment/configure\";i:-11;s:22:\"admin/comment/list/new
\";i:-12;s:27:\"admin/comment/list/approval\";i:-13;s:32:
\"admin/comment/configure/settings\";i:-14;s:30:
\"admin/comment/configure/matrix\";i:-15;s:34:
\"admin/comment/configure/thresholds\";i:-16;s:29:
\"admin/comment/configure/roles\";i:-17;s:29:
\"admin/comment/configure/votes\";i:-18;s:12:
\"comment/edit\";i:-19;s:7:\&q in /home/vhost/ltu/www/includes/database.mysql.inc on line 66.

user error: Can't open file: 'cache.MYI'. (errno: 145)
query: UPDATE cache SET data = '<p >Not sure if your aware of it or if it happens to anyone else, but I\'m getting the following error:</p>
<p >user error: Can\'t open file: \'cache.MYI\'. (errno: 145)<br >
query: SELECT data, created, headers FROM cache WHERE cid = \'menu:1642:en\' in /home/vhost/ltu/www/includes/database.mysql.inc on line 66.</p>
<p >There\'s another error related to the cache but it\'s a huge single line error. It doesn\'t stop functionality of the site tho (that i can tell).</p>', created = 1151244360, expire = 1151330760, headers = '' WHERE cid = 'filter:1:6cfa9c12ac06e8bdde830399b316d9a9' in /home/vhost/ltu/www/includes/database.mysql.inc on line 66.

By Jonathan Tang at Sun, 2006-06-25 14:10 | login or register to post comments

We know. Thanks.

We know. Thanks.

By Ehud Lamm at Sun, 2006-06-25 15:01 | login or register to post comments

Fixed, hopefully

I've cleared the cache and access log tables, which seems to have done the trick. It seems that the server rebooted uncleanly, "by itself". I don't yet know what caused that.

By Anton van Straaten at Sun, 2006-06-25 16:20 | login or register to post comments