Tip Mysql : Cannot delete or update a parent row: a foreign key constraint fails

Code

For those of you who are faced to this type of error, the command “SHOW ENGINE INNODB STATUS;” is your friend.

[...]
------------------------
LATEST FOREIGN KEY ERROR
------------------------
130322 12:03:42  Cannot drop table `test`.`events`
because it is referenced by `test`.`attachments`
[...]

Here it is my 2 cents of the day ;)