magento \"Cannot add or update a child row: a foreign key constraint fails\"

In Progress Posted Apr 29, 2013 Paid on delivery
In Progress Paid on delivery

Magento expert needed to fix problem. The issue has been occured since I have deleted a category in admin.

The problem occurs when click on product page. It gives a "404 Not Found error" on all product pages in frontend.

Next exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`mydb`.`report_viewed_product_index`, CONSTRAINT `FK_REPORT_VIEWED_PRODUCT_INDEX_PRODUCT` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE O)' in /var/www/vhosts/mysite/httpdocs/lib/Zend/Db/Statement/[login to view URL]:234.

I need this fixed asap.

It may be nothing but PLEASE only coders that know how to fix the fault.

Magento MySQL

Project ID: #4473077

About the project

5 proposals Remote project Active Apr 29, 2013

5 freelancers are bidding on average €116 for this job

ForeignTree

Ready to work

€103 EUR in 10 days
(7 Reviews)
2.8
bistanil98

Need to discuss this in detail,please tell me how we can start the discussion on this requirement. for more detail check in Private Message. We have a team of professionals,they have more than 11 year of experience,so More

€226 EUR in 10 days
(18 Reviews)
6.5
satish5178

Hi , I know how to fix it.

€44 EUR in 0 days
(0 Reviews)
0.0
babbypathak

i have six years experience french e-commerce, magento site and catalog processing services. plz provide me job i try my best. my skype id is babbypathak

€165 EUR in 3 days
(0 Reviews)
0.0