How did I fix «Item (Mage_Catalog_Model_Product) with the same id "…" already exist» on loading `Mage_Catalog_Model_Resource_Product_Compare_Item_Collection` in Magento 1?

dmitrii_fediuk · March 18, 2024, 5:14am

«Item (Mage_Catalog_Model_Product) with the same id "…" already exist» on loading `Mage_Catalog_Model_Resource_Product_Compare_Item_Collection`

opened 10:14PM - 16 Mar 24 UTC

closed 05:16AM - 18 Mar 24 UTC

bug

- [magento.stackexchange.com/questions/92400](https://magento.stackexchange.com/…questions/92400) - [magento.stackexchange.com/questions/313278](https://magento.stackexchange.com/questions/313278) ``` [ IP Address: 172.69.70.100 OpenMage: 19.5.2 PHP: 7.4.33 Referer: https://www.thehcginstitute.com/store/customer/account/login/referer/aHR0cHM6Ly93d3cudGhlaGNnaW5zdGl0dXRlLmNvbS9zdG9yZS9jdXN0b21lci9hY2NvdW50L2luZGV4Lw,,/ Request Method: GET URL: https://www.thehcginstitute.com/store/customer/account User-Agent: Mozilla/5.0 (iPhone; CPU iPhone OS 16_1_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.1 Mobile/15E148 Safari/604.1 ] EXCEPTION Item (Mage_Catalog_Model_Product) with the same id "17" already exist ************************************ 1 Varien_Data_Collection::addItem app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php:256 2 Mage_Eav_Model_Entity_Collection_Abstract::addItem app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php:1061 3 Mage_Eav_Model_Entity_Collection_Abstract::_loadEntities app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php:870 4 Mage_Eav_Model_Entity_Collection_Abstract::load app/code/core/Mage/Catalog/Helper/Product/Compare.php:228 5 Mage_Catalog_Helper_Product_Compare::getItemCollection app/design/frontend/default/mobileshoppe/template/catalog/product/compare/sidebar.phtml:3 6 include app/code/core/Mage/Core/Block/Template.php:251 7 Mage_Core_Block_Template::fetchView app/code/core/Mage/Core/Block/Template.php:288 8 Mage_Core_Block_Template::renderView app/code/core/Mage/Core/Block/Template.php:301 9 Mage_Core_Block_Template::_toHtml app/code/core/Mage/Core/Block/Abstract.php:927 10 Mage_Core_Block_Abstract::toHtml app/code/core/Mage/Core/Block/Text/List.php:36 11 Mage_Core_Block_Text_List::_toHtml app/code/core/Mage/Core/Block/Abstract.php:927 12 Mage_Core_Block_Abstract::toHtml app/code/core/Mage/Core/Block/Abstract.php:644 13 Mage_Core_Block_Abstract::_getChildHtml app/code/core/Mage/Core/Block/Abstract.php:588 14 Mage_Core_Block_Abstract::getChildHtml app/design/frontend/default/mobileshoppe/template/page/2columns-left.phtml:62 15 include app/code/core/Mage/Core/Block/Template.php:251 16 Mage_Core_Block_Template::fetchView app/code/core/Mage/Core/Block/Template.php:288 17 Mage_Core_Block_Template::renderView app/code/core/Mage/Core/Block/Template.php:301 18 Mage_Core_Block_Template::_toHtml app/code/core/Mage/Core/Block/Abstract.php:927 19 Mage_Core_Block_Abstract::toHtml app/code/core/Mage/Core/Model/Layout.php:574 20 Mage_Core_Model_Layout::getOutput app/code/core/Mage/Core/Controller/Varien/Action.php:391 21 Mage_Core_Controller_Varien_Action::renderLayout app/code/core/Mage/Customer/controllers/AccountController.php:112 22 Mage_Customer_AccountController::indexAction app/code/core/Mage/Core/Controller/Varien/Action.php:422 23 Mage_Core_Controller_Varien_Action::dispatch app/code/core/Mage/Core/Controller/Varien/Router/Standard.php:256 24 Mage_Core_Controller_Varien_Router_Standard::match app/code/core/Mage/Core/Controller/Varien/Front.php:182 25 Mage_Core_Controller_Varien_Front::dispatch app/code/core/Mage/Core/Model/App.php:365 26 Mage_Core_Model_App::run app/Mage.php:742 27 Mage::run index.php:62 1 Varien_Data_Collection::addItem lib/Varien/Data/Collection.php:359 2 Mage_Eav_Model_Entity_Collection_Abstract::addItem app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php:256 3 Mage_Eav_Model_Entity_Collection_Abstract::_loadEntities app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php:1061 4 Mage_Eav_Model_Entity_Collection_Abstract::load app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php:870 5 Mage_Catalog_Helper_Product_Compare::getItemCollection app/code/core/Mage/Catalog/Helper/Product/Compare.php:228 6 include app/design/frontend/default/mobileshoppe/template/catalog/product/compare/sidebar.phtml:3 7 Mage_Core_Block_Template::fetchView app/code/core/Mage/Core/Block/Template.php:251 8 Mage_Core_Block_Template::renderView app/code/core/Mage/Core/Block/Template.php:288 9 Mage_Core_Block_Template::_toHtml app/code/core/Mage/Core/Block/Template.php:301 10 Mage_Core_Block_Abstract::toHtml app/code/core/Mage/Core/Block/Abstract.php:927 11 Mage_Core_Block_Text_List::_toHtml app/code/core/Mage/Core/Block/Text/List.php:36 12 Mage_Core_Block_Abstract::toHtml app/code/core/Mage/Core/Block/Abstract.php:927 13 Mage_Core_Block_Abstract::_getChildHtml app/code/core/Mage/Core/Block/Abstract.php:644 14 Mage_Core_Block_Abstract::getChildHtml app/code/core/Mage/Core/Block/Abstract.php:588 15 include app/design/frontend/default/mobileshoppe/template/page/2columns-left.phtml:62 16 Mage_Core_Block_Template::fetchView app/code/core/Mage/Core/Block/Template.php:251 17 Mage_Core_Block_Template::renderView app/code/core/Mage/Core/Block/Template.php:288 18 Mage_Core_Block_Template::_toHtml app/code/core/Mage/Core/Block/Template.php:301 19 Mage_Core_Block_Abstract::toHtml app/code/core/Mage/Core/Block/Abstract.php:927 20 Mage_Core_Model_Layout::getOutput app/code/core/Mage/Core/Model/Layout.php:574 21 Mage_Core_Controller_Varien_Action::renderLayout app/code/core/Mage/Core/Controller/Varien/Action.php:391 22 Mage_Customer_AccountController::indexAction app/code/core/Mage/Customer/controllers/AccountController.php:112 23 Mage_Core_Controller_Varien_Action::dispatch app/code/core/Mage/Core/Controller/Varien/Action.php:422 24 Mage_Core_Controller_Varien_Router_Standard::match app/code/core/Mage/Core/Controller/Varien/Router/Standard.php:256 25 Mage_Core_Controller_Varien_Front::dispatch app/code/core/Mage/Core/Controller/Varien/Front.php:182 26 Mage_Core_Model_App::run app/code/core/Mage/Core/Model/App.php:365 27 Mage::run app/Mage.php:742 ```

dmitrii_fediuk · March 18, 2024, 5:18am

github.com

thehcginstitute-com/m1/blob/2024-03-18/app/code/core/Mage/Catalog/Helper/Product/Compare.php#L226-L233


      
          			# 2024-03-18 Dmitrii Fediuk https://upwork.com/fl/mage2pro
          			# 1) "«Item (Mage_Catalog_Model_Product) with the same id "…" already exist»
          			# on loading `Mage_Catalog_Model_Resource_Product_Compare_Item_Collection`":
          			# https://github.com/thehcginstitute-com/m1/issues/496
          			# 2) "How did I fix «Item (Mage_Catalog_Model_Product) with the same id "…" already exist»
          			# on loading `Mage_Catalog_Model_Resource_Product_Compare_Item_Collection` in Magento 1?"
          			# https://mage2.pro/t/6435
          			$this->_itemCollection->getSelect()->group('t_compare.product_id');