latest release as bug in configurable product

[5mehulhelp5]

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”.

[damienwebdev]

@5mehulhelp5 what database system and version are you using?

[melindash]

@5mehulhelp5 Was this a fresh install, or an upgrade?

[fballiano]

is that error not happening on an official 2.4.8 install?

[5mehulhelp5]

as it is solved so i am closing this @rhoerr i have also applied same fix where we are missing ! in the condition.