[RESOLVED] Creating tables with Foreign key producing nondescript errors.
I get this very nondescript error trying to create my next two tables, I believe
its just a misspelling or a missing comma but can't seem to find it. Could someone
please check out my code and see what I did wrong here?
The error starts at the creation of TABLE `melons`, and I'm sure it propagates itself
to the following 4 tables
]Error #1005 - Can't create table './cbw222_inspections/Melons.frm' (errno: 150)
Code to large so Here's a Pastie
It is hard to tell because the reason may be in something you did before. The best idea for you is to enter in google "1005 cant create table errno 105" - here are discussed similar cases.
(see the first answer with explanation)
Check if one of them is similar to your case and write again. Maybe provide more info?
(it is always good to enter all these error numbers into google)
The answer was that I was trying to use a foreign key on a table that was created later down the line, so it technically didn't exist yet.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread