Magento 1.9.3.1 Quck Search Not working

Question

Magento Search Not Working. Search Result: Your search returns no results.

What I have already done.

1. Visibility of the Product is set to Catalog, Search
2. Product Attribute name, SKU, color is set to Yes in Quick Search and is Global.
3. Tried with all Like,FullText,Combine in System->Catalog->Catalog Search.
4. Cleared Cache and Reindexing done several times.
5. Every Category including the root category is set to Yes is_anchor
6. And Did most of the solution given on StackOverflow.

Currently Using Theme Zorka.

Result After I search for a Product or Sku

SQL Query -->

SELECT e.*, search_result.relevance, price_index.price, price_index.tax_class_id, price_index.final_price, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS minimal_price, price_index.min_price, price_index.max_price, price_index.tier_price, cat_index.position AS cat_index_position FROM catalog_product_entity AS e INNER JOIN catalogsearch_result AS search_result ON search_result.product_id=e.entity_id AND search_result.query_id='111' INNER JOIN catalog_product_index_price AS price_index ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN catalog_category_product_index AS cat_index ON cat_index.product_id=e.entity_id AND cat_index.store_id='19' AND cat_index.visibility IN(3, 4) AND cat_index.category_id = '2'

Answer 1

I think there are many attributes have Use in Quick Search value Yes.

Please check and set value for Use in Quick Search to Yes only for Name, Sku and Description (if you want).

Set No for Use in Quick Search for all other attributes.

After doing so, do the reindexing and then check by searching again.