SPECIAL OFFER: Only $69 for access to everything in OSTraining for 1 year! You save $75!  1
Join today and get access to 1,000's of books and videos. Learn WordPress, Drupal, Magento, Joomla and more! Sign up today!

Joomla 2.5.28 to 3.5 Upgrade?

3 years 8 months ago - 3 years 8 months ago #125414 by Madcockney
Joomla 2.5.28 to 3.5 Upgrade? was created by Madcockney
I have an instance of the live site on a local install of XAMPP for a test upgrade. I have cleaned everything up and replaced extensions where possible to later versions, or removed where not so that they can be upgraded after upgrade. I do not allow the XAMPP access to the Internet so download packages and install. I went out to get the latest Joomla 3 this being 3.5, but noticed that from 3.4 to 3.5 cannot follow the normal update procedure. Does this mean that I should go 2.5.28 > 3.4 then followed by 3.5 or will it be OK to go directly to 3.5 from 2.5.28? This may have something to do with php 7. I cannot find anything regarding this on the Internet or at Joomla. The live site is on php.5.5.30 though it can use any php version up to 7.05 though I am not sure that all extensions will be compatible with the higher versions.

Please Log in to join the conversation.

3 years 8 months ago #125416 by Madcockney
Replied by Madcockney on topic Joomla 2.5.28 to 3.5 Upgrade?
Forgot to say that your SSL certificate has expired.

Please Log in to join the conversation.

3 years 8 months ago - 3 years 8 months ago #125462 by Valentin
Replied by Valentin on topic Joomla 2.5.28 to 3.5 Upgrade?
Hi Madcockney,

but noticed that from 3.4 to 3.5 cannot follow the normal update

That's correct. From 3.4 to 3.5, the update should be done from Components > Joomla update only

Follow us on Twitter - twitter.com/OSTraining
Like us on Facebook - facebook.com/ostraining

Please Log in to join the conversation.

3 years 8 months ago - 3 years 8 months ago #125483 by Madcockney
Replied by Madcockney on topic Joomla 2.5.28 to 3.5 Upgrade?
As I mentioned in my original posting I don't allow my XAMPP to go out on the Internet so I downloaded the update package 3.4.0 stable update and installed via Extension Manager. I then got the same problem regarding post install message as in this topic . I have checked with phpMyAdmin and that postinstall table does not exist. If you use the database query mentioned in that topic you get a blank screen. If I extract the update package into the Joomla root it makes no difference.

My thoughts are that maybe that maybe this should be done with an earlier update than 3.4.0, though I would assume that 3.4 and 3.3.6 would be similar for upgrading from 2.5.28. There could also be an issue with undertaking this via Extension Manager, though I have had to do this previously when there has been update issues and had no problem. I used the update and not full as that is the one shown by Rod and Joomla's documentation for the upgrade.

Please Log in to join the conversation.

3 years 8 months ago - 3 years 8 months ago #125501 by Valentin
Replied by Valentin on topic Joomla 2.5.28 to 3.5 Upgrade?
From Joomla 2.5.28 until 3.4.x the upgrade process is similar, however in the last version things changed.
Please take a look to this document that mention the upgrade process from 3.4.x to 3.5.

If you have the chance to update in this way, it would be safest:
  • 2.5.28 -> 3.0.0
  • 3.0.0 -> 3.1.0
  • 3.1.0 -> 3.2.0
  • and so on...

Follow us on Twitter - twitter.com/OSTraining
Like us on Facebook - facebook.com/ostraining

Please Log in to join the conversation.

3 years 8 months ago #125540 by Madcockney
Replied by Madcockney on topic Joomla 2.5.28 to 3.5 Upgrade?
Thanks Valentin.

What I have done is ditched that and using a backup re-installed. I am now going through everything to make sure that I have not missed anything. One thing is that this site, before my time, may have been migrated from 1.6/1.7 to 2.5 so it may also depend on how well that was done. ( It was at 2.5.9 when I took over and should have been much higher but the developer could never get it past there.) I'll get to the bottom of it as I always do eventually. :)

Please Log in to join the conversation.

3 years 8 months ago #125565 by Valentin
Replied by Valentin on topic Joomla 2.5.28 to 3.5 Upgrade?
Hi Madcockney,
In my experience when upgrading from one Joomla version to another, what generates extra work are the third party extensions. The less, the better :)

Let us know how it goes

Follow us on Twitter - twitter.com/OSTraining
Like us on Facebook - facebook.com/ostraining

Please Log in to join the conversation.

3 years 8 months ago #125618 by Madcockney
Replied by Madcockney on topic Joomla 2.5.28 to 3.5 Upgrade?
Yes I know that is why I spent a lot of time removing, updating, and disabling. Unfortunately this site is not small with just half a dozen extensions as in most of the demos, and includes Kunena, Membership Pro, Jomsocial, Alph Points, a shop etc. amongst others. Kunena works in both Joomla 2.5 and J3, Membership Pro will also. Jomsocial I had to remove completely as per their instructions, and I did the same with the shop. Alpha Points I have removed completely. However they are still in the database, though I have backed up each sql part separately just in case, as they will be required when I reinstall. Alphapoints is no more and the replacement Altrapoints should pick up the database according to them.

It can be just one of those things as I have seen in the past, just like no issues with one host, but does not work on another. Things do go wrong, and as this is a test then it gives me a chance to work out the issues before the live site is processed. On the other hand it could be something I have missed, but at least I have the chance to evaluate and work it out.

Please Log in to join the conversation.

3 years 8 months ago #125628 by Valentin
Replied by Valentin on topic Joomla 2.5.28 to 3.5 Upgrade?
That's the negative point when having many third party extensions, however you can get support from the developers of the commercial ones at least. Some of them may have a specific workaround to do the upgrade.

The good thing is you're in a test site. Until you fiugure out the issue, you can touch the live site.

Follow us on Twitter - twitter.com/OSTraining
Like us on Facebook - facebook.com/ostraining

Please Log in to join the conversation.

3 years 7 months ago #125990 by Madcockney
Replied by Madcockney on topic Joomla 2.5.28 to 3.5 Upgrade?
Just an update of where I am up to on this as it may help others in the future.

The following is over several several restores as I discovered what was happening and took the necessary action. One of the things that I always do and did as I undertook my research and investigations was to record it all, that in my case was using Notepad++, so I had a reference to go back to and a quick location to access the relevant information. There is nothing worse than trawling the web,or navigating a multitude of tabs and pages to get to the information you require.

I discovered that there were issues with upgrading from 2.5 to J3, but there were more issues with migrating from J3.0.X, or J3.1.X to Joomla 3.2.X. I also found out that the recommended upgrade version by Joomla.org from J2.5.28 is J3.3.6 and it is listed on their site as such. There were many issues from all accounts with the earlier J3 versions.

When the first upgrade failed I checked the Joomla upgrade documentation again and discovered that besides setting the error reporting to maximum that "Remember Me" has to be disabled. In my research I found that this plug-in has been the cause of many issues, and that people were renaming it and inserting temporary copy from the upgrade installation file and then, after they had been able to get to the Joomla back-end and able to run fix database, they reverted back to the original. I never had to do htat probably as I had disabled it.

Anyway I think that the real issue was that the site looks like it had been migrated from J1.7 through J2.5. This was before my time and I have no ideas how that was done or whether it done properly. (I had take over when it was a J2.5.9 as the original developer could not get it past there.) However over many updates many core files had been left behind instead of being deleted or removed. This was also an issue that the J3.0 and J3.1 to J3.2.X upgraders were seeing. It would appear that this was preventing the upgrade script running properly, or as some indicated was that it was badly written. Both may apply, but I think that Joomla would have sorted if badly written by the time they reached version 3.3.6. (Not actually a script but a series of php files.) I'll come back to this later.

I originally removed all of the Akeeba items but then came across an article by Nicholas from Akeeba that stated that they should not be removed but disabled in a prescribed sequence if not the site may break. This was particularly true of FoF (Framework on Framework). I therefore left these in but disabled in following restores

Anyway to cut a long story short I did the following:

Turn on error messages to maximum
purge caches including browser
ran discover in 2.4.28 and install any Joomla updates after purging cache then ran database fix.
disabled "Remember Me"
removed sql files J1.7.* to J2.5.26 from administrator/components/com_admin/sql/updates/mysql. These can interfere with the later database during the update and fix according to many more experienced commentators.

However I was still seeing issues and many error and non completion messages. One of the things was preventing this was the non deletion of files that should have been done during previous update and upgrades. There is a php file to do this in the joomla cli folder that can run from a browser ( mysite.local/cli/deletefiles.php ) though that won't work unless the infrastructure is correct and as we know it wasn't. So the alternative is, in my case on Windows computer, {change accordingly for Linux and Mac), was to use c:\<pathToPHP>\php.exe c:\<pathToLocalSite>\cli\deletefiles.php and press enter/return and that cleaned out the old files. I could now get further as many of the errors disappeared.

One folder it didn't remove and I discovered on the net that can confuse Joomla was the ./libraries/joomla/plugin directory that is no longer used by Joomla. It was recommended to delete it, but I just renamed the plugin directory.

Now I could actually get to the administrator front end but was getting:

1146 Table ' _postinstall_messages' doesn't exist SQL=SHOW FULL COLUMNS FROM `<prefix>_postinstall_messages

The table was not being created and though I tried copying the mysql and pasting into phpmyadmin and running the table was not created so I manually inserted the table with just three columns
1. postinstall_message_id
2. extension_id
3. enabled

I could now get to the administrator login but was presented with an error message regarding content_types missing so I created that table manually with phpmyadmin. (Initially with a couple of columns, but later adding all.) This enabled me to login and get to the database and run fix. (I had already tried <mysite.local>/administrator/index.php?option=com_installer&view=database several times earlier with no success.)

Now I had to run discover to find many of the J3.3.6 Joomla Project items including all of the templates, select them and then click on install. I was now able to select the J3 ones and uninstall the old 2.5 templates. There were still a few weird things so I ran the J3.3.6 update install again, and now everything appeared to be working OK. I therefore installed Akeeba, followed by AdminTools, and the latter gave an error message that there was with postinstall_messages columns missing. I added those columns manually ran AdminTools again and this time no errors and the relevant messages were inserted. On checking joomla.php I discovered that though the creation of these tables is included in the full version instance the update version does not include them. Weird.

Anyway I now have a fully functioning Joomla 3.5.1 install. Yes I did an on-line update to that without any issues, I have installed several extensions, and currently working on deciding what template to use. I am sure whatever one I decide to use wil need some custom CSS and there are courses on that at OStraining.

One other thing that I discovered is though you uninstall extensions they don't always remove all the folders and files leaving some items behind. I think a clean up is on it's way.
The following user(s) said Thank You: jmc

Please Log in to join the conversation.

3 years 7 months ago #126003 by Nick
Replied by Nick on topic Joomla 2.5.28 to 3.5 Upgrade?
Hi Madcockney,

Thanks for writing your experience! It looks like you did things exactly right to resolve the issues. Nice work!

Your write-up will be useful for a lot of people that find this topic via Google, as well as a reference for you if you update any more Joomla 2.5 sites.

Cheers,
Nick

Follow us on Twitter - twitter.com/OSTraining
Like us on Facebook - facebook.com/ostraining

Please Log in to join the conversation.

3 years 7 months ago #126006 by Madcockney
Replied by Madcockney on topic Joomla 2.5.28 to 3.5 Upgrade?
Thanks Nick,

I took me many days of work, but one of the benefits of this is I now have a better understanding of how Joomla works and how it fits together. Next time I have an issue I should have better knowledge of where to start, what to look for etc, and hopefully quicker to resolve.

Please Log in to join the conversation.

3 years 7 months ago #126008 by Valentin
Replied by Valentin on topic Joomla 2.5.28 to 3.5 Upgrade?
Hi Madcockney,
I'm glad you have this one sorted out!

Let us know if we can be of any help.

Follow us on Twitter - twitter.com/OSTraining
Like us on Facebook - facebook.com/ostraining

Please Log in to join the conversation.

Join today and get access to 1,000's of books and videos. Learn WordPress, Drupal, Magento, Joomla and more! Sign up today!