Migration from 2.5.28 to 3.5.1 Hangs at 86.3 %

[y021ahe]

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

[Per Yngve Berg]

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]

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.

[leolam]

@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

[y021ahe]

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]

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

[y021ahe]

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]

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.

[y021ahe]

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

[sovainfo]

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.

[y021ahe]

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]

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

[leolam]

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

[Slackervaara]

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

[leolam]

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

[sovainfo]

@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.

[poeticabdul]

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

[Slackervaara]

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

[poeticabdul]

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.

[Slackervaara]

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

[poeticabdul]

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

[Slackervaara]

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?

[Per Yngve Berg]

Increase the php max_execution_time on the server to 60 seconds.

Restore a bavkup and try again.