Unable to update Flexbanners

This is the place to post questions and comments about the FlexBanner component
Post Reply
muddauber
Posts: 11
Joined: Sat Apr 06, 2013 5:34 am

Unable to update Flexbanners

Post by muddauber » Fri Jan 08, 2016 5:55 am

Unable to update Flexbanners on Joomla 3.4.8 install with PHP Version 5.4.45

I get the following error message.

Warning
Duplicate column name 'modified' SQL=ALTER TABLE `j25_flexbanners` ADD `modified` datetime NOT NULL default '0000-00-00 00:00:00';

Ran the Database fix option and Akeeba Repair utility to no avail. Any ideas how to fix this?

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

Re: Unable to update Flexbanners

Post by Andrew998 » Fri Jan 08, 2016 9:08 am

Can you try the attached upgrade first.
Attachments
com_flexbanners_4.0.29_update.zip
(295.17 KiB) Downloaded 81 times
Andrew998
Developer

muddauber
Posts: 11
Joined: Sat Apr 06, 2013 5:34 am

Re: Unable to update Flexbanners

Post by muddauber » Sat Apr 02, 2016 7:22 am

Thanks, but I get the following error after install:

Warning
Duplicate column name 'modified' SQL=ALTER TABLE `#__flexbanners` ADD `modified` datetime NOT NULL default '0000-00-00 00:00:00';


Then when I open flexbanner component I get this error message:
An error has occurred.

500 Unknown column 'a.cloud_imageurl' in 'field list' SQL=SELECT a.id AS id, a.name AS name,a.clientid AS clientid, a.linkid AS linkid,a.sizeid AS sizeid, a.type AS type,a.locationid AS locationid,a.imageurl AS imageurl, a.imagealt AS imagealt,a.cloud_imageurl AS cloud_imageurl,a.restrictbyid AS restrictbyid, a.frontpage AS frontpage,a.customcode AS customcode,a.checked_out AS checked_out,a.checked_out_time AS checked_out_time, a.catid AS catid,a.clicks AS clicks, a.maxclicks AS maxclicks, a.maximpressions AS maximpressions, a.impmade AS impmade,a.dailyimpressions AS dailyimpressions,a.state AS state, a.ordering AS ordering,a.published,a.language, a.startdate, a.enddate,l.title AS language_title,uc.name AS editor,c.title AS category_title,cl.clientname AS client_name,link.linkid AS linkid,loc.locationname as locationname,size.sizename AS sizename FROM `#__flexbanners` AS a LEFT JOIN `#__languages` AS l ON l.lang_code = a.language LEFT JOIN #__users AS uc ON uc.id=a.checked_out LEFT JOIN #__categories AS c ON c.id = a.catid LEFT JOIN #__flexbannersclient AS cl ON cl.clientid = a.clientid LEFT JOIN #__flexbannerslink AS link ON link.linkid = a.linkid LEFT JOIN #__flexbannerslocations AS loc ON loc.locationid = a.locationid LEFT JOIN #__flexbannerssize AS size ON size.sizeid = a.sizeid WHERE (a.state IN (0, 1)) ORDER BY a.name asc LIMIT 0, 20

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

Re: Unable to update Flexbanners

Post by Andrew998 » Sat Apr 02, 2016 10:40 am

Try this.
Attachments
com_flexbanners_4.1.00update.zip
(307.43 KiB) Downloaded 69 times
Andrew998
Developer

muddauber
Posts: 11
Joined: Sat Apr 06, 2013 5:34 am

Re: Unable to update Flexbanners

Post by muddauber » Sat Apr 02, 2016 7:06 pm

I continue to get error messages

when opening control panel access to component in categories clients, and links
An error has occurred.
404 Component not found.

Yet, I see the components in the extension manager:

I love this banner extension and would appreciate getting it to work again. Any suggestions?

I tried the uninstall and reinstall

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

Re: Unable to update Flexbanners

Post by Andrew998 » Sat Apr 02, 2016 10:24 pm

That really should have fixed it. And a uninstall and reinstall is like starting from scratch so should be fine. I really think something else is going on. I'll need more details of errors you are now seeing or full access to your site to help any further.
Andrew998
Developer

muddauber
Posts: 11
Joined: Sat Apr 06, 2013 5:34 am

Re: Unable to update Flexbanners

Post by muddauber » Sun Apr 03, 2016 12:06 am

I tried the uninstall and reinstall routine again after your comments, and it took. So, I'm back up and running.

Sent you another donation- Great Mod!!

Thanks

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

Re: Unable to update Flexbanners

Post by Andrew998 » Mon Apr 04, 2016 3:23 pm

Thanks. Glad you got it sorted.
Andrew998
Developer

muddauber
Posts: 11
Joined: Sat Apr 06, 2013 5:34 am

Re: Unable to update Flexbanners

Post by muddauber » Tue Apr 05, 2016 6:07 pm

I had to reinstall the program and recreate all the banners and links, but my problem now is that the
banners do not rotate or refresh when I reload/refresh the pages.

See: http://sanantoniofla.com/index.php?opti ... Itemid=272

I just realized it is only happening with the desktop, so when I disabled one of my new image links, it started working.
Something must be wrong with the jpg image. I changed the image and now it is working. DO you have any idea
what could cause this?

It refreshes fine with the mobile site

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

Re: Unable to update Flexbanners

Post by Andrew998 » Wed Apr 06, 2016 9:19 am

Sorry, your site is blocking me (Admin Tools).
Andrew998
Developer

Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests