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')
info@elgg.org
Security issues should be reported to security@elgg.org!
©2014 the Elgg Foundation
Elgg is a registered trademark of Thematic Networks.
Cover image by Raül Utrera is used under Creative Commons license.
Icons by Flaticon and FontAwesome.
- Cash@costelloc

Cash - 0 likes
You must log in to post replies.Elgg uses MyISAM which supports FULLTEXT. Any normal install of Elgg uses that unless someone changes the table type.