1) both tables are InnoDB. 2) both tables have data in them. 3) both table are the exact same data types.
On 2/20/07 3:51 PM, "Chris White" <[EMAIL PROTECTED]> wrote: > Jay Paulson wrote: >> I really don¹t know what to do because I keep getting this error. Any >> ideas? >> >> SQL query: >> >> ALTER TABLE pl_reports ADD CONSTRAINT fk_region FOREIGN KEY ( region ) >> REFERENCES Region( id ) ON UPDATE CASCADE ON DELETE CASCADE >> >> MySQL said: Documentation >> #1005 - Can't create table './survey_localhost/#sql-113_f8.frm' (errno: 150) >> >> Thanks! >> >> > 1) Are both tables InnoDB? > 2) Do you have data in either tables? > 3) Are the data types of both columns exactly the same ( int(20) > unsigned and int(20) will fail, the unsigned has to be there)? > > you can also run SHOW INNODB STATUS as root to find out exactly what the > error is. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
