Magento - SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '234-0-1-343' for key 1 - How do I? Questions - eCommerce Software for Growth

Log In

Username or Email

Password:

Forgot Password

or
Register

Skip to site navigation »
Skip to main content »
Skip to footer content »

Magento Forum

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘234-0-1-343’ for key 1

chiefair Total Posts: 1681 Joined: 2009-06-04 Ignore user	As a long term solution. Hmm… 1- “Integrity constraint violation: 1062 Duplicate entry “ Solution: This error can be solved by disabling the unique indexes check. Signature ----- 1) For preserving thy future happiness, thou shalt back up thy HTTP doc directories and Magento database regularly. 2) For preserving thy sanity during module installs and moves, thou shalt disable thy cache and compiler and flush their caches.
	Posted: February 22 2012 \| top \| # 16

websymphonies Total Posts: 1 Joined: 2011-11-03 Ignore user	For some reason, this was happening to me when I tried to import a product CSV with more than 1 line of information. Turns out the catalog price rules were conflicting here for some reason. Possibly because a product was added after they were created? I just deleted the price rules and it fixed the issue. I noticed this by searching for the longer number ‘1340755200’ from the error message and found ths in the catalogrule_product table.
	Posted: June 27 2012 \| top \| # 17

SimonWatts Total Posts: 18 Joined: 2012-01-08 Ignore user	I am having a some what similar problem to this that doesn’t seem to be solved by any of the obvious fixes like clearing cache, reindexing, truncating, repair db through phpmyadmin, repair db through magento tool. Magento Version : 1.6.1 CE Server : Dedicated server, 2 x 2.1GHz AMD Opteron 12 Core Processor, 32GB ram, Ubuntu server (14 i think) Error message is : SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘XXXXX-1’ for key ‘UNQ_CATALOGINVENTORY_STOCK_ITEM_PRODUCT_ID_STOCK_ID’ The problem arises when creating a new product. You hit save and you are presented with this error. XXXXX is equal to the current product id that you are creating (foreign key to the catalog_product_entity table) and 1 is an entry in the cataloginventry_stock table. The product is correctly created and everything seems in tact from a user POV once this error is removed - the product looks to be correct throughout the db including the table where the constraint error is thrown. Logic leads me to believe this means that the product models create function must be running the insert script for that portion of the product twice (at least? maybe more?). The server was in test mode and not seeing any issues. After it moved to production there will still no issues for a while (3 months approx). This problem all of a sudden manifested (several users on the system no one can tell that they did anything to cause this error and I can not find any logs that imply anything serious happened). Since product there have been no updates to the product model, and since this is vanilla magento installation for the product side of things (nothing like simple configurable products which i have read can be an issue) this is leading me to think that some data (perhaps cause by a transaction failing and not rolling back?) is stuck in a table, this is in turn causing the code to call two (or more?) inserts on the CATALOGINVENTORY_STOCK_ITEM table. My concern is that bad data is rapidly building up as new products are failing this process and this is subsequently effecting performance in other places (reindexing now takes what is officially considered an age). Perhaps someone has an idea of something else I can try with this issue? Or can point me to the data that the product create methods are looking at to generate the insert statement for that table? Any idea great appreciated. Thanks Simon Watts http://www.waterirrigation.co.uk/
	Posted: August 16 2012 \| top \| # 18

bijalbhavsar99 Total Posts: 70 Joined: 2009-04-13 Ahmedabad Ignore user	Hello, I hope reindex will resolve your problem. If you want to reindex using script than you can use below script: `// reindex everything!!! $processes = Mage::getSingleton('index/indexer')->getProcessesCollection(); $processes->walk('setMode', array(Mage_Index_Model_Process::MODE_REAL_TIME)); $processes->walk('save'); $processes->walk('reindexAll'); $processes->walk('reindexEverything');` Thanks, Bijal Bhavsar Signature MageCracker - [Lets Crack the code ] Mage Cracker
	Posted: January 8 2013 \| top \| # 19

Anand_Girish Total Posts: 4 Joined: 2012-03-30 Ignore user	I tried reindexing using my script but no luck actually the problem is with the duplicate id in cataloginventory_stock_status_idx table… Signature Thanks Girish Anand
	Posted: February 6 2013 \| top \| # 20

Magento Community

Magento Community

Back to top

Remove ’add to cart’ from category

Missing URL information in config.