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 <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- 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
