www.webdeveloper.com
Results 1 to 3 of 3

Thread: [RESOLVED] Creating tables with Foreign key producing nondescript errors.

Hybrid View

  1. #1
    Join Date
    Oct 2008
    Location
    Seattle, Wa
    Posts
    695

    resolved [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

  2. #2
    Join Date
    Mar 2012
    Location
    Saint-Petersburg, Russia
    Posts
    97
    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.

    For example:
    http://stackoverflow.com/questions/4...able-errno-150
    (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)

  3. #3
    Join Date
    Oct 2008
    Location
    Seattle, Wa
    Posts
    695
    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.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles