next »

[scar1105]

When installing JCal Pro (com_jcalpro_1_5_3_2.zip) to Mambo, I receive these errors:

Fatal: Installer error with /usr/home/web/users/a0015474/html/newMambo463/media/install_48505e37171f2/jcalpro.xml: component com_jcalpro SQL error 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 'EXISTS `mos_jcalpro_themes` (`id` int(11) NOT NULL auto_increment,`name` varchar' at line 1 SQL=CREATE TABLE IFNOT EXISTS `mos_jcalpro_themes` (`id` int(11) NOT NULL auto_increment,`name` varchar(100) NOT NULL default '',`theme` varchar(100) NOT NULL default '',`type` varchar(100) NOT NULL default 'plugins',`icon` varchar(255) NOT NULL default '',`published` tinyint(3) NOT NULL default '0',`editable` tinyint(3) NOT NULL default '1',`elements` varchar(255) NOT NULL default '',`iscore` tinyint(3) NOT NULL default '0',`client_id` tinyint(3) 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',`params` text NOT NULL,PRIMARY KEY (`id`),UNIQUE KEY `plugin` (`theme`)) TYPE = MYISAM;
SQL =
CREATE TABLE IFNOT EXISTS `mos_jcalpro_themes` (`id` int(11) NOT NULL auto_increment,`name` varchar(100) NOT NULL default '',`theme` varchar(100) NOT NULL default '',`type` varchar(100) NOT NULL default 'plugins',`icon` varchar(255) NOT NULL default '',`published` tinyint(3) NOT NULL default '0',`editable` tinyint(3) NOT NULL default '1',`elements` varchar(255) NOT NULL default '',`iscore` tinyint(3) NOT NULL default '0',`client_id` tinyint(3) 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',`params` text NOT NULL,PRIMARY KEY  (`id`),UNIQUE KEY `plugin` (`theme`)) TYPE = MYISAM;
 
Fatal: Installer error with /usr/home/web/users/a0015474/html/newMambo463/media/install_48505e37171f2/jcalpro.xml: component com_jcalpro SQL error DB function failed with error number 1146
Table 'a0015474.mos_jcalpro_themes' doesn't exist SQL=INSERT IGNORE INTO mos_jcalpro_themes VALUES ('', 'default', 'default', 'theme', 'default', 1, 1, '', 1, 0, 0, '0000-00-00 00:00:00', '');
SQL =
INSERT IGNORE INTO mos_jcalpro_themes VALUES ('', 'default', 'default', 'theme', 'default', 1, 1, '', 1, 0, 0, '0000-00-00 00:00:00', '');
 
Fatal: Installer error with /usr/home/web/users/a0015474/html/newMambo463/media/install_48505e37171f2/jcalpro.xml: component com_jcalpro SQL error 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 'mos_jcalpro_config VALUES ('archive', '0', 0, '0000-00-00 00:00:00')' at line 1 SQL=INSERT IGNOREINTO mos_jcalpro_config VALUES ('archive', '0', 0, '0000-00-00 00:00:00');
SQL =
INSERT IGNOREINTO mos_jcalpro_config VALUES ('archive', '0', 0, '0000-00-00 00:00:00');



- Exact version of JCal Client (i.e. 1.6.176): com_jcalpro_1_5_3_2.zip
- Exact version of Joomla/Mambo: Mambo 4.6.2
- Whether or not you upgraded JCal/Extcal: new install
- Your php version: PHP Version 4.4.8
- Your JCal theme (default or custom): default?
- Your default Joomla language: N/A?

Please provide direction on how to correct these errors.  Thank you.

[V-man]

You need Mambo 4.6.2.

[scar1105]

Sorry.  It is 4.6.2. 

[scar1105]

Fixed the problem by upgrading to PHP5.  Problem resolved.