running myisamchk against basic table gives this error : stopword doesn't have a correct index definition. you need to recreate it before you can do a repair. table details: create table stopword(word char(32) DEFAULT '' NOT NULL, lang char(2) DEFAULT '' NOT NULL, PRIMARY KEY (word, lang)); This create command look good to me, so what could be the problem? I have already done a drop index, create index, flush tables but it still remains. FS --------------------------------------------------------------------- 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