Practical Guide Upgrade Joomla 2.5 to Joomla 3.x

Need help upgrading your Joomla! website or converting to Joomla! 3.x?

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Post Reply
atty179
Joomla! Intern
Joomla! Intern
Posts: 51
Joined: Mon Oct 30, 2017 11:51 am
Contact:

Re: Practical Guide Upgrade Joomla 2.5 to Joomla 3.x

Post by atty179 » Mon Mar 11, 2019 8:15 am

Hello everyone, in relation to this problem I add further considerations that I found these days.
The error is given by the php files that create the joomla tables ... (after the migration can be found ... \ administrator \ components \ com_admin \ sql \ updates \ mysql \ xxx.sql). The error is given by the 3.1.0.sql file.
This file, in addition to creating the table "#__content_types" (with the IF NOT EXIST rule), also performs an INSERT ... (no rule ..;)).
Then the alternatives are 2:
1) or the Kickstart DB restore procedure does not work well because it should recreate empty tables;
2) or the php files for the recreation of the db of the migration procedure should also put the insert of the records under IF, or alternatively make updates ...

In short, there is the problem somewhere ... I hope I have been clear and useful to solve the problem.

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 37286
Joined: Sat Apr 05, 2008 9:58 pm

Re: Practical Guide Upgrade Joomla 2.5 to Joomla 3.x

Post by Webdongle » Mon Mar 11, 2019 8:24 am

You could try viewtopic.php?f=710&t=956702 . It allows you to update the original database with fresh Joomla files and then create fresh 3rd party files to connect to the updated database.
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"The definition of insanity is doing the same thing over and over again, but expecting different results": Albert Einstein

atty179
Joomla! Intern
Joomla! Intern
Posts: 51
Joined: Mon Oct 30, 2017 11:51 am
Contact:

Re: Practical Guide Upgrade Joomla 2.5 to Joomla 3.x

Post by atty179 » Mon Mar 11, 2019 8:56 am

thanks for the answer Webdongle. but why do you think my site has been hacked ??

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 37286
Joined: Sat Apr 05, 2008 9:58 pm

Re: Practical Guide Upgrade Joomla 2.5 to Joomla 3.x

Post by Webdongle » Mon Mar 11, 2019 2:14 pm

That method works even if the site is not hacked.
It allows you to update the original database with fresh Joomla files and then create fresh 3rd party files to connect to the updated database.
Your site does not need to be hacked for the method to work
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"The definition of insanity is doing the same thing over and over again, but expecting different results": Albert Einstein

nigelj
Joomla! Apprentice
Joomla! Apprentice
Posts: 33
Joined: Tue May 29, 2007 1:42 pm
Location: Cheddington, UK

Re: Practical Guide Upgrade Joomla 2.5 to Joomla 3.x

Post by nigelj » Thu Jul 04, 2019 9:59 am

I have a very old intranet site running on 2.5.24. This guide talks about migrating from 2.5.28 to 3x.

Before I potentially waste a load of time, can someone tell me if I follow this procedure from 2.5.24, as I can't find an update package from 2.5.24 to 28?

Thanks

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 37286
Joined: Sat Apr 05, 2008 9:58 pm

Re: Practical Guide Upgrade Joomla 2.5 to Joomla 3.x

Post by Webdongle » Thu Jul 04, 2019 12:14 pm

https://downloads.joomla.org/cms/joomla ... format=zip from https://downloads.joomla.org/cms/joomla25/2-5-28 .
But if you have a lot of non 3.x compatible 3rd party extensions then it might be quicker to start from a fresh 3.9.8 than unistall non compatible extensions.
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"The definition of insanity is doing the same thing over and over again, but expecting different results": Albert Einstein

nigelj
Joomla! Apprentice
Joomla! Apprentice
Posts: 33
Joined: Tue May 29, 2007 1:42 pm
Location: Cheddington, UK

Re: Practical Guide Upgrade Joomla 2.5 to Joomla 3.x

Post by nigelj » Thu Jul 04, 2019 4:38 pm

Thanks for that.

I have some third party extensions, and a few of those aren't 3 compatible...I'm looking for alternatives at the moment.

Is it possible to migrate just menu structure, articles, users and other content to a fresh v3 install? If it is do you know If there are guides on how to achieve this?

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 25963
Joined: Mon Oct 27, 2008 9:27 pm
Location: Akershus, Norway

Re: Practical Guide Upgrade Joomla 2.5 to Joomla 3.x

Post by Per Yngve Berg » Thu Jul 04, 2019 6:25 pm


User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 37286
Joined: Sat Apr 05, 2008 9:58 pm

Re: Practical Guide Upgrade Joomla 2.5 to Joomla 3.x

Post by Webdongle » Thu Jul 04, 2019 6:48 pm

https://extensions.joomla.org/extension/j2xml/
I think it works in 2.5.x as well as 3.x ... if not then see their home page.
Anything that exports menus as well ... imho doesn't give a 'clean database.
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"The definition of insanity is doing the same thing over and over again, but expecting different results": Albert Einstein

nigelj
Joomla! Apprentice
Joomla! Apprentice
Posts: 33
Joined: Tue May 29, 2007 1:42 pm
Location: Cheddington, UK

Re: Practical Guide Upgrade Joomla 2.5 to Joomla 3.x

Post by nigelj » Thu Jul 04, 2019 8:40 pm

Thank you!

nigelj
Joomla! Apprentice
Joomla! Apprentice
Posts: 33
Joined: Tue May 29, 2007 1:42 pm
Location: Cheddington, UK

Re: Practical Guide Upgrade Joomla 2.5 to Joomla 3.x

Post by nigelj » Thu Jul 04, 2019 9:38 pm

Webdongle wrote:
Thu Jul 04, 2019 6:48 pm
https://extensions.joomla.org/extension/j2xml/
I think it works in 2.5.x as well as 3.x ... if not then see their home page.
Anything that exports menus as well ... imho doesn't give a 'clean database.
So you'd recommend creating menus manually, and only transferring content?

What about users...there's about 1000 in the 2.5 site, and I don't really want to recreate them manually!!

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 37286
Joined: Sat Apr 05, 2008 9:58 pm

Re: Practical Guide Upgrade Joomla 2.5 to Joomla 3.x

Post by Webdongle » Thu Jul 04, 2019 10:00 pm

nigelj wrote:
Thu Jul 04, 2019 9:38 pm
...
So you'd recommend creating menus manually, and only transferring content? ....
Yes Install a fresh 3.9.8 and use j2xml. That will also export/import users ... it may have a limit so you may have to export/import the users x amount at a time.

https://extensions.joomla.org/extension ... p-upgrade/ is more comprehensive but is commercial.
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"The definition of insanity is doing the same thing over and over again, but expecting different results": Albert Einstein

User avatar
leolam
Joomla! Master
Joomla! Master
Posts: 19666
Joined: Mon Aug 29, 2005 10:17 am
Location: Netherlands/ UK/ S'pore/Jakarta/ North America
Contact:

Re: Practical Guide Upgrade Joomla 2.5 to Joomla 3.x

Post by leolam » Fri Jul 05, 2019 4:06 pm

With all respects for the answers given here: You do not need to use anything what is suggested but for the methods I wrote. Thousands of sites have been updated in that matter without any issues. It is a waste of using J2XML if you just follow the steps I have outlined. You wrote
Before I potentially waste a load of time, can someone tell me if I follow this procedure from 2.5.24, as I can't find an update package from 2.5.24 to 28?
. You first just update from J2.5.24 to latest 2.5.28 https://downloads.joomla.org/cms/joomla ... format=zip after which you follow the steps in my guide and all content, menu's, users etc etc will be nicely upgraded to 3.9.x Don't waste your time with the advises given (no offense WD)

Leo 8)
Joomla's #1 Professional Support Provider:
-> Joomla Professional Support: https://gws-desk.com -
-> Joomla Specialized Hosting Solutions: https://gws-host.com -
-> Joomla Webmaster Services: gws-webmaster.services

nigelj
Joomla! Apprentice
Joomla! Apprentice
Posts: 33
Joined: Tue May 29, 2007 1:42 pm
Location: Cheddington, UK

Re: Practical Guide Upgrade Joomla 2.5 to Joomla 3.x

Post by nigelj » Fri Jul 05, 2019 4:10 pm

Thanks Leo. I'll be looking at this next all being well.

Can I just clarify the instructions at 3a...its 'delete' for non-v3 components, and uninstall non-v3 extensions...is that right?

User avatar
leolam
Joomla! Master
Joomla! Master
Posts: 19666
Joined: Mon Aug 29, 2005 10:17 am
Location: Netherlands/ UK/ S'pore/Jakarta/ North America
Contact:

Re: Practical Guide Upgrade Joomla 2.5 to Joomla 3.x

Post by leolam » Fri Jul 05, 2019 4:19 pm

It is "uninstall" and not "delete"... which is a difference in Joomla. When you uninstall you do remove (normally ) all files and folders as well as db-entries but if you delete files an folders you do not remove db-entries and still have issues. If you keep having issues send me a pm and we see how I can help you

Leo 8)
Joomla's #1 Professional Support Provider:
-> Joomla Professional Support: https://gws-desk.com -
-> Joomla Specialized Hosting Solutions: https://gws-host.com -
-> Joomla Webmaster Services: gws-webmaster.services

nigelj
Joomla! Apprentice
Joomla! Apprentice
Posts: 33
Joined: Tue May 29, 2007 1:42 pm
Location: Cheddington, UK

Re: Practical Guide Upgrade Joomla 2.5 to Joomla 3.x

Post by nigelj » Fri Jul 05, 2019 4:25 pm

Ok, thanks

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 37286
Joined: Sat Apr 05, 2008 9:58 pm

Re: Practical Guide Upgrade Joomla 2.5 to Joomla 3.x

Post by Webdongle » Fri Jul 05, 2019 5:13 pm

Whichever method you choose ... it is best done using Wamp (localhost) on your PC. Then you can change the php version on the fly.

One of the big problems with migrating from 2.5.x to 3.9.x is 3rd party extensions. Even when a 3rd party extension is 2.5.x/3.9.x compatible it often installs different files depending on the version of Joomla that it is installed in to.

Leo's guide is excellent and at the time of writing it was the 'Bees Knees'. But it was written over 6 years ago and Joomla extensions (as well as the php they run on) have changed massively since. That means the files of the 3rd party extensions can adversely affect the migration as it progresses.

You can use this method to migrate the site. Best done on localhost.

* Update to J2.5.28
** Uninstall non compatible 3rd party extensions

* In another folder install a fresh Joomla 2.5.28
** Connect the configuration.php to the original database (changing the php version as needed)
Your original database is now up to date.

* In another folder Install the latest Joomla and install the newest of your compatible 3rd party extensions.
You now have fresh Joomla and 3rd party files
* Edit the configuration.php (of that Joomla) to connect to the original updated database.
Your database is now connected to fresh Joomla and 3rd party files

The advantage of that method it uses fresh Joomla files (without 3rd party files) to update/migrate Joomla and the database separately.

But in all honesty your site is (and extensions are) so outdated that the quickest/easiest method is to install 3.9.8 and export/import Categories/Articles/Users in to it.

You now have 3 different methods (all of which work) and the opinions of why either is best.
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"The definition of insanity is doing the same thing over and over again, but expecting different results": Albert Einstein

nigelj
Joomla! Apprentice
Joomla! Apprentice
Posts: 33
Joined: Tue May 29, 2007 1:42 pm
Location: Cheddington, UK

Re: Practical Guide Upgrade Joomla 2.5 to Joomla 3.x

Post by nigelj » Fri Jul 05, 2019 6:37 pm

Yeah the different php versions is another issue for me. The site is running on a very out of date XAMPP (as it's an intranet security issues don't come into it).

To start this migration I needed to get the site running on my Laptop, so I installed the latest XAMPP, backed up using Akeeba and restored using Kickstart, but I got loads of errors during the restore (all to various Kickstart files). The site restored but isn't working properly...when I access it I get a random page up, not the home page, and when I access the back end I can't get into any article, user or other record to edit!

After lots of trial and error I've ended up restored on my laptop to the same outdated XAMPP as on the server, and installed a fresh 3.9.8 to start a migration.

Is there any reason that you know of why a 2.5.24 site won't run on the latest PHP? I've never done it, but I guess I can update PHP in XAMPP to see if it works?

User avatar
sozzled
Joomla! Exemplar
Joomla! Exemplar
Posts: 7740
Joined: Sun Jul 05, 2009 3:30 am
Location: Canberra, Australia
Contact:

Re: Practical Guide Upgrade Joomla 2.5 to Joomla 3.x

Post by sozzled » Fri Jul 05, 2019 7:38 pm

nigelj wrote:
Fri Jul 05, 2019 6:37 pm
Is there any reason that you know of why a 2.5.24 site won't run on the latest PHP?
Because it won't. It's that simple.

Basically, J! 2.5 was created in 2011; it was originally called J! 1.6. J! 1.6 was renamed J! 1.7 and then it was renamed J! 2.5. J! 2.5.24 was released in July 2014; the final release of J! 2.5 was J! 2.5.28 on 10 December 2014. J! 2.5 was designed around PHP 5 which was available at the time.

PHP 7.0 was released in December 2015; you can research the release history of PHP here: https://en.wikipedia.org/wiki/PHP#Release_history

Now if you don't want more of the history lesson, the lesson from history is that the technology of the internet has changed. PHP 7.x is different to PHP 5 and software that was designed for PHP 5 just won't work with PHP 7 unless you change the software. So, again, it's really that simple.

J! 2.5 is dead. People who have J! 2.5 websites have two choices: (a) they can rebuild their websites by "starting over" (i.e. create a new website based on current technology) and, perhaps, salvage some of the old site content or (b) they can attempt to "migrate" their websites to J! 3. Neither of these approaches is dead easy: the methodology requires patience, planning, commitment, investment of time (and perhaps money). If people lack patience, the ability to plan and see a project through to completion, or the resources and skill to undertake the technical tasks, then they will fail, obviously.

It's your website; it's your choice to do what you want with it. We can only provide you the benefit of our experience and offer you our advice. Good luck. 8)
https://www.kuneze.com/blog
I need your help to help reduce spam at the Joomla forum. You can help with your ideas, questions and opinions at viewtopic.php?f=7&t=974006. Together we can make a difference :)

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 37286
Joined: Sat Apr 05, 2008 9:58 pm

Re: Practical Guide Upgrade Joomla 2.5 to Joomla 3.x

Post by Webdongle » Fri Jul 05, 2019 8:01 pm

Nope ... you can not change php version on the fly with xampp. You need Wamp http://www.wampserver.com/en/
http://blog.astemplates.com/change-php-version-wamp/


If you are using a version of WAMPServer > 3.0 then there are lots of simple php ADDON installs that you can pick from

See SourceForge repo for all the available PHP ADDONS

Or the backup Repo which can be easier to navigate than SourceForge.

These are simply download and run the installs. It will just add another PHP folder in the usual place in the wamp folder structure.

You can then Switch to the new release and back again to older releases using the wampmanager menus.
https://stackoverflow.com/questions/445 ... or-magento
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"The definition of insanity is doing the same thing over and over again, but expecting different results": Albert Einstein


Post Reply

Return to “Migrating and Upgrading to Joomla! 3.x”