cancel
Showing results for 
Search instead for 
Did you mean: 

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

SOLVED

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

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

1 ACCEPTED SOLUTION

Accepted Solutions

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

@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.

Magento Certified Solution Specialist | Lead Magento developer
If this response was helpful to you, consider giving kudos to this post

View solution in original post

1 REPLY 1

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

@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.

Magento Certified Solution Specialist | Lead Magento developer
If this response was helpful to you, consider giving kudos to this post