Autocomplete Fulltext query broken for Owners

[knoxguru]

When attempting to search using the dropdown for users when adding a contact or a contact group the autocomplete query returns a 500:

The query it runs produces:
#1191 - Can't find FULLTEXT index matching the column list

I've confirmed that it is the query and not the script. I can get the query to run by removing the MATCH() in the SELECT but don't want to do that in the code base.

The full query and params below:

An exception occurred while executing 'SELECT DISTINCT MATCH(o0_.value) AGAINST (? ) AS sclr0, o1_.id AS id1, o1_.entity AS entity2, o1_.alias AS alias3, o1_.record_id AS record_id4, o1_.title AS title5, o1_.changed AS changed6, o1_.created_at AS created_at7, o1_.updated_at AS updated_at8, o2_.id AS id9, o2_.field AS field10, o2_.value AS value11, o2_.item_id AS item_id12 FROM oro_search_item o1_ LEFT JOIN oro_search_index_text o2_ ON o1_.id = o2_.item_id AND (o2_.field = ?) LEFT JOIN oro_search_index_text o0_ ON o1_.id = o0_.item_id LEFT JOIN oro_search_index_integer o3_ ON o1_.id = o3_.item_id LEFT JOIN oro_search_index_decimal o4_ ON o1_.id = o4_.item_id LEFT JOIN oro_search_index_datetime o5_ ON o1_.id = o5_.item_id WHERE o1_.alias IN ('oro_user') AND (((MATCH(o0_.value) AGAINST (? IN BOOLEAN MODE ) > 0 AND o0_.field = ?) OR o0_.value LIKE ?)) ORDER BY sclr0 DESC LIMIT 11' with params ["d", "all_text", "d*", "all_text", "d%"]:

[knoxguru]

If anyone is interested in fixing it themselves here is the diff ( just two lines need to be edited):
File: Oro/Bundle/SearchBundle/Engine/Orm/PdoMysql.php

Change Line 165:
"MATCH_AGAINST(textField.value, :$rawValueParameter) AS rankField"
To:
"textField.value AS rankField"

Change line 167:
)->setParameter($rawValueParameter, $fieldValue)->orderBy('rankField', 'DESC');
To:
)->orderBy('rankField', 'DESC');

I would assume you could override function createMatchAgainstWordsExpr as well.

[yurio]

Good day.
Error "1191 - Can't find FULLTEXT index matching the column list" is telling that You don't enabled MyISAM fulltext index.
Try to run php app/console oro:seach:create-index command. It will create fulltext index.

[knoxguru]

I used the setup wizard instead of the install.sh script. Does this mean the wizard didn't run this step?

[yurio]

To install from the console, use php app/console oro:install command. install.sh script will be removed.

[knoxguru]

Thanks, So the problem is that the wizard doesn't create the fulltext indexes? app/console oro:search:create-index fixed the issue without my hack above.

I'll use command like oro:install going forward. Thanks.

[dxops]

Hi, @knoxguru !

This issue was fixed, and I think we can close it. Thanks!