mySQL Error when upgrade from 1.7-2.5 (newsfeed unistalled)

[hugoaf]

Hi,

If you had uninstalled the newsfeed plugin, and you attempt to upgrade from 1.7.x to 2.5, you will get database errors because the upgrade proccess will try to run this sql command:

Code: Select all

ALTER TABLE `#__newsfeeds` CHANGE `alias` `alias` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '';

Even if you reinstall the plugin, and try upgrading again, now you will get errors because the fist attempt already applyed some changes to the DB, and will try to run this twice:

Code: Select all

#__languages` ADD UNIQUE `idx_image` (`image`);
#__languages` ADD UNIQUE `idx_langcode` (`lang_code`);

resulting in another sql error.

Since the newsfeed is not a protected system plugin, the upgrade needs to be modified to check if the plugin exists.