|
|
My DB solution. - 2007/02/23 23:43
Hi, I couldn't get the component to install as it kept halting on this part of the install.
alter table `jos_gmaps_markers` add constraint
FOREIGN KEY (`id`)
REFERENCES `jos_gmaps_points` (item_id)
So after some investigation I found that the database tables were being created as InnoDB in mysql and that if I altered them to MyISAM then the part of the DB script that was causing problem could be execuited. 
I ain't no DB expert but I counted 75 tables in my joomla DB only 3 are InnoDB and all the rest are MyISAM.
Hope this help someone else.
Keith
www.scott-land.net
The administrator has disabled public write access.
|
|
|
Re:My DB solution. - 2007/02/23 23:47
Keith,
Thanks for the info. Good post. Someone else had a similar problem. I am not a MySQL expert ... and Oracle guy.
Chris
The administrator has disabled public write access.
|
|
|
Re:My DB solution. - 2007/02/24 19:49
I am new to joomla and wonder if someone can give a step by step on how to make these changes.
Please.
Thank you
Tina
The administrator has disabled public write access.
|
|
