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 😉