Main menu

Forum


× Help Forum English

Error during Icagenda installation

  • frarusso
  • Topic Author
  • Fresh Boarder
  • Fresh Boarder
More
1 week 3 days ago #16270 by frarusso
Error during Icagenda installation was created by frarusso
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

Please Log in or Create an account to join the conversation.

  • Kadlook
  • Fresh Boarder
  • Fresh Boarder
More
1 week 3 days ago #16271 by Kadlook
Replied by Kadlook on topic Error during Icagenda installation
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;

Please Log in or Create an account to join the conversation.

  • Lyr!C
  • Lyr!C's Avatar
  • Administrateur
  • Administrateur
  • Lead Developer
More
1 week 3 days ago #16280 by Lyr!C
Replied by Lyr!C on topic Error during Icagenda installation
Hello,

Sorry, my mistake...

Please check this topic:
www.joomlic.com/forum/icagenda-help-en/4...h-installation#16279

Latest version : 3.7.8

We recommend every user to keep your iCagenda updated.
Don't forget to have your Joomla!™ up-to-date!


Do you like iCagenda?
I would appreciate if you could take 5 minutes to post a review on JED (Joomla Extensions Directory) .

Please Log in or Create an account to join the conversation.

Moderators: Lyr!C
Time to create page: 0.108 seconds

Follow Us

Create your Joomla templates with Template Creator CK