DatabaseException: unknown column: ‘autocomplete’

Problem

During full search reindex, Magento can throw this error:

Mirasvit\SearchSphinx\SphinxQL\Exception\DatabaseException: [1064] unknown column: 'autocomplete'

Reason

In recent update (Elastic Search Ultimate or Sphinx Search Ultimate) we added new column “autocomplete” to indexation. This column/attribute contains information required to display search results in autocomplete box:

• name
• short description
• link
• price
• reviews
• etc

Solution

To resolve this error, you just need to reset old Sphinx configuration and run reindex:

1. Go to System / Search Management / Settings
2. Press “Reset” button. This will reset configuration.
3. Then press “Restart Sphinx Daemon” button. This will restart search service.

4. Run search reindex from SSH/Console with the command below:

   bin/magento indexer:reindex catalogsearch_fulltext