List:General Discussion« Previous MessageNext Message »
From:Victoria Reznichenko Date:May 28 2004 3:42pm
Subject:Re: strange behaviour in foreign keys
View as plain text  
joao.miguel.ferreira.19740720@stripped wrote:
> 
> I've been running MySQL 4.0.x on a RH9 machine for some months and everything
> was fine. I could create tables of type InnoDB and define FOREIGN KEY's.... all
> was well.
> 
> A few days ago it does not let me create tables with foreign keys anymore.... it
> says something like "unable to create /databasename/tablename"...
> 
> If I remove the FOREIGN KEY constraint it accepts de table creation.
> 

You have incorrect foreign key definition. Use SHOW INNODB STATUS command to see more
detailed error message.



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   Victoria.Reznichenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
       <___/   www.mysql.com




Thread
strange behaviour in foreign keysjoao.miguel.ferreira.1974072028 May
  • Re: strange behaviour in foreign keysVictoria Reznichenko28 May