× Help Forum English

Upgrade not working

Inizio
Indietro
1
Avanti
Fine

chmanoogs
Autore della discussione
Junior Member

Di più

11 Anni 8 Mesi fa #9134 da chmanoogs

Upgrade not working è stato creato da chmanoogs

Hi I have upgraded to 3.4.1 but receive the following error

JInstaller: :Install: Error SQL 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 'DEFAULT '' `releasedate`' at line 1 SQL=ALTER TABLE `lyst6_icagenda` ADD COLUMN `params` TEXT NOT NULL AFTER DEFAULT '' `releasedate`;

In the frontend it says

iC Library is not correctly installed or is not loaded.
Please, check if iC Library and the system plugin iC Library are installed and enabled.

I have spent hours uploading and testing each of the foloders such as library, utilities, plugins. but nothing works.

Help please.

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

Lyr!C
Administrator
Lead Developer

Di più

11 Anni 8 Mesi fa #9191 da Lyr!C

Risposta da Lyr!C al topic Upgrade not working

Hello,

Sorry for slow response...

The issue is when updating for a too old release (before 3.2.14).

So, first unzip 3.4.1. package

Then, go in admin/sql/updates/3.2.14.sql

Edit the first line with this (to fix the issue introduced in 3.4.1, when updated all sql files in one click, with a mass replace) :

ALTER TABLE `#__icagenda` ADD COLUMN `params` TEXT NOT NULL DEFAULT '' AFTER `releasedate`;

The issue is the after not well placed.

So then, package your modified 3.4.1, and install it.
It should solve the issue!

Best Regards,
Cyril

Latest version : iCagenda 4.0.17 Joomla! 4 > Joomla! 6
We recommend every user to keep iCagenda updated.
Support for iCagenda version 3.9 (the final version compatible with Joomla 3) ended on October 13, 2026
Extended security support for the iCagenda PRO 3.9 version until October 13, 2027 (to benefit from this extended support, you must have a Pro subscription: www.joomlic.com/extensions/icagenda)
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) .

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

Inizio
Indietro
1
Avanti
Fine

Moderatori: Lyr!C

Tempo creazione pagina: 0.044 secondi

Forum

Upgrade not working

Legal

Follow Us