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, paul@stripped