DatabaseException

Can't find FULLTEXT index matching the column list

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 ('+jazz' IN BOOLEAN MODE)))
AND ( (e.access_id IN (2)
OR (e.owner_guid = -1)
OR (
e.access_id = 0
AND e.owner_guid = -1
)
) and e.enabled='yes')
AND ( (a.access_id IN (2)
OR (a.owner_guid = -1)
OR (
a.access_id = 0
AND a.owner_guid = -1
)
) and a.enabled='yes')


DatabaseException Object
(
[message:protected] => Can't find FULLTEXT index matching the column list

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 ('+jazz' IN BOOLEAN MODE)))
AND ( (e.access_id IN (2)
OR (e.owner_guid = -1)
OR (
e.access_id = 0
AND e.owner_guid = -1
)
) and e.enabled='yes')
AND ( (a.access_id IN (2)
OR (a.owner_guid = -1)
OR (
a.access_id = 0
AND a.owner_guid = -1
)
) and a.enabled='yes')

[string:Exception:private] => exception 'DatabaseException' with message 'Can't find FULLTEXT index matching the column list

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 ('+jazz' IN BOOLEAN MODE)))
AND ( (e.access_id IN (2)
OR (e.owner_guid = -1)
OR (
e.access_id = 0
AND e.owner_guid = -1
)
) and e.enabled='yes')
AND ( (a.access_id IN (2)
OR (a.owner_guid = -1)
OR (
a.access_id = 0
AND a.owner_guid = -1
)
) and a.enabled='yes')

' in /home/dizabil1/public_html/engine/lib/database.php:194
Stack trace:
#0 /home/dizabil1/public_html/engine/lib/database.php(280): execute_query('SELECT count(DI...', Resource id #56)
#1 /home/dizabil1/public_html/mod/search/search_hooks.php(364): get_data('SELECT count(DI...')
#2 /home/dizabil1/public_html/engine/lib/elgglib.php(903): search_comments_hook('search', 'comments', Array, Array)
#3 /home/dizabil1/public_html/mod/search/index.php(239): trigger_plugin_hook('search', 'comments', Array, Array)
#4 /home/dizabil1/public_html/mod/search/start.php(72): include_once('/home/dizabil1/...')
#5 /home/dizabil1/public_html/engine/lib/pagehandler.php(33): search_page_handler(Array, 'search')
#6 /home/dizabil1/public_html/engine/handlers/pagehandler.php(20): page_handler('search', '')
#7 {main}
[code:protected] => 0
[file:protected] => /home/dizabil1/public_html/engine/lib/database.php
[line:protected] => 194
[trace:Exception:private] => Array
(
[0] => Array
(
[file] => /home/dizabil1/public_html/engine/lib/database.php
[line] => 280
[function] => execute_query
[args] => Array
(
[0] => 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 ('+jazz' IN BOOLEAN MODE)))
AND ( (e.access_id IN (2)
OR (e.owner_guid = -1)
OR (
e.access_id = 0
AND e.owner_guid = -1
)
) and e.enabled='yes')
AND ( (a.access_id IN (2)
OR (a.owner_guid = -1)
OR (
a.access_id = 0
AND a.owner_guid = -1
)
) and a.enabled='yes')

[1] => Resource id #56
)

)

[1] => Array
(
[file] => /home/dizabil1/public_html/mod/search/search_hooks.php
[line] => 364
[function] => get_data
[args] => Array
(
[0] => 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 ('+jazz' IN BOOLEAN MODE)))
AND ( (e.access_id IN (2)
OR (e.owner_guid = -1)
OR (
e.access_id = 0
AND e.owner_guid = -1
)
) and e.enabled='yes')
AND ( (a.access_id IN (2)
OR (a.owner_guid = -1)
OR (
a.access_id = 0
AND a.owner_guid = -1
)
) and a.enabled='yes')

)

)

[2] => Array
(
[file] => /home/dizabil1/public_html/engine/lib/elgglib.php
[line] => 903
[function] => search_comments_hook
[args] => Array
(
[0] => search
[1] => comments
[2] => Array
(
)

[3] => Array
(
[query] => jazz
[offset] => 0
[limit] => 2
[sort] => relevance
[order] => desc
[search_type] => comments
[type] =>
[owner_guid] =>
[container_guid] =>
[pagination] =>
)

)

)

[3] => Array
(
[file] => /home/dizabil1/public_html/mod/search/index.php
[line] => 239
[function] => trigger_plugin_hook
[args] => Array
(
[0] => search
[1] => comments
[2] => Array
(
[query] => jazz
[offset] => 0
[limit] => 2
[sort] => relevance
[order] => desc
[search_type] => comments
[type] =>
[owner_guid] =>
[container_guid] =>
[pagination] =>
)

[3] => Array
(
)

)

)

[4] => Array
(
[file] => /home/dizabil1/public_html/mod/search/start.php
[line] => 72
[args] => Array
(
[0] => /home/dizabil1/public_html/mod/search/index.php
)

[function] => include_once
)

[5] => Array
(
[file] => /home/dizabil1/public_html/engine/lib/pagehandler.php
[line] => 33
[function] => search_page_handler
[args] => Array
(
[0] => Array
(
)

[1] => search
)

)

[6] => Array
(
[file] => /home/dizabil1/public_html/engine/handlers/pagehandler.php
[line] => 20
[function] => page_handler
[args] => Array
(
[0] => search
[1] =>
)

)

)

[previous:Exception:private] =>
)