perror 28
No space left on device.
I guess your disk is getting full.
John Wards wrote:
>Hi,
>
>I am getting a weird error message in mysql.
>
>I am doing this query
>
>SELECT t0.sid, t1.stid, t0.clubname, t1.longheadline FROM club t0, story t1
>WHERE t0.sid = t1.siteid AND t1.hold='no' AND t0.test = 0 AND t1.synd = '1'
>AND t0.sport='football' ORDER BY `stid` DESC LIMIT 10;
>
>and I am getting this error message
>
>ERROR 1030: Got error 28 from table handler
>
>I have figured out that it is t0.test that is causeing the problem as when i
>remove it the query works. This query has been working fine for months and
>we haven't done anything to the tables used.
>
>I have tried explain, check and analyse and everything seems normal.
>
>Any clues?
>
>Cheers
>John Wards
>SportNetwork.net
>
>
>
>---------------------------------------------------------------------
>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 <mysql-thread118778@stripped>
>To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
