Migration from 2.5.28 to 3.5.1 Hangs at 86.3 %

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.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10.
Locked
y021ahe
Joomla! Intern
Joomla! Intern
Posts: 58
Joined: Sat Apr 21, 2012 9:56 am

Migration from 2.5.28 to 3.5.1 Hangs at 86.3 %

Post by y021ahe » Thu May 26, 2016 11:40 am

Hi,
I have been working for 2 days trying to migrate my test site (first) from J2.5.28 to J3.5.1 and it keeps hanging at 86.3%, then timesout and the site is too corrupt to continue and requires a restore.

All the writeups suggest that there is a contention, but I cant find it and so am looking for a log, or something which will tell me what it is contending with?

The instructions suggest that we have to remove 3rd party extensions and whilst I can accept that that may be a good idea for using the site, its an impossible dream for the real world - theres alot of data in JEM, Event Gallery, Tracks etc which removing from the 2.5 website would have to be rekeyed which is a nightmare scenario.

I really need the advice to work out what is stalling the upgrade process, even if its only to give me a template site to copy article data from into a clean J3.5.1 site - which is also a possibility I am exploring.

Please help me.

My website is http://www.fgatest.com (copy of http://www.formulagrasstrack.com)

Thanks

Rich :'( ???

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

Re: Migration from 2.5.28 to 3.5.1 Hangs at 86.3 %

Post by Per Yngve Berg » Thu May 26, 2016 12:02 pm

Increase the max_Execution_Time in php on the server from the default 30 to 300, to let the upgrade run until it's finished.

sovainfo
Joomla! Exemplar
Joomla! Exemplar
Posts: 8808
Joined: Sat Oct 01, 2011 7:06 pm

Re: Migration from 2.5.28 to 3.5.1 Hangs at 86.3 %

Post by sovainfo » Thu May 26, 2016 12:54 pm

As always: what does logs/joomla_update.php say?
Unfortunately, J35 introduces utf8mb4 conversion. A process requiring much of the infrastructure.
You may want to split the migration at J348.
Issue with migrating? Include logs/joomla_update.php in your report!
Blank screen? Verify pagesource for HTML code (javascript error)
Installation failing on populating database? Install with set_time_limit(0)
Document your customizations!

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

Re: Migration from 2.5.28 to 3.5.1 Hangs at 86.3 %

Post by leolam » Fri May 27, 2016 4:22 am

@y021ahe: The reason why this is hanging at 86,3% is the simple fact that you still have an extension (probably a plugin) installed that are not compliant with Joomla 3.x. If you follow my guide http://forum.joomla.org/viewtopic.php?f=710&t=793171 you will have this done in a nutshell. No need to make a step in between as Sovainfo recommends.

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

y021ahe
Joomla! Intern
Joomla! Intern
Posts: 58
Joined: Sat Apr 21, 2012 9:56 am

Re: Migration from 2.5.28 to 3.5.1 Hangs at 86.3 %

Post by y021ahe » Fri May 27, 2016 6:26 pm

Hi
I cant work out how to do the step in between anyway - when I add it the J347 full package in extension manager install as I used to do, it just does nothing, and the Joomla Update only shows me J351.

I tried increasing the maxtime to 300 as advised to no avail - it just takes longer before failing.

I have removed all the extensions I have in my site, the only 2 non Joomla Project entries in the Manage field is Hathor (2.5.0) and Beez5 (2.5.0) templates and Protected entries

The Joomla Update Log ends with the following - URL herehttps://www.dropbox.com/s/hmlokodwg7t76 ... 9.php?dl=0

2016-05-27T18:15:41+00:00 INFO 86.162.41.78 update Ran query from file 3.5.0-2016-03-01. Query text: ALTER TABLE `#__redirect_links` ADD INDEX `idx_old_url` (`old_url`(100));.
2016-05-27T18:15:45+00:00 INFO 86.162.41.78 update Ran query from file 3.5.1-2016-03-25. Query text: ALTER TABLE `#__user_keys` MODIFY `user_id` varchar(150) NOT NULL;.
2016-05-27T18:15:45+00:00 INFO 86.162.41.78 update Ran query from file 3.5.1-2016-03-29. Query text: UPDATE `#__utf8_conversion` SET `converted` = 0 WHERE (SELECT COUNT(*) FROM `#_.
2016-05-27T18:15:46+00:00 INFO 86.162.41.78 update Deleting removed files and folders.

Any advice would be awesome

Rich

sovainfo
Joomla! Exemplar
Joomla! Exemplar
Posts: 8808
Joined: Sat Oct 01, 2011 7:06 pm

Re: Migration from 2.5.28 to 3.5.1 Hangs at 86.3 %

Post by sovainfo » Fri May 27, 2016 6:54 pm

Then you are lucky, the files and database update took place. As suspected it bailed out on the utf8mb4 conversion:
- remove files from administrator/components/com_admin/sql/updates/mysql
- Make script.php finish regardless how long it takes: set_time_limit(0); just before the conversion
- This is the only time you can run Extensions->Database->Fix. It should only report the line of the conversion. ->Fix will try it again and should finish without problem
Issue with migrating? Include logs/joomla_update.php in your report!
Blank screen? Verify pagesource for HTML code (javascript error)
Installation failing on populating database? Install with set_time_limit(0)
Document your customizations!

y021ahe
Joomla! Intern
Joomla! Intern
Posts: 58
Joined: Sat Apr 21, 2012 9:56 am

Re: Migration from 2.5.28 to 3.5.1 Hangs at 86.3 %

Post by y021ahe » Fri May 27, 2016 7:12 pm

Hi sovainfo,
Could you explain your second point - how do I "Make script.php finish regardless how long it takes: set_time_limit(0); just before the conversion" - How exactly do I make script.php finish and where is script.php located?

Thanks

sovainfo
Joomla! Exemplar
Joomla! Exemplar
Posts: 8808
Joined: Sat Oct 01, 2011 7:06 pm

Re: Migration from 2.5.28 to 3.5.1 Hangs at 86.3 %

Post by sovainfo » Fri May 27, 2016 7:39 pm

Suggest you put the statement on line 1742 just before 1743 // Step 1: Drop ....
in administrator/components/com_admin/script.php.

That will make sure the conversion finishes, normally!

Too bad, you didn't split the upgrade at j348. It would have shown that there is nothing wrong with the update. The update from j348 to j351 would succeed when you are lucky or again fail at converting your database. Obviously, with a lot of data, creating indexes is going to take time.
Last edited by sovainfo on Fri May 27, 2016 7:46 pm, edited 1 time in total.
Issue with migrating? Include logs/joomla_update.php in your report!
Blank screen? Verify pagesource for HTML code (javascript error)
Installation failing on populating database? Install with set_time_limit(0)
Document your customizations!

y021ahe
Joomla! Intern
Joomla! Intern
Posts: 58
Joined: Sat Apr 21, 2012 9:56 am

Re: Migration from 2.5.28 to 3.5.1 Hangs at 86.3 %

Post by y021ahe » Fri May 27, 2016 7:44 pm

Hi Sovainfo
OK - so after it failed and timed out I did the following

1) removed all files from sql folder as advised
2) edited script.php and added time(0) as advised.
3) clicked back button on browser.. script started to run, then logged me out to admin login screen
4) Logged in and it started to execute an update=finalise URL
5) When it logged in, it said the Joomla was succesfully upgraded to 3.5.1
6) I went to database and Fix said it was already ok.

Question - is there anything else I should do/check or is it now ok?

--

Also, how do we advise Joomla developers to add the time(0) into the upgrade script to prevent other poor souls wasting "2 days" of their life to try and fix a problem like this

Thanks again for awesome advice

Rich :) :D

sovainfo
Joomla! Exemplar
Joomla! Exemplar
Posts: 8808
Joined: Sat Oct 01, 2011 7:06 pm

Re: Migration from 2.5.28 to 3.5.1 Hangs at 86.3 %

Post by sovainfo » Fri May 27, 2016 8:04 pm

It should be ok now. At least as far as Joomla is concerned. You need to check extensions for updates. Hopefully they provide the same utf8mb4 conversion or fix it differently.

Tried to convince the Joomla developers/PLT, and failed. Not going to waste my time on that again. Even tried to prevent this mistake from happening, but was told not showing respect.

By now I advised to about any issue reported here about failing to update. Surprisingly enough I have to mention logs/joomla_update.php and set_time_limit(0) or max_execution_time every time, despite putting it in my signature!

Suggest you change the title of the first post, marking it solved. Maybe people find it and learn from your experience.
Issue with migrating? Include logs/joomla_update.php in your report!
Blank screen? Verify pagesource for HTML code (javascript error)
Installation failing on populating database? Install with set_time_limit(0)
Document your customizations!

y021ahe
Joomla! Intern
Joomla! Intern
Posts: 58
Joined: Sat Apr 21, 2012 9:56 am

What to do when your Joomla Upgrade hangs when going from J2.5 to J3.5

Post by y021ahe » Fri May 27, 2016 8:37 pm

Hi
Turns out I didnt have a stuck plugin - I have restored the original website (including extensions) and upgraded as discussed.. only point is that in step 3) I didnt click the back button, I clicked the browser refresh button to fall out to the log in page.
The rest worked as we discussed and I am now updating the extensions to the J3.x compatible ones.

Why oh Why wont the Joomla developers add one line of code to the Update script - its hardly a major change is it and would have saved me blooming ages and ages trying to look for corrupt plugins etc etc - sounds a bit arrogant to me!

Thanks sovainfo - you have saved my life.

y021ahe
Joomla! Intern
Joomla! Intern
Posts: 58
Joined: Sat Apr 21, 2012 9:56 am

Re: Migration from 2.5.28 to 3.5.1 Hangs at 86.3 %

Post by y021ahe » Sat May 28, 2016 3:21 pm

I dont know how to set this to SOLVED - but it is now solved

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

Re: Migration from 2.5.28 to 3.5.1 Hangs at 86.3 %

Post by leolam » Sat May 28, 2016 3:39 pm

y021ahe wrote:I dont know how to set this to SOLVED - but it is now solved
So important to know for all other Joomlers: how did you solve it?

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

User avatar
Slackervaara
Joomla! Ace
Joomla! Ace
Posts: 1032
Joined: Sat Aug 13, 2011 6:27 am

Re: Migration from 2.5.28 to 3.5.1 Hangs at 86.3 %

Post by Slackervaara » Sat May 28, 2016 4:53 pm

He should after the upgrade clicked on Database Fix. That had finalized the upgrade.

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

Re: Migration from 2.5.28 to 3.5.1 Hangs at 86.3 %

Post by leolam » Sat May 28, 2016 5:12 pm

sovainfo wrote:Tried to convince the Joomla developers/PLT, and failed. Not going to waste my time on that again. Even tried to prevent this mistake from happening, but was told not showing respect..
Do I have to start crying now? You have been invited multiple times to join the Joomla Bug Squad or add code to "Issues" or write better documentations. You have refused doing so and as such you refuse to contribute to the project....You only flame here (and in other posts) and throw up on your sadly misconceived treatment.

Again if you want to share your (for sure recognized) knowledge join and contribute instead of throwing up here on the forums? It seems you have enough time to post here so why not join the "Joomla-cause" and contribute with code, documentation and whatever you can positively do so stop wasting time with your blah, blah, blah and start doing something constructive and as mentioned contribute?

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

sovainfo
Joomla! Exemplar
Joomla! Exemplar
Posts: 8808
Joined: Sat Oct 01, 2011 7:06 pm

Re: Migration from 2.5.28 to 3.5.1 Hangs at 86.3 %

Post by sovainfo » Sat May 28, 2016 7:53 pm

@y021ahe It probably too late to change the icon of your first post in this thread. Maybe not too late to change the title adding [SOLVED] in front of it.
Issue with migrating? Include logs/joomla_update.php in your report!
Blank screen? Verify pagesource for HTML code (javascript error)
Installation failing on populating database? Install with set_time_limit(0)
Document your customizations!

poeticabdul
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Sun Aug 26, 2012 10:11 pm

Re: Migration from 2.5.28 to 3.5.1 Hangs at 86.3 %

Post by poeticabdul » Fri Jun 10, 2016 12:14 pm

Even after doing the following

1) removed all files from sql folder
2) edited script.php and added time(0)
3) clicked back button on browser

The page now shows the following error "The page isn't redirecting properly"

Note. I had to put set_time_limit(0); on line 1722 (instead of 1742 as advised), that's where I found // Step 1: Drop ....

Can anyone help? Thanks

User avatar
Slackervaara
Joomla! Ace
Joomla! Ace
Posts: 1032
Joined: Sat Aug 13, 2011 6:27 am

Re: Migration from 2.5.28 to 3.5.1 Hangs at 86.3 %

Post by Slackervaara » Fri Jun 10, 2016 1:06 pm

Have you looked in log/joomla_update.php to see if the database have been updated properly.

poeticabdul
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Sun Aug 26, 2012 10:11 pm

Re: Migration from 2.5.28 to 3.5.1 Hangs at 86.3 %

Post by poeticabdul » Fri Jun 10, 2016 2:13 pm

Yes, the log/joomla_update.php ends with this

2016-06-09T16:37:44+00:00 INFO 167.114.123.186 update Deleting removed files and folders.
2016-06-09T16:49:50+00:00 INFO 167.114.123.186 update Cleaning up after installation.
2016-06-09T16:49:50+00:00 INFO 167.114.123.186 update Update to version 3.5.1 is complete.

User avatar
Slackervaara
Joomla! Ace
Joomla! Ace
Posts: 1032
Joined: Sat Aug 13, 2011 6:27 am

Re: Migration from 2.5.28 to 3.5.1 Hangs at 86.3 %

Post by Slackervaara » Fri Jun 10, 2016 2:44 pm

Have you emptied the cache in browser? Do you have any extension that affects the URL?

poeticabdul
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Sun Aug 26, 2012 10:11 pm

Re: Migration from 2.5.28 to 3.5.1 Hangs at 86.3 %

Post by poeticabdul » Fri Jun 10, 2016 3:04 pm

With the hang, I can no more access both the frontend and backend. To your question specifically, no, they're no such extensions.

User avatar
Slackervaara
Joomla! Ace
Joomla! Ace
Posts: 1032
Joined: Sat Aug 13, 2011 6:27 am

Re: Migration from 2.5.28 to 3.5.1 Hangs at 86.3 %

Post by Slackervaara » Fri Jun 10, 2016 3:43 pm

Have you tried another browser? It seems that when you login the normal redirection from login page to /administrator/index.php does not work. Have you tried with /administrator/index.php after login?

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

Re: Migration from 2.5.28 to 3.5.1 Hangs at 86.3 %

Post by Per Yngve Berg » Fri May 12, 2017 9:23 am

Increase the php max_execution_time on the server to 60 seconds.

Restore a bavkup and try again.


Locked

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