MiaCMS: Convert an Existing Mambo site over to MiaCMS

Convert an Existing Mambo site over to MiaCMS

Can a Mambo site be easily converted over to MiaCMS? You bet. We use to write the Mambo upgrade patches and bundle the releases so we have continued on with the same conventions. The process outlined below will help you convert a Mambo version 4.6.2+ site over to Mia. If you are running a Mambo release prior to version 4.6.2 it is best to patch up to that version before continuing with this conversion.

If you have ever applied a Mambo patch before then you'll recognize this process. Since Mambo served as the initial base of Mia the systems are similar enough that the conversion process is not much more involved than a standard upgrade.

Conversion Steps

1) Download our Mambo to Mia conversion patch here - http://code.google.com/p/miacms/downloads/list

2) Backup your site files and database. We have tested the conversion process quite a bit and have successfully upgraded a number of our own sites to Mia. That being said if something does happen to go wrong you'll want those backups. This is really not abnormal, we'd recommend the same even for Mia maintenance release.

3) Take your site offline: Site->Global Configuration->Site Offline (YES).

4) This patch includes a complete update for the MOStlyCE editor. To make sure the update goes smoothly follow these steps:

* If you have made customizations to your existing MOStlyCE install (ex) icon changes, enabling/disabling plugins, etc then first make a local backup copy of your MOStlyCE configuration file. You can find it at the following location mambots/editors/mostlyce/jscripts/tiny_mce/mostlyce_config.php.

* Next remove these three items (they will be replaced by the patch and we do not want to leave old artifacts around):
a) mambots/editors/mostlyce (the entire directory)
b) mambots/editors/mostlyce.php
c) mambots/editors/mostlyce.xml

5) Extract (or FTP) the conversion patch files into your existing Mambo 4.6.2+ installation and let the files overwrite the existing files with the same names. The conversion patch mirrors the existing Mambo 4.6.2+ file/folder structure so the files will go into the correct locations when extracted.

6) In this step you must replace your existing Mambo admin template with the new MiaCMS admin template or the system will not function properly. Run the SQL statement below via your normal database utility (i.e.) phpMyAdmin, MySQL Query Browser, etc.

Note: You need to replace #__ with the prefix of your tables. The default use to be mos_ and so that is more than likely what you will use unless you customized during your original Mambo installation. You will also need to verify that the admin template you are currently using on your Mambo site is called "mambo_admin_blue". That was the default in the Mambo 4.6 series and so unless you have changed it then this should still be the case. If you are using something different then just replace "mambo_admin_blue" in the WHERE clause with the template you are using.

UPDATE #__templates_menu
SET template='miacms_admin'
WHERE template='mambo_admin_blue';

7) Several new database tables have been added in MiaCMS to support new functionality. Run the following 3 SQL statements to create the new database tables via your normal database utility (i.e.) phpMyAdmin, MySQL Query Browser, etc.

CREATE TABLE `#__poll_charts` (
  `id` int(11),
  `bar_type` varchar(25) NOT NULL default 'bar_outline',
  `bar_color` varchar(6) NOT NULL default '45E56F',
  `width` int(11) NOT NULL default '300',
  `height` int(11) NOT NULL default '300',
  `title_font_size` int(11) NOT NULL default '12',
  PRIMARY KEY (`id`)
);

ALTER TABLE `#__polls` 
ADD COLUMN `use_chart_api` int(11) NOT NULL default '0' AFTER `lag`;

ALTER TABLE `#__comment` ADD COLUMN `website` varchar( 250 ) NOT NULL default '' AFTER `name` ,
ADD COLUMN `email` varchar( 100 ) NOT NULL default '' AFTER `name` ,
ADD COLUMN `user_id` varchar( 250 ) NOT NULL default '' AFTER `name` ,
ADD COLUMN `spam` tinyint( 1 ) NOT NULL default '0';

Note: You need to replace #__ with the prefix of your tables. The default use to be mos_ and so that is more than likely what you will use unless you customized during your original Mambo installation.

8) Add the following three lines to your configuration.php file:

$mosConfig_enable_stats_charting = '0';
$mosConfig_yui_version = '2.5.2';
$mosConfig_yui_loader='local_min';

9) Bring your site back online: Site->Global Configuration->Site Offline (NO).

10) If you are using the MOStlyCE editor then you need to do the following to finish off the editor update:

* If you made a backup of your mostlyce_config.php file in step 2 you should now put that back in place (mambots/editors/mostlyce/jscripts/tiny_mce/mostlyce_config.php).
* Verify your mostlyce_config.php file is writable (mambots/editors/mostlyce/jscripts/tiny_mce/mostlyce_config.php).
* Toggle the editor off and then back on to re-register it within your installation. You can do this via the first tab inside the global configuration interface.
* Clear your browsers cache. TinyMCE doesn't like to give up the cache so if you see errors like tinyMCE is not defined it's still hanging on. Clear again and refresh :)

Note: Failure to follow the steps mentioned above could cause the editor to load improperly and/or just display as a plain white textarea after the patch. If you experience any issues with the editor after follow these steps noted above please see the following thread for troubleshooting tips (http://forum.brilaps.com/index.php?topic=285.0).

That's it. Conversion Complete.

MiaCMS

The Official MiaCMS Documents

Content Management Made Easy

MiaCMS : ConvertMamboToMia

Convert an Existing Mambo site over to MiaCMS

Conversion Steps

Mia Official Sites