Yup I used repair table as well. Also I have resarted mysql and that made no difference
John ----- Original Message ----- From: "Karthik" <[EMAIL PROTECTED]> To: "John Wards" <[EMAIL PROTECTED]> Sent: Thursday, September 05, 2002 11:11 AM Subject: Re: Weird error message > Hi, > > Try using this command in mysql > > check table <table name> > > if any of them return a error message run > > repair table <table name> > > Karthik. > > ----- Original Message ----- > From: "John Wards" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, September 05, 2002 3:35 PM > Subject: Weird error message > > > > 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
