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
