× Help Forum English

Upgrade not working

Début
Précédent
1
Suivant
Fin

chmanoogs
Auteur du sujet
Membre junior

Plus d'informations

il y a 11 ans 8 mois #9134 par chmanoogs

Upgrade not working a été créé par 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.

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

Lyr!C
Administrateur
Lead Developer

Plus d'informations

il y a 11 ans 8 mois #9191 par Lyr!C

Réponse de Lyr!C sur le sujet 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) .