Error: The used table type doesn't support FULLTEXT indexes

I'm getting this error when I search on my site. I saw there was a similar post but the answer went completely over my head. Have I made a mistake and is there a simple fix?

 

The used table type doesn't support FULLTEXT indexes

QUERY: SELECT count(DISTINCT a.id) as total FROM elgg_annotations a
JOIN elgg_metastrings msn ON a.name_id = msn.id
JOIN elgg_metastrings msv ON a.value_id = msv.id
JOIN elgg_entities e ON a.entity_guid = e.guid
WHERE msn.string IN ('generic_comment', 'group_topic_post')
AND ((MATCH (msv.string) AGAINST ('+amyl' IN BOOLEAN MODE)))
AND ( (1 = 1) and e.enabled='yes')
AND ( (1 = 1) and a.enabled='yes')