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]
