Installation Problem

This is the place to post questions and comments about the FlexBanner component
Post Reply
doorknob
Posts: 22
Joined: Mon Dec 30, 2013 12:34 pm

Installation Problem

Post by doorknob » Fri Jan 17, 2014 9:21 am

Re: Handling responsive templates

Postby doorknob » Thu Jan 02, 2014 2:14 pm
I uninstalled v4.0.3, all went well and the db tables were successfully removed.
I installed v4.0.0 and again all went well.
When I installed the update2, I got the error message
1060 Duplicate column name 'modified' SQL=ALTER TABLE `pasdf_flexbanners` ADD `modified` datetime NOT NULL default '0000-00-00 00:00:00';
I dropped that column and ran the update again. This time I got
1060 Duplicate column name 'modified_by' SQL=ALTER TABLE `pasdf_flexbanners` ADD `modified_by` int(10) unsigned NOT NULL default '0';
Then
1060 Duplicate column name 'version' SQL=ALTER TABLE `pasdf_flexbanners` ADD COLUMN `version` int(10) unsigned NOT NULL DEFAULT '1';
Then
1054 Unknown column 'categoryid' in 'pasdf_flexbanners' SQL=ALTER TABLE `pasdf_flexbanners` CHANGE `categoryid` `newwin` TINYINT(1) NOT NULL default '0';
Changed the column name catid to categoryid and tried again. Then
1060 Duplicate column name 'newwin' SQL=ALTER TABLE `pasdf_flexbanners` CHANGE `categoryid` `newwin` TINYINT(1) NOT NULL default '0';
Dealt with that and the got 'catid not found and gave up

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

Re: Installation Problem

Post by Andrew998 » Fri Jan 17, 2014 9:28 am

Can you please try this update.
Attachments
com_flexbanners_4.0.5_nodata.zip
(275.76 KiB) Downloaded 136 times
Andrew998
Developer

Post Reply