Hello, I've tried to use CREATE INDEX to create a fulltext index on an existing table and received the message: "Can't create table './old/#sql-d55_ae7.frm' (errno: 140)". I tried dropping the table and recreating it with the fulltext index in the new table description and got this message: "Can't create table './old/oldfmp.frm' (errno: 140)", however it would create the table without the fulltext index. I can't find an explanation of (errno: 40). I am guessing the problem is with either a temp directory or some file permission on our UNIX system? What do you think?
Thank you, Eric Dean [EMAIL PROTECTED] Chief Curator, Office of Visual Materials School of Art and Art History, University of Iowa --------------------------------------------------------------------- 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