Actions

Database Errors When Upgrading to 2.5.0

From Joomla! Documentation

Revision as of 20:17, 30 January 2012 by Betweenbrain (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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.