Re: re:FOREIGN KEY{ERROR:1005/150}

On Wed, Feb 11, 2009 at 7:36 PM, mrfroasty <mrfroasty@gmail.com> wrote: > Hello, > I have been browsing on mysql manual > > <http://dev.mysql.com/doc/refman/5.1/en/innodb-foreign-key-constraints.html> > with not much of success.I am trying to put 2 foreign keys(from > different external table) on my table, but if I put the 2nd one it > fails.....here is my table > > CREATE TABLE pack_accomodation ( > id int(16) NOT NULL auto_increment, > pack_id int(16) NOT NULL , > hotel_id int(16) NOT NULL , > PRIMARY KEY (id), > INDEX (pack_id), > FOREIGN KEY (pack_id) REFERENCES pack(items_no) > ON DELETE CASCADE > ON UPDATE CASCADE, > INDEX (hotel_id), > FOREIGN KEY (hotel_id) REFERENCES hotel(items_no) > )ENGINE=INNODB; > > > I can get rid of the 2nd foreign key with programming, but I think it > should be possible to have them both...I just I cant figure out why it > fails with this error: > ERROR 1005 (HY000): Can't create table './tabasam/pack_accomodation.frm' > (errno: 150) For description of the error > > <http://dev.mysql.com/doc/refman/5.0/en/innodb-error-codes.html> Did you read the comments on that page? The top 2 give clues about what else to check. Is the 'hotel' table innodb as well? What type is items_no in the hotel table? Is it int(16) ? -- Postgresql & php tutorials http://www.designmagick.com/