Hi all,
Is there any limitation in creating full-text indexes on MyISAM tables?
Currently, I have a table like this:
CREATE TABLE IF NOT EXISTS mytable (
UId BIGINT(20) NOT NULL AUTO_INCREMENT,
Title VARCHAR(255) NOT NULL,
Field1 TEXT,
Field2 TEXT,
Field3 VARCHAR(255),
Field4 TEXT,
Field5 TEXT,
Field6 VARCHAR(50),
Field7 VARCHAR(50),
Field8 VARCHAR(50),
Field9 TIMESTAMP NOT NULL,
Field10 TIMESTAMP NOT NULL,
PRIMARY KEY(UId),
INDEX article_idx1(Field6),
INDEX article_idx2(Field7),
INDEX article_idx3(Field8),
FULLTEXT article_idx4(Field1, Field2, Field3, Field4, Field5, Field6,
Field7, Field8)
) TYPE=MyISAM;
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.
Is the problem more on the Java side?
Could anyone suggest any solution or direct me to some resources? (Other
than converting all my fields to TEXT :))
Many THANKS!!!
Al
_________________________________________________________
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
