Upgrading Mambo 4.5(1.0.9) to Joomla 1.0.7 (maybe) easily.

Forum closed, please submit your tips and tricks to: http://docs.joomla.org/Category:Tips_and_tricks
Forum rules
Please submit all new Tips and Tricks to: http://docs.joomla.org/Category:Tips_and_tricks

This forum section will be closed and removed eventually.
User avatar
PhilTaylor-Prazgod
Joomla! Ace
Joomla! Ace
Posts: 1122
Joined: Sat Aug 20, 2005 12:32 pm
Location: Weymouth, UK
Contact:

Upgrading Mambo 4.5(1.0.9) to Joomla 1.0.7 (maybe) easily.

Postby PhilTaylor-Prazgod » Tue Feb 07, 2006 8:59 pm

http://blog.phil-taylor.com/2006/02/07/ ... be-easily/
Filed under: Joomla Core — Phil Taylor @ 8:48 pm

DO NOT ATTEMPT THIS IF YOU DONT KNOW WHAT YOU ARE DOING!!! EMPLOY AN EXPERT TO DO IT IF YOU ARE AT ALL UNSURE - MESSING IT UP COULD LOOSE ALL YOUR DATA !!!!!

Today I had to upgrade a customer form Mambo 4.5(1.0.9) to Joomla 1.0.7, this is not for the feint hearted!

Although they had loads of custom components I was only interested in upgrading the core of Mambo, I.e. the database schema and files.

I manually went through and compared the database, table by table, field by field, property by property, index/key by index/key, and compiled a long list of SQL commands that are needed to upgrade the database so it can be used.

I AM RELEASING THIS SCRIPT FOR FREE in the hope it is useful :-)

Here are the steps I took


  1. BACKUP FILES

  2. BACKUP THE DATABASE

  3. BACKUP AGAIN

  4. Overwrite the Mambo files with the Joomla Files

  5. Run my upgrade SQL (Download from http://www.phil-taylor.com/Free )

  6. TEST

  7. Optional: upgrade custom components/modules/mambots


DO NOT ATTEMPT THIS IF YOU ARE UNSURE


This script is provided AS IS and is NOT SUPPORTED by Phil Taylor, Blue Flame IT Ltd. Use at your own risk.
Last edited by stingrey on Mon Feb 27, 2006 10:07 am, edited 1 time in total.
Phil Taylor - Full Time Joomla/PHP Security Expert
Blue Flame IT Ltd.
-- https://myjoomla.com/ Joomla Security/Hack fix Auditing Service
-- https://www.phil-taylor.com/

zorro128
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 147
Joined: Tue Sep 27, 2005 7:27 am
Contact:

Re: Upgrading Mambo 4.5(1.0.9) to Joomla 1.0.7 (maybe) easily.

Postby zorro128 » Sun Feb 12, 2006 6:14 am

After I have followed these steps my new upgraded site worked perfectly. Bur when I have tried to execute update.sql file I got error saying that some tables already exists. But even without upgrading the database everything worked ok.

Maybe this is because I have tried this on clean installation of mambo 451a.

Is it really necessary to run that upgrade.sql file
http://www.allmightyweb.com
Custom modules, components anad joomla templates

User avatar
PhilTaylor-Prazgod
Joomla! Ace
Joomla! Ace
Posts: 1122
Joined: Sat Aug 20, 2005 12:32 pm
Location: Weymouth, UK
Contact:

Re: Upgrading Mambo 4.5(1.0.9) to Joomla 1.0.7 (maybe) easily.

Postby PhilTaylor-Prazgod » Sun Feb 12, 2006 2:38 pm

probably - the title of my post says FROM Mambo 4.5(1.0.9) which is not the same as Mambo 4.5.1a and therefore you probably will have issues.
Phil Taylor - Full Time Joomla/PHP Security Expert
Blue Flame IT Ltd.
-- https://myjoomla.com/ Joomla Security/Hack fix Auditing Service
-- https://www.phil-taylor.com/

mcbain
Joomla! Apprentice
Joomla! Apprentice
Posts: 29
Joined: Sun Feb 12, 2006 5:28 pm

Re: Upgrading Mambo 4.5(1.0.9) to Joomla 1.0.7 (maybe) easily.

Postby mcbain » Sun Feb 12, 2006 5:29 pm

Can this update also be run from a 4.5.2 version ??

User avatar
PhilTaylor-Prazgod
Joomla! Ace
Joomla! Ace
Posts: 1122
Joined: Sat Aug 20, 2005 12:32 pm
Location: Weymouth, UK
Contact:

Re: Upgrading Mambo 4.5(1.0.9) to Joomla 1.0.7 (maybe) easily.

Postby PhilTaylor-Prazgod » Sun Feb 12, 2006 6:46 pm

The clue is in the title :

Mambo 4.5(1.0.9) to Joomla 1.0.7

In other words no :-) :-)
Phil Taylor - Full Time Joomla/PHP Security Expert
Blue Flame IT Ltd.
-- https://myjoomla.com/ Joomla Security/Hack fix Auditing Service
-- https://www.phil-taylor.com/

mlcdigital
Joomla! Apprentice
Joomla! Apprentice
Posts: 7
Joined: Thu Jan 12, 2006 10:56 am
Contact:

Re: Upgrading Mambo 4.5(1.0.9) to Joomla 1.0.7 (maybe) easily.

Postby mlcdigital » Fri Feb 24, 2006 10:40 pm

I had to upgrade two sites from Mambo 4.5.2 (last stable release) to Joomla! 1.7 because we were getting attacked and our ISP was seeing the attacks as coming from us.
I upgraded the sites to Joomla! just fine but I didn't copy Joomla! over our current files.
I moved our files to a temp directory then copied the Joomla! files into the hosted directory.
Edited the Joomla! config file to point to the hosted directory.
Then moved any additional modules, components, mambots, images, and files over.
Manually changed the SQL variables for the administrator page/templates.
Everything was working great on the back-end and front-end of the site except the Contacts.
On the back-end the Contacts module works fine and all the contacts are listed under their group but on the front-end of the site if you try to fill the email form out it never gets to the contact and a copy never goes to the sender.
We were/are using SMTP and a hostname and that is how it looks under Global Config.
Is there an SQL value or a config file I need to adjust?

User avatar
kenmcd
Joomla! Champion
Joomla! Champion
Posts: 5672
Joined: Thu Aug 18, 2005 2:09 am
Location: California
Contact:

Re: Upgrading Mambo 4.5(1.0.9) to Joomla 1.0.7 (maybe) easily.

Postby kenmcd » Mon Feb 27, 2006 1:52 pm

zorro128 wrote:After I have followed these steps my new upgraded site worked perfectly. Bur when I have tried to execute update.sql file I got error saying that some tables already exists. But even without upgrading the database everything worked ok.

Maybe this is because I have tried this on clean installation of mambo 451a.

Is it really necessary to run that upgrade.sql file


kenmcd wrote:The Mambo 4.5 Stable-1.0.9 to Mambo 4.5.1 SQL upgrade file (upgrade45_109to451.sql) has some errors which may be the problem.
There are duplicates for some of the entries made in the 4.014 to 4.5 SQL file (upgrade4014to45.sql).

Commenting-out the duplicates may allow the upgrade to complete properly.
See attached file:  upgrade45_109to451_fixed.sql.txt

More info here:
Migrating Mambo 4.5 Stable-1.0.9 to Joomla 1.04
http://forum.joomla.org/index.php/topic ... #msg140356

Fix:
Some of the entries for the already existing table must be commented out in the SQL update file.
This allows the script to finish without crashing.
Yes, you must run this script - the other changes are needed.
██ LibreTraining

mlcdigital
Joomla! Apprentice
Joomla! Apprentice
Posts: 7
Joined: Thu Jan 12, 2006 10:56 am
Contact:

Re: Upgrading Mambo 4.5(1.0.9) to Joomla 1.0.7 (maybe) easily.

Postby mlcdigital » Mon Feb 27, 2006 8:05 pm

After reading through this thread again I actually looked at the sql upgrade script and noticed it did more then just tweak the admin template table.
So I ran the sql upgrade script and it ran with no problems.
So I've migrated from Mambo 4.5.2 to Joomla 1.7 ran the sql script verified the Global Configurations BUT our Contacts still aren't working.
If you try and fill out a contact email form mail isn't sent.
Is there a config in the MySQL tables that needs to be tweaked?

zorro128
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 147
Joined: Tue Sep 27, 2005 7:27 am
Contact:

Re: Upgrading Mambo 4.5(1.0.9) to Joomla 1.0.7 (maybe) easily.

Postby zorro128 » Tue Feb 28, 2006 5:34 pm

I am having a problem with backup of my site. I have tried to run sql query which contained my old databse but I got this error:

"#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 19
"
http://www.allmightyweb.com
Custom modules, components anad joomla templates

User avatar
PhilTaylor-Prazgod
Joomla! Ace
Joomla! Ace
Posts: 1122
Joined: Sat Aug 20, 2005 12:32 pm
Location: Weymouth, UK
Contact:

Re: Upgrading Mambo 4.5(1.0.9) to Joomla 1.0.7 (maybe) easily.

Postby PhilTaylor-Prazgod » Tue Feb 28, 2006 5:35 pm

It means that you are running an older version of mysql - just remove that last part about default charsets
Phil Taylor - Full Time Joomla/PHP Security Expert
Blue Flame IT Ltd.
-- https://myjoomla.com/ Joomla Security/Hack fix Auditing Service
-- https://www.phil-taylor.com/

Jaga
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Thu Sep 14, 2006 10:32 am

Re: Upgrading Mambo 4.5(1.0.9) to Joomla 1.0.7 (maybe) easily.

Postby Jaga » Thu Sep 14, 2006 10:37 am

Hello

I want to upgrading to Joomla from my old Mambo CMS ... but I'm little confused with the versions. In my backend there's written: Version: 4.5.1 Stable [Three For Rum] 24/09/2004 00:08 GMT ... so can I use this upgrade-tutorial or should I first update to Mambo 4.5.2 (I hope this is still possible!?) and then follow these instructions: http://help.joomla.org/content/view/818/181/

Thanks for any help ... I hope I can soon participate the Joomla Community

mauri
Joomla! Intern
Joomla! Intern
Posts: 64
Joined: Mon Aug 22, 2005 6:47 pm

Re: Upgrading Mambo 4.5(1.0.9) to Joomla 1.0.7 (maybe) easily.

Postby mauri » Thu Nov 16, 2006 10:19 pm

Hi Phil
Mambo 4.5(1.0.9) to Joomla 1.0.7 Upgrade Script v1.0 is great and works upgrading 4.5(1.0.9) to Joomla 1.0.11 too.
But I think there is missing one row:

Code: Select all

INSERT INTO `mos_components` VALUES ('', 'Syndicate', '', 0, 0, 'option=com_syndicate', 'Manage Syndication Settings', 'com_syndicate', 0, 'js/ThemeOffice/component.png', 0, '');

because in 4.5(1.0.9) , there is no com_syndicate.
Last edited by mauri on Sat Nov 18, 2006 6:35 pm, edited 1 time in total.

User avatar
cradleofphil
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 188
Joined: Wed Aug 24, 2005 5:22 pm
Location: Ashland, OR
Contact:

Re: Upgrading Mambo 4.5(1.0.9) to Joomla 1.0.7 (maybe) easily.

Postby cradleofphil » Mon Feb 26, 2007 6:57 am

I am wondering if these same rules apply to migrating from Mambo 4.6.1 to Joomla 1.0.12 ?  The main reason I am wanting to migrate is because joomla supports the SEO component that allows individual page titles.  Not having this has REALLY hurt my SEO ratings and possibilities of more traffic.

Any info greatly appreciated,

Phil


Return to “Submit Your Suggested Tips & Tricks to Docs.joomla.org now please.”

Who is online

Users browsing this forum: No registered users and 1 guest