[documentation] Draft (please comment): Can't open file: 'TABLE.MYI' (errno: 145)

[Anisa]

Please comment on the rough draft below.  I saw a post on this recently in
the forum, and thought it would be a nice candidate for the Trouble shooting
faq.

===================

http://drupal.org/node/85866

This is for errors like this:
user error: Can't open file: 'accesslog.MYI'. (errno: 145)
query: INSERT INTO accesslog (title, path, url, hostname, uid, timestamp)
values('story', 'node/add/story', '.../node/add/story', '000.0.000.000', 1,
1146151588) in .../includes/database.mysql.inc on line 66.

errno: 145 is a MySQL error.

MySQL error code 145: Table was marked as crashed and should be repaired

(source: http://drupal.org/node/60693)

In this case, the affected table is accesslog.

*BACK UP YOUR TABLE!*

Possible solutions.

1) Please repair your table.

In phpmyadmin:
Select your database
check the corrupted table
scroll down and select the option "repair table".

from mysql command line:

repair table tablename;

2) Empty your table.
Be sure you know what you are doing!


===================

Anisa.


-- 
*********************************
www.AnimeCards.Org

16,000 scans and counting!
*********************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/documentation/attachments/20061106/12df762a/attachment.htm