Error number 1191 Can't find FULLTEXT index matching the column list
Hi, I'm new to full text searches using MySQL so I would like some help.
First I read everything in the documentation about Full Text Search (http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html), then I read a book about MySQL and full search (http://safari.oreilly.com/059652708X). Then I did everything acording to the instructions (at least I think I did). Still it's not working. I created the FULLTEXT index whith MYSQL Administrator (the grafical way) and my index spans over several collumns.
My question is basicly if there are some common errors that can generate this error? I have of course checked the syntax several times so I didn't spell any collumns wrong.
Regards Jonas
Subject
Views
Written By
Posted
Error number 1191 Can't find FULLTEXT index matching the column list
8184
September 30, 2007 08:31AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.