Phoca Forum

I receive a DB error when attempting to install Phocmaps into Joomla 1.6, using Wamp 2.1e.

The Error is TYPE=MyISAM.

I have tried editing the Install.bak.sql file i 3 places replacing TYPE= with ENGINE= But still get an error complaining about TYPE= MyISAM.

Does anyone know where else I should look for TYPE= ?

Thanks...

Phoca Maps not successfully installed:
DB function failed with error number 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM CHARACTER SET `utf8`' at line 36 SQL=CREATE TABLE IF NOT EXISTS `jos_phocamaps_map` ( `id` int(11) NOT NULL auto_increment, `title` varchar(255) NOT NULL default '', `alias` varchar(255) NOT NULL default '', `width` int(5) NOT NULL default '0', `height` int(5) NOT NULL default '0', `latitude` varchar(20) NOT NULL default '', `longitude` varchar(20) NOT NULL default '', `zoom` int(3) NOT NULL default '0', `lang` varchar(6) NOT NULL default '', `border` tinyint(1) NOT NULL default '0', `continuouszoom` tinyint(1) NOT NULL default '0', `doubleclickzoom` tinyint(1) NOT NULL default '0', `scrollwheelzoom` tinyint(1) NOT NULL default '0', `zoomcontrol` tinyint(1) NOT NULL default '0', `scalecontrol` tinyint(1) NOT NULL default '0', `typeid` tinyint(1) NOT NULL default '0', `typecontrol` tinyint(1) NOT NULL default '0', `typecontrolposition` tinyint(1) NOT NULL default '0', `collapsibleoverview` tinyint(1) NOT NULL default '0', `dynamiclabel` tinyint(1) NOT NULL default '0', `googlebar` tinyint(1) NOT NULL default '0', `displayroute` tinyint(1) NOT NULL default '0', `kmlfile` varchar(255) NOT NULL default '', `description` text NOT NULL, `published` tinyint(1) NOT NULL default '0', `checked_out` int(11) unsigned NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `ordering` int(11) NOT NULL default '0', `access` tinyint(3) unsigned NOT NULL default '0', `hits` int(11) NOT NULL default '0', `params` text NOT NULL, `language` char(7) NOT NULL Default '', PRIMARY KEY (`id`), KEY `cat_idx` (`published`,`access`), KEY `idx_access` (`access`), KEY `idx_checkout` (`checked_out`) ) TYPE=MyISAM CHARACTER SET `utf8`;

After a lot of experimenting I have found a solution, even if I do not yet understand the cause of the problem...

I extracted the install.bak.sql file from the installation zip archive and modified it as follows:
I changed TYPE= to ENGINE= in 3 places and then updated the table names using my default prefix of "jos_".
I then installed the phocamap extention as normal and received the database error.
I then opened PHPADMIN using the WampServer control panel and selected my sql table (joomladb in my case).
I then clicked on SQL tab at the top of the page and copied and pasted the sql query script from the install.bak.sql file.
Click GO and the tables are then installed correctly.

Modified instal.bak.sql file
DROP TABLE IF EXISTS `jos_phocamaps_map`;

CREATE TABLE `jos_phocamaps_map` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`alias` varchar(255) NOT NULL default '',
`width` int(5) NOT NULL default '0',
`height` int(5) NOT NULL default '0',
`latitude` varchar(20) NOT NULL default '',
`longitude` varchar(20) NOT NULL default '',
`zoom` int(3) NOT NULL default '0',
`lang` varchar(6) NOT NULL default '',
`border` tinyint(1) NOT NULL default '0',
`continuouszoom` tinyint(1) NOT NULL default '0',
`doubleclickzoom` tinyint(1) NOT NULL default '0',
`scrollwheelzoom` tinyint(1) NOT NULL default '0',
`zoomcontrol` tinyint(1) NOT NULL default '0',
`scalecontrol` tinyint(1) NOT NULL default '0',
`typeid` tinyint(1) NOT NULL default '0',
`typecontrol` tinyint(1) NOT NULL default '0',
`typecontrolposition` tinyint(1) NOT NULL default '0',
`collapsibleoverview` tinyint(1) NOT NULL default '0',
`dynamiclabel` tinyint(1) NOT NULL default '0',
`googlebar` tinyint(1) NOT NULL default '0',
`displayroute` tinyint(1) NOT NULL default '0',
`kmlfile` varchar(255) NOT NULL default '',
`description` text NOT NULL,
`published` tinyint(1) NOT NULL default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`ordering` int(11) NOT NULL default '0',
`access` tinyint(3) unsigned NOT NULL default '0',
`hits` int(11) NOT NULL default '0',
`params` text NOT NULL,
`language` char(7) NOT NULL Default '',
PRIMARY KEY (`id`),
KEY `cat_idx` (`published`,`access`),
KEY `idx_access` (`access`),
KEY `idx_checkout` (`checked_out`)
) ENGINE=MyISAM CHARACTER SET `utf8`;

DROP TABLE IF EXISTS `jos_phocamaps_marker`;

CREATE TABLE `jos_phocamaps_marker` (
`id` int(11) unsigned NOT NULL auto_increment,
`catid` int(11) NOT NULL default '0',
`title` varchar(250) NOT NULL default '',
`alias` varchar(255) NOT NULL default '',
`latitude` varchar(20) NOT NULL default '',
`longitude` varchar(20) NOT NULL default '',
`gpslatitude` varchar(50) NOT NULL default '',
`gpslongitude` varchar(50) NOT NULL default '',
`displaygps` tinyint(1) NOT NULL default '0',
`icon` tinyint(1) NOT NULL default '0',
`iconext` int(11) NOT NULL default '0',
`description` text NOT NULL,
`contentwidth` varchar(8) NOT NULL default '',
`contentheight` varchar(8) NOT NULL default '',
`markerwindow` tinyint(1) NOT NULL default '0',
`published` tinyint(1) NOT NULL default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`ordering` int(11) NOT NULL default '0',
`access` tinyint(3) unsigned NOT NULL default '0',
`hits` int(11) NOT NULL default '0',
`params` text NOT NULL,
`language` char(7) NOT NULL Default '',
PRIMARY KEY (`id`),
KEY `catid` (`catid`,`published`)
) ENGINE=MyISAM CHARACTER SET `utf8`;

-- Since Phoca Maps 2
DROP TABLE IF EXISTS `jos_phocamaps_icon`;
CREATE TABLE `jos_phocamaps_icon` (
`id` int(11) unsigned NOT NULL auto_increment,
`title` varchar(250) NOT NULL default '',
`alias` varchar(255) NOT NULL default '',
`url` text NOT NULL,
`urls` text NOT NULL,
`object` varchar(255) NOT NULL default '',
`objects` varchar(255) NOT NULL default '',
`published` tinyint(1) NOT NULL default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`ordering` int(11) NOT NULL default '0',
`access` tinyint(3) unsigned NOT NULL default '0',
`hits` int(11) NOT NULL default '0',
`params` text NOT NULL,
`language` char(7) NOT NULL Default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM CHARACTER SET `utf8`;

INSERT INTO `jos_phocamaps_icon` (`id`, `title`, `alias`, `url`, `urls`, `object`, `objects`, `published`, `checked_out`, `checked_out_time`, `ordering`, `access`, `hits`, `params`, `language`) VALUES
(1, 'Tree', 'tree', 'http://maps.google.com/mapfiles/ms/icons/tree.png', 'http://maps.google.com/mapfiles/ms/icon ... shadow.png', '', '59,32;0,0;16,34', 1, 0, '0000-00-00 00:00:00', 1, 1, 0, '', ''),
(2, 'Pushpin', 'pushpin', 'http://maps.google.com/mapfiles/ms/icon ... ushpin.png', '', '', '', 1, 0, '0000-00-00 00:00:00', 2, 1, 0, '', ''),
(3, 'Blue Dot', 'blue-dot', 'http://maps.google.com/mapfiles/ms/icons/blue-dot.png', '', '', '', 1, 0, '0000-00-00 00:00:00', 3, 1, 0, '', ''),
(4, 'Flag', 'flag', 'http://maps.google.com/mapfiles/ms/icons/flag.png', 'http://maps.google.com/mapfiles/ms/icon ... shadow.png', '', '59,32;0,0;16,34', 1, 0, '0000-00-00 00:00:00', 3, 1, 0, '', ''),
(5, 'Info', 'info', 'http://maps.google.com/mapfiles/ms/icons/info.png', 'http://maps.google.com/mapfiles/ms/icon ... shadow.png', '', '59,32;0,0;16,34', 1, 0, '0000-00-00 00:00:00', 5, 1, 0, '', ''),
(6, 'Snack Bar', 'snack-bar', 'http://maps.google.com/mapfiles/ms/icons/snack_bar.png', 'http://maps.google.com/mapfiles/ms/icon ... shadow.png', '', '59,32;0,0;16,34', 1, 0, '0000-00-00 00:00:00', 6, 1, 0, '', '');


-- 2.0.0 UPDATE ONLY (to 1.1.0)
-- ALTER TABLE `jos_phocamaps_map` ADD `language` char(7) NOT NULL Default '' AFTER `params` ;
-- ALTER TABLE `jos_phocamaps_marker` ADD `language` char(7) NOT NULL Default '' AFTER `params` ;
-- ALTER TABLE `jos_phocamaps_marker` ADD `iconext` int(11) NOT NULL default '0' AFTER `icon` ;



-- UTF-8 test: ä,ö,ü


I hope that this solution assists others, and I will be interested if anyone can enlighten me as the cause of the problem - why my modified sql file will not install automatically.

Regards, Ian

Hi, this were fixed since 2.

Jan