Re: Foreign Key Error 121

[Stephen Lynch]

Heikki,

Still getting the same error.

There is nothing much in the error log. Do I need to configure any params in the ini file for error logging?

060410 12:44:02 InnoDB: Started; log sequence number 0 85424452
C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-nt: ready for connections.
Version: '4.1.14-nt-log' socket: '' port: 3306 Official MySQL binary


mysql> DROP DATABASE full_fusion;
Query OK, 1 row affected (0.39 sec)

mysql>
mysql> CREATE DATABASE full_fusion;
Query OK, 1 row affected (0.00 sec)

mysql>
mysql> use full_fusion;
Database changed
mysql>
mysql> CREATE TABLE parent (a INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql> CREATE TABLE child (a INT NOT NULL PRIMARY KEY, CONSTRAINT FK_staffmember
s_3 FOREIGN KEY (a) REFERENCES parent (a)) ENGINE=InnoDB;
ERROR 1005 (HY000): Can't create table '.\full_fusion\child.frm' (errno: 121)

show innodb status shows the same problem I get with my own table definition.


>If yes, please show the table definitions in the SQL dump relevant for >FK_staffmembers_3.

Im not sure what you mean by this. The table definition of the table that has this constraint name? I can give it to you, but creating the above child table proves its not my table definition.

Thanks,
Stephen