Autocomplete Fulltext query broken for Owners about platform HOT 6 CLOSED

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.

from platform.

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.

from platform.

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

from platform.

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

from platform.

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.

from platform.

Hi, @knoxguru !

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

from platform.