MySQL Bugs: #10325: Number's of foreign keys

Bug #10325	Number's of foreign keys
Submitted:	2 May 2005 23:35	Modified:	4 May 2005 8:10
Reporter:	Guy Morin	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server	Severity:	S1 (Critical)
Version:	4.1	OS:	Windows (windows xp)
Assigned to:		CPU Architecture:	Any

Description:
Hi,

I have 11 tables.  4 of them are reference tables with static information in it.  7 of it are to link all the others together in some functional way.  

While I was creating the tables, I was generating the foreign keys and out of the suddents, I could create some.  

errno 150 for #sql-d8_2.frm.  So I can't create other foreign keys.  If I just keep the fields as regular it is ok.

I had 6 forign keys when it gave me problems

How to repeat:
While I was creating the tables, I was generating the foreign keys and out of the suddents, I could create some.  

errno 150 for #sql-d8_2.frm.  So I can't create other foreign keys.  If I just keep the fields as regular it is ok.

I had 6 forign keys when it gave me problems

We're sorry, but the bug system is not the appropriate forum for 
asking help on using MySQL products. Your problem is not the result 
of a bug.

Support on using our products is available both free in our forums
at http://forums.mysql.com and for a reasonable fee direct from our
skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.

Additional info:

C:\my>perror 150
MySQL error code 150: Foreign key constraint is incorrectly formed

Use

SHOW INNODB STATUS

to get a detailed information about your foreign key error.

http://dev.mysql.com/doc/mysql/en/innodb-monitor.html