MySQL Most common solution for "ERROR 1005 (HY000): Can't create table (errno: 150)"

MySQL sucks and one reason (of many) of this are error messages.

Ok this error annoyed me for 1 hour, check everything but not the type of columns! they must be the same type and not null!

At symfony primary keys are created as BIGINT, not INT...check that!