Re: Alter table - adding constraints?

[Chris White]

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.