Update Problem

This is the place to post questions and comments about the FlexBanner component
tyrannski
Posts: 10
Joined: Wed Jan 08, 2014 11:36 am

Re: Update Problem

Post by tyrannski » Thu Jan 09, 2014 11:02 am

I downloaded both updates three times now and tried to install them one after the other. But i still get the same error messages.


The first update from Mon Nov 25, 2013 4:59 pm gave the following error:


JInstaller: :Install: SQL-Fehler DB-Funktion mit Fehlercode 1060 fehlgeschlagen!
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';

Komponentenaktualisierung: SQL-Fehlerdatei DB-Funktion mit Fehlercode 1060 fehlgeschlagen!
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';

the update from Tue Nov 26, 2013 11:34 am gave the following error:



JInstaller: :Install: SQL-Fehler DB-Funktion mit Fehlercode 1060 fehlgeschlagen!
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';

Komponentenaktualisierung: SQL-Fehlerdatei DB-Funktion mit Fehlercode 1060 fehlgeschlagen!
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';

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

Re: Update Problem

Post by Andrew998 » Thu Jan 09, 2014 11:04 am

The update must be cached because those versions do not contain that database update. Try this version.
Attachments
com_flexbanners_update2.zip
(273.52 KiB) Downloaded 95 times
Andrew998
Developer

tyrannski
Posts: 10
Joined: Wed Jan 08, 2014 11:36 am

Re: Update Problem

Post by tyrannski » Thu Jan 09, 2014 11:11 am

Same error with your update2.
I cleared all cache in Joomla before installing.

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

Re: Update Problem

Post by Andrew998 » Thu Jan 09, 2014 11:13 am

Then I can't help you. That update package does not include the update to the database and cannot give that error message.
Andrew998
Developer

tyrannski
Posts: 10
Joined: Wed Jan 08, 2014 11:36 am

Re: Update Problem

Post by tyrannski » Thu Jan 09, 2014 11:22 am

I could give you access to my backend and you cold look at the error message yourself if that helps.

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

Re: Update Problem

Post by Andrew998 » Thu Jan 09, 2014 11:23 am

I'm happy to take a look if you want. You can direct message me the details.
Andrew998
Developer

tyrannski
Posts: 10
Joined: Wed Jan 08, 2014 11:36 am

Re: Update Problem

Post by tyrannski » Thu Jan 09, 2014 1:15 pm

Hello Andrew,

thank you for taking care of my issue.

One question remains. In Extension manager: update i am notified of an update of flexbanner 4.0.4 although the version running is 4.0.4

i did not try to install this update as i am afraid i could ruin it again.

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

Re: Update Problem

Post by Andrew998 » Thu Jan 09, 2014 1:26 pm

If you clear the update cache it will not show it.
Andrew998
Developer

tyrannski
Posts: 10
Joined: Wed Jan 08, 2014 11:36 am

Re: Update Problem

Post by tyrannski » Thu Jan 09, 2014 1:38 pm

Thank you Andrew for helping me out.

Adam_NZ
Posts: 2
Joined: Sat Feb 08, 2014 2:48 am

Re: Update Problem

Post by Adam_NZ » Sat Feb 08, 2014 2:55 am

I have the same problem - trying to update from 4.0.0 to 4.0.8 (shown below).

I've read update/install problems topics here, but they appear to indicate that a fresh/total reinstall may be required. I have many flexbanners already set up and don't want to lose them.

I'm able to get onto the database via phpMyAdmin and manually alter any tables if required - if that's an easier way to fix this.

Many thanks,

Adam.

P.S. It's an *excellent* Joomla add-on!

==============================================================
JInstaller: :Install: Error SQL DB function failed with error number 1060
Duplicate column name 'modified' SQL=ALTER TABLE `jos_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 `jos_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';

Post Reply

Who is online

Users browsing this forum: No registered users and 4 guests