Troubleshooting

This section contains the most common problems, that customer can encounter, and how they can be resolved:

• Search is not possible by SKU
• After enabling fallback search and entering too many words, search fails
• Autocomplete (and/or Search Results) is too slow
• Aheadworks blog search doesn`t return results
• "unknown column" error while Sphinx reindex

Search is not possible by SKU

Please, make sure about the following:

• SKU attribute is searchable. You can check it in Stores -> Attributes -> Product grid -> SKU -> Storefront Properties -> Use in Search and Visible in Advanced Search should be Yes.
• SKU is in the list of Searchable attributes in Product Index. You can check it in System -> Search Management -> Search Indexes -> Product Index.
• If SKU includes dashes or other non-alphabetic symbols, set up Long Tail Search expressions as described in our manuals.
• Validate search result. Go to System -> Validator -> Validate Search Results. In Search term field enter your SKU, in Product ID - ID of the product with not searchable SKU and press Validate Search Results.

After enabling fallback search and entering too many words, search fails

Possible cause: too small max_execution_time PHP parameter, which is not enough to complete requests with large number of words.

Solution: there can be two possible solutions.

1. Increase max_execution_time parameter either in .htaccess, or directly in PHP.ini.

2. Use default Magento settings to adjust search parameters. They are located at Stores -> Configuration -> Catalog -> Catalog Search and consist of two options:
   • Minimal Query Length - defines minimal quantity of words in search request (1 for default).
   • Maximum Query Length - defines maximal quantity of words in search request (128 by default).

Typically it is enough to decrease the latter parameter, until search will work correctly.

Autocomplete (and/or Search Results) is too slow

Aheadworks blog search doesn\`t return results

• How to Resolve:
  • Find and open the following file : Aheadworks/Blog/Block/Post.php
  • Find public function getSocialIconsHtml()
  • After condition you will see this row $block = $this->getLayout()->createBlock, place this code before $socialIconsBlock = !empty($this->getSocialIconsBlock())?$this->getSocialIconsBlock():'Aheadworks\Blog\Block\Sharethis';
  • Replace $this->getSocialIconsBlock() after createBlock with $socialIconsBlock
  • You should get your code look like $socialIconsBlock = !empty($this->getSocialIconsBlock())?$this->getSocialIconsBlock():'Aheadworks\Blog\Block\Sharethis'; $block = $this->getLayout()->createBlock( $socialIconsBlock,...