ERROR 1191 (HY000): Can't find FULLTEXT index matching the column list

[Ched Dar]

Hi,

I'm trying to optimize a query using MATCH/AGAINST, but I'm getting the error "ERROR 1191 (HY000): Can't find FULLTEXT index matching the column list".

I realize the nature of the error message seems self-explanatory, but I don't understand why there appears to be no FULLTEXT index matching the column when, if I do a SHOW INDEX on the table it seems to be present.

The query:
SELECT STOREKEY,PRODUCT, CATEGORY FROM PW_PRODUCTS WHERE PRODUCT LIKE "%furniture%" OR MATCH(DESCRIPTION) AGAINST ("%furniture%" WITH QUERY EXPANSION) LIMIT 0,15;


The SHOW INDEX result:
+-------------+------------+----------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type |
+-------------+------------+----------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+
| PW_PRODUCTS | 0 | SKU | 1 | SKU | A | 509672 | NULL | NULL | | BTREE |
| PW_PRODUCTS | 0 | SKU_2 | 1 | SKU | A | 509672 | NULL | NULL | | BTREE |
| PW_PRODUCTS | 1 | IDX1 | 1 | PRODUCT | A | 84945 | 15 | NULL | | BTREE |
| PW_PRODUCTS | 1 | STOREKEY_INDEX | 1 | STOREKEY | A | 21 | NULL | NULL | | BTREE |
| PW_PRODUCTS | 1 | PRODUCT | 1 | PRODUCT | NULL | 101934 | NULL | NULL | | FULLTEXT |
| PW_PRODUCTS | 1 | PRODUCT | 2 | DESCRIPTION | NULL | 509672 | NULL | NULL | YES | FULLTEXT |
+-------------+------------+----------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+


Does anyone have any ideas/suggestions? Many thanks!

(Apologies for the results looking a mess, but there seems no way to format the text here).