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

[2007lf]

Hi sir
Use the cache extension, there is a problem, my website report log follows：

a:5:{i:0;s:69:"You cannot define a correlation name 'shown_color_idx' more than once";i:1;s:3296:"#0 /home/test/public_html/lib/Varien/Db/Select.php(281): Zend_Db_Select->_join('inner join', Array, 'shown_color_idx...', Array, NULL)
#1 /home/test/public_html/lib/Zend/Db/Select.php(336): Varien_Db_Select->_join('inner join', Array, 'shown_color_idx...', Array, NULL)
#2 /home/test/public_html/lib/Zend/Db/Select.php(315): Zend_Db_Select->joinInner(Array, 'shown_color_idx...', Array, NULL)
#3 /home/test/public_html/app/code/core/Mage/Catalog/Model/Resource/Layer/Filter/Attribute.php(70): Zend_Db_Select->join(Array, 'shown_color_idx...', Array)
#4 /home/test/public_html/app/code/core/Mage/Catalog/Model/Layer/Filter/Attribute.php(94): Mage_Catalog_Model_Resource_Layer_Filter_Attribute->applyFilterToCollection(Object(Mage_Catalog_Model_Layer_Filter_Attribute), '143')
#5 /home/test/public_html/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_Catalog_Block_Layer_Filter_Attribute))
#6 /home/test/public_html/app/code/core/Mage/Catalog/Block/Layer/Filter/Abstract.php(73): Mage_Catalog_Block_Layer_Filter_Abstract->_initFilter()
#7 /home/test/public_html/app/code/core/Mage/Catalog/Block/Layer/View.php(136): Mage_Catalog_Block_Layer_Filter_Abstract->init()
#8 /home/test/public_html/app/code/core/Mage/Core/Block/Abstract.php(247): Mage_Catalog_Block_Layer_View->_prepareLayout()
#9 /home/test/public_html/app/code/core/Mage/Core/Model/Layout.php(456): Mage_Core_Block_Abstract->setLayout(Object(Mage_Core_Model_Layout))
#10 /home/test/public_html/app/code/core/Mage/Core/Model/Layout.php(472): Mage_Core_Model_Layout->createBlock('catalog/layer_v...', 'catalog.leftnav...')
#11 /home/test/public_html/app/code/core/Mage/Core/Model/Layout.php(239): Mage_Core_Model_Layout->addBlock('catalog/layer_v...', 'catalog.leftnav...')
#12 /home/test/public_html/app/code/core/Mage/Core/Model/Layout.php(205): Mage_Core_Model_Layout->_generateBlock(Object(Mage_Core_Model_Layout_Element), Object(Mage_Core_Model_Layout_Element))
#13 /home/test/public_html/app/code/core/Mage/Core/Model/Layout.php(210): Mage_Core_Model_Layout->generateBlocks(Object(Mage_Core_Model_Layout_Element))
#14 /home/test/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(345): Mage_Core_Model_Layout->generateBlocks()
#15 /home/test/public_html/app/code/core/Mage/Catalog/controllers/CategoryController.php(152): Mage_Core_Controller_Varien_Action->generateLayoutBlocks()
#16 /home/test/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(422): Mage_Catalog_CategoryController->viewAction()
#17 /home/test/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch('view')
#18 /home/test/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#19 /home/test/public_html/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
#20 /home/test/public_html/app/Mage.php(692): Mage_Core_Model_App->run(Array)
#21 /home/test/public_html/index.php(98): Mage::run('', 'store')
#22 {main}";s:3:"url";s:134:"/special-occasion-dresses/shop-by-occasion/evening-dresses/?body_shape=54&length=63&limit=5&mode=list&price=&shown_color=143&sleeve=30";s:11:"script_name";s:10:"/index.php";s:4:"skin";s:7:"default";}

please help me, thanks!

[aheadley]

From that stacktrace, this doesn't appear to be related to Turpentine. Can you tell me what makes you think it is?

[2007lf]

Because I deactivate this extension, varnish deactivated, such errors will not occur again, I don't know exactly what causes, very depressed, can you help me, please, thank you.

------------------ 原始邮件 ------------------
发件人: "Alex Headley";notifications@github.com;
发送时间: 2014年6月11日(星期三) 凌晨4:56
收件人: "nexcess/magento-turpentine"magento-turpentine@noreply.github.com;
抄送: " 刘锋"782363589@qq.com;
主题: Re: [magento-turpentine] You cannot define a correlation name'mycustomattribute' more than once (#559)

From that stacktrace, this doesn't appear to be related to Turpentine. Can you tell me what makes you think it is?

—
Reply to this email directly or view it on GitHub.

[theycallmepepper]

Was anyone able to reproduce this issue? I just encountered the same thing and am looking for a solid fix. I'm also using turpentine at the moment.