Joomla Templates Club 406,261 posts

[azraf03 Friend azraf03Join date: January 2012Posts: 2Downloads:0Uploads:1]

#173751

While I am trying to upgrade the site using Extension Manager: Update, its showing following error:

<blockquote> JInstaller: :Install: Error SQL DB function failed with error number 1060
Duplicate column name ‘ordering’ SQL=ALTER TABLE `dwsta_languages` ADD COLUMN `ordering` int(11) NOT NULL default 0 AFTER `published`;
SQL =

ALTER TABLE `#__languages` ADD COLUMN `ordering` int(11) NOT NULL default 0 AFTER `published`;

Files Update: SQL error file DB function failed with error number 1060
Duplicate column name ‘ordering’ SQL=ALTER TABLE `dwsta_languages` ADD COLUMN `ordering` int(11) NOT NULL default 0 AFTER `published`;
SQL =

ALTER TABLE `#__languages` ADD COLUMN `ordering` int(11) NOT NULL default 0 AFTER `published`;</blockquote>

How to upgrade in Joomla 2.5.x series?

[jhicks Friend jhicksJoin date: March 2011Posts: 94Downloads:0Uploads:15 Thanks: 29 Thanked: 12 times in 1 posts]

#437829

check under the Extension manager for the Database tab per this:

http://docs.joomla.org/Upgrading_from_an_existing_version

Jeff

[alexc Friend alexcJoin date: September 2011Posts: 2Downloads:0Uploads:1 Thanks: 2]

#440100

Yes – I had exactly the same problem as azraf03, and I needed to fix the database using the above instructions. Seems fine.

Thanks.

[Author]

Posts