SQL Error: 1191 - Can't find FULLTEXT index matching the column list
mybb, mysql, php, sql
Solution
ALTER TABLE table ADD FULLTEXT index_name(column1);
Try this to add a full text index.
Problem
I'm trying to solve this error : 1191 - Can't find 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 ``` whene i try to create a new thread in my multiforums website.