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: 1388
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: 1388
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: 1388
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: 1388
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: 1388
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

Who is online

Users browsing this forum: No registered users and 5 guests