Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘18856-1’ for key 2
 
sasupo
Member
 
Total Posts:  38
Joined:  2010-07-31
 

I try to add new products to my magento 1.7.0.2 store and after saving it I get this error: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘18856-1’ for key 2

any Idea what can be wrong?

I did not make some changes, updates or installed some new extensions at all.

Thanks for any advice

File Attachments
1234960209457.txt  (File Size: 3KB - Downloads: 24)
 
Magento Community Magento Community
Magento Community
Magento Community
 
srmobile
Sr. Member
 
Total Posts:  276
Joined:  2011-10-25
 

What happens when you try and reindex your site?

 
Magento Community Magento Community
Magento Community
Magento Community
 
sasupo
Member
 
Total Posts:  38
Joined:  2010-07-31
 

it get reindexed normaly but the error still exist

 
Magento Community Magento Community
Magento Community
Magento Community
 
srmobile
Sr. Member
 
Total Posts:  276
Joined:  2011-10-25
 

I assume you’ve already tried restarting your MySQL server?

Can you post the contents of you my.cnf ? (MYSQL configuration file)

SR

 
Magento Community Magento Community
Magento Community
Magento Community
 
sasupo
Member
 
Total Posts:  38
Joined:  2010-07-31
 

ok, I just hired a freelancer and he fixed this in 15 minutes

The solution was clearing log database with a script /mlx.php

Hope this will help someone wink

Thanks anyway for your help

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top