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:
- Go to System / Search Management / Settings
- Press “Reset” button. This will reset configuration.
- Then press “Restart Sphinx Daemon” button. This will restart search service.
Run search reindex from SSH/Console with the command below:
bin/magento indexer:reindex catalogsearch_fulltext