Upgrade to 4.0.18 database table error

This is the place to post questions and comments about the FlexBanner component
Post Reply
gwsdesk
Posts: 2
Joined: Tue Aug 26, 2014 4:31 am

Upgrade to 4.0.18 database table error

Post by gwsdesk » Tue Aug 26, 2014 4:37 am

Hello Andrew,
We are trying to upgrade a client site to Joomla 3.3.3 from 2.5.24. We first bring all extensions to date and client uses Flexbanners 4..0.0. Upgrade to 4.0.18 is not possible since we get following error:
----------------------------------------------
JInstaller: :Install: Error SQL DB function failed with error number 1060
Duplicate column name 'modified' SQL=ALTER TABLE `egu_flexbanners` ADD `modified` datetime NOT NULL default '0000-00-00 00:00:00';
SQL =

ALTER TABLE `#__flexbanners` ADD `modified` datetime NOT NULL default '0000-00-00 00:00:00';

Component Update: SQL error file DB function failed with error number 1060
Duplicate column name 'modified' SQL=ALTER TABLE `egu_flexbanners` ADD `modified` datetime NOT NULL default '0000-00-00 00:00:00';
SQL =

ALTER TABLE `#__flexbanners` ADD `modified` datetime NOT NULL default '0000-00-00 00:00:00';
-------------------------------------
Your guidance will be appreciated

Leo Lammerink
GWS-Desk.com

Andrew998
Posts: 1400
Joined: Wed Jan 07, 2009 10:43 am

Re: Upgrade to 4.0.18 databse table error

Post by Andrew998 » Tue Aug 26, 2014 11:13 am

Can you try the attached version please.
Attachments
com_flexbanners_4.0.18_update.zip
(290.57 KiB) Downloaded 141 times
Andrew998
Developer

gwsdesk
Posts: 2
Joined: Tue Aug 26, 2014 4:31 am

Re: Upgrade to 4.0.18 databse table error

Post by gwsdesk » Tue Aug 26, 2014 11:34 am

Andrew,
Thanks for that and for the very fast response. much appreciated and we have

Installing component was successful.

Cheers and thanks once again'

Leo L.

Post Reply