If you’re trying to import an sql file using symfony propel-insert-sql and you get this error :
ERROR 1005 (HY000): Can’t create table ‘Table.frm’ (errno: 150)
check this command output it’s really helpful :
mysql>SHOW ENGINE INNODB STATUS;
it will give you the detailed explanation about the most recent innoDB foreign key error.
If you are using a mysqldump file [...]