I have issues creating tables (errno: 150) in MySQL while trying to migrate to 3.0

You probably get an error similar to:

ERROR 1005 (HY000) at line 101: Can't create table './pandora/talert_template_modules.frm' (errno: 150)

This is due to a problem in MySQL because some fields aren’t the expected type. id_agente_modulo field in 2.1 should have bigint(10) type. If you have migrated from version 1.x before you will encounter this issue. Before running the migration tool on 3.0, enter this command in the MySQL console:

ALTER TABLE tagente_modulo MODIFY id_agente_modulo bigint(10) unsigned NOT NULL auto_increment;

And try to run the migration tool again. Please remember that 2.x and 3.x versions needs to have InnoDB support enabled in your MySQL database server

Another possible explanation is that your MySQL is too old and doesn’t support some foreign key syntaxes. Be sure you are running at least MySQL version 5.1.