Joomla Tutorials and Blog Posts

SP Upgrade for Joomla 1.5 to 2.5 Migration

22944Now here's a strange coincidence ... while I was writing this tutorial, one of my sites got hacked because it wasn't updated. I had neglected to update my site because it involves downloads and uploads and who has time for that? Well I should have taken the time. I learned my lesson, and I'm getting ready for the future.

With Joomla 2.5 the upgrades are much easier, so I've decided to migrate all my Joomla sites to 2.5. There is a simple, new tool for making the transition, and it works - SP Upgrade. You may not need to do this today, but when that day eventually arrives, this tutorial will help you make this transition very smoothly. A note before we start: this extension is commercial. If you're looking for a free alternative, try our tutorial on jUpgrade.

Step 1. Get ready to migrate

To make it quick, start with preparation.

  1. Make a list of all your plugins and components. These will not be copied to the new site, and you will most likely need to upload versions compatible with Joomla 2.5.
  2. Download and have ready for install all of the updated plugins.
  3. Get an updated version of your template if possible
  4. Create a clean (clean no sample data installed), installation of Joomla 2.5 on your server. If you have to delete the sample data, be sure you empty all the trash.
  5. Check your installation to see if you are up-to-date. If you are using Quick Install or Fantastico you might not have the latest version of 2.5, so use the upgrade feature of 2.5 to update to your latest version. You can also install Akeeba Admin Tools, if you prefer using that. It won't affect the migration.
  6. Check your installation to see whether your new site is using MySQLi. (Instructions below)
  7. Gather all your usernames, passwords and file directory paths and have them handy.

Gathering the database information from the original site.

tutuploadsGathering_the_database_information_from_the_original_si_1.png

Before you start use a file manager or FTP to open your configuration.php file, All you need to know will be there. During the process you will need some information so you can fill in the fields correctly.

  1. Server path to your J15 home directory
  2. Hostname
  3. DB Username
  4. Database name
  5. DB Prefix
  6. DB Password

Tip: The path to your tmp or log folder will give you a clue to the path to your current J15 installation. Unless you changed the default tmp folder, it will probably say something like /home/username/public_html/tmp - just delete the /tmp from the path and you're at your Joomla 1.5 root. In this case, /home/username/public_html is what I need for now. If you changed the default path, you probably don't need any advice from me.

Step 2. Check your J17 installation for MySQLi database installation.

tutuploadsStep_2._Check_your_J17_installation_for_MySQLi_database_i.png

Make this the first thing you do after you install J17. Check and/or modify the Global configuration.

The first thing you'll see after you install the plugin is this warning, "Important Note: It is very important before you proceed with migration to make sure that your J16 installation is MySQLi and not MySQL (see note below in case it's not MySQLi). You can check from \Global Configuration\, tab \Server\, section \Database Settings\, field \Database Type\. "

  1. Go to Site
  2. Click Global Configuration
  3. Go to the Server Tab
  4. Check if MySQLi is selected in the Database Type.
  5. a. If it doesn't already say MySQLi in the dropdown, stop this tutorial and please contact the SP Upgrade Team and they will give you instructions on how to remove the MySQLi prerequisite.
    b. If it does say MySQLi please continue with the tutorial.

Reading the comments online and some notes from the developer this seems to be the only stumbling block for beginners. In fact all the reviews are 5 stars on the JED except for one, and I'm betting that guy didn't do this first or didn't understand the note. If you have all the information ready, and understand how to fill in the forms, I can't see where you could possibly have any trouble using this extension.

NOTE: MySQLi stands for My SQL Improved. You can get a quick explanation of it from Wikipedia or for the technical minded http:php.net has the manual online.

Step 3. Download and install the plugin.

tutuploadsStep_3._Download_and_install_the_plugin..png

You can get the plugin from the JED. (Joomla Extension Directory) After you've downloaded it go to:

  1. Extensions > Manage Extensions
  2. Browse for the file
  3. Click Upload & Install

Step 4. Fill in the Database Information

tutuploadsStep_4._Fill_in_the_DataBase_Information.png

All of this information is available in your configuration.php file. Refer back to Step 1.

tutuploadsmedia_1320704847956.png

In the Template field, fill in the exact name that is on the directory in your templates directory.

The template will be copied over, but if it is not compatible with J17, it's not going to work until you modify it. There was no updated version of the original template when I did this, so I just left this field blank and set to no. Everything was transferred and the default 2.5 template was used on the new site.

Step 5. Monitor your progress.

tutuploadsStep_5._Monitor_your_progress..png

You'll see pop up window that shows your progress through all the steps. Note that at the beginning of the progress log, it gives you some valuable information, so don't close the window right away when your finished.

In this case I used the same username and password for the new site as the old, and as you can see here the plug-in added the old admin user but added v15 to the end to avoid conflicts.

There were a few other messages as well. Nothing affected the migration, but you might want to look at these before you close this window.

Step 6. Get ready to do the "hand work".

tutuploadsStep_6._Get_ready_to_do_the_hand_work..png

The last thing you see in the progress window is some advice on how to proceed from here. Also the path where you can find the log file for the migration in case you need to refer to it. It would be a good idea to record the path somewhere, just in case.

The Original Site

tutuploadsThe_Original_Site.png

On the original I have several modules published plus some graphics and a YouTube video. It's using RocketTheme Versatility 4 as the template. When I did the migration I did not specify any template migration.

After migration

tutuploadsAfter_migration.png
  1. The menu is correct and it works. I did not have to change any links.
  2. The modules are uploaded, but don't show and they won't until I change the positions.
  3. The YouTube video did not show originally, but I installed the AllVideos Plug-in on the new site, and the everything was back to normal.
  4. Check to see if your graphics and images are present.

The first time I tried this, none of the images originally showed, however on subsequent tests, everything transferred perfectly and I had no trouble. My problem was that I entered an incomplete path on the first entry form. If you look at the error log (See the message at the top of the image in Step 5), it shows that what i entered wasn't accessible, so images and templates were not transferred.

If the images don't transfer, you can use a file manger to copy everything in the old images directory to the new one. Be sure to preserve the entire directory structure from the old site. J17 uses a different images directory ( no more stories directory in J17) and this plugin transfers the paths from the old site, so the easiest thing to do is maintain the folder and file structure for the images directory from J15.

tutuploadsmedia_1320779167760.png
  1. Change module positions for each module, When you change the module positions, be sure to make your menu assignments or the modules won't show.
  2. Upload your plugins or any updates that you need.
  3. You will also need to redo the global parameters for your articles and category displays, and may need to tweak a menu item.
  4. Read the installation log and see if any aliases have been changed. It will automatically change aliases to avoid conflicts, and you might want to adjust them for SEO.

Check for updates

tutuploadsCheck_for_updates.png
  1. Go to Extensions
  2. Extension Manager
  3. Discover Tab - Click the Discover icon on this page and then Install if anything was discovered.
  4. Update Tab - Click Find Updates on this page and install any updates necessary.

If you started with good preparation, you have everything you need at hand and can complete the rest of the migration fairly quickly. Work methodically and try not to rush. With J17, and Update as part of the Extensions component, maybe you won't procrastinate those security updates.

Comments

 
samoskill
#1 samoskill 2011-11-09 21:42

wow. this is simply amazing.
 
 
Nick
#2 Nick 2011-11-10 01:34

I'm glad you think so! :)

Kind regards,
Nick
 
 
Spider
#3 Spider 2011-11-11 16:19

Hi Nick: I'm back... jUpgrade didn't work for me as you may remember. I visited numerous forums and found no answer to the particular problem I had. I am planning on using the SP Upgrade as it had a great rating on JED.

The beauty of this compared to jUpgrade is the fact that it does not alter or affect the original site in any way. OK, so I will be giving this a try in a few days and will
Thanks for this tutorial...

Tony
 
 
Nick
#4 Nick 2011-11-11 16:55

You're very welcome, Tony! :) Hopefully this extension will work better for you.

Kind regards,
Nick
 
 
Spider
#5 Spider 2011-11-11 17:21

Thanks Nick...
I wonder, do you think that I should upload all of the components that are on 1.5 to the new site in preparation for SP Upgrade... for example I use DocMan and it is a repository that contains about 80 documents (I presume that the documents are in the database - correct?)... I also have NSPro, iJoomla Surveys, etc... All of these have 1.7 versions. So, I guess I am guessing that it would be beneficial to upload these???

I plan on buying the component -- just waiting for a response from the developer.

Cheers,

Tony
 
 
edandrea
#6 edandrea 2011-11-11 18:10

Hi Spider,

When I wrote the tutorial i tested it with adding the plugins before I did the migration and after.

It worked both times, but when you have uploaded modules or other content, you get various error messages in the progress window. They aren't a big problem, but will make extra work for you tracking them down to see if they are critical or not.

Best to start with a clean install and keep the error messages to a minimum.

Cheers,
Ed
 
 
Spider
#7 Spider 2011-11-11 18:13

Hi Ed:

Well, I decided not to upload as you are suggesting and I got your email when I was actually at step 1! In the middle of the process... should be able to report soon.

Tony
 
 
Spider
#8 Spider 2011-11-11 18:30

Hi Nick and Ed:

My site has been migrated using this component... this is so great and thanks for your assistance in this!

Tony
 
 
Nick
#9 Nick 2011-11-11 22:37

You're welcome, Tony! We're glad you got things sorted!

Kind regards,
Nick
 
 
johnniek2
#10 johnniek2 2011-11-12 08:22

Ok, but what about websites in joomla 1.5 that are multilingual joomfish driven?

I asusme this is not an option if I want to keep my languages working?
 
 
Spider
#11 Spider 2011-11-12 13:32

Hi There J..
Well, I am not sure how you would do this; but I do know that 1.7 supports languages better than 1.5. The company providing the component SP Upgrade have already offered support. I would guess they would be able to answer you questions.
However, you really don't have anything to lose. It is quick and simple and does not affect your 1.5 site. I believe it is worth the 30 euros...

Good luck,

Tony
 
 
johnniek2
#12 johnniek2 2011-11-12 14:47

Quoting Spider:
Hi There J..
Well, I am not sure how you would do this; but I do know that 1.7 supports languages better than 1.5. The company providing the component SP Upgrade have already offered support. I would guess they would be able to answer you questions.
However, you really don't have anything to lose. It is quick and simple and does not affect your 1.5 site. I believe it is worth the 30 euros...

Good luck,

Tony

the money is not the issue, but I do have like 3 languages with joomfish as as K2 listimg of news and boats? what about K2? is there a link to the company support?
 
 
Spider
#13 Spider 2011-11-12 15:01

Hi Again...
I never used K2 in my 1.5 sites (didn't need it). But my understanding is that K2 is not quite so necessary with 1.7. Perhaps one of the OS team could answer that query better than I.

Whatever, 1.7 is surely much more adaptable in many ways...

Tony
 
 
Nick
#14 Nick 2011-11-12 16:08

Hi Johnnie,

We recommend waiting until Joomla 2.5 (which comes after 1.7 and is a direct upgrade of 1.7) when Joomfish releases a compatible version.

Kind regards,
Nick
 
 
Nick
#15 Nick 2011-11-12 16:10

Hi Johnnie,

You should use jUpgrade if you're using k2, see:
getk2.org/.../...
and:
ostraining.com/.../...

Kind regards,
Nick
 
 
Ade
#16 Ade 2011-11-21 15:46

I just purchased this component this morning but i just migration and the page give error Internal Server Error, what could be the issue?
 
 
Nick
#17 Nick 2011-11-21 17:54

Hi Ade,

Mind contacting the developer for this specific issue as there could be many different reasons for the internal server error? Here's the link to the contact forum: cyend.com/.../contact-us

Kind regards,
Nick
 
 
cobruijn
#18 cobruijn 2011-11-24 07:09

Can I use this tutorial to upgrade my 1.5 site to 1.7? Or is it neccesary that I first upgrade to 1.6??
 
 
hossamostafa707@gmail.com
#19 hossamostafa707@gmail.com 2011-12-01 09:00

Hi Cobruijn,

Yes you can use this tutorial to upgrade my 1.5 site to 1.7. Keep in your mind and do it step by step. It should be work with you.

Cheers,
Hossam
 
 
Spider
#20 Spider 2011-12-01 15:05

Hi All subscribers to this thread... I would sure like to see a comprehensive follow up to the 'migration' issue. How does a person make this the 'default' site on the WWW?
I tried using CODA, transferring files from the upgrade to public_html, and got into a real mess! I had to have the site restored completely. I wonder if there is a 'foolproof' way to do this...
Using CPanel, CODA, etc...

Tony
 
 
Nick
#21 Nick 2011-12-02 08:10

Hi Tony,

What you can do is use cpanel to move the contents of your live site to a subfolder then move your test site (if you have it in a subfolder) to your live site folder (usually public_html). Here's a tutorial using cPanel:
ostraining.com/.../...

Kind regards,
Nick
 
 
Spider
#22 Spider 2011-12-02 17:37

HI Nick:
Thanks for that 'link' to the cPanel option. I have CODA and use it a lot to modify files.. I tried to make my 'test' site the main site and screwed up royally... Not sure why, it wasn't easy and I had to create 'substitute' folders etc.. I got lost in the process. It appears that the DB's were not accessible after this transfer. I had the hosting company I use do a system restore! Back to square one, so to speak.

I am now rewriting the site (it is a smallish one, my business site) as alongcameaspide r.ca/dev. The next job will be to make this the 'live' site as alongcameaspide r.ca.

It appears that the tutorial on cPanel should solve this problem... So, I will indeed report back!

Tony
 
 
Cwk
#23 Cwk 2011-12-04 20:31

I'm confused with the beginning... where am I supposed to install 1.7? In a separate folder? I have 1.5.25 in the root of my server, which is where I would like Joomla to stay. OR will i have to move my 1.5.25 into a folder, have the site down for a while as I install 1.7 in the root, etc? Some one please help!
 
 
Nick
#24 Nick 2011-12-05 05:58

You're welcome, Tony! Good luck with the rest.

Kind regards,
Nick
 
 
Nick
#25 Nick 2011-12-05 06:03

Hi Cwk,

You can just install it in a subfolder of your Joomla root.

Then you can use the advice that I gave Tony above (see: ostraining.com/.../...

Hope this helps!

Kind regards,
Nick
 
 
NWLB
#26 NWLB 2011-12-12 04:10

I'm getting two errors, despite all other things seemingly doing fine.

Could not connect. Go back correct db 1.5 info and try again. Access denied for user 'XXXX'@'localho st' (using password: YES)

and:
Warning: mysql_connect() [function.mysql -connect]: Access denied for user 'XXXX1'@'localh ost' (using password: YES) in /home/XXXX/publ ic_html/XXXX.co m/community2/ad ministrator/com ponents/com_spu pgrade/controll er.php on line 72

Any thoughts?

The script ran well the first time. Even a second time during testing. But as I was working out kinks in getting Kunena to work with it, I ran into this issue after uninstalling Joomla, starting fresh.
 
 
Louise
#27 Louise 2011-12-12 16:06

Anyone had problems with using Mysql on the old site and Mysqli on the new clean site? My SP upgrade keeps stopping right at the start and saying there is a password conflict. I know have all the information filled in correctly. Search seems to suggest it is a hash issue.
 
 
jportkoa
#28 jportkoa 2012-01-21 15:43

Did you ever figure out why this was happening, I am having the same issue with mine.
 
 
Jooomlaaa
#29 Jooomlaaa 2012-03-01 12:00

DB Error, could not query j15 database: 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 'ORDER BY id ASC' at line 1

Anyone else get this ERROR?

Thx
 
 
Ross Bartholomew
#30 Ross Bartholomew 2012-03-07 09:46

I have tried SP
Upgrade but as yet have notmanaged to get it to work. This is the error I get: Could not connect. Go back correct db 1.5 info and try again. mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD('your_ existing_passwo rd'). This will store a new, and more secure, hash value in mysql.user. If this user is used in other scripts executed by PHP 5.2 or earlier you might need to remove the old-passwords flag from your my.cnf file
 
 
dunxmax
#31 dunxmax 2012-03-07 15:59

I've been getting this same error message on my first ever proper upgrade from a 1.5 site to 2.5, but also going to a new host. Have you guys managed to solve this issue?
 
 
Christine
#32 Christine 2012-03-13 13:34

I attempted to upgrade from 1.5 to 2.5 and it appears that my template/theme is not compatible...ho w can I make it compatible?
 
 
Michael Mueller
#33 Michael Mueller 2012-07-06 14:10

After upgrade from Joomla 1.5 to Joomla 2.5, all my aliases changed, SP Upgrade added to each of them something like v15-xxxx (string of numbers). I need my old aliases back, is there a way to rebuild all content aliases or could I empty alias column in DB - will Joomla then rebuild all aliases?
 
 
cb1
#34 cb1 2012-08-07 13:31

Having problems... folowed instructions to the letter - they have been very easy.

Been when I configure my DB information from the target sites config file - I fill in the information, hit "save and close" and site says:
"Failed to connect to source database.
Update source database connection credentials in options. "

But can find no troubleshooting help.
 
 
Michelle Diamond
#35 Michelle Diamond 2013-01-29 17:54

Hi, My db is MySql not MySQLi How can I change this? Please advise
 
 
alex acosta
#36 alex acosta 2013-03-07 22:06

I'm sorry, I was completely lost at the part when you mention "Make this the first thing you do after you install J17. Check and/or modify the Global configuration."

were this up to be for J1.5? I don't understand why it has to be done on the new installation (2.5)

Any way, I ran the installation and I got this:
"Failed to connect to source database.
Update source database connection credentials in options."

I have tried with Mysql or Mysqli...

any help will be appretiated =S
 

Add comment


Security code
Refresh

blog-ad

Start Online Training

Members get access to all our video training. That's 1,142 training sessions in Joomla, Drupal, WordPress and Coding.

Manage All Your Joomla Sites

adminicredible

With Admincredible you can update and manage all your Joomla sites. If you have 5 or 500 sites, Admincredible will make your life easier! Visit Admincredible.com.

Latest Comments

The License for Our Tutorials

All of our tutorials are published under the Creative Commons Attribution-NonCommercial license. This means:

  • You can re-use these tutorials.
  • You can modify these tutorials.
  • You must link back to our original tutorial.
  • You can't use these tutorials commercially.

Click here to read the full license.

Open Source Training is not affiliated with or endorsed by the Joomla, WordPress or Drupal projects.
All product names and trademarks are the property of their respective owners.

Copyright 2013 Open Source Training, LLC. All rights reserved.