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 add these commands at the top and bottom of the sql file

SET FOREIGN_KEY_CHECKS = 0; -- TOP
SET FOREIGN_KEY_CHECKS = 1; -- BOTTOM

that will disable constraints check