Main menu

Forum


× Help Forum English

Error during Icagenda installation

  • frarusso
  • Auteur du sujet
  • Nouveau membre
  • Nouveau membre
Plus d'informations
il y a 5 ans 2 mois #16270 par frarusso
Error during Icagenda installation a été créé par 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

Connexion ou Créer un compte pour participer à la conversation.

 

  • Kadlook
  • Nouveau membre
  • Nouveau membre
Plus d'informations
il y a 5 ans 2 mois #16271 par Kadlook
Réponse de Kadlook sur le sujet 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;

Connexion ou Créer un compte pour participer à la conversation.

  • Lyr!C
  • Portrait de Lyr!C
  • Administrateur
  • Administrateur
  • Lead Developer
Plus d'informations
il y a 5 ans 2 mois #16280 par Lyr!C
Réponse de Lyr!C sur le sujet 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 : iCagenda 3.9.2
We recommend every user to keep 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) .

Fichier attaché :

Connexion ou Créer un compte pour participer à la conversation.

Modérateurs: Lyr!C
Temps de génération de la page : 0.060 secondes

 

Follow Us

acymailing logo new

Créez vos templates Joomla avec Template Creator CK