[Resolved] Pending translations whereas I have nothing
This thread is resolved. Here is a description of the problem and solution.
Problem: The client reported an issue where the translation status incorrectly showed as pending, even though there were no pending translations. Solution: Initially, we suggested following the instructions in our guide to resolve issues where the translation process is stuck. This guide can be found here: https://wpml.org/faq/translation-status-stuck-or-displaying-the-error-wpml-didnt-manage-to-translate-this-page/ When the problem persisted, we identified that 25 translation jobs were stuck in the database with a status of '2' . We resolved this by executing the following SQL command to manually change their status to '9':
update
`icl_translation_status`
set status = 9
where status = 2
If this solution does not apply to your case, or if it seems outdated, we recommend opening a new support ticket. We also 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. For further assistance, please visit our support forum at https://wpml.org/forums/forum/english-support/.
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.
Languages: English (English )Portuguese (Brazil) (Português )
Timezone: America/Sao_Paulo (GMT-03:00)
Hello There,
Thank you for reaching out.
Typically, the translation process gets stuck in the "in-progress" state if there's any interruption happens during translation. Most of the time the issue gets resolved after following the instructions mentioned in the guide below:
That's I'm telling you, the problem is that I don't have any jobs in progress
I also tried all the troubleshooting methods
And it's keep saying I have 25 pending
I can hive you admin access to see the problem
Languages: English (English )Portuguese (Brazil) (Português )
Timezone: America/Sao_Paulo (GMT-03:00)
Hello,
I would like to request temporary access (wp-admin and FTP) to your site to take better look at the issue. You will find the needed fields for this below the comment area when you log in to leave your next reply. The information you will enter is private which means only you and I can see and have access to it.
Our Debugging Procedures
I will be checking various settings in the backend to see if the issue can be resolved. Although I won't be making changes that affect the live site, it is still good practice to backup the site before providing us access. In the event that we do need to debug the site further, I will duplicate the site and work in a separate, local development environment to avoid affecting the live site.
- Please make a backup of site files and database before providing us access.
- If you do not see the wp-admin/FTP fields this means your post & website login details will be made PUBLIC. DO NOT post your website details unless you see the required wp-admin/FTP fields. If you do not, please ask me to enable the private box. The private box looks like this: hidden link
Please, let me know if you need any additional details. Have a nice day.
Sorry, because that you shown me the SQL request, I thought that I had to do it ^^
That's perfect so !
One other question I have, as soon as I translate jobs, the language of back office change randomly, it's really annoying, do you know why ?
You can make a test by translating 10 or 20 jobs (you can force again already translated post), you will see that the language on the top change alone ...
New threads created by Mateus Getulio and linked to this one are listed below:
As you can see, jobs are being translated with automatic translation, and the language of wordpress is changing alone randomly as soon as the translation moves on ...
Languages: English (English )Portuguese (Brazil) (Português )
Timezone: America/Sao_Paulo (GMT-03:00)
Hello Nicolas,
Thank you for the video. I was able to reproduce the issue now and I appreciate your detailed explanation.
I wanted to let you know that we have a new version currently in the latest testing stages. I have tried extensively to replicate this issue in the new version, and it doesn't seem to be happening. While we don't have a beta version available for you to install yet, and I don't have an exact ETA for the launch, it will be available as soon as possible and will likely fix this issue.
Thank you for your patience and understanding. Please let me know if there's anything else I can assist you with.
Languages: English (English )Portuguese (Brazil) (Português )
Timezone: America/Sao_Paulo (GMT-03:00)
Hello there,
In order to look for a workaround, I'd like to ask permission to make a copy/staging version of your site where I can debug this closely without affecting the live site.
I'll make sure to delete this copy as soon as we get this issue fixed.
I'm afraid of debugging directly on the live site and cause issues to your visitors. Also, it is important to test a different setup as part of the troubleshooting.
