I have no results and see exception in exception.log file :Error:SQLSTATE[23000]: Integrity constraint > violation: 1452 Cannot add or update a child row: a foreign key > constraint fails

This situation happens if you are removing products from magento non-magento way, so lucene index is not aware of that and is still trying to serve products which don't exists anymore.


Switch off module in administration (Lucene enabled on frontend to NO)
Remove var/indexer (in your magento root) folder completely
Reindex again (from SSH or using web browser)
Enable module again (Lucene enabled on frontend to YES)



Article is closed for comments.
Powered by Zendesk