Boolean Fulltext Searching

[wxdqz]

i'm using the code at:
<!-- m --><a class="postlink" href="http://www.evolt.org/article/Boolean_Fulltext_Searching_with_PHP_and_MySQL/18/15665/">http://www.evolt.org/article/Boolean_Fu ... /18/15665/</a><!-- m -->

for searching a small database. i used this code because i figured it'd be worth reusing on other projects.

anyone know why i'm getting the error: "Can't find FULLTEXT index matching the column list."

below is the table dump data.. i've seen in documentation something like this: FULLTEXT KEY author (author,content).

is this my problem? not having a couple FULLTEXT keys? i don't know much about this so maybe i should add: FULLTEXT KEY product (product, description)?

any help would be appreciated. many thanks!



CREATE TABLE inventory (
product tinytext NOT NULL,
quantity int(6) NOT NULL default '0',
id int(6) NOT NULL auto_increment,
description text,
price float(10,2) NOT NULL default '0.00',
category tinytext NOT NULL,
bin_data longblob,
filename varchar(50) default NULL,
filesize varchar(50) default NULL,
filetype varchar(50) default NULL,
PRIMARY KEY (id),
KEY id (id),
KEY price (price),
FULLTEXT KEY product (product),
FULLTEXT KEY description (description)
) TYPE=MyISAM;