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

Update Problem

Post by tyrannski » Wed Jan 08, 2014 11:43 am

Hello,

i want to update my FlexBanner component from version 4.0.0 to 4.0.4. I use Joomla 1.5.17. I get 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';


Any help is appreciated.

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

Re: Update Problem

Post by Andrew998 » Thu Jan 09, 2014 8:29 am

Please see other threads on update problems.
Andrew998
Developer

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

Re: Update Problem

Post by tyrannski » Thu Jan 09, 2014 9:17 am

Hello Andrew,

thank you for your response. I did look for topics before posting about my update issues. I found these topics with similar issues but wasn't sure what to do with this information, as it is a bit old (flexbanner/install-error-t628.html#p2603) or regarding version 4.0.0 (flexbanner/warning-mysqli-num-rows-expe ... html#p2643)

Could you point me to the right topic or update package please?

Thanks in advance and kind regards
tyrannski

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

Re: Update Problem

Post by Andrew998 » Thu Jan 09, 2014 9:26 am

I would start here and see if the update helps: flexbanner/install-error-t628.html
Andrew998
Developer

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

Re: Update Problem

Post by tyrannski » Thu Jan 09, 2014 10:06 am

I installed the file posted by you on Nov 26, 2013 11:34 am but i get the same error message.

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

Re: Update Problem

Post by Andrew998 » Thu Jan 09, 2014 10:19 am

Did you try both update packages?
Andrew998
Developer

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

Re: Update Problem

Post by tyrannski » Thu Jan 09, 2014 10:27 am

Yes, i first installed update from Mon Nov 25, 2013 4:59 pm and after that the update from Tue Nov 26, 2013 11:34 am.

Both updates result in the same error message from above.

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

Re: Update Problem

Post by Andrew998 » Thu Jan 09, 2014 10:34 am

They may have given a similar message but they can't have given the same error. I need more information please.
Andrew998
Developer

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

Re: Update Problem

Post by tyrannski » Thu Jan 09, 2014 10:48 am

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: 1400
Joined: Wed Jan 07, 2009 10:43 am

Re: Update Problem

Post by Andrew998 » Thu Jan 09, 2014 10:53 am

I'm sorry but those updates deliberately don't include those updates so you need need to try saving them again and ensuring you are using the right version.
Andrew998
Developer

Post Reply