Skip navigation links

MySQL Forums


Advanced Search

ERROR 1005: Can't create table (errno: 150)
Posted by: elmpie ()
Date: March 24, 2005 01:20PM

I'm using the MySql version that comes with the Debian Sarge.
(mysql Ver 12.22 Distrib 4.0.23, for pc-linux-gnu (i386))

I already have one database that has a few tables with foreign keys.

I've created a anew database and it seems impossible to put new foreign keys on these tables?
So I've tried the most basic thing ans its still not working.

create table test1 (pk_alias int not null auto_increment,
primary key (pk_alias)) type=innodb;

create table test2 (pk_alias2 int unsigned not null auto_increment,
fk_test1 int not null, primary key (pk_alias2),
foreign key (fk_test1) references test1(pk_alias)) type=innodb;


I don't really get it. What am I doing wrong??

Thanks!

Options: Reply•Quote


Subject Views Written By Posted
ERROR 1005: Can't create table (errno: 150) 171557 elmpie 03/24/2005 01:20PM
Re: ERROR 1005: Can't create table (errno: 150) 88016 Martin Lukasiewycz 03/28/2005 02:15PM
Re: ERROR 1005: Can't create table (errno: 150) 68515 KimSeong Loh 03/29/2005 08:42PM
Re: ERROR 1005: Can't create table (errno: 150) 53631 Michael Buell 05/30/2005 10:29AM
Re: ERROR 1005: Can't create table (errno: 150) 50370 Chris Yuan 10/27/2005 11:01PM
Re: ERROR 1005: Can't create table (errno: 150) 30189 Deepak Kumar 03/14/2008 11:45PM
ERROR 1005: Can't create table (errno: 150) 21703 Pradeep Max 07/07/2008 09:00AM
Re: ERROR 1005: Can't create table (errno: 150) 9702 karthik sakthi 03/12/2009 07:38AM
Re: ERROR 1005: Can't create table (errno: 150) 7125 Agyeya Gupta 04/26/2009 06:23AM
Re: ERROR 1005: Can't create table (errno: 150) 4090 Chris Walker 06/28/2009 12:40PM
Re: ERROR 1005: Can't create table (errno: 150) [SOLVED] 6111 Chris Walker 06/28/2009 12:41PM
Re: ERROR 1005: Can't create table (errno: 150) [SOLVED] 2764 Jitendra Gupta 09/04/2009 02:30AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 29096 chaotical_impulse 06/09/2005 04:01AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 25056 chaotical_impulse 06/09/2005 04:22AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 17727 Vishal Mody 07/20/2005 03:02PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 68415 Maria Modeste 08/03/2005 08:08PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 16660 KimSeong Loh 08/04/2005 02:57AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 18546 Maria Modeste 08/06/2005 08:38PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 15632 KimSeong Loh 08/06/2005 11:07PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 14310 KimSeong Loh 08/07/2005 06:52PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 12104 jacob wood 08/09/2005 09:43AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 12875 Maria Modeste 08/10/2005 06:23PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 8991 mySQL newbie 11/30/2005 01:11AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 5142 Halil Özgür 06/24/2008 02:43PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 2649 Todd S 02/03/2009 02:26PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 4157 Pradeep Max 07/07/2008 07:37AM
ERROR 1005: Can't create table (errno: 150) :: InnoDB 4865 Thomas Rasoarahona 07/10/2008 08:29AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 1400 Bill Monk 05/19/2009 02:43PM
Solution to Bill Monk's problem creating table structures. 1466 Mohamed Infiyaz Zaffer Khalid 05/19/2009 10:17PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 757 David Chell 07/19/2009 11:28PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 735 Mohamed Infiyaz Zaffer Khalid 07/20/2009 06:34AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 14911 Maria Modeste 08/07/2005 10:06AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 13148 Edwin Dando 09/10/2005 04:31PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 5261 KimSeong Loh 09/11/2005 04:40AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 5528 max ac 04/20/2007 04:54AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 4922 KimSeong Loh 04/29/2007 10:05PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 4450 Brian Couchman 10/20/2005 09:52AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 3725 Sean Jones 10/30/2005 10:51PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 3526 Sean Jones 10/30/2005 10:52PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 11804 iker landajuela 11/10/2005 04:24AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 4079 dammika priyakumara 11/14/2006 05:42AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 3692 Anadi Misra 08/08/2007 07:06AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 3709 James Day 08/08/2007 05:24PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 3419 Sean Jones 10/30/2005 10:37PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 3295 sheryl tesoro 12/19/2005 05:24AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 3336 Felix Geerinckx 12/19/2005 06:19AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 3335 Jim Campbell 02/08/2008 10:19PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 3935 Jim Campbell 02/08/2008 10:34PM
my script 3495 dan bilauca 05/09/2006 06:01PM
Re: my script 2952 kevin martin 11/15/2006 02:05PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 1721 Steve Cavanagh 12/02/2008 09:05PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 983 Marc Binder 05/08/2009 01:56AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 1033 Mohamed Infiyaz Zaffer Khalid 05/08/2009 05:23AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 1633 Jaco Imthorn 11/24/2008 07:20AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 1681 Kola Yusuf 01/05/2009 04:58AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 3503 Maxim Shumov 10/23/2007 02:34PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 2697 Ian Channing 12/07/2007 11:41AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 2193 Suman Kirti 04/21/2008 03:38PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB ---- [Solved] 900 Manimaran Ramaraj 08/21/2009 06:18AM
The Answer 4 FK Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB ---- [Solved] 952 yvonne kire 08/21/2009 05:00PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 2805 elango elango 12/07/2005 12:51AM
Can't create table (errno: 150) :: InnoDB 3831 Vikram Tambe 05/13/2008 09:38AM
Solved! Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 1058 T D 06/25/2009 03:30AM
Re: Solved! Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 879 Roland Booth 06/26/2009 10:23AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 1696 krishnakumar M 10/14/2008 04:36AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 1437 Mikhail Shalai 12/02/2008 09:05AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 1259 Ankit Garg 02/17/2009 01:46AM
Re: ERROR 1005: Can't create table (errno: 150) 3422 José Martínez Benavides 12/06/2005 06:22AM
Re: ERROR 1005: Can't create table (errno: 150) 1323 Łukasz Grzenkowicz 03/18/2009 11:56AM
Re: ERROR 1005: Can't create table (errno: 150) 1081 Lisa DeSouza 04/23/2009 07:03AM
Re: ERROR 1005: Can't create table (errno: 150) 3097 satya pal 12/16/2005 12:53AM
Re: ERROR 1005: Can't create table (errno: 150) 2732 emir mahmut bahsi 05/18/2006 12:01PM
Re: ERROR 1005: Can't create table (errno: 150) Possible solution 4631 FREDERIC BEGIN 01/03/2006 11:53AM
Re: ERROR 1005: Can't create table (errno: 150) Possible solution 3458 DnlCY 05/03/2006 06:23AM
Re: ERROR 1005: Can't create table (errno: 150) 2747 Gilles GUEDIKIAN 06/15/2006 07:56AM
Re: ERROR 1005: Can't create table (errno: 150) 3281 Paul Carey 02/27/2007 10:58AM
Re: ERROR 1005: Can't create table (errno: 150) 3284 amol.viit 04/03/2007 07:40PM
Re: ERROR 1005: Can't create table (errno: 150) 2556 KimSeong Loh 04/05/2007 08:57PM
Re: ERROR 1005: Can't create table (errno: 150) 2631 Filippo Monti 10/25/2006 02:14AM
Re: ERROR 1005: Can't create table (errno: 150) 2421 Brendan Abbott 10/25/2006 09:11PM
Re: ERROR 1005: Can't create table (errno: 150) 2826 Albert Arul prakash Rajendran 04/25/2007 03:23AM
Re: ERROR 1005: Can't create table (errno: 150) 2697 Anadi Misra 08/08/2007 07:09AM
Re: ERROR 1005: Can't create table (errno: 150) 2854 Felix Geerinckx 08/08/2007 07:13AM
Re: ERROR 1005: Can't create table (errno: 150) 3516 Alexei Guevara 08/22/2007 09:34AM
Re: ERROR 1005: Can't create table (errno: 150) 2502 Wagner Bianchi 12/17/2007 04:31PM
Re: ERROR 1005: Can't create table (errno: 150) 3368 Andrey Svitlow 01/12/2008 06:00AM
Re: ERROR 1005: Can't create table (errno: 150) 2902 Victor Cherkassky 01/18/2008 06:34AM
Re: ERROR 1005: Can't create table (errno: 150) 2464 T D 02/01/2008 06:47AM
Re: ERROR 1005: Can't create table (errno: 150) 2456 Bug Me Not 02/12/2008 04:46AM
Re: ERROR 1005: Can't create table (errno: 150) [Probable Solution] 4230 Kishore Bulusu 02/16/2008 01:29PM
Re: ERROR 1005: Can't create table (errno: 150) [Probable Solution] 3694 JOBY JOB 03/05/2008 02:59AM
Re: ERROR 1005: Can't create table (errno: 150) [Probable Solution] 3163 Willem P 03/17/2008 07:00AM
Re: ERROR 1005: Can't create table (errno: 150) [Probable Solution] 2652 Roberto Linares 04/09/2008 11:25AM
Re: ERROR 1005: Can't create table (errno: 150) [Probable Solution] 3369 Adam Franco 04/16/2008 01:37PM
Re: ERROR 1005: Can't create table (errno: 150) 3328 Håkan Askengren 02/26/2008 11:46PM
Re: ERROR 1005: Can't create table (errno: 150) 3053 C Fischer 05/30/2008 07:43AM
Re: ERROR 1005: Can't create table (errno: 150) [Oracle Conversion Potential Solution] 2979 Kevin Clark 06/03/2008 06:52AM
Re: ERROR 1005: Can't create table (errno: 150) 2939 Eduardo Chico 06/17/2008 09:39PM
This worked for me 3449 Kyle Stevens 08/27/2008 08:08AM
A solution to: ERROR 1005: Can't create table (errno: 150) 4673 Andrew Pitonyak 09/10/2008 12:37PM
Re: A solution to: ERROR 1005: Can't create table (errno: 150) 826 Bhanu Nadendla 06/10/2009 02:29PM
Re: A solution to: ERROR 1005: Can't create table (errno: 150) 717 ka sanoob 06/29/2009 07:17AM
Considerations: Re: ERROR 1005: Can't create table (errno: 150) 2280 Albert Lombarte 10/22/2008 05:31AM
Unsigned was the problem!! 3243 Franck Mercado 12/03/2008 10:15AM
He's right 1147 Liron Homapour 05/01/2009 07:39AM
Re: ERROR 1005: Can't create table (errno: 150) 3480 Stefan Wallin 11/12/2008 01:20PM
Re: ERROR 1005: Can't create table (errno: 150) 2969 Erin W 12/05/2008 11:05AM
Re: ERROR 1005: Can't create table (errno: 150) 1380 banaz kaki 05/05/2009 02:52PM
SOLVED: Here's my solution to ERROR 1005: Can't create table (errno: 150) 2316 Mohamed Infiyaz Zaffer Khalid 05/07/2009 10:50AM
SOLVED AGAIN: More info - Error 1005 is connected to Error 1452 1781 Mohamed Infiyaz Zaffer Khalid 05/07/2009 10:12PM
Re: ERROR 1005: Can't create table (errno: 150) 1107 Juan Carlos Rubiano 05/25/2009 10:50AM
Re: ERROR 1005: Can't create table (errno: 150) 1130 kashif murtaa 06/02/2009 08:22PM
PLEASE STATE YOUR PROBLEM Re: ERROR 1005 (errno: 150) 1169 Mohamed Infiyaz Zaffer Khalid 06/02/2009 10:04PM
Re: PLEASE STATE YOUR PROBLEM Re: ERROR 1005 (errno: 150) 1139 Felix Glez 06/08/2009 01:28AM
Re: PLEASE STATE YOUR PROBLEM Re: ERROR 1005 (errno: 150) 1334 Felix Glez 06/08/2009 02:04AM
Re: PLEASE STATE YOUR PROBLEM Re: ERROR 1005 (errno: 150) 1332 Andrew Pitonyak 06/28/2009 03:41PM
Re: ERROR 1005: Can't create table (errno: 150) 1254 Jeremy Hatcher 08/12/2009 09:29AM
Re: ERROR 1005: Can't create table (errno: 150) 556 Aftab Haider 10/19/2009 03:09AM


Sorry, only registered users may post in this forum.
Click here to login
powered by phorum