MySQL Forums :: InnoDB :: errno: 150 - foreign key constraint was not correctly formed


Advanced Search

errno: 150 - foreign key constraint was not correctly formed
Posted by: ()
Date: July 09, 2009 11:52AM

Hi

I would really appreciate any help with resolving the problem I appear to have with my foreign-key definition in the query below.

I have read http://dev.mysql.com/doc/refman/5.1/en/innodb-foreign-key-constraints.html but I still can't figure out where my query is malformed...

This is the error:
ERROR 1005 (HY000): Can't create table './myDB/sG.frm' (errno: 150)

The failing 'create table' query:
----
CREATE TABLE `sG`
(
`nID` mediumint(8) unsigned NOT NULL default '0',
`tabA` varchar(30) collate utf8_unicode_ci NOT NULL default '',
`lastUpdate` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`nID`,`tabA`),
KEY `permitabA_fkey` (`tabA`),
CONSTRAINT `permitabA_fkey` FOREIGN KEY (`tabA`) REFERENCES `permitSG` (`tabA`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
----

The referenced table:
----
CREATE TABLE `permitSG` (
`tabA` varchar(30) NOT NULL default '',
`desc` varchar(255) default NULL,
PRIMARY KEY (`tabA`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
----

Many thanks
NJH

Options: ReplyQuote


Subject Views Written By Posted
errno: 150 - foreign key constraint was not correctly formed 7938 07/09/2009 11:52AM
Re: errno: 150 - foreign key constraint was not correctly formed 2760 07/10/2009 04:33AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.