× Help Forum English

Upgrade not working

Start
Prev
1
Next
End

chmanoogs
Topic Author
New Member

9 years 10 months ago #9134 by chmanoogs

Upgrade not working was created by 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.

Please Log in or Create an account to join the conversation.

Lyr!C
Administrator
Lead Developer

9 years 10 months ago #9191 by Lyr!C

Replied by Lyr!C on 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) .

Please Log in or Create an account to join the conversation.

Start
Prev
1
Next
End

Moderators: Lyr!C

Time to create page: 0.067 seconds

Forum

Upgrade not working

Legal

Follow Us