Error upgrading Joomla 2.5.7 to 2.5.8

Joomla versions 2.5, 1.7 and 1.6 are all end-of-life since December 31st 2014 and are no longer supported. Please use Joomla 3.x instead.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Locked
alefmemalef64
Joomla! Intern
Joomla! Intern
Posts: 70
Joined: Mon Jul 14, 2008 6:50 pm

Error upgrading Joomla 2.5.7 to 2.5.8

Post by alefmemalef64 » Sun Sep 14, 2014 8:30 am

Hi,
I was working on a website I built a while ago with Joomla 2.5.7.
I saw in the control panel a message that the site needs to be updated to 2.5.8 so I pressed the link and the site has been downgraded to 2.5.24 and the following message appears:
JInstaller: :Install: Error SQL DB function failed with error number 1060
Duplicate column name 'ordering' SQL=ALTER TABLE `jos_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 `jos_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`;
see screenshot attached
You do not have the required permissions to view the files attached to this post.

User avatar
toivo
Joomla! Master
Joomla! Master
Posts: 17516
Joined: Thu Feb 15, 2007 5:48 am
Location: Sydney, Australia

Re: Error upgrading Joomla 2.5.7 to 2.5.8

Post by toivo » Sun Sep 14, 2014 8:54 am

I pressed the link and the site has been downgraded to 2.5.24
The site was not downgraded, it was upgraded to the latest 2.5 version, 2.5.24.

Go to Extension Manager - Database and click the button Fix in the top right hand corner. That will add the new columns to the tables.

Remember to clear the cache.
Toivo Talikka, Global Moderator

alefmemalef64
Joomla! Intern
Joomla! Intern
Posts: 70
Joined: Mon Jul 14, 2008 6:50 pm

Re: Error upgrading Joomla 2.5.7 to 2.5.8

Post by alefmemalef64 » Sun Sep 14, 2014 9:43 am

Thank you toivo.
I'm a bit worried about clearing my cache - see screenshot attached - do you think it should be ok?
You do not have the required permissions to view the files attached to this post.

User avatar
toivo
Joomla! Master
Joomla! Master
Posts: 17516
Joined: Thu Feb 15, 2007 5:48 am
Location: Sydney, Australia

Re: Error upgrading Joomla 2.5.7 to 2.5.8

Post by toivo » Sun Sep 14, 2014 10:59 am

Clearing the cache from the server is a safe operation. The purpose of cached contents is to avoid generating the same content repeatedly, which makes the server respond faster.

It is important to clear the cache from your browser to avoid problems with obsolete javascript files in the back end.
Toivo Talikka, Global Moderator

alefmemalef64
Joomla! Intern
Joomla! Intern
Posts: 70
Joined: Mon Jul 14, 2008 6:50 pm

Re: Error upgrading Joomla 2.5.7 to 2.5.8

Post by alefmemalef64 » Sun Sep 14, 2014 11:08 am

thanks


Locked

Return to “Migrating and Upgrading to Joomla! 2.5”