完整性约束违规：1062重复条目“UNQ_CATALOG_PRODUCT_SUPER_ATTRIBUTE_PRODUCT_ID_ATTRIBUTE_ID”的重复条目“4974-134”

Question

I am getting the above error in Magento when adding a configurable product (before creating simple products)

This has worked but for some reason it is now failing.

The key value 4974-134 doesn't even exist in the table:

I've tried re-creating the table. I''ve cleare cache/log tables/re-indexed and nothing seems to work - each time the 4974 (product/entity_id) increments by 1 implying it is being created in the catalog_product_entity table but it isn't:

Answer 1

The only way that I could resolve this eventually was to extend/overwrite the Product model _afterSave function in a new module (make sure the new class extends extends Mage_Catalog_Model_Product).

Like so:

/**
 * Saving product type related data and init index
 *
 * @return Mage_Catalog_Model_Product
 */
protected function _afterSave()
{
    $this->getLinkInstance()->saveProductRelations($this);

    if($this->getTypeId() !== 'configurable')
    {
        $this->getTypeInstance(true)->save($this);
    }


    /**
     * Product Options
     */
    $this->getOptionInstance()->setProduct($this)
        ->saveOptions();

    $result = parent::_afterSave();

    Mage::getSingleton('index/indexer')->processEntityAction(
        $this, self::ENTITY, Mage_Index_Model_Event::TYPE_SAVE
    );
    return $result;
}

The key bit being:

if($this->getTypeId() !== 'configurable')
    {
        $this->getTypeInstance(true)->save($this);
    }

}

It looks like for some reason, when creating the configurable product it was trying to save an object that already existed in the resource adapter possibly - Some thoughts on this would be appreciated.