Hi,
I have the script below to create 5 tables. Three of them create fine but
two return an error of 150 which I understand to be a foreign key issue,
however I can't see anything wrong with the foreign key statements.
Could someone possibly have a look and see if they can identify the issue
Sorry all, I was being a dummy! Missed the unsigned attribute off the
foreign key columns on the problem tables.
Regards
Hi,
I have the script below to create 5 tables. Three of them create fine but
two return an error of 150 which I understand to be a foreign key issue,
however I can't
! Missed the unsigned attribute off the
foreign key columns on the problem tables.
Regards
Hi,
I have the script below to create 5 tables. Three of them create fine but
two return an error of 150 which I understand to be a foreign key issue,
however I can't see anything wrong
Check the output of SHOW INNODB STATUS. You should see a more helpful
error message there.
This shows the following information:
LATEST FOREIGN KEY ERROR
070519 15:15:28 Error in foreign key constraint of table
woodturners/#sql-2dc_1e:
Currently using MySQL version 5.0.22-community-nt on a Windows XP Pro box
(my development machine).
When I attempt to add a Foreign Key to one of my tables, I get the error,
Can't create table '.\woodturners\#sql-2dc_8.frm' (errno: 150). I have
checked through all of the standard issues:
Hi Jesse,
Jesse wrote:
Currently using MySQL version 5.0.22-community-nt on a Windows XP Pro
box (my development machine).
When I attempt to add a Foreign Key to one of my tables, I get the
error, Can't create table '.\woodturners\#sql-2dc_8.frm' (errno: 150).
I have checked through all