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

Pågående Publicerat Apr 29, 2013 Betalades vid leverans
Pågående Betalades vid leverans

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

Projekt-id: #4473077

About the project

5 offerter Distansprojekt Aktivt Apr 29, 2013

5 frilansare har lagt bud på i genomsnitt €116 för det här jobbet

ForeignTree

Ready to work

€103 EUR inom 10 dagar
(7 omdömen)
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 Mer

€226 EUR inom 10 dagar
(18 omdömen)
6.5
satish5178

Hi , I know how to fix it.

€44 EUR inom 0 dagar
(0 omdömen)
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 inom 3 dagar
(0 omdömen)
0.0