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.<br><br>===================<br><span style="text-decoration: underline;">
<br></span><p><a href="http://drupal.org/node/85866" title="http://drupal.org/node/85866">http://drupal.org/node/85866</a></p>
<p>This is for errors like this:</p>
<div class="codeblock"><code>user error: Can't open file: 'accesslog.MYI'. (errno: 145)<br>query:
INSERT INTO accesslog (title, path, url, hostname, uid, timestamp)
values('story', 'node/add/story', '.../node/add/story',
'<a href="http://000.0.000.000">000.0.000.000</a>', 1, 1146151588) in .../includes/database.mysql.inc on
line 66.</code></div>
<p>errno: 145 is a MySQL error.</p>
<p><code>MySQL error code 145: Table was marked as crashed and should be repaired</code></p>
<p>(source: <a href="http://drupal.org/node/60693" title="http://drupal.org/node/60693">http://drupal.org/node/60693</a>)</p>
<p>In this case, the affected table is <code>accesslog</code>.</p>
<p><b>BACK UP YOUR TABLE!</b></p>
<p>Possible solutions.</p>
<p>1) Please repair your table.</p>
<p>In phpmyadmin:<br>
Select your database<br>
check the corrupted table<br>
scroll down and select the option "repair table".</p>
<p>from mysql command line:</p>
<p><code>repair table tablename;</code></p>
<p>2) Empty your table.<br>
Be sure you know what you are doing!</p><br><p><br></p><p>===================</p>
<p>Anisa.</p><br clear="all"><br>-- <br>*********************************<br><a href="http://www.AnimeCards.Org">www.AnimeCards.Org</a><br><br>16,000 scans and counting!<br>*********************************