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 > > > > > __________________________________ > Do you Yahoo!? > Read only the mail you want - Yahoo! Mail SpamGuard. > http://promotions.yahoo.com/new_mail > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >
