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.
---------------------------------------------------------------------
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