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

[T D]

Thanks, i found one more common problem:

3. make sure the column charset of both foreign and reference key are the same, e.g. utf8 and utf8, not utf8 and latin1

Victor Cherkassky Wrote:
-------------------------------------------------------
> Hello everyone having such a trouble. Sorry if i
> have duplicated some of your responses, but i have
> just had and resolved such a trouble in my DB.
>
> Here are cases you can have such a trouble (if i
> am wrong, please correct me and we'll summarize
> those stuff):
> 1. You have incompatible types of keys (for
> example, your foreign key is bigint and reference
> key is integer(11))
> 2. You have different engines specified for your
> tables (that was my trouble - had parent MyISAM
> and child InnoDB)
>
> If you have some more or some corrects, please
> make a new list in your post.