Member Login

Resources

Developers Blog
GMapsPRO Demo
Bug Tracker
-----------------------------------
GMaps Community Forums
GMaps Subscriber Forums
-----------------------------------
Google Maps API Reference
Google Maps Group Forum

Who's Online

Affiliates



DB Error is occuring when performing the install? PDF Print E-mail

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 ). 

 

 
< Prev   Next >