1 exception(s): Exception #0 (Zend_Db_Select_Exception): You cannot define a correlation name 'heig_idx' more than once Exception #0 (Zend_Db_Select_Exception): You cannot define a correlation name 'heig_idx' more than once
#1 Magento\Framework\DB\Select->_join('inner join', array('heig_idx' => 'catalog_product_...'), 'heig_idx.entity_...', array(), NULL) called at [vendor/magento/zendframework1/library/Zend/Db/Select.php:357] #2 Zend_Db_Select->joinInner(array('heig_idx' => 'catalog_product_...'), 'heig_idx.entity_...', array(), NULL) called at [vendor/magento/zendframework1/library/Zend/Db/Select.php:336] #3 Zend_Db_Select->join(array('heig_idx' => 'catalog_product_...'), 'heig_idx.entity_...', array()) called at [app/code/MGS/Ajaxlayernavigation/Model/ResourceModel/Layer/Filter/Attribute.php:46] #4 MGS\Ajaxlayernavigation\Model\ResourceModel\Layer\Filter\Attribute->getCount(&MGS\Ajaxlayernavigation\Model\Layer\Filter\Attribute#00000000207aba9a000000000ba9f5b4#, array(array('id' => 151, 'code' => 'material', 'values' => array(82)), array('id' => 189, 'code' => 'heig', 'values' => array(array(2, 10))))) called at [app/code/MGS/Ajaxlayernavigation/Model/Layer/Filter/Attribute.php:79] #5 MGS\Ajaxlayernavigation\Model\Layer\Filter\Attribute->_getFilterItemsCount() called at [app/code/MGS/Ajaxlayernavigation/Model/Layer/Filter/Attribute.php:129] #6 MGS\Ajaxlayernavigation\Model\Layer\Filter\Attribute->_getItemsData() called at [app/code/MGS/Ajaxlayernavigation/Model/Layer/Filter/DefaultFilter.php:117] #7 MGS\Ajaxlayernavigation\Model\Layer\Filter\DefaultFilter->_initItems() called at [app/code/MGS/Ajaxlayernavigation/Model/Layer/Filter/DefaultFilter.php:98] #8 MGS\Ajaxlayernavigation\Model\Layer\Filter\DefaultFilter->getItems() called at [app/code/MGS/Ajaxlayernavigation/Model/Layer/Filter/DefaultFilter.php:105] #9 MGS\Ajaxlayernavigation\Model\Layer\Filter\DefaultFilter->getItemsCount() called at [app/code/MGS/Ajaxlayernavigation/view/frontend/templates/layer/view.phtml:25] #10 include('/home/silgo/web/...') called at [vendor/magento/framework/View/TemplateEngine/Php.php:59] #11 Magento\Framework\View\TemplateEngine\Php->render(&Magento\LayeredNavigation\Block\Navigation#00000000207ab928000000000ba9f5b4#, '/home/silgo/web/...', array()) called at [vendor/magento/framework/View/Element/Template.php:271] #12 Magento\Framework\View\Element\Template->fetchView('/home/silgo/web/...') called at [vendor/magento/framework/View/Element/Template.php:301] #13 Magento\Framework\View\Element\Template->_toHtml() called at [vendor/magento/framework/View/Element/AbstractBlock.php:668] #14 Magento\Framework\View\Element\AbstractBlock->toHtml() called at [vendor/magento/framework/View/Layout.php:557] #15 Magento\Framework\View\Layout->_renderBlock('catalog.leftnav') called at [vendor/magento/framework/View/Layout.php:533] #16 Magento\Framework\View\Layout->renderNonCachedElement('catalog.leftnav') called at [vendor/magento/framework/View/Layout.php:488] #17 Magento\Framework\View\Layout->renderElement('catalog.leftnav', false) called at [vendor/magento/framework/View/Layout.php:585] #18 Magento\Framework\View\Layout->_renderContainer('sidebar.main', false) called at [vendor/magento/framework/View/Layout.php:535] #19 Magento\Framework\View\Layout->renderNonCachedElement('sidebar.main') called at [vendor/magento/framework/View/Layout.php:488] #20 Magento\Framework\View\Layout->renderElement('sidebar.main', false) called at [vendor/magento/framework/View/Layout.php:585] #21 Magento\Framework\View\Layout->_renderContainer('div.sidebar.main', false) called at [vendor/magento/framework/View/Layout.php:535] #22 Magento\Framework\View\Layout->renderNonCachedElement('div.sidebar.main') called at [vendor/magento/framework/View/Layout.php:488] #23 Magento\Framework\View\Layout->renderElement('div.sidebar.main', false) called at [vendor/magento/framework/View/Layout.php:585] #24 Magento\Framework\View\Layout->_renderContainer('columns', false) called at [vendor/magento/framework/View/Layout.php:535] #25 Magento\Framework\View\Layout->renderNonCachedElement('columns') called at [vendor/magento/framework/View/Layout.php:488] #26 Magento\Framework\View\Layout->renderElement('columns', false) called at [vendor/magento/framework/View/Layout.php:585] #27 Magento\Framework\View\Layout->_renderContainer('main.content', false) called at [vendor/magento/framework/View/Layout.php:535] #28 Magento\Framework\View\Layout->renderNonCachedElement('main.content') called at [vendor/magento/framework/View/Layout.php:488] #29 Magento\Framework\View\Layout->renderElement('main.content', false) called at [vendor/magento/framework/View/Layout.php:585] #30 Magento\Framework\View\Layout->_renderContainer('page.wrapper', false) called at [vendor/magento/framework/View/Layout.php:535] #31 Magento\Framework\View\Layout->renderNonCachedElement('page.wrapper') called at [vendor/magento/framework/View/Layout.php:488] #32 Magento\Framework\View\Layout->renderElement('page.wrapper', false) called at [vendor/magento/framework/View/Layout.php:585] #33 Magento\Framework\View\Layout->_renderContainer('root', false) called at [vendor/magento/framework/View/Layout.php:535] #34 Magento\Framework\View\Layout->renderNonCachedElement('root') called at [vendor/magento/framework/View/Layout.php:488] #35 Magento\Framework\View\Layout->renderElement('root') called at [vendor/magento/framework/View/Layout.php:954] #36 Magento\Framework\View\Layout->getOutput() called at [vendor/magento/framework/Interception/Interceptor.php:58] #37 Magento\Framework\View\Layout\Interceptor->___callParent('getOutput', array()) called at [vendor/magento/framework/Interception/Interceptor.php:138] #38 Magento\Framework\View\Layout\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153] #39 Magento\Framework\View\Layout\Interceptor->___callPlugins('getOutput', array(), array(array('layout-model-cac...'))) called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:39] #40 Magento\Framework\View\Layout\Interceptor->getOutput() called at [vendor/magento/framework/View/Result/Page.php:258] #41 Magento\Framework\View\Result\Page->render(&Magento\Framework\App\Response\Http\Interceptor#00000000207abc6b000000000ba9f5b4#) called at [vendor/magento/framework/View/Result/Layout.php:171] #42 Magento\Framework\View\Result\Layout->renderResult(&Magento\Framework\App\Response\Http\Interceptor#00000000207abc6b000000000ba9f5b4#) called at [vendor/magento/framework/Interception/Interceptor.php:58] #43 MGS\Mpanel\Block\Framework\Page\Interceptor->___callParent('renderResult', array(&Magento\Framework\App\Response\Http\Interceptor#00000000207abc6b000000000ba9f5b4#)) called at [vendor/magento/framework/Interception/Interceptor.php:138] #44 MGS\Mpanel\Block\Framework\Page\Interceptor->Magento\Framework\Interception\{closure}(&Magento\Framework\App\Response\Http\Interceptor#00000000207abc6b000000000ba9f5b4#) called at [vendor/magento/framework/Interception/Interceptor.php:153] #45 MGS\Mpanel\Block\Framework\Page\Interceptor->___callPlugins('renderResult', array(&Magento\Framework\App\Response\Http\Interceptor#00000000207abc6b000000000ba9f5b4#), array(array('result-messages', 'result-builtin-c...', 'result-varnish-c...'))) called at [generated/code/MGS/Mpanel/Block/Framework/Page/Interceptor.php:39] #46 MGS\Mpanel\Block\Framework\Page\Interceptor->renderResult(&Magento\Framework\App\Response\Http\Interceptor#00000000207abc6b000000000ba9f5b4#) called at [vendor/magento/framework/App/Http.php:140] #47 Magento\Framework\App\Http->launch() called at [vendor/magento/framework/App/Bootstrap.php:258] #48 Magento\Framework\App\Bootstrap->run(&Magento\Framework\App\Http\Interceptor#00000000207abc69000000000ba9f5b4#) called at [index.php:54]