Thomas’ Developer Blog

April 28, 2008

mySQL’s pesky little Error: 1005 errno: 150 issue solution

Filed under: sql — Tags: , , , , , , , , — sanzon @ 1:47 am

Alright, a lot of people probably get this a lot with mySQL.  Here’s the fact, there is a 99.999% chance your code is wrong and there is not a bug with mySQL.

The solution to this problem is actually really easy to figure out, it’s just that SQL has a horrible debuging scripts which make it a pain to figure out.

Just type:

Show innoDB status;

Read under the section: Latest Foreign Key Error, and there you go!  Your problem explained!  Just read it two or three times if you don’t get it.  Trust me it helps a lot.

Happy coding



  1. Thank you very much this helped me alot

    Comment by Luiz — November 26, 2009 @ 4:56 pm

  2. Thanks ,

    It helped me in solving my problem.

    Comment by Bharathi — July 19, 2010 @ 6:09 am

  3. Thank’s !

    Comment by Matti — September 9, 2010 @ 6:10 pm

  4. great! thx!

    Comment by ramona — October 26, 2010 @ 1:47 pm

  5. thanks a lot dude!! you helped me out on figuring my 14-hour problem !! thanks!!

    Comment by Lumhiere — February 13, 2011 @ 10:21 am

  6. Hey I am so happy I found your weblog, I really found you by accident,
    while I was searching on Yahoo for something else, Regardless I
    am here now and would just like to say kudos for a tremendous post and
    a all round interesting blog (I also love the theme/design),
    I don’t have time to go through it all at the moment but I have bookmarked it
    and also added your RSS feeds, so when I have time I will be back to read a great deal more, Please do keep up the awesome work.

    Comment by how to configure best comcast how to configure modem streamyx — September 9, 2014 @ 1:28 am

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Blog at

%d bloggers like this: