Flexbanner upgrade to 4.0.19 error

This is the place to post questions and comments about the FlexBanner component
Post Reply
pkrahulec
Posts: 3
Joined: Tue Nov 18, 2014 3:20 pm

Flexbanner upgrade to 4.0.19 error

Post by pkrahulec » Tue Nov 18, 2014 3:26 pm

I've been a user and fan of Flexbanner for at least 5 years now and have had no issues with updates until lately. I have version 4.0.0 installed, and when I click to auto-upgrade the version to 4.0.19, I receive the following error messages:
===========================
JInstaller: :Install: Error SQL DB function failed with error number 1060
Duplicate column name 'modified' SQL=ALTER TABLE `j25_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 `j25_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';
===========================

Now when I got into the Flexbanner component and try to create a new banner, I receive this message as well:
===========================
Unknown column 'linkname' in 'field list' SQL=SELECT linkid AS value, IF(LENGTH(linkname)>0, linkname, linkurl) AS text FROM j25_flexbannerslink AS a ORDER BY a.linkname
===========================

When I click on the the new banner on my site I receive this error:
===========================
500 - View not found [name, type, prefix]: flexbanners, html, flexbannersView
===========================
Any help will be greatly appreciated. As always, thank you in advance,

Paul

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

Re: Flexbanner upgrade to 4.0.19 error

Post by Andrew998 » Wed Nov 19, 2014 12:07 pm

Try the attached update file please. Please do it before trying to upgrade to 4.0.20.
Attachments
com_flexbanners_4.0.19_update.zip
(293.33 KiB) Downloaded 109 times
Andrew998
Developer

pkrahulec
Posts: 3
Joined: Tue Nov 18, 2014 3:20 pm

Re: Flexbanner upgrade to 4.0.19 error

Post by pkrahulec » Wed Nov 19, 2014 2:28 pm

Andrew

Thank you very much for this fix, very much appreciated!

p
paul@krahulec.com

Post Reply

Who is online

Users browsing this forum: No registered users and 6 guests