Skip Navigation

This thread is resolved. Here is a description of the problem and solution.

Problem:
The client reported that pages previously translated using the Classic Translation Editor (CTE) were unexpectedly redirected to the Advanced Translation Editor (ATE), resulting in the loss of professional translations.

Solution:
We discovered that an alteration in the database might have caused this issue. We recommend running the following SQL query to address the problem:

UPDATE `wp_icl_translate_job` SET `editor` = 'wpml' WHERE `editor_job_id` IS NULL;

Before executing this query, ensure you have a full backup of your site and database. If there were structural changes to the content (fields changed, added, or removed), some translations might appear incomplete in the CTE, and you will need to manually complete these translations.

If this solution does not resolve your issue or seems irrelevant due to being outdated or not applicable to your case, we highly recommend checking related known issues at https://wpml.org/known-issues/, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins. If further assistance is needed, please open a new support ticket at WPML support forum.

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.

Tagged: 

This topic contains 6 replies, has 0 voices.

Last updated by John-Pierre Cornelissen 2 months ago.

Assisted by: Waqas Bin Hasan.

Author Posts
March 7, 2025 at 12:57 pm #16788448

John-Pierre Cornelissen

To stop the cleanup bot again 😉
Next week I get back to this.

March 10, 2025 at 6:24 am #16794388

Waqas Bin Hasan
WPML Supporter since 05/2014

Languages: English (English )

Timezone: Asia/Karachi (GMT+05:00)

Sure, thank you.

March 10, 2025 at 4:18 pm #16797488

John-Pierre Cornelissen

Hi again and sorry for the delay.

To update on the current status
- All prices have been updated and translated with the CTE.
- I updated the editor in wp_icl_translate_job as instructed in reply #16729534.
- The ATE is activated and set it to keep old CTE translations.
- I tested editing the menu page, and translation updates use the CTE👍
- I added Portuguese as a new language.
- I went to All Pages » clicked the + icon to translate in Portuguese. It translated with the ATE to 100% but when I return to All Pages, it shows the cog icon, and under 'translation jobs', it remains 'in progress'.
- I cancelled the job, used the translation dashboard to send it to translate automatically, and that way also gets stuck at 'in progress'.

This is the I originally issue I reported here:
https://wpml.org/forums/topic/how-to-accept-all-ate-translations/

I know that issue is back because I restored a backup to start over from scratch.

Can you please let me know how to fix this in the database?
Or re-open that previous ticket to pick it up again from there?

Thanks
JP

PS: here is a recording that shows what I did hidden link

March 11, 2025 at 6:55 am #16799510

Waqas Bin Hasan
WPML Supporter since 05/2014

Languages: English (English )

Timezone: Asia/Karachi (GMT+05:00)

Thank you for the updates.

That ticket (https://wpml.org/forums/topic/how-to-accept-all-ate-translations/) has been closed almost a month ago and can not be reopened, however you can visit that ticket and see if the option is available for you to reopen. Otherwise, you can open a new one, with reference to that ticket, so our support can catch up accordingly.

The issue resolved in there was not in the database but was a problem with your site records in our servers. And it was fixed by our relevant team by hand.

For this very ticket, if you think that CTE vs ATE issue for existing vs new language (i.e. Menukaart page) has been resolved, please feel free to close it.

However, since restoring from backup has resurfaced previous issue, I'll recommend keeping this ticket with you, while that issue is fixed again via the new (or other) ticket. So you can determine that if the editors issue is also back or not (and can continue accordingly).

March 11, 2025 at 8:55 am #16800051

John-Pierre Cornelissen

Ok, this ticket is created: https://wpml.org/forums/topic/ate-translations-stuck-at-in-progress/

Since you have been working with me on this, can you please pick it up?

---
PS: this AI rewriting support requests is really bad. It removes most of the background including the links to the other two related tickets. I complaint about this many times before and since it doesn't seem to improve, so I copy my entire message before submitting it, and then paste that back under 'questions' in the AI result. To a certain degree I can understand support uses AI to summarise and improve submissions, but it should also keep the original message with it. Can you please forward this AI support feedback to the relevant people? Thanks.

March 12, 2025 at 6:39 am #16805054

Waqas Bin Hasan
WPML Supporter since 05/2014

Languages: English (English )

Timezone: Asia/Karachi (GMT+05:00)

Thank you for the updates, I've already taken that ticket and 'll update you via that one (about that resurfaced issue).

March 13, 2025 at 12:28 pm #16811817

Waqas Bin Hasan
WPML Supporter since 05/2014

Languages: English (English )

Timezone: Asia/Karachi (GMT+05:00)

Reference to the other ticket, where the issue has been fixed.

Now please try the solution provided here earlier and see if it works.

And if that does not work, do not restore site from backup but let me know (via that ticket), so we can move forward.

IMPORTANT: I'll recommend creating a staging site based on the live site and then try the solution from this ticket, so if issue remains we can continue working on the staging one.

March 14, 2025 at 5:17 pm #16818176

John-Pierre Cornelissen

Thanks, I already ran that query before creating the other ticket. So far so good. Will report back on monday. Thanks. JP

March 17, 2025 at 5:10 am #16822866

Waqas Bin Hasan
WPML Supporter since 05/2014

Languages: English (English )

Timezone: Asia/Karachi (GMT+05:00)

Sure, please take your time and let me know when you're ready.

March 17, 2025 at 3:35 pm #16826123

John-Pierre Cornelissen

This looks good now. Thank you for all your help!