<br><br><div><span class="gmail_quote">On 11/10/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>> ...<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
<br>> this is<br>> a MySQL error). But I don't think that sort of help belongs here.<br>><br>><br>> But I feel very relieved when I look in the troubleshooting faq, or<br>> indeed, anywhere in the handbook, when there is something with just
<br>> the right title. :)<br>So do I. The problem is that the right title for you may not be the<br>same as the right title for me.<br>> What I did with the duplicate error faq was to have a short and long<br>> explanation. Would that do?
<br>I think I'm not explaining myself well, because I don't see how that<br>would address the point I'm raising.<br><br>One difference between this and the duplicate entry FAQ is that there<br>are a variety of errors that can occur with regard to being unable to
<br>open a file. Suppose there's more than one FAQ on this subject. How<br>will the user find the right one?<br><br>Or suppose the user starts looking in the FAQ under "user error" (since<br>that's the first part of the message), can't find it, and gives up?
</blockquote><div><br>I would be happy to add user error, it's in my original original draft, but it made the subject of this message too long so I cut it out (long subject titles are a pet peeve :).<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;">
The current FAQ is thoroughly unorganized. A handful of them have<br>actual fragments from error messages in their titles. By putting this<br>into context, I was thinking more along the lines of having a section of<br>the FAQ dealing just with error messages, with perhaps the first entry
<br>being how to figure out whether the message came from MySql, PHP, or<br>Drupal.</blockquote><div><br>So it would! But I don't know how to write that. :( I basically just saw this problem in the forum and thought it'd be an easy page to add.
<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;">> ...<br>> I think there should be some more information, for people who know
<br>> nothing about databases. Something like "Databases store<br>> 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'
<br>> (without the<br>> .MYI). This is the table that has a problem. Fortunately, MySQL<br>> has an<br>> operation to repair tables. You can invoke it with phpmyadmin as<br>> follows:...
<br>><br>> ...<br>><br>><br>> I think anyone who is USING drupal should know what the heck a<br>> database table is.<br>I suppose, though from some of the questions that get asked in the<br>forums, I'm not so sure.
</blockquote><div><br>:) Quite! So no assuming.<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;"> But at a minimum, I think it should say that
<br>the filename 'accesslog.MYI' corresponds to the MySql table named<br>accesslog.</blockquote><div><br>I think if you are going to say it is a filename, you have to also say that it's not a file that the person would actually have.
<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;">> When is this useful or possible? I get the impression it's only for<br>> when certain tables are corrupted.
<br>><br>I would think that's it's only for corruption at the MySql level (which<br>I've never had happen), as opposed to being perfectly good as far as<br>MySql is concerned, but having bad data as far as Drupal is concerned.
</blockquote><br>So repairing tables will fix this error all the time?<br><br>Anisa.<br></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>*********************************