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
