Hi everyone,
installing Icagenda 3.7.8 on a newly created website joomla 3.9.1 I get the error:

JInstaller:: Install: SQL error You have an error in your SQL syntax; ADD KEY `idx_state` (` state`), ADD KEY 'at line 50
Extension Installation: SQL error processing request: DB function failed with error number 1064
You have an error in your SQL syntax; ADD KEY `idx_state` (` state`), ADD KEY 'at line 50
SQL =

How can I solve this problem?
Thanks for the attention
Francis

Hi everyone,
installing Icagenda 3.7.8 on a newly created website joomla

JInstaller::Instalacja: Błąd SQL You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ADD KEY `idx_state` (`state`), ADD KEY `idx_approval` (`approval`), ADD KEY ' at line 50.
Rozszerzenie Instaluj: SQL- błąd podczas przetwarzania zapytania: Wywołanie funkcji bazy danych zakończyło się numerem błędu 1064
.
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;