Database error: Invalid SQL: SELECT id_article,subject,body,newsgroup,name,date,num_readings, MATCH (body,subject) AGAINST('rose') AS relevance FROM `myng_england_rec_gardening` WHERE MATCH(body,subject) AGAINST('rose') ORDER BY relevance DESC LIMIT 20
MySQL Error: 1191 (Can't find FULLTEXT index matching the column list)
Error occured!
Error code:Query failed:SELECT id_article,subject,body,newsgroup,name,date,num_readings, MATCH (body,subject) AGAINST('rose') AS relevance FROM `myng_england_rec_gardening` WHERE MATCH(body,subject) AGAINST('rose') ORDER BY relevance DESC LIMIT 20