MySQL Forums :: InnoDB :: ERROR 1005: Can't create table (errno: 150)

Re: ERROR 1005: Can't create table (errno: 150) [ANOTHER SOLUTION]

Posted by: Jim Smith ()

Date: January 11, 2010 10:23AM

In my case, the problem was that the NAMES of the foreign keys were not unique.
I wasn't aware that this was a requirement, but changing them worked.
So I changed the line:
KEY `fk_productid`
to
KEY `fk_productid222`

And it worked! (This was because another table was using the foreign key name "fk_productid"

Navigate: Previous Message•Next Message

Options: Reply•Quote

Subject	Views	Written By	Posted
ERROR 1005: Can't create table (errno: 150)	578924	elmpie	03/24/2005 01:20PM
Re: ERROR 1005: Can't create table (errno: 150)	280745	Martin Lukasiewycz	03/28/2005 02:15PM
Re: ERROR 1005: Can't create table (errno: 150)	202032	KimSeong Loh	03/29/2005 08:42PM
Re: ERROR 1005: Can't create table (errno: 150)	146602	Michael Buell	05/30/2005 10:29AM
Re: ERROR 1005: Can't create table (errno: 150)	141063	Chris Yuan	10/27/2005 11:01PM
Re: ERROR 1005: Can't create table (errno: 150)	87165	Deepak Kumar	03/14/2008 11:45PM
ERROR 1005: Can't create table (errno: 150)	68055	Pradeep Max	07/07/2008 09:00AM
Re: ERROR 1005: Can't create table (errno: 150)	46563	karthik sakthi	03/12/2009 07:38AM
Re: ERROR 1005: Can't create table (errno: 150) Global solution	45794	Mayur P Vegad	06/23/2010 08:13AM
Re: ERROR 1005: Can't create table (errno: 150) Global solution	16825	B S	08/13/2011 09:04PM
unfortunately not	2433	Gavin Stokes	10/09/2012 09:48PM
Re: ERROR 1005: Can't create table (errno: 150)	34526	Agyeya Gupta	04/26/2009 06:23AM
Re: ERROR 1005: Can't create table (errno: 150)	23754	Chris Walker	06/28/2009 12:40PM
Re: ERROR 1005: Can't create table (errno: 150) [SOLVED]	44882	Chris Walker	06/28/2009 12:41PM
Re: ERROR 1005: Can't create table (errno: 150) [SOLVED]	26923	Jitendra Gupta	09/04/2009 02:30AM
Re: ERROR 1005: Can't create table (errno: 150) [ANOTHER SOLUTION]	26001	Jim Smith	01/11/2010 10:23AM
Re: ERROR 1005: Can't create table (errno: 150) [ANOTHER SOLUTION]	9174	Esen Sagynov	04/17/2011 05:39AM
Re: ERROR 1005: Can't create table (errno: 150) [SOLVED]	10876	noor afies prasetyo	11/03/2010 10:10PM
Re: ERROR 1005: Can't create table (errno: 150) [SOLVED]	756	marius m	12/17/2012 07:52AM
Re: ERROR 1005: Can't create table (errno: 150) [SOLUTION]	15971	Stefan Catalin	01/29/2010 05:15AM
Re: ERROR 1005: Can't create table (errno: 150) [SOLUTION]	11616	Mahesh Raju	05/11/2010 03:36AM
Re: ERROR 1005: Can't create table (errno: 150)	6464	Petrica Martinescu	04/09/2010 02:05AM
Re: ERROR 1005: Can't create table (errno: 150)	2255	Prasad Kothe	12/19/2011 01:49AM
Do not reply to this thread!	2036	Rick James	12/19/2011 10:13PM
Re: ERROR 1005: Can't create table (errno: 150)	2436	Jayesh Tejwani	08/12/2011 12:19PM
Re: ERROR 1005: Can't create table (errno: 150)	3834	Dan Beavon	10/20/2010 03:59AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	41918	chaotical_impulse	06/09/2005 04:01AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	40015	chaotical_impulse	06/09/2005 04:22AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	32764	Vishal Mody	07/20/2005 03:02PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	145321	Maria Modeste	08/03/2005 08:08PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	26138	KimSeong Loh	08/04/2005 02:57AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	28797	Maria Modeste	08/06/2005 08:38PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	23881	KimSeong Loh	08/06/2005 11:07PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	21791	KimSeong Loh	08/07/2005 06:52PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	18382	jacob wood	08/09/2005 09:43AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	19217	Maria Modeste	08/10/2005 06:23PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	2633	Dave Kelly	12/30/2010 06:06AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	3552	Mahder Gebremedhin	01/01/2011 04:45PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	2378	Mile Stojanov	01/08/2011 01:56PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	2187	Mile Stojanov	01/08/2011 01:59PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	13933	mySQL newbie	11/30/2005 01:11AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	9954	Halil Özgür	06/24/2008 02:43PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	7190	Todd S	02/03/2009 02:26PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	8497	Pradeep Max	07/07/2008 07:37AM
ERROR 1005: Can't create table (errno: 150) :: InnoDB	13681	Thomas Rasoarahona	07/10/2008 08:29AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	3172	marat beiner	05/11/2010 06:02AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	5872	Bill Monk	05/19/2009 02:43PM
Solution to Bill Monk's problem creating table structures.	6423	Mohamed Infiyaz Zaffer Khalid	05/19/2009 10:17PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	4808	David Chell	07/19/2009 11:28PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	4818	Mohamed Infiyaz Zaffer Khalid	07/20/2009 06:34AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	35707	Maria Modeste	08/07/2005 10:06AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	24995	Edwin Dando	09/10/2005 04:31PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	9244	KimSeong Loh	09/11/2005 04:40AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	13114	max ac	04/20/2007 04:54AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	9099	KimSeong Loh	04/29/2007 10:05PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	8253	Brian Couchman	10/20/2005 09:52AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	7439	Sean Jones	10/30/2005 10:51PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	7202	Sean Jones	10/30/2005 10:52PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	41491	iker landajuela	11/10/2005 04:24AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	8575	dammika priyakumara	11/14/2006 05:42AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	675	Abdul Ismail	09/17/2012 03:27AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	7811	Anadi Misra	08/08/2007 07:06AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	7768	James Day	08/08/2007 05:24PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	7296	Sean Jones	10/30/2005 10:37PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	6906	sheryl tesoro	12/19/2005 05:24AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	7040	Felix Geerinckx	12/19/2005 06:19AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	7105	Jim Campbell	02/08/2008 10:19PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	7994	Jim Campbell	02/08/2008 10:34PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	3826	Gary machol	04/21/2010 04:55AM
my script	7454	dan bilauca	05/09/2006 06:01PM
Re: my script	6881	kevin martin	11/15/2006 02:05PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	2241	Guillermo Gutiérrez	10/23/2010 05:23PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	5432	Steve Cavanagh	12/02/2008 09:05PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	4484	Marc Binder	05/08/2009 01:56AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	1344	andrea manconi	10/11/2011 02:30AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	5219	Jaco Imthorn	11/24/2008 07:20AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	6921	Kola Yusuf	01/05/2009 04:58AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	1308	ken wang	08/11/2011 02:04AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	943	Chris Moreland	02/15/2012 02:10PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	777	Bellfalasch -	05/07/2012 08:08AM
DO NOT add to this thread! Start a new one!	758	Rick James	05/08/2012 09:19AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	2008	Aniruddha Manakeshwar	02/21/2012 11:05AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	7428	Maxim Shumov	10/23/2007 02:34PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	6264	Ian Channing	12/07/2007 11:41AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	5804	Suman Kirti	04/21/2008 03:38PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB ---- [Solved]	7828	Manimaran Ramaraj	08/21/2009 06:18AM
The Answer 4 FK Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB ---- [Solved]	8344	yvonne kire	08/21/2009 05:00PM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	6342	elango elango	12/07/2005 12:51AM
Can't create table (errno: 150) :: InnoDB	10266	Vikram Tambe	05/13/2008 09:38AM
Solved! Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	6252	T D	06/25/2009 03:30AM
Re: Solved! Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	5163	Roland Booth	06/26/2009 10:23AM
Re: Solved! Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	1514	Colleen Boye	12/13/2011 12:43PM
[Solved] Re: Solved! Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	2246	Anand H	02/10/2011 07:24AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	2204	Arturs Pelniks	08/04/2010 03:04AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	5179	krishnakumar M	10/14/2008 04:36AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	5002	Mikhail Shalai	12/02/2008 09:05AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	4780	Ankit Garg	02/17/2009 01:46AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB	3095	perez kakaire	06/22/2010 06:42AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB: Solved	3486	perez kakaire	06/22/2010 06:44AM
Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB: Solved	3035	David Brown	06/29/2010 07:48AM
Re: ERROR 1005: Can't create table (errno: 150)	7268	José Martínez Benavides	12/06/2005 06:22AM
Re: ERROR 1005: Can't create table (errno: 150)	6644	Łukasz Grzenkowicz	03/18/2009 11:56AM
Re: ERROR 1005: Can't create table (errno: 150)	4615	Lisa DeSouza	04/23/2009 07:03AM
Re: ERROR 1005: Can't create table (errno: 150)	6732	satya pal	12/16/2005 12:53AM
Re: ERROR 1005: Can't create table (errno: 150)	6287	emir mahmut bahsi	05/18/2006 12:01PM
Re: ERROR 1005: Can't create table (errno: 150) Possible solution	9803	FREDERIC BEGIN	01/03/2006 11:53AM
Re: ERROR 1005: Can't create table (errno: 150) Possible solution	7426	DnlCY	05/03/2006 06:23AM
Re: ERROR 1005: Can't create table (errno: 150)	6238	Gilles GUEDIKIAN	06/15/2006 07:56AM
Re: ERROR 1005: Can't create table (errno: 150)	7448	Paul Carey	02/27/2007 10:58AM
Re: ERROR 1005: Can't create table (errno: 150)	7732	amol.viit	04/03/2007 07:40PM
Re: ERROR 1005: Can't create table (errno: 150)	5937	KimSeong Loh	04/05/2007 08:57PM
Re: ERROR 1005: Can't create table (errno: 150)	6214	Filippo Monti	10/25/2006 02:14AM
Re: ERROR 1005: Can't create table (errno: 150)	5894	Brendan Abbott	10/25/2006 09:11PM
Re: ERROR 1005: Can't create table (errno: 150)	6390	Albert Arul prakash Rajendran	04/25/2007 03:23AM
Re: ERROR 1005: Can't create table (errno: 150)	6211	Anadi Misra	08/08/2007 07:09AM
Re: ERROR 1005: Can't create table (errno: 150)	6345	Felix Geerinckx	08/08/2007 07:13AM
Re: ERROR 1005: Can't create table (errno: 150)	6920	Alexei Guevara	08/22/2007 09:34AM
Re: ERROR 1005: Can't create table (errno: 150)	5898	Wagner Bianchi	12/17/2007 04:31PM
Re: ERROR 1005: Can't create table (errno: 150)	9268	Andrey Svitlow	01/12/2008 06:00AM
Re: ERROR 1005: Can't create table (errno: 150)	6371	Victor Cherkassky	01/18/2008 06:34AM
Re: ERROR 1005: Can't create table (errno: 150)	6060	T D	02/01/2008 06:47AM
Re: ERROR 1005: Can't create table (errno: 150)	5942	Bug Me Not	02/12/2008 04:46AM
Re: ERROR 1005: Can't create table (errno: 150) [Probable Solution]	9085	Kishore Bulusu	02/16/2008 01:29PM
Re: ERROR 1005: Can't create table (errno: 150) [Probable Solution]	8461	JOBY JOB	03/05/2008 02:59AM
Re: ERROR 1005: Can't create table (errno: 150) [Probable Solution]	7169	Willem P	03/17/2008 07:00AM
Re: ERROR 1005: Can't create table (errno: 150) [Probable Solution]	2731	karthik bhaskaran	06/11/2010 02:55AM
Re: ERROR 1005: Can't create table (errno: 150) [Probable Solution]	6360	Roberto Linares	04/09/2008 11:25AM
Re: ERROR 1005: Can't create table (errno: 150) [Probable Solution]	7674	Adam Franco	04/16/2008 01:37PM
Re: ERROR 1005: Can't create table (errno: 150)	6786	Håkan Askengren	02/26/2008 11:46PM
Re: ERROR 1005: Can't create table (errno: 150)	8369	C Fischer	05/30/2008 07:43AM
Re: ERROR 1005: Can't create table (errno: 150) [Oracle Conversion Potential Solution]	7597	Kevin Clark	06/03/2008 06:52AM
Re: ERROR 1005: Can't create table (errno: 150)	6357	Eduardo Chico	06/17/2008 09:39PM
This worked for me	7548	Kyle Stevens	08/27/2008 08:08AM
A solution to: ERROR 1005: Can't create table (errno: 150)	11497	Andrew Pitonyak	09/10/2008 12:37PM
Re: A solution to: ERROR 1005: Can't create table (errno: 150)	4541	Bhanu Nadendla	06/10/2009 02:29PM
Re: A solution to: ERROR 1005: Can't create table (errno: 150)	4288	ka sanoob	06/29/2009 07:17AM
Considerations: Re: ERROR 1005: Can't create table (errno: 150)	5995	Albert Lombarte	10/22/2008 05:31AM
Unsigned was the problem!!	8138	Franck Mercado	12/03/2008 10:15AM
He's right	4747	Liron Homapour	05/01/2009 07:39AM
Re: ERROR 1005: Can't create table (errno: 150)	3233	elliot Justice	01/26/2010 12:34PM
Re: ERROR 1005: Can't create table (errno: 150)	11857	Stefan Wallin	11/12/2008 01:20PM
Re: ERROR 1005: Can't create table (errno: 150)	6621	Erin W	12/05/2008 11:05AM
Re: ERROR 1005: Can't create table (errno: 150)	5330	banaz kaki	05/05/2009 02:52PM
SOLVED AGAIN: More info - Error 1005 is connected to Error 1452	6128	Mohamed Infiyaz Zaffer Khalid	05/07/2009 10:12PM
Re: ERROR 1005: Can't create table (errno: 150)	4634	Juan Carlos Rubiano	05/25/2009 10:50AM
Re: ERROR 1005: Can't create table (errno: 150)	4675	kashif murtaa	06/02/2009 08:22PM
PLEASE STATE YOUR PROBLEM Re: ERROR 1005 (errno: 150)	4901	Mohamed Infiyaz Zaffer Khalid	06/02/2009 10:04PM
Re: PLEASE STATE YOUR PROBLEM Re: ERROR 1005 (errno: 150)	4776	Felix Glez	06/08/2009 01:28AM
Re: PLEASE STATE YOUR PROBLEM Re: ERROR 1005 (errno: 150)	4860	Felix Glez	06/08/2009 02:04AM
Re: PLEASE STATE YOUR PROBLEM Re: ERROR 1005 (errno: 150)	5057	Andrew Pitonyak	06/28/2009 03:41PM
Re: ERROR 1005 (errno: 150)	1857	Glenn Strickland	08/29/2011 04:46PM
Re: ERROR 1005: Can't create table (errno: 150)	5024	Jeremy Hatcher	08/12/2009 09:29AM
Re: ERROR 1005: Can't create table (errno: 150)	3638	s l	12/15/2009 01:48PM
Re: ERROR 1005: Can't create table (errno: 150)	4861	Aftab Haider	10/19/2009 03:09AM
my problem were different data types	3565	Sebastian Kahl	12/22/2009 02:54AM
Re: ERROR 1005: Can't create table (errno: 150)	3227	Max Mir	02/01/2010 01:49PM
Re: ERROR 1005: Can't create table (errno: 150)	3255	Tuan Nguyen	02/20/2010 09:56PM
Re: ERROR 1005: Can't create table (errno: 150) (Potential solution)	4832	Niranjan Hoskote	03/02/2010 02:06PM
Re: PARENT HAS GOOD SOLUTIONS!	1895	raachachacha	02/18/2011 08:55AM
Re: ERROR 1005: Can't create table (errno: 150) - Please help	3692	Anil Karamchandani	03/14/2010 12:41AM
Re: ERROR 1005: Can't create table (errno: 150) - Please help	3154	Vishwanath Savakar	04/15/2010 07:10AM
Re: ERROR 1005: Can't create table (errno: 150)	3081	Nick Blackwood	04/24/2010 04:47PM
Re: ERROR 1005: Can't create table (errno: 150)	3362	Jacques Meyer	04/28/2010 01:51PM
Re: ERROR 1005: Can't create table (errno: 150) [SOLVED]	3696	Ivan Gromov	07/06/2010 07:36AM
Re: ERROR 1005: Can't create table (errno: 150)	2283	Bill Cogan	07/09/2010 12:21PM
Re: ERROR 1005: Can't create table (errno: 150). [SOLVED] An other solution	3845	Adrian Meyer	07/12/2010 12:49PM
Re: ERROR 1005: Can't create table (errno: 150)	2673	Arturs Pelniks	08/04/2010 05:43AM
Re: ERROR 1005: Can't create table (errno: 150) - my SOLUTION	3031	David Cardoso	09/21/2010 03:31PM
Re: ERROR 1005: Can't create table (errno: 150) - my SOLUTION	2624	Luca Porro	09/27/2010 02:23AM
Re: ERROR 1005: Can't create table (errno: 150) - my SOLUTION	2326	David Cardoso	10/06/2010 03:23PM
Re: ERROR 1005: Can't create table (errno: 150) DEFINITE SOLUTION!!!	3961	Emin Ogur	10/07/2010 10:25PM
Re: ERROR 1005: Can't create table (errno: 150) DEFINITE SOLUTION!!!	4086	Mahder Gebremedhin	10/08/2010 06:54PM
Re: ERROR 1005: Can't create table (errno: 150) [SOLVED]	3092	Nacho Pas	01/26/2011 12:32PM
Re: ERROR 1005: Can't create table (errno: 150)	3704	Kann Vearasilp	11/05/2010 09:08AM
Re: Known Causes PLUS ONE	2389	asd asd	05/24/2011 10:11AM
Re: ERROR 1005: Can't create table (errno: 150)	2435	acoolme.com hulu	08/17/2011 11:24PM
Re: ERROR 1005: Can't create table (errno: 150)	19831	Chetan Dhumale	11/18/2011 12:31AM
Various reasons and solutions for Error 150 (and other foreign key errors)	1997	Philip Flammer	06/07/2012 01:22AM
Re: ERROR 1005: Can't create table (errno: 150)	916	Fredrik k	07/25/2012 08:38AM
ERROR 1005: Can't create table (errno: 150) (New solution)	2546	Yomna Mahmoud	07/30/2012 06:05AM
Re: ERROR 1005: Can't create table (errno: 150) (New solution)	1713	Babak Bandpey	09/25/2012 07:19AM
Yet another mismatch (yet another solution)	1049	Gavin Stokes	10/09/2012 10:24PM
Re: ERROR 1005: Can't create table (errno: 150)	839	Marko Mäkelä	01/13/2013 04:39AM

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.