I'm having the following issue:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (
db12038032-fsm
.rating
, CONSTRAINTFK_RATING_ENTITY_ID_RATING_ENTITY_ENTITY_ID
FOREIGN KEY (entity_id
) REFERENCESrating_entity
(entity_id
) ON DELETE CASCADE ON UPDATE CASCADE), query was: INSERT INTOrating
(entity_id
,rating_code
,position
) VALUES (?, ?, ?)
It pops up when I want to create a "rating" (Admin > Catalog > Ratings > Manage Ratings). (! Might not be the correct English expressions !)
Using Magento 1.9.1
Customers also can't add ratings in the frontend. There is also a error message like: "Review could not be transferred."
What I've already tried:
- Magento DB-Repair-Tool
- DROP TABLE rating, rating_entity.. and so on > then Magento DB-Repair Tool
I already tried to come to know SQL Syntax better but this error message has so many hints so that I'm struggling on which point I should work on. There might be any old module which makes some troubles, but I couldn't figure it out yet..
Your help is really appreciated!