Mambo Upgrade

How to upgrade your Mambo version?

If you have installed Mambo via Fantastico:

You have to open Cpanel => Fantastico => Mambo Open Source and if there is a new version of Mambo, Fantastico will give you an 'Upgrade' button. You will be able to upgrade Mambo by clicking on that button:

If you have installed Mambo manually, you have to upgrade it manually.

We will show you how to upgrade Mambo 4.5.4 to Mambo 4.6.1:

Step 1. We assume that you have already installed Mambo 4.5.4 on your account. Now, you have to download this '_4.5.4_to_4.6' Patch from here. After you've downloaded the file, you have to extract it:

Step 2. Backup your site (both database & site files). Learn how to backup of your Mambo website.

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

Step 4. Then, you have to remove the following files and whole directories in your current Mambo installation by using your FTP client:

Directories:
/includes/patTemplate
/includes/domit
/help

Files:
/includes/mamboxml.php
/globals.php
/administrator/includes/auth.php
/administrator/components/com_weblinks/weblinks_item.xml
/administrator/components/com_languages/admin.languages.html.php

For example if you have installed Mambo in the folder named: 'mambo1' on your account, you have to remove:

public_html/mambo1/includes/patTemplate
public_html/mambo1/includes/domit
public_html/mambo1/help

and

public_html/mambo1/includes/mamboxml.php
public_html/mambo1/globals.php
public_html/mambo1/administrator/includes/auth.php
public_html/mambo1/administrator/components/com_weblinks/weblinks_item.xml
public_html/mambo1/administrator/components/com_languages/admin.languages.html.php

Step 5. Now, you have to run the SQL statements in the file called 454_to_46_upgrade.sql in the upgrades folder via your normal database interface (i.e.) phpMyAdmin, MySQL commandline, etc. (We will show you how to do it via PHPMyAdmin) You will need to replace #__ with whatever your table prefix is. By default the Mambo table prefix is set to mos_. Here are the SQL statements that you have to run (The #__ is renamed to mos_).

SQL Statements

INSERT INTO `mos__mambots` (`name`, `element`, `folder`, `access`, `ordering`, `published`, `iscore`, `client_id`, `checked_out`, `checked_out_time`, `params`) VALUES ('User Authenticator', 'mosvaliduserbot', 'authenticator', 0, 0, 1, 0, 0, 0, '0000-00-00 00:00:00', '' );


#
# Table structure for table `#__parameters`
#

CREATE TABLE `mos__parameters` (
`id` int(11) NOT NULL auto_increment,
`param_name` varchar(50) NOT NULL default '',
`param_file` varchar(50) NOT NULL default '',
`param_version` varchar(50) NOT NULL default '',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `names` (`param_name`, `param_version`)
) TYPE=MyISAM;

#
# Table structure for table `#__containers`
#

CREATE TABLE `mos__containers` (
`id` int(11) NOT NULL auto_increment,
`parentid` int(11) NOT NULL default '0',
`ordering` int(11) NOT NULL default '0',
`published` smallint(6) NOT NULL default '0',
`childcount` int(11) NOT NULL default '0',
`name` varchar(100) NOT NULL default '',
`title` varchar(100) NOT NULL default '',
`windowtitle` varchar(50) NOT NULL default '',
`keywords` varchar(255) NOT NULL default '',
`icon` varchar(25) NOT NULL default '',
`description` text NOT NULL,
PRIMARY KEY (`id`)
);

As we have already mentioned - you can run these SQL statements by using PHPMyadmin that comes with your CPanel. You can find how to reach PHPMyAdmin here

congfiguration.php

Now you need to find which database your Mambo installation uses. You can find that by using: Cpanel -> File Manager and navigate to the configuration.php file in your Mambo directory. Click on the file and from the file menu the right choose the Edit File link. Please, find the following variable:

$mosConfig_db

The value of this variable will show you which database does your Mambo installation use - e.g.:

$mosConfig_db = 'username_mamb1';

Step 6. Now navigate to your Mambo database in PHPMYadmin, go to the 'SQL' tab and paste the SQL statements in the blank box, named Run SQL query/queries on...

Step 7. Upload all files inside the Patch_4.5.4_to_4.6 (on your computer) into your Mambo installation on your hosting account. Let them overwrite the existing files. You can do that by using an FTP client.

Step 8. Open your configuration.php file and if your

$mosConfig_lang = 'english';

change it to

$mosConfig_lang = 'en';

To do that you can use the File manager (see the step above).

Step 9. If you are using SEO then remove your old .htaccess file and rename the new htaccess.txt file to .htaccess.

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

Step 11. Remove the upgrade folder.

Well done! You have successfully upgraded your Mambo system!

Please, feel free to contact us if you have any questions or recommendations about this tutorial at: tutorials 'at' siteground.com