Hi guys got a weird one the normal magento search returns 0 results, but the advanced search works?


  • Reindexing
  • Clearing Cache
  • Re updating attributes of products to link to website
  • Checked for theme files overriding (have I missed any?)

I edited "Mage_CatalogSearch_Model_Layer"

And added:

Mage::log($collection->getSelectSQL(1), false, 'search.log', true);
Mage::log((array)Mage::getConfig()->getNode()->global->models->catalogsearch, false, 'search.log', true)

Which gave me the SQL query, ran it in MySQL and returned a load of products as it should!

Any ideas why this wouldn't be working?

  • did you go through here check this also – Hitesh Oct 18 '18 at 6:40
  • @Hit's yes I have been through both of those – KiwisTasteGood Oct 18 '18 at 8:19

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.