This is the technical support forum for WPML - the multilingual WordPress plugin.

Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.

This topic contains 25 replies, has 2 voices.

Last updated by Dan 7 months, 2 weeks ago.

Assigned support staff: David.

Author Posts
February 12, 2019 at 1:57 pm #3188960

Dan

I am trying to update to WPML Multilingual CMS 4.2.0 on dev3.internetsociety.org.
After updating all wpml plugins, there will be this message "WPML Translation Jobs Migration..." with a "Run Now" button to finalise the update.
The problem is that "Run now" never completes, the turning wheel stays forever.

This makes it impossible to update wpml.
This may be related to our rather big wp_postmeta table with over 1.4 million rows.

Do you have any idea how to accomplish this update?

Also when I copy-pasted debug information in your support field, it crashes your form submission with an error "413 Request Entity Too Large"

Please respond to wohlfarth@isoc.org.

Thanks very much for your help!
With best regards,
Henri
Developer
Internet Society

February 13, 2019 at 9:12 am #3192689

David
Supporter

Languages: English (English ) Spanish (Español )

Timezone: Europe/Madrid (GMT+02:00)

I saw that problem reported already in our system.
Let me find out more information and I will get back to you.

On another subject, can you pass me the debug information via patebin.com or similar?
We'd like to resolve this issue for future tickets.

Thanks

February 13, 2019 at 10:36 am #3193328

Dan

Hi David,
Thanks for your response, here is the debug info:

hidden link

Let me know if you have any troubles to get it.

Kind regards,
Henri

February 13, 2019 at 10:46 am #3193365

David
Supporter

Languages: English (English ) Spanish (Español )

Timezone: Europe/Madrid (GMT+02:00)

Thanks, I passed the information to our developers to fix the issue attaching debug info.

I am still waiting for feedback about your main issue, I will get back to you shorlty.

February 15, 2019 at 1:09 pm #3205000

David
Supporter

Languages: English (English ) Spanish (Español )

Timezone: Europe/Madrid (GMT+02:00)

Apparently, this is caused by different collations in database tables.

Next WPML release will have dedicated code to fix this situation, but meanwhile, we have to put together a small utility plugin that fixes this for you:

hidden link

- Install and activate the plugin and it will run automatically.
- You can deactivate it immediately after and check if the "Run now" button works.

I would advise that you make a backup before doing this, just in case.

February 15, 2019 at 10:19 pm #3206726

Dan

Hi David,
I have installed that plugin "WPML Fix Collation" but it
hasn't solved the issue. Still exactly the same thing: "Run now" never ends.
I will be back on 25 February to take it up.
In the meantime, let me know if there is any other recommendation.
Best,
Henri

February 18, 2019 at 6:08 pm #3213676

David
Supporter

Languages: English (English ) Spanish (Español )

Timezone: Europe/Madrid (GMT+02:00)

Oh, thats unexpected. It worked for other clients with the same issue.

Is there any chance of getting a duplicator package of your site to debug the issue step by step?

https://wordpress.org/plugins/duplicator/

If you can exclude the uploads folder from the package, the size will be smaller and more convenient.

February 25, 2019 at 2:28 pm #3240304

Dan

Hi David,
We use box.com to share such files with an authorised url.
As I can't send that publicly, how should I share that with you?
Do you have an e-mail, slack, zoom, jabber, etc address to share that with you?
Thanks!
Henri

February 26, 2019 at 8:31 am #3243486

David
Supporter

Languages: English (English ) Spanish (Español )

Timezone: Europe/Madrid (GMT+02:00)

I have your copy up and running on my local host.

I will get back to you shortly about this.

February 27, 2019 at 4:44 pm #3251574

David
Supporter

Languages: English (English ) Spanish (Español )

Timezone: Europe/Madrid (GMT+02:00)

I need you to follow these steps:

1) Update to latest versions of WPML + addons

2) Run the migration one last time

It is possible that the notice is still there.
If so, please share a screenshot and I will give you one last step to run.

Let me know how it goes.

February 28, 2019 at 8:34 am #3254090

Dan

Hi David,
I have tried once more but still the same: "Run now" runs forever.
How much time is this supposed to run, approximately?
Otherwise, no error at all in debug.log and no notice at all here.
Did you manage to install locally our site and update wpml on your side?
Let me know,
Thanks, gracias
Henri

March 1, 2019 at 1:38 pm #3261101

David
Supporter

Languages: English (English ) Spanish (Español )

Timezone: Europe/Madrid (GMT+02:00)

Yes, I had to delete the site key and create another one:
https://wpml.org/account/sites/
After updating the site key in my copy the updates worked.

The actual migration job is already done in your database.
The problem happens when trying to mark the migration as complete.
We can resolve it by running the following SQL query in your database:

INSERT INTO wp_options (option_name, option_value) VALUES ('wpml-tm-translation-jobs-migration', '1')

You might have to adjust the table name if your table prefix is different.

Our development team is looking into this to find a definite solution, so if you prefer to wait until we release a solution thats ok, because the notification shouldn't hurt.
As I mentioned above the migration is already done.

March 3, 2019 at 6:29 pm #3266556

Dan

Thank you David for your feedback.

So I have done "Run Now" and did that query INSERT INTO wp_options (option_name, option_value) VALUES ('wpml-tm-translation-jobs-migration', '1')

The notification "Run now" disappeared as you described. However, it would still be important to know how much time the "Run now" button needs to run approximaltely to accomplish the necessary updates. Is it 5 minutes, 10minutes, 2 hours? Just to prevent any update abortion.

After the above, there is now another pop-up:

Quote
Problem receiving translation jobs?
WPML needs to update its table of translation jobs, so that your site can continue receiving completed translations. This process will take a few minutes and does not modify content or translations in your site.
Unquote

After half an hour, that one is still ongoing. There is obviously a similar problem.

Also during today's updating attempts, there hasn't been any error logged in debug.log or apache logs.

Given that last issue, my preference would be to fix that update script at the developer team level.
Would be great if you could give me a timeline when these fixes could be delivered.

Thanks again for your support!

Best regards,
Henri

March 4, 2019 at 4:03 pm #3269781

David
Supporter

Languages: English (English ) Spanish (Español )

Timezone: Europe/Madrid (GMT+02:00)

The message states "4/4 jobs" which indicates the migration was done.
For only 4 jobs it should be a matter of seconds.

About the fix I sent you, it comes straight from the developer's team.

The long explanation is that we made a mistake in 4.2 and this whole process attempts to fix that mistake. We are almost sure you didn't update to version 4.2 so you didn't run into this problem. Can you confirm this?

March 4, 2019 at 4:08 pm #3269789

David
Supporter

Languages: English (English ) Spanish (Español )

Timezone: Europe/Madrid (GMT+02:00)

I am re-reading your last post and I realize that you are running into a second problem.

I will need at least a fresh database dump to examine what happened.
If you prefer to give me access details I can take the dump myself. It's your choice.

I have marked your next reply as private.