Monthly Archives: February 2012

My new smartphone, iOs or Android ?

Before you start reading this post, please note this is not about which of these is better than the other. It is just a list of criteria on which I based my decision.

A few months ago, my Nokia N900 (with the Maemo OS) broke down, so I was forced to buying a new one. I had thought for a long time that my next phone would be an iPhone (I admit, I’m kind of an Apple fan, although not all the way). I had seen Android in action about two years ago, and I was not at all impressed (it was very slow), but still I decided to take a look at it again. Here are the criteria on which I based my decision.
Read more »

Mysql errno: 150 when creating a foreign key

If you receive a errno; 150 when creating a foreign key in mysql, you may have encountered one of following problems :

  • The type of your foreign key is not the same as the referencing key, e.g. BIGINT -> INT
  • One of the two tables does not have the InnoDB engine. You cannot add foreign keys to MyISAM tables, or referencing MyISAM tables.

If you need more info about the actual error that occured, you can execute following sql statement :

SHOW ENGINE INNODB STATUS

This will show you which foreign key gave the error (or about other errors for that matter) and some more info about possible causes.