<br><br><div><span class="gmail_quote">On 11/8/06, <b class="gmail_sendername">Gary Feldman</b> <<a href="mailto:dpal_gaf_doc@marsdome.com">dpal_gaf_doc@marsdome.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Anisa wrote:<br>> Please comment on the rough draft below. I saw a post on this<br>> recently in the forum, and thought it would be a nice candidate for<br>> the Trouble shooting faq.<br>><br>> ===================
<br>><br>> <a href="http://drupal.org/node/85866">http://drupal.org/node/85866</a><br>><br>> This is for errors like this:<br>><br>> |user error: Can't open file: 'accesslog.MYI'. (errno: 145)<br>> query: INSERT INTO accesslog (title, path, url, hostname, uid,
<br>> timestamp) values('story', 'node/add/story', '.../node/add/story',<br>> '<a href="http://000.0.000.000">000.0.000.000</a> <<a href="http://000.0.000.000">http://000.0.000.000</a>>', 1, 1146151588) in<br>
> .../includes/database.mysql.inc on line 66.|<br>><br>> errno: 145 is a MySQL error.<br>><br>I think there needs to be some context around this. How did the user<br>get to this FAQ item? Searching for "errno: 145"? Or searching for
<br>"user error: Can't open file"? The reason is that people are often<br>intimidated by error messages, so some help in just reading this (as<br>in: If you see "(errno: nnn)", where "nnn" is some number, then this is
<br>a MySQL error). But I don't think that sort of help belongs here.</blockquote><div><br>But I feel very relieved when I look in the troubleshooting faq, or indeed, anywhere in the handbook, when there is something with just the right title. :)
<br><br>What I did with the duplicate error faq was to have a short and long explanation. Would that do?<br></div><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
> |MySQL error code 145: Table was marked as crashed and should be repaired|<br>><br>> (source: <a href="http://drupal.org/node/60693">http://drupal.org/node/60693</a>)<br>><br>> In this case, the affected table is |accesslog|.
<br>><br>I think there should be some more information, for people who know<br>nothing about databases. Something like "Databases store information in<br>tables, which are kept in files. Do you see 'accesslog.MYI
' in the<br>message? This file is used for the table named 'accesslog' (without the<br>.MYI). This is the table that has a problem. Fortunately, MySQL has an<br>operation to repair tables. You can invoke it with phpmyadmin as
<br>follows:...<br><br><br>> *BACK UP YOUR TABLE!*<br>><br>How? (Presumably a link to instructions.)<br>><br>> Possible solutions.<br>><br>> 1) Please repair your table.<br>><br>> In phpmyadmin:<br>
> Select your database<br>> check the corrupted table<br>> scroll down and select the option "repair table".<br>><br>> from mysql command line:<br>><br>> |repair table tablename;|<br>><br>
> 2) Empty your table.<br>> Be sure you know what you are doing!<br>><br>I don't think the second choice should be here. Anyone who knows what<br>they're doing won't need the FAQ for this question.</blockquote><div>
<br>;p<br><br>I think anyone who is USING drupal should know what the heck a database table is. <br><br>When is this useful or possible? I get the impression it's only for when certain tables are corrupted.<br><br>Anisa.
<br></div></div><br clear="all"><br>-- <br>*********************************<br><a href="http://www.AnimeCards.Org">www.AnimeCards.Org</a><br><br>16,000 scans and counting!<br>*********************************