> > > > > > > On Dec 10, Al Caponi wrote: > > > > > > > > > > But I keep getting the following error when I try to delete > > some row: > > > > > > > > > > java.sql.SQLException: General error: Incorrect key file > for table: > > > > > 'mytable'. Try to repair it > > > > > > > > > > So far, I've figured out that the error is due to mixing > > > > > VARCHAR and TEXT > > > > > type in the FULLTEXT index but I dunno why is there a problem. > > > > > Haven't found much in MySQL doc about that yet. > > > > > > > > No, mixing VARCHAR and TEXT is perfectly legal > > > > (even fulltext search example in the manual does it). > > > > > > Yup, seen that... which makes me even more frustrated :( > > > > > > > > > > > What version of MySQL are you using ? > > > > > > I'm using MySQL 3.23.39 on Win98SE with JSDK 1.3 > > > > This one is old. (June 2001) > > The bug you've hit was fixed in Jule. > > > > Is it the 'UPDATE|DELETE) ...WHERE MATCH bugfix' in MySQL 3.23.45? > I'm not performing a delete using a WHERE MATCH but on a BIGINT > column type. > Anyway, I'll upgrade my MySQL version and check it out.
Problem solved after upgrading 3.23.46a for Win98. Haven't used UPDATE|DELETE) ...WHERE MATCH yet... Cheers! _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com --------------------------------------------------------------------- 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