Main menu

Forum


× Help Forum English

[SOLVED] MySQL error on fresh installation

  • sniegu
  • Autore della discussione
  • New Member
  • New Member
Di più
5 Anni 2 Mesi fa - 5 Anni 2 Mesi fa #16268 da sniegu
[SOLVED] MySQL error on fresh installation è stato creato da sniegu
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.
Ultima Modifica 5 Anni 2 Mesi fa da Lyr!C. Motivo: [SOLVED]

Si prega Accedi o Crea un account a partecipare alla conversazione.

 

  • Lyr!C
  • Avatar di Lyr!C
  • Administrator
  • Administrator
  • Lead Developer
Di più
5 Anni 2 Mesi fa #16279 da Lyr!C
Risposta da Lyr!C al topic MySQL error on installation
Hello,

i'm sorry, my mistake in creating install sql file...

Attached a version with a patch.
Could you install it and test again ?

note: issue only on fresh install of iCagenda

Thank you!

Best regards,
Cyril

File allegato:

Nome del file: iCagenda_3...atch.zip
Dimensione del file:1,764 KB

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) .

File allegato:

Allegati:
Ringraziano per il messaggio: sniegu

Si prega Accedi o Crea un account a partecipare alla conversazione.

  • sniegu
  • Autore della discussione
  • New Member
  • New Member
Di più
5 Anni 2 Mesi fa #16319 da sniegu
Risposta da sniegu al topic MySQL error on installation
Sorry for not replying so long - yes, this one fixed the problem :) Thanks!
Ringraziano per il messaggio: Lyr!C

Si prega Accedi o Crea un account a partecipare alla conversazione.

  • Lyr!C
  • Avatar di Lyr!C
  • Administrator
  • Administrator
  • Lead Developer
Di più
5 Anni 2 Mesi fa #16325 da Lyr!C
Risposta da Lyr!C al topic MySQL error on installation

sniegu ha scritto: Sorry for not replying so long - yes, this one fixed the problem :) Thanks!

You're welcome! ;-)

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) .

File allegato:

Si prega Accedi o Crea un account a partecipare alla conversazione.

Moderatori: Lyr!C
Tempo creazione pagina: 0.089 secondi

 

Follow Us

acymailing logo new

Create your Joomla templates with Template Creator CK