I'm having the following issue:
SQLSTATE: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (
FK_RATING_ENTITY_ID_RATING_ENTITY_ENTITY_IDFOREIGN KEY (
entity_id) ON DELETE CASCADE ON UPDATE CASCADE), query was: INSERT INTO
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!