Phoca Forum

Hi i had some problems when i installed phoca maps on my joomla site, i got this message when i was done: oca Maps was 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 32 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', `typecontrol` 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', `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, PRIMARY KEY (`id`), KEY `cat_idx` (`published`,`access`), KEY `idx_access` (`access`), KEY `idx_checkout` (`checked_out`) ) TYPE=MyISAM CHARACTER SET `utf8`;

Any solution
//johan

I had the same problem

What I did to solve the problem was to go in your Joomla database using myphpadmin and created the missing tables using the following two SQL scripts

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',
`typecontrol` 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',
`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,
PRIMARY KEY (`id`),
KEY `cat_idx` (`published`,`access`),
KEY `idx_access` (`access`),
KEY `idx_checkout` (`checked_out`)
) ENGINE=MyISAM CHARACTER SET `utf8`;

And

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',
`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,
PRIMARY KEY (`id`),
KEY `catid` (`catid`,`published`)
) ENGINE=MyISAM CHARACTER SET `utf8`;

Then everything worked as it should

Ok thanks i will try that.

Same problems here. Using latest MAMP 1.9.6 and Joomla 1.5.23
I will try your manual suggestions! WORKED like a charm!

EDIT:
Map creation throws error message:
Error while saving Map(s)

Same problems here. Using latest MAMP 1.9.6 and Joomla 1.5.23
I will try your manual suggestions! WORKED like a charm!

EDIT:
Map creation throws error message:
Error while saving Map(s)

The same thing happens to me

I've been watching and the file "com_phocamaps_v1.1.1.zip" I downloaded the PhocaMaps the page, the file "install.sql" has nothing inside. I think it's soposto have the code to create the DB tables and fields ?????

Chase90 wrote:I've been watching and the file "com_phocamaps_v1.1.1.zip" I downloaded the PhocaMaps the page, the file "install.sql" has nothing inside. I think it's soposto have the code to create the DB tables and fields ?????

Have a look 3 posts above... the manual table creation works fine. The extension seems to be complete and installed, but i still have the mentioned error message

Yes I had ever seen. But he is supposed to make the creation of the DB when installing? And still have the same problem as you.

Error while saving Map (s


Can anyone help?

I'm working with:

MAMP Pro 1.9.6.1
php 5.2.17
joomla 1.5.23
phocamaps v1.1.1

Hi, did you enable php error reporting and debug mode to check if there is no error?

https://www.phoca.cz/documents/16-joomla ... rs-on-site

Jan