MySQL Forums
Forum List  »  InnoDB

Re: ERROR 1005: Can't create table (errno: 150)
Posted by: banaz kaki
Date: May 05, 2009 02:52PM

Hi!
I have read all of the inputs here regarding this 150 error, bur I cannot find a soluition to my problem. I use server version 5.0.41 and phpmyadmin version 2.10.1. The datatype of the attribute ID in the table Alternativ is the same as in the tables EttAlternativ and FleraAlternativ, IN(11) NOT NULL.The engine type is InnoDB, the three of them are not UNSIGNED and I eaven tried to create an index on the foreign key in the referencin tables. I´ll be very glad for any recomendations I can get to try.Here is my SQL statments:

Creation of table nr1:

CREATE TABLE Alternativ (FrageTypKod VARCHAR (50) NOT NULL ,
ID INT(11) NOT NULL) ENGINE=INNODB;

ALTER TABLE Alternativ ADD
CONSTRAINT PK_Alternativ
PRIMARY KEY (FrageTypKod,ID);

ALTER TABLE Alternativ ADD
CONSTRAINT FK_alternativ_fragetyp
FOREIGN KEY (FrageTypKod)
REFERENCES FrageTyp(Kod) ON UPDATE CASCADE ON DELETE CASCADE;

Cration of table nr2:
CREATE TABLE EttAlternativ (FrageTypKod VARCHAR (50) NOT NULL ,
AlternativID INT (11) NOT NULL,
SvarFrageNr INT (11) NOT NULL ,
SvarPersonRaknare INT (11) NOT NULL,
SvarOmradeNr VARCHAR (2) NOT NULL) ENGINE=INNODB;

ALTER TABLE EttAlternativ ADD
CONSTRAINT PK_EttAlternativ
PRIMARY KEY (SvarFrageNr,SvarPersonRaknare,SvarOmradeNr);

ALTER TABLE EttAlternativ ADD
CONSTRAINT FK_EttAlternativ
FOREIGN KEY (SvarFrageNr,SvarPersonRaknare,SvarOmradeNr)
REFERENCES Svar(FrageNr, PersonRaknare, OmradeNr)
ON UPDATE CASCADE ON DELETE CASCADE;

ALTER TABLE EttAlternativ ADD
CONSTRAINT FK_EttAlternativ_fragetyp
FOREIGN KEY (FrageTypKod)
REFERENCES FrageTyp(Kod) ON UPDATE CASCADE ON DELETE CASCADE;



I get the erro: 150 when I run this statment to crate an FK:

ALTER TABLE EttAlternativ ADD
CONSTRAINT FK_EttAlternativ_alt
FOREIGN KEY (AlternativID)
REFERENCES Alternativ(ID) ON UPDATE CASCADE ON DELETE CASCADE;

The erro I get is:#1005 - Can't create table '#sql-1801a_502d374.frm' (errno: 150)

Please help me see the problem...

Options: ReplyQuote


Subject
Views
Written By
Posted
645587
March 24, 2005 01:20PM
5170
October 09, 2012 09:48PM
3470
December 19, 2011 10:13PM
8876
May 09, 2006 06:01PM
8064
November 15, 2006 02:05PM
7116
T D
February 01, 2008 06:47AM
8919
August 27, 2008 08:08AM
9441
December 03, 2008 10:15AM
5901
May 01, 2009 07:39AM
Re: ERROR 1005: Can't create table (errno: 150)
6560
May 05, 2009 02:52PM
3123
August 29, 2011 04:46PM
4724
s l
December 15, 2009 01:48PM
4691
December 22, 2009 02:54AM
2982
February 18, 2011 08:55AM
3545
May 24, 2011 10:11AM


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.