Results 1 to 3 of 3
Apr 12, 2013, 15:48 #1
phpMyAdmin #1005 errno: 150 error code
I am trying to import MySQL code into phpMyAdmin.
#1005 - Can't create table 'dbname.test_table' (errno: 15
I am reading this article, trying to troubleshoot. http://verysimple.com/2006/10/22/mys...frm-errno-150/
- All tables use INNODB engine.
- I have re-ordered my tables (it has created the first few tables which require no foreign keys successfully)
Is it wrong to have a foreign key in my members type table called memberID and also to have the primary key in my members table called memberID. Could this be why it is not importing when I list the constraint like this...
CONSTRAINT member_fk FOREIGN KEY (`member_id`) REFERENCES members (`member_id`)
Apr 12, 2013, 16:33 #2
- Join Date
- Jul 2002
- Toronto, Canada
- 63 Post(s)
- 3 Thread(s)
member types to members is a one-to-many relationship
each member type can have multiple members, but a member can belong to only one member type
in one-to-many relationships, the foreign key goes in the "many" table, referencing the primary key of the "one" table
Apr 13, 2013, 13:38 #3
I've checked my relationships according to how you mentioned above and it is how you have described. What I've done is import tables (successful) without constraints. I am going to try and use ALTER table now and see if I can implement the constraints that way since the tables with fields are there now.