Re: errno 150 - foreign key problems

[Paul Blazek]

Hi Heikki,

Thanks for jumping in - I believe the underlying cause of the problem is possibly in MySQL Administrator - the original FUN_Function table was InnoDB referencing COD_Code (another InnoDB table) - I changed the name COD_Code to TCO_Code and the column name CODlCodeKey to TCOlCodeKey first, and then when I tried to modify FUN_Function to change FUNCODlFunctionAccessKey to FUNTCOlFunctionAccessKey my troubles started. I ended up recreating the table in MyISAM for temporary use but I could not get rid of the orphaned constraint in InnoDB.

Following your suggestion I recreated the original tables with the original column names and discovered several orphaned constraints. Dropping the FOREIGN KEYs manually I was then able to drop the tables and alter the engine of FUN_Function to InnoDB. I think, though, that this still may be a bug in either MySQL Administrator or in the DROP TABLE functionality that caused the constratints to be orphaned.

Thanks again,

Paul