Thanks for the tip about the 14 columns, Sergei and Dan. I reduced the number of columns by two and the index seemed to build just fine. I would like to make a suggestion though. I originally tried to create the fulltext index with more than 16 columns and received an error saying that I could have at most 16 columns in a fulltext index. It would be great if the error message could be changed to say 14 instead of 16. If that can't be done, a note in the manual discussing the limitation would be helpful. Just my 2 cents!
Thanks, Duncan > From: Sergei Golubchik [mailto:[EMAIL PROTECTED]] > > Hi! > > > > > I'm running Ver 8.39 Distrib 4.0.9-gamma, for intel-linux on > > > > i686. I'm > > > > trying to create a fulltext index on an existing myisam table > > > > and running up > > > > against an error. From what I can tell, I'm using the alter > > > > table command > > > > correctly, but I keep getting errno 140. Can anyone point > > > > out my error? > > > > > > > > mysql> alter table materials add fulltext title > > > > (title,variant_title,ss_title,term_1,term_2,term_3,term_4, > > > > term_5,abstract,notes,personal_name_1,personal_name_2, > > > > personal_name_3,personal_name_4, > > > > personal_name_5,personal_name_6); > > > > > > > > ERROR 1005: Can't create table './lincs/#sql-6d12_7.frm' (errno: 140) > > Too many columns. > No more than 14 is allowed in FULLTEXT index in MySQL before 4.1, > because MySQL adds two columns internally to each FULLTEXT index. > > In 4.1 it was fixed, but the way it was fixed cannot be backported to > 4.0 :( > > Regards, > Sergei > > -- > MySQL Development Team > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ > /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany > <___/ --------------------------------------------------------------------- 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