× Help Forum English

Upgrade not working

Inizio
Indietro
1
Avanti
Fine

chmanoogs
Autore della discussione
New Member

Di più

9 Anni 10 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ù

9 Anni 10 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 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) .

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

Inizio
Indietro
1
Avanti
Fine

Moderatori: Lyr!C

Tempo creazione pagina: 0.093 secondi

Forum

Upgrade not working

Legal

Follow Us