John, > and I am getting this error message > > ERROR 1030: Got error 28 from table handler
# perror 28 Error code 28: No space left on device Free some disk space! > 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. I guess that when you add the t0.test that it needs to use a temporary table for sorting or something like that - but there's not enough space on your disk. Chris --------------------------------------------------------------------- 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
