Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB

[Jaco Imthorn]

I cam across some solutions on another site; it read:

ERROR 1005: Can't create table './test/fkey_exmpl.frm' (errno: 150)
This means either:
* The referenced table is not an InnoDB table
* The referenced column in other_table is not unique
* The referenced column in other_table has a different type to other_id
In MySQL prior to 5.0, this error can also indicate that:
* No index has been defined on the column other_id

In my case (as was also mentioned before by someone else in this thread) the cause of the error was that 'the referenced column in other_table has a different type to other_id'. Specifically, I defined the field holding the foreign key as 'INT' whereas the field referenced was of type INT UNSIGNED.