Re: SOLVED: Re: Foreign Key Issue

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, > &g

SOLVED: Re: Foreign Key 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,

Foreign Key Issue

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

Re: Create Foreign Key Issue

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: FOREIGN

Re: Create Foreign Key Issue

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 o

Create Foreign Key Issue

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: