Magento 1.9 – Fix Uncaught Exception ‘Item with Same ID’ Error

fatal errormagento-1.9

I'm trying to generate a feed and the code [CODE] is working like a charm on store1 but generates an error [ERROR] on store2. When I skip the SKIPPING PART (see source) it works fine but I can't select catgeories anymore and all products are used

[ERROR]

Fatal error: Uncaught exception 'Exception' with message 'Item (Mage_Catalog_Model_Product) with the same id "171" already exist' in /home/huisent/public_html/staging/lib/Varien/Data/Collection.php:373 Stack trace: #0 /home/huisent/public_html/staging/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(265): Varien_Data_Collection->addItem(Object(Mage_Catalog_Model_Product)) #1 /home/huisent/public_html/staging/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(1055): Mage_Eav_Model_Entity_Collection_Abstract->addItem(Object(Mage_Catalog_Model_Product)) #2 /home/huisent/public_html/staging/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(871): Mage_Eav_Model_Entity_Collection_Abstract->_loadEntities(false, false) #3 /home/huisent/public_html/staging/lib/Varien/Data/Collection.php(741): Mage_Eav_Model_Entity_Collection_Abstract->load() #4 /home/huisent/public_html/staging/advertentieFeed/removeLF.php(94): Varien_Data_Collection->getIterator() #5 {main} thrown in /home/huisent/public_html/staging/lib/Varien/Data/Collection.php on line 373

[CODE]

require '../app/Mage.php';
Mage::app("default");

$products = Mage::getModel('catalog/product')->getCollection();
$products->joinField(
'qty',
'cataloginventory/stock_item',
'qty',
'product_id=entity_id',
'{{table}}.stock_id=1',
'left'
);

  //Id;Extra;Description;Price;Title;Image1;Image2;Image3;Image4;Image5;Image6;Image7;Image8;Url
$products->addAttributeToFilter('status', 1);
$products->addAttributeToFilter('visibility', 4);
$products->addAttributeToSelect('id');
$products->addAttributeToSelect('description');
$products->addAttributeToSelect('price');
$products->addAttributeToSelect('name');
$products->addAttributeToSelect('image');
$products->addAttributeToSelect('url');
$products->addAttributeToSelect('sku');
$products->addAttributeToSelect('media_gallery');

****/* SKIPPING PART BEGIN
*/****
 $products->joinField('category_id',
'catalog/category_product',
'category_id',
'product_id=entity_id',
null,
'left' 
);
*** END SKIPINNG PART ***

/* Selection of wanted categories */
$products->addAttributeToFilter('category_id', array('in' => array($CAT_ID1,$CAT_ID2,$CAT_ID3,$CAT_ID4,$CAT_ID5)));

Best Answer

I think the part where you're joining to category_product selects double items. Try adding a Zend_Db_Select::distinct() to the collection

$products->getSelect()->distinct();

or use a group by

$product->getSelect()->group('e.entity_id');

Related Solutions

Magento 1.9 Installation – Fix Invalid Backend Model for Zitec: Site Branding

Look in the table eav_attribute for a record with backend_model = 'scena/catalog_attribute_backend_cimage' and delete the row.
Clear the cache when you are done.

[EDIT]
I took a look through the extension code.
To completely uninstall the extension you need to remove the tables zitec_branding_store and zitec_branding. and remove the extension from the core_resource table` with

DELETE FROM `core_resource` WHERE `code` = 'zitec_branding_setup';

The extension does not add any product or category attributes. My hunch is that you have an other extension that is responsible for this error.
I see that you have an extension called BL_CustomGrid that has an eval in it. Never use extensions that have eval in their php code. Even if they might work, they are very dangerous.

Magento – SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘core_store’ doesn’t exist

The table you are looking for is a simple table.

When your host restored your database, it sounds like it did not have the core_store table inside of it. Also, it might be that there is a table prefix that might or might not be at play here.

Try these first:

Check your database to ensure there is a core_store (or variant) table available.
Check to make sure your local.xml config file is pointing to the right database.
Ask your host to restore from another restore point.
Check to ensure your local.xml didn't have a table prefix recently added or removed.

If that does not work, you can always do raw SQL inside your database.

PLEASE NOTE: TEST THIS ON A NON PRODUCTION ENVIRONMENT BEFORE PRODUCTION!

Core Store Table:

CREATE TABLE `core_store` (
  `store_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Store Id',
  `code` varchar(32) DEFAULT NULL COMMENT 'Code',
  `website_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Website Id',
  `group_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Group Id',
  `name` varchar(255) NOT NULL COMMENT 'Store Name',
  `sort_order` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Sort Order',
  `is_active` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Activity',
  PRIMARY KEY (`store_id`),
  UNIQUE KEY `UNQ_core_store_CODE` (`code`),
  KEY `IDX_core_store_WEBSITE_ID` (`website_id`),
  KEY `IDX_core_store_IS_ACTIVE_SORT_ORDER` (`is_active`,`sort_order`),
  KEY `IDX_core_store_GROUP_ID` (`group_id`),
  CONSTRAINT `FK_core_store_GROUP_ID_core_store_GROUP_GROUP_ID` FOREIGN KEY (`group_id`) REFERENCES `core_store_group` (`group_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_core_store_WEBSITE_ID_WBCORE_WEBSITE_WEBSITE_ID` FOREIGN KEY (`website_id`) REFERENCES `wbcore_website` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Stores';

Insert default entries:

INSERT INTO `core_store` VALUES (0,'admin',0,0,'Admin',0,1),(1,'default',1,1,'Default Store View',0,1);

Best Answer

Related Solutions

Magento 1.9 Installation – Fix Invalid Backend Model for Zitec: Site Branding

Magento – SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘core_store’ doesn’t exist

Related Topic