[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.
We use cookies to optimize our website and services. Your consent allows us to process data such as browsing behavior. Not consenting may affect some features.
Functional
Always active
Required for our website to operate and communicate correctly.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
We use these to analyze the statistics of our site. Collected information is completely anonymous.The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
These cookies track your browsing to provide ads relevant to you.