:perror 150 MySQL error: 150 = Foreign key constraint is incorrectly formed
This is usually due to a missing index. To make a foreign key, both of the involved columns must come first in an index. Do you have indexes on msg_recipients.recipient_member_id and members.id?
Michael
[EMAIL PROTECTED] wrote:
run the command: SHOW INNODB STATUS; whenever you get those errors and it will give you more details.
Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Herman Scheepers <[EMAIL PROTECTED]> wrote on 10/13/2004 03:42:34 PM:
I tried to create a foreign key using:
ALTER TABLE msg_recipients ADD CONSTRAINT msg_recipient_member_fk FOREIGN KEY (recipient_member_id) REFERENCES members (id);
and got this error:
Can't create table '.\wapmagic\#sql-c50_48.frm' (errno: 150)
Any ideas?
Thanx Herman
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
