[Resolved] Can't access second page in translation queue
This thread is resolved. Here is a description of the problem and solution.
Problem: If you're experiencing an error message 'jobs cannot be loaded' when trying to access page 2 of the Translation Queue or when increasing the number of items per page, it might be due to a specific item on that page causing a failure. Solution: We recommend accessing your database and running the following SQL query:
UPDATE `{wpdbPrefix}_icl_translation_status` SET `status` = 1 WHERE `status` = 2;
Make sure to replace {wpdbPrefix} with your table prefix. It's crucial to back up your database and website before proceeding. If you're unsure how to run the SQL query, please contact your hosting support for assistance.
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 the problem persists, please open a new support ticket.
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 in Translation Queue page (hidden link). When I try to go to page number 2 (specifically page number 2) I see an error message 'jobs cannot be loaded'. The same happens when I try to increase the number of items in each page. I suspect that there is a particular item in page two that breaks the code, because there is no problem accessing other pages (pages 3-7 are accessible).
In the background this is the error that is logged in my log file when I try to access page 2:
Symptoms:
Error message 'jobs cannot be loaded' when accessing page 2 of the Translation Queue or increasing the number of items per page.
Questions:
How can I access page 2. I would like to translate one of the "Footer" Template Part (there are two of them for some reason) to Spanish, but can't find it in the list although I sent to the queue from Translation Management. It might be in page 2.
Thank you very much, it does seem to be the same issue. However, the link that you provided links to another issue that in it's turn link to another issue so I am not sure what exactly is meant by "follow the workaround in the ticket". each ticket there has a slightly different process mentioned.
Can you please write here a step by step explanation of what exactly to do and how. " running SQL queries" is not clear enough for me, I will need the steps please.
Please try to access your database, and run this SQL query
UPDATE `{wpdbPrefix}_icl_translation_status` SET `status` = 1 WHERE `status` = 2
and recheck the issue. Remember to change the {wpdbPrefix} with the table prefix.
❌ IMPORTANT: Please backup your database and website before proceeding ❌
If you don't know how to run the SQL query, you can contact your hosting support and ask them to help you run the query.
