"Correlation name color_idx more than once" error.

Good afternoon.

When registering a shipment in my web site I get the following error:

a:5:{i:0;s:63:"You cannot define a correlation name ‘color_idx’ more than once";i:1;s:3570:"#0 /home/tiedu374/public_html/loja/lib/Varien/Db/Select.php(281): Zend_Db_Select->_join(‘inner join’, Array, ‘color_idx.entit…’, Array, NULL)
#1 /home/tiedu374/public_html/loja/lib/Zend/Db/Select.php(336): Varien_Db_Select->_join(‘inner join’, Array, ‘color_idx.entit…’, Array, NULL)
#2 /home/tiedu374/public_html/loja/lib/Zend/Db/Select.php(315): Zend_Db_Select->joinInner(Array, ‘color_idx.entit…’, Array, NULL)
#3 /home/tiedu374/public_html/loja/app/code/core/Mage/Catalog/Model/Resource/Layer/Filter/Attribute.php(70): Zend_Db_Select->join(Array, ‘color_idx.entit…’, Array)
#4 /home/tiedu374/public_html/loja/app/code/core/Mage/Catalog/Model/Layer/Filter/Attribute.php(94): Mage_Catalog_Model_Resource_Layer_Filter_Attribute->applyFilterToCollection(Object(Mage_CatalogSearch _Model_Layer_Filter_Attribute), ’26’)
#5 /home/tiedu374/public_html/loja/app/code/core/Mage/Catalog/Block/Layer/Filter/Abstract.php(91): Mage_Catalog_Model_Layer_Filter_Attribute->apply(Object(Mage_Core_Controller_Request_Http) , Object(Mage_CatalogSearch_Block_Layer_Filter_Attri bute))
#6 /home/tiedu374/public_html/loja/app/code/core/Mage/Catalog/Block/Layer/Filter/Abstract.php(73): Mage_Catalog_Block_Layer_Filter_Abstract->_initFilter()
#7 /home/tiedu374/public_html/loja/app/code/core/Mage/Catalog/Block/Layer/View.php(136): Mage_Catalog_Block_Layer_Filter_Abstract->init()
#8 /home/tiedu374/public_html/loja/app/code/core/Mage/Core/Block/Abstract.php(238): Mage_Catalog_Block_Layer_View->_prepareLayout()
#9 /home/tiedu374/public_html/loja/app/code/core/Mage/Core/Model/Layout.php(456): Mage_Core_Block_Abstract->setLayout(Object(Mage_Core_Model_Layout))
#10 /home/tiedu374/public_html/loja/app/code/core/Mage/Core/Model/Layout.php(472): Mage_Core_Model_Layout->createBlock(‘catalogsearch/l…’, ‘catalogsearch.l…’)
#11 /home/tiedu374/public_html/loja/app/code/core/Mage/Core/Model/Layout.php(239): Mage_Core_Model_Layout->addBlock(‘catalogsearch/l…’, ‘catalogsearch.l…’)
#12 /home/tiedu374/public_html/loja/app/code/core/Mage/Core/Model/Layout.php(205): Mage_Core_Model_Layout->_generateBlock(Object(Mage_Core_Model_Layout_Elem ent), Object(Mage_Core_Model_Layout_Element))
#13 /home/tiedu374/public_html/loja/app/code/core/Mage/Core/Model/Layout.php(210): Mage_Core_Model_Layout->generateBlocks(Object(Mage_Core_Model_Layout_Elem ent))
#14 /home/tiedu374/public_html/loja/app/code/core/Mage/Core/Controller/Varien/Action.php(344): Mage_Core_Model_Layout->generateBlocks()
#15 /home/tiedu374/public_html/loja/app/code/core/Mage/Core/Controller/Varien/Action.php(269): Mage_Core_Controller_Varien_Action->generateLayoutBlocks()
#16 /home/tiedu374/public_html/loja/app/code/core/Mage/CatalogSearch/controllers/ResultController.php(77): Mage_Core_Controller_Varien_Action->loadLayout()
#17 /home/tiedu374/public_html/loja/app/code/core/Mage/Core/Controller/Varien/Action.php(419): Mage_CatalogSearch_ResultController->indexAction()
#18 /home/tiedu374/public_html/loja/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch(‘index’)
#19 /home/tiedu374/public_html/loja/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http) )
#20 /home/tiedu374/public_html/loja/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
#21 /home/tiedu374/public_html/loja/app/Mage.php(683): Mage_Core_Model_App->run(Array)
#22 /home/tiedu374/public_html/loja/index.php(87): Mage::run(”, ‘store’)
#23 {main}";s:3:"url";s:82:"/catalogsearch/result/index/?cat=13&color=26&enable_googlecheckout=0&price=40-&q=1";s:11:"script_name";s:10:"/index.php";s:4:"skin";s:7:"default";}

The customer receives the shipment e-mail, but I cannot change the order status.

Any idea of what’s going on?

Thanks.

1 answer

quanpa 0.00 $tone August 27, 2013
Public

Hi alexpersilva !
"Correlation name color_idx more than once" error because catalog/layer_view module was called twice. You can search <block type="catalog/layer_view" name="catalog.leftnav" after="currency" template="catalog/layer/view.phtml"/> in your catalog.xml(in your theme folder). Remove the block you don’t needed or change the type to another class.

#1

This question is now closed

Written By

Comments