× Help Forum English

Upgrade not working

Début
Précédent
1
Suivant
Fin

chmanoogs
Auteur du sujet
Nouveau membre

Plus d'informations

il y a 9 ans 10 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 9 ans 10 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 3.9.8
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) .