Foreign Key Issue

2009-03-26 Thread John Daisley
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

SOLVED: Re: Foreign Key Issue

2009-03-26 Thread John Daisley
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

Re: SOLVED: Re: Foreign Key Issue

2009-03-26 Thread Claudio Nanni
! 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

Re: Create Foreign Key Issue

2007-05-19 Thread Jesse
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:

Create Foreign Key Issue

2007-05-18 Thread Jesse
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:

Re: Create Foreign Key Issue

2007-05-18 Thread Baron Schwartz
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