MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: ERROR 1005: Can't create table (errno: 121) Help
Posted by: AAA BBB
Date: April 25, 2008 02:07PM

For me this error was caused my having FKs in different tables use the same CONSTRAINT name/symbol. As expected, it was corrected by renaming the CONSTRAINT in the table that was giving the error.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
ERROR 1005: Can't create table (errno: 121) Help
324550
Stephen Baker
July 12, 2005 11:49AM
Re: ERROR 1005: Can't create table (errno: 121) Help
145382
Shweta Gadgil
July 18, 2005 10:12PM
Re: ERROR 1005: Can't create table (errno: 121) Help
133752
development
July 19, 2005 12:37AM
Re: ERROR 1005: Can't create table (errno: 121) Help
89281
Willumpie de Jong
March 15, 2006 06:35AM
Re: ERROR 1005: Can't create table (errno: 121) Help
70584
Tafadzwa Karimazondo
December 20, 2007 03:05PM
Re: ERROR 1005: Can't create table (errno: 121) Help
118178
Heikki Tuuri
March 15, 2006 03:17PM
Re: ERROR 1005: Can't create table (errno: 121) Help
39906
Fred Riley
May 05, 2006 10:49AM
Re: ERROR 1005: Can't create table (errno: 121) Help
16734
Cooper Quintin
December 11, 2008 04:29AM
Re: ERROR 1005: Can't create table (errno: 121) Help
17925
Michael Soliman
August 30, 2006 07:00AM
Re: ERROR 1005: Can't create table (errno: 121) Help
16444
Christian An
September 03, 2006 05:50AM
Re: ERROR 1005: Can't create table (errno: 121) Help
16556
Hsing-Tsu Lai
September 03, 2006 10:47AM
Re: ERROR 1005: Can't create table (errno: 121) Help
13080
bhanu prasad
May 29, 2007 05:25AM
Re: ERROR 1005: Can't create table (errno: 121) Help
16321
Vladimir Gorokhov
October 25, 2007 08:21AM
Re: ERROR 1005: Can't create table (errno: 121) Help
10314
danielle davis
February 19, 2009 08:39AM
Re: ERROR 1005: Can't create table (errno: 121) Help
10945
Chemi Peña
June 08, 2007 10:41AM
Re: ERROR 1005: Can't create table (errno: 121) Help
10420
James Troi
March 23, 2006 04:07PM
Re: ERROR 1005: Can't create table (errno: 121) Help
8689
Lanny Day
July 06, 2006 10:02AM
Re: ERROR 1005: Can't create table (errno: 121) Help
8805
Paul Pikowsky
July 26, 2006 03:34PM
Re: ERROR 1005: Can't create table (errno: 121) Help
8034
Mourad DRAOUIL
September 19, 2007 04:47AM
Re: ERROR 1005: Can't create table (errno: 121) Help
10973
Eric Brunson
September 12, 2006 12:53PM
Re: ERROR 1005: Can't create table (errno: 121) Help
9466
Prabhakar Kasi
June 06, 2007 07:37AM
Re: ERROR 1005: Can't create table (errno: 121) Help
13432
charles sheinin
March 06, 2008 06:22PM
Re: ERROR 1005: Can't create table (errno: 121) Help
8474
AAA BBB
April 25, 2008 02:07PM
Re: ERROR 1005: Can't create table (errno: 121) Help
5705
m h
January 28, 2009 05:16AM
Re: ERROR 1005: Can't create table (errno: 121) Help
16529
morgan mora
February 23, 2009 07:16PM
Re: ERROR 1005: Can't create table (errno: 121) Help
7698
Bernie Glynn
April 28, 2009 01:06AM
Re: ERROR 1005: Can't create table (errno: 121) Help
16878
John Wilson
May 22, 2009 09:04AM


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.