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" <chriswhite@stripped> 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.
