Database Errors When Upgrading to 2.5.0
When upgrading from an earlier, compatible version, to 2.5.0, you may experience a database error such as the following
JInstaller: :Install: Error SQL DB function failed with error number 1060
Duplicate column name 'ordering' SQL=ALTER TABLE `j17_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 `j17_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`;"
To fix this issues, go to Extension Manager -> Database then click the fix button. This will attempt to fix any database issues caused by changes in the database structure that occurred between versions.
