SQLSTATE 23000 Integrity constraint violation 1062 Duplicate entry 1922-1 for key IDX STOCK PRODUCT

Question

While creating product  at the last step after retrieving for a time  Magento gives following error-      SQLSTATE 23000   Integrity constraint violation  1062 Duplicate entry  1922-1  for key  IDX STOCK PRODUCT    What I am doing is  by capturing product id  I am putting it s entry in custom table  I have connected to Magento database externally   Surprisingly data is inserted in both Magento s base table  amp  also in Custom table but why it is giving me that error after product saving      I cleared cache  browser cookies  Also remove  var cache   var session  still giving error  Can anybody suggest a solution

User · Answer

I also encountered this problem  I found after changing the table storage engine from MyISAM to Innodb  problem solved

User · Answer

your column value is already in database table  it means your table column is Unique you should change your value  and try again

User · Answer

Try to change the FK to INDEX instead of UNIQUE

User · Answer

Many time this error is caused when you update a product in your custom module s observer as shown below   class  NAMESPACE   MODULE NAME  Model Observer                  Flag to stop observer executing more than once                var static bool             static protected   singletonFlag   false       public function saveProductData Varien Event Observer  observer                if   self    singletonFlag                self    singletonFlag   true                product    observer- gt getEvent  - gt getProduct                   do stuff to the  product object                 product- gt save        commenting out this line prevents the error              product- gt getResource  - gt save  product              Hence whenever you save your product after updating some properties in your module s observer use  product- gt getResource  - gt save  product  instead of  product- gt save

User · Answer

I just added an   symbol and it started working  Like this    product- gt save

User · Answer

You might have forgotten to auto increment the id field

User · Answer

the message means you are doing another insert with the same combination of columns that are part of the IDX STOCK PRODUCT  which seams to be defined as UNIQUE  If it is so  it doesn t allow to enter same combination  it seems like it consists of two fields  twice    If you are inserting records  make sure you are picking brand new record id or that the combination of record id and the other column is unique    Without detailed table structure and your code  we can hardly guess whats going wrong

[magento] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1922-1' for key 'IDX_STOCK_PRODUCT'

Examples related to magento

Examples related to constraints

Examples related to mysql-error-1062

Examples related to duplicates