The Joomla! Forum ™



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.



Post new topic Reply to topic  [ 13 posts ] 
Author Message
PostPosted: Tue Feb 07, 2006 8:59 pm 
User avatar
Joomla! Ace
Joomla! Ace

Joined: Sat Aug 20, 2005 12:32 pm
Posts: 1118
Location: Weymouth, UK
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.

_________________
Phil Taylor - Full Time Joomla/PHP Expert
Blue Flame IT Ltd.
-- http://myjoomla.com/ Joomla Security/Hack fix Auditing Service
-- http://www.phil-taylor.com/


Last edited by stingrey on Mon Feb 27, 2006 10:07 am, edited 1 time in total.

Top
 Profile  
 
PostPosted: Sun Feb 12, 2006 6:14 am 
Joomla! Enthusiast
Joomla! Enthusiast

Joined: Tue Sep 27, 2005 7:27 am
Posts: 146
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


Top
 Profile  
 
PostPosted: Sun Feb 12, 2006 2:38 pm 
User avatar
Joomla! Ace
Joomla! Ace

Joined: Sat Aug 20, 2005 12:32 pm
Posts: 1118
Location: Weymouth, UK
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 Expert
Blue Flame IT Ltd.
-- http://myjoomla.com/ Joomla Security/Hack fix Auditing Service
-- http://www.phil-taylor.com/


Top
 Profile  
 
PostPosted: Sun Feb 12, 2006 5:29 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Sun Feb 12, 2006 5:28 pm
Posts: 29
Can this update also be run from a 4.5.2 version ??


Top
 Profile  
 
PostPosted: Sun Feb 12, 2006 6:46 pm 
User avatar
Joomla! Ace
Joomla! Ace

Joined: Sat Aug 20, 2005 12:32 pm
Posts: 1118
Location: Weymouth, UK
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 Expert
Blue Flame IT Ltd.
-- http://myjoomla.com/ Joomla Security/Hack fix Auditing Service
-- http://www.phil-taylor.com/


Top
 Profile  
 
PostPosted: Fri Feb 24, 2006 10:40 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Thu Jan 12, 2006 10:56 am
Posts: 7
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?


Top
 Profile  
 
PostPosted: Mon Feb 27, 2006 1:52 pm 
User avatar
Joomla! Champion
Joomla! Champion

Joined: Thu Aug 18, 2005 2:09 am
Posts: 5657
Location: California
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.

_________________
██ AllMedia4Joomla Project
██ http://sourceforge.net/projects/allmedia4joomla/
██ AllMedia YöuTube Feed Gallery module released
██ Download: http://sourceforge.net/projects/allmedia4joomla/files/


Top
 Profile  
 
PostPosted: Mon Feb 27, 2006 8:05 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Thu Jan 12, 2006 10:56 am
Posts: 7
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?


Top
 Profile  
 
PostPosted: Tue Feb 28, 2006 5:34 pm 
Joomla! Enthusiast
Joomla! Enthusiast

Joined: Tue Sep 27, 2005 7:27 am
Posts: 146
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


Top
 Profile  
 
PostPosted: Tue Feb 28, 2006 5:35 pm 
User avatar
Joomla! Ace
Joomla! Ace

Joined: Sat Aug 20, 2005 12:32 pm
Posts: 1118
Location: Weymouth, UK
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 Expert
Blue Flame IT Ltd.
-- http://myjoomla.com/ Joomla Security/Hack fix Auditing Service
-- http://www.phil-taylor.com/


Top
 Profile  
 
PostPosted: Thu Sep 14, 2006 10:37 am 
Joomla! Fledgling
Joomla! Fledgling

Joined: Thu Sep 14, 2006 10:32 am
Posts: 2
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


Top
 Profile  
 
PostPosted: Thu Nov 16, 2006 10:19 pm 
Joomla! Intern
Joomla! Intern

Joined: Mon Aug 22, 2005 6:47 pm
Posts: 64
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:
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.

Top
 Profile  
 
PostPosted: Mon Feb 26, 2007 6:57 am 
User avatar
Joomla! Enthusiast
Joomla! Enthusiast

Joined: Wed Aug 24, 2005 5:22 pm
Posts: 188
Location: Ashland, OR
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

_________________
http://www.netlogicsolutions.net

http://www.cradleofphil.com


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 13 posts ] 



Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group