SQLSTATE[23000]: Integrity constraint violation

I’m trying to populate content into my site, and when I go to add a product, I get the following error notification:

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

Where ‘1-1’ is the same as ‘X-1’, with X changing each time I try to add a product.

Can someone please tell me how to fix this problem.

What I am doing is creating a downloadable product, using an attribute set I previously made. No matter what I do to create a new product, I get that notification every time.

Any help is greatly appreciated. I can’t start putting products into my site until I fix this.


1 answer

Profile photo of Daniel Pegues 0.00 $tone December 22, 2011

Hello. Although the reply is not posted here from JoomlArt, thanks for the reply. What I did was I disabled each extension one at a time. I was then able to discover which extension was causing the problem. It turned out to be a problem with a custom extension I had developed for my MarketPlace. I contacted the developer, and they fixed the problem.

Thanks JA for the suggestion.


This question is now closed

Written By