SQL Error: 1191 - Cannot find FULLTEXT index matching column list

Question

I am trying to solve this error:

1191 - Cannot find the FULLTEXT index matching the column list

Query:

SELECT t.*, t.username AS threadusername, u.username, MATCH (t.subject) AGAINST ('test123 test') AS relevance FROM 123test_threads t LEFT JOIN 123test_users u ON (u.uid = t.uid) WHERE t.fid='2' AND t.tid!='4' AND t.visible='1' AND t.closed NOT LIKE 'moved|%' AND MATCH (t.subject) AGAINST ('test123 test') >= '2' ORDER BY t.lastpost DESC LIMIT 0, 5 

When I try to create a new thread on my multiforums website.

Answer 1

 ALTER TABLE table ADD FULLTEXT index_name(column1); 

Try adding a full text index.