SQL STATE(23000) error while adding product from supplier panel

[Vijayiitr]

Hi Guys,

Getting Error SQLSTATE(23000):Integrity constraint violation:1062 Duplicate entry 331 for key Primary, query was:Insert INTO 'catalog_product_entity'(entity id , attribute set id, type id, sku,has options, required options)values(?????).

I am getting above error while adding products from supplier panel. Any suggestion please.

Thanks 

Vijay

[ShoaibRehman89 · Accepted solution]

@Vijayiitr

For some reason, your Magento installation is trying to write/cache products whose IDs don't exist in your current catalog, catalog_product_entity. Catalog search results are saved in catalogsearch_result, each unique query will have a set of corresponding results saved in this table. This is why some of your search queries work and others don't work.

My guess is that Magento is using data from your indexed catalog search fulltext table, which is not up-to-date with your latest catalog. It seems like a full reindex should take care of it, unless you have made customization to the catalog search.