Skip navigation links

MySQL Forums


Advanced Search

Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB
Posted by: chaotical_impulse ()
Date: June 09, 2005 04:22AM

In the manual search for this chapter "Creating InnoDB Tables" and the title "FOREIGN KEY Constraints"...

Foreign keys definitions are subject to the following conditions:

- Both tables must be InnoDB type.

- In the referencing table, there must be an index where the foreign key columns are listed as the first columns in the same order.

- In the referenced table, there must be an index where the referenced columns are listed as the first columns in the same order.

- Index prefixes on foreign key columns are not supported. One consequence of this is that BLOB and TEXT columns cannot be included in a foreign key, because indexes on those columns must always include a prefix length.

Options: Reply•Quote


Subject Views Written By Posted
ERROR 1005: Can't create table (errno: 150) 171741 elmpie 03/24/2005 01:20PM
Re: ERROR 1005: Can't create table (errno: 150) 88091 Martin Lukasiewycz 03/28/2005 02:15PM
Re: ERROR 1005: Can't create table (errno: 150) 68575 KimSeong Loh 03/29/2005 08:42PM
Re: ERROR 1005: Can't create table (errno: 150) 53678 Michael Buell 05/30/2005 10:29AM
Re: ERROR 1005: Can't create table (errno: 150) 50412 Chris Yuan 10/27/2005 11:01PM
Re: ERROR 1005: Can't create table (errno: 150) 30215 Deepak Kumar 03/14/2008 11:45PM
ERROR 1005: Can't create table (errno: 150) 21726 Pradeep Max 07/07/2008 09:00AM
Re: ERROR 1005: Can't create table (errno: 150) 9722 karthik sakthi 03/12/2009 07:38AM
Re: ERROR 1005: Can't create table (errno: 150) 7143 Agyeya Gupta 04/26/2009 06:23AM
Re: ERROR 1005: Can't create table (errno: 150) 4100 Chris Walker 06/28/2009 12:40PM
Re: ERROR 1005: Can't create table (errno: 150) [SOLVED] 6133 Chris Walker 06/28/2009 12:41PM
Re: ERROR 1005: Can't create table (errno: 150) [SOLVED] 2792 Jitendra Gupta 09/04/2009 02:30AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 29110 chaotical_impulse 06/09/2005 04:01AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 25070 chaotical_impulse 06/09/2005 04:22AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 17743 Vishal Mody 07/20/2005 03:02PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 68452 Maria Modeste 08/03/2005 08:08PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 16678 KimSeong Loh 08/04/2005 02:57AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 18570 Maria Modeste 08/06/2005 08:38PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 15638 KimSeong Loh 08/06/2005 11:07PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 14315 KimSeong Loh 08/07/2005 06:52PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 12111 jacob wood 08/09/2005 09:43AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 12883 Maria Modeste 08/10/2005 06:23PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 8996 mySQL newbie 11/30/2005 01:11AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 5148 Halil Özgür 06/24/2008 02:43PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 2653 Todd S 02/03/2009 02:26PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 4162 Pradeep Max 07/07/2008 07:37AM
ERROR 1005: Can't create table (errno: 150) :: InnoDB 4871 Thomas Rasoarahona 07/10/2008 08:29AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 1405 Bill Monk 05/19/2009 02:43PM
Solution to Bill Monk's problem creating table structures. 1470 Mohamed Infiyaz Zaffer Khalid 05/19/2009 10:17PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 760 David Chell 07/19/2009 11:28PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 739 Mohamed Infiyaz Zaffer Khalid 07/20/2009 06:34AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 14927 Maria Modeste 08/07/2005 10:06AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 13157 Edwin Dando 09/10/2005 04:31PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 5265 KimSeong Loh 09/11/2005 04:40AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 5534 max ac 04/20/2007 04:54AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 4926 KimSeong Loh 04/29/2007 10:05PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 4453 Brian Couchman 10/20/2005 09:52AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 3730 Sean Jones 10/30/2005 10:51PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 3532 Sean Jones 10/30/2005 10:52PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 11815 iker landajuela 11/10/2005 04:24AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 4083 dammika priyakumara 11/14/2006 05:42AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 3695 Anadi Misra 08/08/2007 07:06AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 3712 James Day 08/08/2007 05:24PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 3423 Sean Jones 10/30/2005 10:37PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 3298 sheryl tesoro 12/19/2005 05:24AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 3339 Felix Geerinckx 12/19/2005 06:19AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 3339 Jim Campbell 02/08/2008 10:19PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 3939 Jim Campbell 02/08/2008 10:34PM
my script 3500 dan bilauca 05/09/2006 06:01PM
Re: my script 2955 kevin martin 11/15/2006 02:05PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 1725 Steve Cavanagh 12/02/2008 09:05PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 988 Marc Binder 05/08/2009 01:56AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 1037 Mohamed Infiyaz Zaffer Khalid 05/08/2009 05:23AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 1637 Jaco Imthorn 11/24/2008 07:20AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 1685 Kola Yusuf 01/05/2009 04:58AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 3505 Maxim Shumov 10/23/2007 02:34PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 2702 Ian Channing 12/07/2007 11:41AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 2196 Suman Kirti 04/21/2008 03:38PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB ---- [Solved] 911 Manimaran Ramaraj 08/21/2009 06:18AM
The Answer 4 FK Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB ---- [Solved] 958 yvonne kire 08/21/2009 05:00PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 2809 elango elango 12/07/2005 12:51AM
Can't create table (errno: 150) :: InnoDB 3835 Vikram Tambe 05/13/2008 09:38AM
Solved! Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 1060 T D 06/25/2009 03:30AM
Re: Solved! Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 885 Roland Booth 06/26/2009 10:23AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 1700 krishnakumar M 10/14/2008 04:36AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 1440 Mikhail Shalai 12/02/2008 09:05AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB 1263 Ankit Garg 02/17/2009 01:46AM
Re: ERROR 1005: Can't create table (errno: 150) 3425 José Martínez Benavides 12/06/2005 06:22AM
Re: ERROR 1005: Can't create table (errno: 150) 1328 Łukasz Grzenkowicz 03/18/2009 11:56AM
Re: ERROR 1005: Can't create table (errno: 150) 1084 Lisa DeSouza 04/23/2009 07:03AM
Re: ERROR 1005: Can't create table (errno: 150) 3102 satya pal 12/16/2005 12:53AM
Re: ERROR 1005: Can't create table (errno: 150) 2736 emir mahmut bahsi 05/18/2006 12:01PM
Re: ERROR 1005: Can't create table (errno: 150) Possible solution 4636 FREDERIC BEGIN 01/03/2006 11:53AM
Re: ERROR 1005: Can't create table (errno: 150) Possible solution 3463 DnlCY 05/03/2006 06:23AM
Re: ERROR 1005: Can't create table (errno: 150) 2752 Gilles GUEDIKIAN 06/15/2006 07:56AM
Re: ERROR 1005: Can't create table (errno: 150) 3284 Paul Carey 02/27/2007 10:58AM
Re: ERROR 1005: Can't create table (errno: 150) 3287 amol.viit 04/03/2007 07:40PM
Re: ERROR 1005: Can't create table (errno: 150) 2559 KimSeong Loh 04/05/2007 08:57PM
Re: ERROR 1005: Can't create table (errno: 150) 2634 Filippo Monti 10/25/2006 02:14AM
Re: ERROR 1005: Can't create table (errno: 150) 2423 Brendan Abbott 10/25/2006 09:11PM
Re: ERROR 1005: Can't create table (errno: 150) 2830 Albert Arul prakash Rajendran 04/25/2007 03:23AM
Re: ERROR 1005: Can't create table (errno: 150) 2701 Anadi Misra 08/08/2007 07:09AM
Re: ERROR 1005: Can't create table (errno: 150) 2860 Felix Geerinckx 08/08/2007 07:13AM
Re: ERROR 1005: Can't create table (errno: 150) 3519 Alexei Guevara 08/22/2007 09:34AM
Re: ERROR 1005: Can't create table (errno: 150) 2505 Wagner Bianchi 12/17/2007 04:31PM
Re: ERROR 1005: Can't create table (errno: 150) 3376 Andrey Svitlow 01/12/2008 06:00AM
Re: ERROR 1005: Can't create table (errno: 150) 2906 Victor Cherkassky 01/18/2008 06:34AM
Re: ERROR 1005: Can't create table (errno: 150) 2466 T D 02/01/2008 06:47AM
Re: ERROR 1005: Can't create table (errno: 150) 2460 Bug Me Not 02/12/2008 04:46AM
Re: ERROR 1005: Can't create table (errno: 150) [Probable Solution] 4234 Kishore Bulusu 02/16/2008 01:29PM
Re: ERROR 1005: Can't create table (errno: 150) [Probable Solution] 3696 JOBY JOB 03/05/2008 02:59AM
Re: ERROR 1005: Can't create table (errno: 150) [Probable Solution] 3167 Willem P 03/17/2008 07:00AM
Re: ERROR 1005: Can't create table (errno: 150) [Probable Solution] 2656 Roberto Linares 04/09/2008 11:25AM
Re: ERROR 1005: Can't create table (errno: 150) [Probable Solution] 3373 Adam Franco 04/16/2008 01:37PM
Re: ERROR 1005: Can't create table (errno: 150) 3332 Håkan Askengren 02/26/2008 11:46PM
Re: ERROR 1005: Can't create table (errno: 150) 3057 C Fischer 05/30/2008 07:43AM
Re: ERROR 1005: Can't create table (errno: 150) [Oracle Conversion Potential Solution] 2982 Kevin Clark 06/03/2008 06:52AM
Re: ERROR 1005: Can't create table (errno: 150) 2944 Eduardo Chico 06/17/2008 09:39PM
This worked for me 3455 Kyle Stevens 08/27/2008 08:08AM
A solution to: ERROR 1005: Can't create table (errno: 150) 4678 Andrew Pitonyak 09/10/2008 12:37PM
Re: A solution to: ERROR 1005: Can't create table (errno: 150) 831 Bhanu Nadendla 06/10/2009 02:29PM
Re: A solution to: ERROR 1005: Can't create table (errno: 150) 721 ka sanoob 06/29/2009 07:17AM
Considerations: Re: ERROR 1005: Can't create table (errno: 150) 2284 Albert Lombarte 10/22/2008 05:31AM
Unsigned was the problem!! 3247 Franck Mercado 12/03/2008 10:15AM
He's right 1152 Liron Homapour 05/01/2009 07:39AM
Re: ERROR 1005: Can't create table (errno: 150) 3488 Stefan Wallin 11/12/2008 01:20PM
Re: ERROR 1005: Can't create table (errno: 150) 2972 Erin W 12/05/2008 11:05AM
Re: ERROR 1005: Can't create table (errno: 150) 1385 banaz kaki 05/05/2009 02:52PM
SOLVED: Here's my solution to ERROR 1005: Can't create table (errno: 150) 2327 Mohamed Infiyaz Zaffer Khalid 05/07/2009 10:50AM
SOLVED AGAIN: More info - Error 1005 is connected to Error 1452 1788 Mohamed Infiyaz Zaffer Khalid 05/07/2009 10:12PM
Re: ERROR 1005: Can't create table (errno: 150) 1113 Juan Carlos Rubiano 05/25/2009 10:50AM
Re: ERROR 1005: Can't create table (errno: 150) 1138 kashif murtaa 06/02/2009 08:22PM
PLEASE STATE YOUR PROBLEM Re: ERROR 1005 (errno: 150) 1176 Mohamed Infiyaz Zaffer Khalid 06/02/2009 10:04PM
Re: PLEASE STATE YOUR PROBLEM Re: ERROR 1005 (errno: 150) 1144 Felix Glez 06/08/2009 01:28AM
Re: PLEASE STATE YOUR PROBLEM Re: ERROR 1005 (errno: 150) 1340 Felix Glez 06/08/2009 02:04AM
Re: PLEASE STATE YOUR PROBLEM Re: ERROR 1005 (errno: 150) 1336 Andrew Pitonyak 06/28/2009 03:41PM
Re: ERROR 1005: Can't create table (errno: 150) 1258 Jeremy Hatcher 08/12/2009 09:29AM
Re: ERROR 1005: Can't create table (errno: 150) 566 Aftab Haider 10/19/2009 03:09AM


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