SQL Error: 1191 - Can't find FULLTEXT index matching the column list

php mysql sql mybb
user2649117 picture user2649117 · Aug 3, 2013 · Viewed 23.9k times · Source

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.

Answer

Mihai picture Mihai · Aug 3, 2013 
ALTER TABLE table ADD FULLTEXT index_name(column1);

Try this to add a full text index.

Related questions

How can I prevent SQL injection in PHP?

If user input is inserted without modification into an SQL query, then the application becomes vulnerable to SQL injection, like in the following example: $unsafe_variable = $_POST['user_input']; mysql_query("INSERT INTO `table` (`column`) VALUES ('$unsafe_variable')"); That's …

Read More
MySQL query String contains

I've been trying to figure out how I can make a query with MySQL that checks if the value (string $haystack ) in a certain column contains certain data (string $needle), like this: mysql_query(" SELECT * FROM `table` WHERE `column`.contains(…

Read More
How to 'insert if not exists' in MySQL?

I started by googling, and found this article which talks about mutex tables. I have a table with ~14 million records. If I want to add more data in the same format, is there a way to ensure the record I …

Read More