This thread is resolved. Here is a description of the problem and solution.
Problem:
The client is experiencing issues with the WPML translation queue not loading, displaying the error 'Aufträge konnten nicht geladen werden'. This issue began after adding new languages and persists despite various troubleshooting steps, including disabling plugins and adding different language pairs to the translator profile. A 'Division by Zero' error was identified in the debug log, indicating a potential cause.
Solution:
We resolved the issue by running SQL queries to update the status of translation jobs in the 'icl_translation_status' table. First, we changed the status of jobs that were 'In Progress' (status 2) to 'Needs Update' (status 1) with the following query:
UPDATE `{wpdbPrefix}_icl_translation_status` SET `status` = 1 WHERE `status` = 2
Then, we set all remaining ongoing jobs to 'Finished' (status 10) using these queries:
UPDATE `{wpdbPrefix}_icl_translation_status` SET `status` = 10 WHERE `status` = 1;
UPDATE `{wpdbPrefix}_icl_translation_status` SET `status` = 10 WHERE `status` = 9;
After applying these fixes, we advised the client to go to WPML > Translation Management and resend any pages they wish to translate.
If these steps do not resolve the issue or if the solution seems outdated or irrelevant to your specific 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 problems persist, please open a new support ticket at WPML support forum for further assistance.
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.
Background of the issue:
I am trying to access the translations queue in WPML. When I go to the translations queue, WPML attempts to load the tasks but fails. The issue can be seen at this link: hidden link.
Symptoms:
WPML tries for a while and then gives up, displaying the error message "Aufträge konnten nicht geladen werden". This error started about 30 minutes ago and persists even after deleting the cache.
Questions:
Why can't the translation queue be loaded?
How can I resolve the error 'Aufträge konnten nicht geladen werden'?
The help misdetect the installed mariadb version. The installed version is 10.6.22, not 5.something.
Also the WPML SEO plugin is at the latest avaiable version. An update which I am suggested to install is NOT available.
An additional note: This seems to have started occurring since I enabled two more languages (Dutch & Spanish), however, disabling them again didn't resolve it.
when I assign another language pair to myself, the problem goes away, but this is an ugly kludge, because I don't speak those other languages. Also now I face the error that when I click "review" for a particular translation and then "edit", the editor opens but never displays anything, instead it says "unable to retrieve job details". WPML seems really buggy.
Welcome to the WPML support forum. I will do my best to help you resolve the issue.
Please go to WPML >> Translation Management >> Translation Jobs and make sure the posts or pages you sent for translation show your name as the translator, or that they are marked as “first available” for translation.
Please try the steps below and check if it works as expected:
- Create a simple post for testing in the default language.
- Go to WPML >> Translation Management Dashboard.
- Select the test post and assign yourself as the translator (instead of selecting "Translate automatically" – see this screenshot: hidden link).
- Send the post for translation.
- Then go to WPML >> Translations and check if everything works as expected.
My goal is to /review/ existing and automatic translations, not to accept translation jobs as you seem to imply. Again, the strange behaviour is, that when I add a second language pair to my own translator profile, the error goes away, yet since I don't actually speak the other language, this is an ugly kludge. Can you explain this rather odd behaviour? Have you seen it before?
Thank you for the updates. I requested the above steps to check if the issue also occurs with new posts.
Please go to WPML >> Translation Management >> Translators tab, remove the existing translators (after taking a full site backup), and then add them again. After that, check if the issue still exists.
If the problem remains, please share the WordPress debug.log (not WPML debug information) with us so we can collect more details on this. Refer to the following links for instructions
To enable WordPress Debug log, open your wp-config.php file of the site root and look for define('WP_DEBUG', false);. Change it to:
// Enable WP_DEBUG mode
define( 'WP_DEBUG', true );
// Enable Debug logging to the /wp-content/debug.log file
define( 'WP_DEBUG_LOG', true );
// Disable display of errors and warnings
define( 'WP_DEBUG_DISPLAY', false );
@ini_set( 'display_errors', 0 );
In this case, the errors will be saved to a debug.log log file inside the */wp-content/* directory. Please do the steps to reproduce the bug and check if you are getting any errors or warnings related to WPML in the log file.
If you can paste your debug.log to http://pastebin.com/index.php and provide me with that link, it would be great! (This is the cleanest way because sometimes the logs are long and create a complete mess of discussion.)
I did as you advised and it partly helped. In the sense that now the problem occurs not all the time, but in specific situations. I reproducibly get this error when clicking "next" on the first page in the translation queue or "back" on the last page. So the page between them is just never displayed. I'll produce the debug output you requested.
Thank you for the updates. I hope you have enabled WordPress Debug Mode as described in my previous reply.
If yes, please check the "wp-content/debug.log" file to see if it contains any warnings or errors related to WPML while the issue occurs. This will help us identify the root cause.
Also, please check the browser console for any JavaScript errors when you are on the WPML >> Translations queue page.
Thanks. This workaround seemed to help. Unfortunately, then the very first item I tried to review after that again hung with the message "unable to retrieve job details" (or similar), but this is probably a separate issue.
New threads created by Bigul and linked to this one are listed below:
Thank you for the updates. I have created a new ticket for this issue to make it easier to follow up and to avoid mixing multiple topics in one ticket.
I will get back to you soon in the latest one. Please wait.
