Re: ERROR 1005: Can't create table (errno: 150) [Probable Solution]

[Willem P]

Hello to all,

This problem occurs also in Master-Detail situations:

CREATE TABLE `master`.`master_detail` (
`id` int(10) unsigned NOT NULL auto_increment,
`idmaster` int(10) unsigned NOT NULL COMMENT 'Column idmaster references MASTER_record column id',
....

I solved the error by changing next line:
`idmaster` int(11) NOT NULL COMMENT 'Column....
into
`idmaster` int(10) unsigned NOT NULL COMMENT 'Column....

With 'MySQL Administrator' you can see the error because 'idmaster' changes form 'INT' to 'INTEGER' and checkbox 'unisgned' will be checked.'

Bye.