List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:January 31 2001 4:59pm
Subject:Re: Please help!
View as plain text  
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
Thread
Please help!Daren Cotter31 Jan
  • Re: Please help!Gerald L. Clark31 Jan
    • Re: Please help!Paul DuBois31 Jan
RE: Please help!Chris M. Oson31 Jan
RE: Please help!Paul DuBois31 Jan