List:General Discussion« Previous MessageNext Message »
From:Tom Brown Date:April 22 2004 1:55pm
Subject:Re: Create table results in (errno: 121)
View as plain text  
> Is it indexed?
>
> And don't forget you can use the command
> SHOW INNODB STATUS\G
>
> to show the last FK related error.

ahh yes - i did not know about this command

------------------------
LATEST FOREIGN KEY ERROR
------------------------
040422 14:39:09 Error in foreign key constraint creation for table
TNMailServer/TNSession.
A foreign key constraint of name TNMailServer/0_20
already exists (note that internally InnoDB adds 'databasename/'
in front of the user-defined constraint name).

thankyou for your quick response as this has fixed my error

Tom


Thread
Create table results in (errno: 121)Tom Brown22 Apr
  • Re: Create table results in (errno: 121)Martijn Tonies22 Apr
  • Re: Create table results in (errno: 121)Tom Brown22 Apr
  • Re: Create table results in (errno: 121)Adam28 Apr
    • urban myth?Boyd E. Hemphill3 May
      • Re: urban myth?Peter J Milanese3 May
      • Re: urban myth?Daniel Clark3 May
      • Re: urban myth?Garth Webb3 May
        • Re: urban myth?Bob Ramsey3 May
          • Re: urban myth?Josh Trutwin3 May
          • Re: urban myth?Garth Webb3 May
          • Re: urban myth?Michael Stassen3 May
            • RE: urban myth?Boyd E. Hemphill3 May
              • Re: urban myth?Anders Karlsson3 May
              • Re: urban myth?Michael T. Babcock13 May
      • Re: urban myth?Josh Trutwin3 May
      • Re: urban myth?Jeremy Zawodny3 May
      • Re: urban myth?gerald_clark3 May
        • Re: urban myth?Peter J Milanese3 May
Re: Create table results in (errno: 121)beacker22 Apr
RE: urban myth?Mike Johnson3 May
Re: urban myth?Udikarni3 May