Sharing is helping.

We offer you this space to share your knowledge about Magento and learn from our experienced customers.


    Hi,

    Im using the hellojynx theme and getting the below issue. Can anyone help please?

    After performing a product search and results are found (using search box), in the right column there are 3 "search options" (category, price and manufacturer). - When a users clicks on "manufacturer" the following error is produced;

    You cannot define a correlation name 'manufacturer_idx' more than once

    Trace:
    #0 /var/www/vhosts/urlremoved.co.uk/httpdocs/lib/Zend/Db/Select.php(324): Zend_Db_Select->_join(\'inner join\', Array, \'manufacturer_id...\', Array, NULL)
    #1 /var/www/vhosts/urlremoved.co.uk/httpdocs/lib/Zend/Db/Select.php(303): Zend_Db_Select->joinInner(Array, \'manufacturer_id...\', Array, NULL)
    #2 /var/www/vhosts/urlremoved.co.uk/httpdocs/app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Layer/Filter/Attribute.php(70): Zend_Db_Select->join(Array, \'manufacturer_id...\', Array)
    #3 /var/www/vhosts/urlremoved.co.uk/httpdocs/app/code/core/Mage/Catalog/Model/Layer/Filter/Attribute.php(94): Mage_Catalog_Model_Resource_Eav_Mysql4_Layer_Filter_Attribute->applyFilterToCollection(Object(Mage_CatalogSearch_Model_Layer_Filter_Attribute), \'142\')
    #4 /var/www/vhosts/urlremoved.co.uk/httpdocs/app/code/core/Mage/Catalog/Block/Layer/Filter/Abstract.php(85): Mage_Catalog_Model_Layer_Filter_Attribute->apply(Object(Mage_Core_Controller_Request_Http), Object(Mage_CatalogSearch_Block_Layer_Filter_Attribute))
    #5 /var/www/vhosts/urlremoved.co.uk/httpdocs/app/code/core/Mage/Catalog/Block/Layer/Filter/Abstract.php(67): Mage_Catalog_Block_Layer_Filter_Abstract->_initFilter()
    #6 /var/www/vhosts/urlremoved.co.uk/httpdocs/app/code/core/Mage/Catalog/Block/Layer/View.php(76): Mage_Catalog_Block_Layer_Filter_Abstract->init()
    #7 /var/www/vhosts/urlremoved.co.uk/httpdocs/app/code/core/Mage/Core/Block/Abstract.php(218): Mage_Catalog_Block_Layer_View->_prepareLayout()
    #8 /var/www/vhosts/urlremoved.co.uk/httpdocs/app/code/core/Mage/Core/Model/Layout.php(430): Mage_Core_Block_Abstract->setLayout(Object(Mage_Core_Model_Layout))
    #9 /var/www/vhosts/urlremoved.co.uk/httpdocs/app/code/core/Mage/Core/Model/Layout.php(446): Mage_Core_Model_Layout->createBlock(\'catalogsearch/l...\', \'catalogsearch.l...\')
    #10 /var/www/vhosts/urlremoved.co.uk/httpdocs/app/code/core/Mage/Core/Model/Layout.php(238): Mage_Core_Model_Layout->addBlock(\'catalogsearch/l...\', \'catalogsearch.l...\')
    #11 /var/www/vhosts/urlremoved.co.uk/httpdocs/app/code/core/Mage/Core/Model/Layout.php(204): Mage_Core_Model_Layout->_generateBlock(Object(Mage_Core_Model_Layout_Element), Object(Mage_Core_Model_Layout_Element))
    #12 /var/www/vhosts/urlremoved.co.uk/httpdocs/app/code/core/Mage/Core/Model/Layout.php(209): Mage_Core_Model_Layout->generateBlocks(Object(Mage_Core_Model_Layout_Element))
    #13 /var/www/vhosts/urlremoved.co.uk/httpdocs/app/code/core/Mage/Core/Controller/Varien/Action.php(343): Mage_Core_Model_Layout->generateBlocks()
    #14 /var/www/vhosts/urlremoved.co.uk/httpdocs/app/code/core/Mage/Core/Controller/Varien/Action.php(270): Mage_Core_Controller_Varien_Action->generateLayoutBlocks()
    #15 /var/www/vhosts/urlremoved.co.uk/httpdocs/app/code/core/Mage/CatalogSearch/controllers/ResultController.php(77): Mage_Core_Controller_Varien_Action->loadLayout()
    #16 /var/www/vhosts/urlremoved.co.uk/httpdocs/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_CatalogSearch_ResultController->indexAction()
    #17 /var/www/vhosts/urlremoved.co.uk/httpdocs/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch(\'index\')
    #18 /var/www/vhosts/urlremoved.co.uk/httpdocs/app/code/core/Mage/Core/Controller/Varien/Front.php(177): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
    #19 /var/www/vhosts/urlremoved.co.uk/httpdocs/app/code/core/Mage/Core/Model/App.php(304): Mage_Core_Controller_Varien_Front->dispatch()
    #20 /var/www/vhosts/urlremoved.co.uk/httpdocs/app/Mage.php(596): Mage_Core_Model_App->run(Array)
    #21 /var/www/vhosts/urlremoved.co.uk/httpdocs/index.php(78): Mage::run(\'\', \'store\')
    #22 {main}