Hi,
Here's the error I'm getting when I'm trying to install iCagenda
Warning
JInstaller: :Install: Error SQL 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 'ADD KEY `idx_state` (`state`), ADD KEY `idx_approval` (`approval`), ADD KEY ' at line 50
Extension Install: SQL error processing query: 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 'ADD KEY `idx_state` (`state`), ADD KEY `idx_approval` (`approval`), ADD KEY ' at line 50
SQL =
CREATE TABLE IF NOT EXISTS `#__icagenda_events` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`asset_id` int(10) NOT NULL DEFAULT '0',
`ordering` int(11) NOT NULL,
`state` tinyint(1) NOT NULL DEFAULT '1',
`approval` int(11) NOT NULL DEFAULT '0',
`site_itemid` int(10) NOT NULL DEFAULT '0',
`checked_out` int(11) NOT NULL,
`checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`title` varchar(255) NOT NULL,
`alias` varchar(255) NOT NULL,
`access` int(10) unsigned NOT NULL DEFAULT '0',
`language` varchar(10) NOT NULL DEFAULT '*',
`hits` int(10) unsigned NOT NULL DEFAULT '0',
`created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`created_by` int(10) unsigned NOT NULL DEFAULT '0',
`created_by_alias` varchar(255) NOT NULL,
`created_by_email` varchar(100) NOT NULL,
`modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`modified_by` int(10) unsigned NOT NULL DEFAULT '0',
`username` varchar(255) NOT NULL,
`catid` int(11) NOT NULL,
`image` varchar(255) NOT NULL,
`file` varchar(255) NOT NULL,
`displaytime` int(10) NOT NULL DEFAULT '1',
`weekdays` varchar(255) NOT NULL,
`daystime` varchar(255) NOT NULL,
`startdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`enddate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`period` text(65535) NOT NULL,
`dates` text(65535) NOT NULL,
`next` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`time` varchar(255) NOT NULL,
`place` varchar(255) NOT NULL,
`website` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`phone` varchar(255) NOT NULL,
`name` varchar(255) NOT NULL,
`city` varchar(255) NOT NULL,
`country` varchar(255) NOT NULL,
`address` varchar(255) NOT NULL,
`coordinate` varchar(255) NOT NULL,
`lat` float( 20, 16 ) NOT NULL,
`lng` FLOAT( 20, 16 ) NOT NULL,
`shortdesc` text NOT NULL,
`desc` text(65535) NOT NULL ,
`metadesc` text NOT NULL,
`params` text NOT NULL,
PRIMARY KEY (`id`),
ADD KEY `idx_state` (`state`),
ADD KEY `idx_approval` (`approval`),
ADD KEY `idx_language` (`language`),
ADD KEY `idx_catid` (`catid`)
) ENGINE=MyISAM DEFAULT COLLATE=utf8_general_ci;
I'm on MySQL 5.7.23 and PHP 7.2.32, fresh Joomla 3.9.1 installation with the CloudBase 3 template from CloudAccess.
Thanks! 
