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
