MiaCMS 4.6.5 to 4.8 Patch Instructions
This patch is to be used to upgrade a MiaCMS 4.6.5 site to version 4.8. This patch fixes numerous bugs and adds a good bit of new functionality to the CMS.
If you are NOT running MiaCMS 4.6.5 then you should patch up to this version prior to applying this new patch. If you are looking to convert from Mambo to MiaCMS see the conversion guide here - http://docs.miacms.org/wikka.php?wakka=ConvertMamboToMia. If this is your first MiaCMS site then you should be using the full install package rather than this patch.
1) Backup your MiaCMS site files and database before being this upgrade.
2) Take your site offline: Site->Global Configuration->Site Offline (YES).
3) Removing the following files:
- administrator/includes/js/miacms_admin_menu.js
- includes/js/yui_extras/miacms_yui_general.js
- includes/js/yui (this folder and all files under it)
4) Extract the patch into your existing MiaCMS 4.6.5 installation and let the files overwrite the existing files with the same names. The patch mirrors the existing MiaCMS 4.6.5 file/folder structure so the files will go into the correct locations when extracted.
5) Some database table changes are required to support content versioning & OpenID. Run the following SQL 4 statements. Run them via your normal database utility (i.e.) phpMyAdmin, MySQL Query Browser, etc.
CREATE TABLE `#__content_revisions` ( `id` int(11) NOT NULL auto_increment, `content_id` int(11) default NULL, `title` varchar(100) default NULL, `title_alias` varchar(100) default NULL, `introtext` mediumtext, `fulltext` mediumtext, `revision` int(11) default NULL, `modified_by` int(11) default NULL, `modification_date` datetime default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM; INSERT INTO `#__components` VALUES (NULL,'OpenID','option=com_openid',0,0,'','','com_openid',0,'',0,''); CREATE TABLE IF NOT EXISTS `#__user_openids` ( `id` int(11) NOT NULL auto_increment, `user_id` int(11) NOT NULL, `openid` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM; CREATE TABLE IF NOT EXISTS `#__openid_association` ( `idp_endpoint_uri` varchar(255) default NULL, `assoc_handle` varchar(255) NOT NULL, `assoc_type` varchar(32) default NULL, `session_type` varchar(32) default NULL, `mac_key` varchar(255) default NULL, `created` int(11) NOT NULL default '0', `expires_in` int(11) NOT NULL default '0', PRIMARY KEY (`assoc_handle`) ) ENGINE=MyISAM;
Note: You MUST replace #__ with the prefix of your tables. The old Mambo default was mos_ and the current MiaCMS default is mia_ so you'll probably be using one of these unless you customized your prefix during the original installation.
6) Add the following four lines to your configuration.php file:
$mosConfig_enable_revisioning = '0'; $mosConfig_revision_count = '10'; $mosConfig_enable_old_javascript = '0'; $mosConfig_enable_openid = '0';
7) Update the following variable value in the configuration.php file:
$mosConfig_yui_version = '2.6.0';
8) Bring your site back online: Site->Global Configuration->Site Offline (NO).
That's it. Patch Complete.
