DB Error is occuring when performing the install?

I have seen a few comments on the board about and error that occurs during the install when attempting to alter a foreign key reference.

SQL Error DB function failed with error number 1005
Can’t create table ‘.seil i nord#sql-46c_2e.frm’ (errno: 150) SQL=alter table `jos_gmaps_maps` add constraint FOREIGN KEY (`id`) REFERENCES `jos_gmaps_points (id)` on delete cascade
SQL =

alter table `jos_gmaps_maps` add constraint
FOREIGN KEY (`id`)
REFERENCES `jos_gmaps_points (id)` on delete cascade

 

Keith posted a comment on the forums indicating that if you change the table engine from InnoDB to MyISAM, that should do the trick.  The command to change the engine type is:

ALTER TABLE {tablename} ENGINE=MyISAM

For further details, please refer to the MySQL documentation (click here for MySQL’s ALTER TABLE command )

You may also like