Actions

Difference between revisions of "Database Errors When Upgrading to 2.5.0"

From Joomla! Documentation

(Created page with "When upgrading from an earlier, compatible version, to 2.5.0, you may experience a database error such as the following <code>JInstaller: :Install: Error SQL DB function failed ...")
 
m (clean up categories with <noinclude> tags)
 
Line 12: Line 12:
 
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.
 
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.
  
[[Category:Version 2.5 FAQ]][[Category:Version 2.5.0 FAQ]]
+
<noinclude>[[Category:Version 2.5 FAQ]][[Category:Version 2.5.0 FAQ]]</noinclude>

Latest revision as of 17:09, 1 September 2012

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.