Magento定制模块中的完整性约束违规 [英] Integrity constraint violation in Magento custom module

问题描述

我有类似的原理在Magento中创建产品的完整性约束违反（未回覆），但是我正在创建一个自定义的观察者进入catalog_product_save_after事件 - 基于本教程： http：// fishpig.co.uk/blog/custom-tabs-magento-product-admin.html

I have a similar probelm to Integrity constraint violation creating Product in Magento (unanswered) but I am creating a custom Observer that hooks into the catalog_product_save_after event - based on this tutorial: http://fishpig.co.uk/blog/custom-tabs-magento-product-admin.html

无论何时保存新产品，都会收到此错误：

However whenever a new product is saved I get this error:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '22-1' for key 'UNQ_CATALOGINVENTORY_STOCK_ITEM_PRODUCT_ID_STOCK_ID'

config.xml如下所示：

The config.xml looks like this:

<adminhtml>
    <events>
        <catalog_product_save_after>
            <observers>
                <a1web_save_product_data>
                    <type>singleton</type>
                    <class>metricimperial/observer</class>
                    <method>saveProductData</method>
                </a1web_save_product_data>
            </observers>
        </catalog_product_save_after>
    </events>
</adminhtml>

课程大纲如下：

<?php

class A1web_MetricImperialConverter_Model_Observer
{
    /**
     * Flag to stop observer executing more than once
     *
     * @var static bool
     */
    static protected $_singletonFlag = false;

     * @param Varien_Event_Observer $observer
     */
    public function saveProductData(Varien_Event_Observer $observer)
    {
        if (!self::$_singletonFlag) {
               self::$_singletonFlag = true;

                $product = $observer->getEvent()->getProduct();

                //Custom updates made to product object here

                $product->save();
            }
            catch (Exception $e) {
                Mage::getSingleton('adminhtml/session')->addError($e->getMessage());
            }
        }
    }

    /**
     * Retrieve the product model
     *
     * @return Mage_Catalog_Model_Product $product
     */
    public function getProduct()
    {
        return Mage::registry('product');
    }

    /**
     * Shortcut to getRequest
     *
     */
    protected function _getRequest()
    {
        return Mage::app()->getRequest();
    }
}

该产品与自定义产品数据一致保存'添加 - 一旦产品保存，同一产品的后续保存不会发生错误。只是当产品首次创建时出现错误。

The product is saved correctly with the custom product data I'm adding - and once the product is saved the error does not occur on subsequent saves of the same product. It is just when the product is first created the error occurs.

提前感谢

推荐答案

而不是使用 $ product-> save（）尝试使用资源模型，la $ product-> getResource （） - > save（$ product）。

Instead of using $product->save() try using the resource model, a la $product->getResource()->save($product).

原因是 $ product-> save（） 将重新触发所有保存事件，因此运行保存cataloginventory_stock并抛出错误的任何内容。

The reason being $product->save() will re-trigger all save events, hence running whatever is saving the cataloginventory_stock and throwing the error.

这篇关于Magento定制模块中的完整性约束违规的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！