jueves 21 de abril de 2011

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!
Google Analytics Alternative