latest release as bug in configurable product #137
Description
Preconditions and environment
- Mage-OS Magento version 1.1.0
- Configurable product not showing in the frontend
main.CRITICAL: Zend_Db_Select_Exception: You cannot define a correlation name 'stock' more than once in D:\www\mageos\vendor\mage-os\zend-db\library\Zend\Db\Select.php:833
Stack trace:
#0 D:\www\mageos\vendor\mage-os\framework\DB\Select.php(306): Zend_Db_Select->_join()
#1 D:\www\mageos\vendor\mage-os\zend-db\library\Zend\Db\Select.php(357): Magento\Framework\DB\Select->_join()
#2 D:\www\mageos\vendor\mage-os\zend-db\library\Zend\Db\Select.php(336): Zend_Db_Select->joinInner()
#3 D:\www\mageos\vendor\mage-os\module-inventory-configurable-product\Pricing\Price\LowestPriceOptionsProvider\StockStatusBaseSelectProcessor.php(113): Zend_Db_Select->join()
#4 D:\www\mageos\vendor\mage-os\module-configurable-product\Model\ResourceModel\Product\LinkedProductSelectBuilder.php(49): Magento\InventoryConfigurableProduct\Pricing\Price\LowestPriceOptionsProvider\StockStatusBaseSelectProcessor->process()
#5 D:\www\mageos\vendor\mage-os\module-configurable-product\Pricing\Price\LowestPriceOptionsProvider.php(74): Magento\ConfigurableProduct\Model\ResourceModel\Product\LinkedProductSelectBuilder->build()
#6 D:\www\mageos\vendor\mage-os\module-configurable-product\Pricing\Price\ConfigurablePriceResolver.php(65): Magento\ConfigurableProduct\Pricing\Price\LowestPriceOptionsProvider->getProducts()
#7 D:\www\mageos\vendor\mage-os\module-configurable-product\Pricing\Price\FinalPrice.php(45): Magento\ConfigurableProduct\Pricing\Price\ConfigurablePriceResolver->resolvePrice()
#8 D:\www\mageos\vendor\mage-os\framework\Pricing\Price\AbstractPrice.php(102): Magento\ConfigurableProduct\Pricing\Price\FinalPrice->getValue()
#9 D:\www\mageos\vendor\mage-os\module-configurable-product\view\base\templates\product\price\final_price.phtml(21): Magento\Framework\Pricing\Price\AbstractPrice->getAmount()
#10 D:\www\mageos\vendor\mage-os\framework\View\TemplateEngine\Php.php(67): include('...')
#11 D:\www\mageos\vendor\mage-os\framework\View\Element\Template.php(263): Magento\Framework\View\TemplateEngine\Php->render()
#12 D:\www\mageos\vendor\mage-os\framework\View\Element\Template.php(293): Magento\Framework\View\Element\Template->fetchView()
#13 D:\www\mageos\vendor\mage-os\framework\Pricing\Render\PriceBox.php(69): Magento\Framework\View\Element\Template->_toHtml()
#14 D:\www\mageos\vendor\mage-os\module-catalog\Pricing\Render\FinalPriceBox.php(72): Magento\Framework\Pricing\Render\PriceBox->_toHtml()
#15 D:\www\mageos\vendor\mage-os\framework\View\Element\AbstractBlock.php(1128): Magento\Catalog\Pricing\Render\FinalPriceBox->_toHtml()
#16 D:\www\mageos\vendor\mage-os\framework\Cache\LockGuardedCacheLoader.php(131): Magento\Framework\View\Element\AbstractBlock->Magento\Framework\View\Element{closure}()
#17 D:\www\mageos\vendor\mage-os\framework\View\Element\AbstractBlock.php(1149): Magento\Framework\Cache\LockGuardedCacheLoader->lockedLoadData()
#18 D:\www\mageos\vendor\mage-os\framework\View\Element\AbstractBlock.php(676): Magento\Framework\View\Element\AbstractBlock->_loadCache()
#19 D:\www\mageos\vendor\mage-os\framework\Pricing\Render.php(97): Magento\Framework\View\Element\AbstractBlock->toHtml()
#20 D:\www\mageos\vendor\mage-os\module-catalog\Block\Product\ListProduct.php(419): Magento\Framework\Pricing\Render->render()
#21 D:\www\mageos\vendor\mage-os\module-catalog\view\frontend\templates\product\list.phtml(77): Magento\Catalog\Block\Product\ListProduct->getProductPrice()
#22 D:\www\mageos\vendor\mage-os\framework\View\TemplateEngine\Php.php(67): include('...')
#23 D:\www\mageos\vendor\mage-os\framework\View\Element\Template.php(263): Magento\Framework\View\TemplateEngine\Php->render()
#24 D:\www\mageos\vendor\mage-os\framework\View\Element\Template.php(293): Magento\Framework\View\Element\Template->fetchView()
#25 D:\www\mageos\vendor\mage-os\framework\View\Element\AbstractBlock.php(1128): Magento\Framework\View\Element\Template->_toHtml()
#26 D:\www\mageos\vendor\mage-os\framework\View\Element\AbstractBlock.php(1132): Magento\Framework\View\Element\AbstractBlock->Magento\Framework\View\Element{closure}()
#27 D:\www\mageos\vendor\mage-os\framework\View\Element\AbstractBlock.php(676): Magento\Framework\View\Element\AbstractBlock->_loadCache()
#28 D:\www\mageos\vendor\mage-os\framework\View\Layout.php(578): Magento\Framework\View\Element\AbstractBlock->toHtml()
#29 D:\www\mageos\vendor\mage-os\framework\View\Layout.php(555): Magento\Framework\View\Layout->_renderBlock()
Steps to reproduce
Navigation to frontend
visit any category which has configurable products
it's shoes empty.
Expected result
it should show products on category pages
Actual result
category page are empty
Additional information
No response
Release note
No response
Triage and priority
- Severity: S0 - Affects critical data or functionality and leaves users without workaround.
- Severity: S1 - Affects critical data or functionality and forces users to employ a workaround.
- Severity: S2 - Affects non-critical data or functionality and forces users to employ a workaround.
- Severity: S3 - Affects non-critical data or functionality and does not force users to employ a workaround.
- Severity: S4 - Affects aesthetics, professional look and feel, “quality” or “usability”.