Date: 12/16/05 (MySQL Communtiy)    Keywords: mysql, sql

This is bound to be something simple I've overlooked (and besides, I'm new at this)...

First, the table. Created from a pre-existing spreadsheet for a community library so please forgive the non-optimum design...


mysql> create table books (
-> book_id mediumint unsigned not null auto_increment,
-> author1 varchar(255) not null,
-> author2 varchar(255) not null,
-> title varchar(255) not null,
-> subtitle varchar(255) not null,
-> subject1 varchar(255) not null,
-> subject2 varchar(255) not null,
-> subject3 varchar(255) not null,
-> subject4 varchar(255) not null,
-> publisher varchar(255) not null,
-> year smallint unsigned not null,
-> loc varchar(255) not null,
-> edition varchar(255) not null,
-> isbn varchar(255) not null,
-> location varchar(255) not null,
-> notes varchar(255) not null,
-> PRIMARY KEY (book_id)
-> );
Query OK, 0 rows affected (0.01 sec)


Then a data import (load data local infile "/home/lev/Desktop/test.csv" into table books;) - no problem.

Then adding a fairly large fulltext index i.e.,

mysql> alter table books add fulltext index (author1, author2, title, subtitle, subject1, subject2, subject3, subject4, publisher, location);

But a search, any search e.g.,

mysql> select * from books where match (author1,author2) against ('ali');
ERROR 1191 (HY000): Can't find FULLTEXT index matching the column list

help?

Source: http://community.livejournal.com/mysql/77082.html