At the risk of getting flamed for something that may or may not be in the
manual,
at the beginning of Paul's email
% perror 127
127 = Record-file is crashed
When I did a man perror from Solaris 2.6, it says that perror returns the
last system
error. I guess what's confusing me is that an error was generated from
mySQL running
as a process and after it stopped (because of the error), you could find out
from the
shell what the problem was. Is this assumption correct?
-----Original Message-----
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 31, 2001 9:00 AM
To: Gerald L. Clark; Daren Cotter
Cc: [EMAIL PROTECTED]
Subject: Re: Please help!
At 10:25 AM -0600 1/31/01, Gerald L. Clark wrote:
>Daren Cotter wrote:
>>
>> Someone please help me. This query has always worked until now, now all
of a
>> sudden I get a weird error:
>>
>> SELECT DISTINCT(signup_date), COUNT(*) AS count,
>> CONCAT(SUBSTRING(MONTHNAME(signup_date),1,3), ' ',
DAYOFMONTH(signup_date),
>> ', ', YEAR(signup_date)) AS signup_date_display FROM members GROUP BY
>> signup_date ORDER BY signup_date DESC;
>>
>> ERROR 1030: Got error 127 from table handler
>>
>> Does anyone know what could be wrong?
>>
>Count is a reserved word.
I doubt if that's the problem, I use COUNT(*) AS count all the time.
% perror 127
127 = Record-file is crashed
It might be that myisamchk needs to be run on the table.
--
Paul DuBois, [EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php