Home›Support›English Support›[Resolved] Pending review is empty but I see 62 translations are waiting for review
[Resolved] Pending review is empty but I see 62 translations are waiting for review
This thread is resolved. Here is a description of the problem and solution.
Problem: The client was unable to see the German translations on their website despite having translations pending for review. The issue was twofold: SQL server settings interfering with the query execution and unregistered custom Elementor widgets not appearing in the translation editor. Solution: First, we identified that the SQL server's ANSI_QUOTES mode was causing the term 'local' to be misinterpreted. We recommended the client to request their server support team to disable the ANSI_QUOTES mode globally for MySQL. After this adjustment, the translations queue began to function correctly.
Secondly, the issue of English content still appearing on the translated pages was due to the use of default Elementor widgets from a theme not listed in our compatible theme directory. We advised the client to register these widgets for translation by following our guide: Registering Custom Elementor Widgets for Translation. Additionally, we suggested contacting the theme author to join the WPML Go-global program to ensure compatibility.
If these solutions do not resolve your issues or seem outdated, we 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.
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 translate the page to German. Yesterday I started the automatic translation and my credits went down from 20k to 4400 but 90% of the pages remain in English. In translation management, I see that 62 translations are waiting for review but when I click on the link my pending review table is empty. I tried to update the database as it was suggested in one of WPML's tickets but this didn't help either.
Symptoms:
Pending review table is empty but 62 translations are waiting for review.
Questions:
Why are 62 translations showing as waiting for review but the pending review table is empty?
How can I resolve the issue of translations not appearing in the pending review table?
It appears that you're having two different issues. Let's focus first on resolving the problem with the Pending Review table.
The Pending Review section will appear empty if the translation has already been published. If you haven't manually published the translation or reviewed anything, please follow these steps to resolve the issue:
1. Navigate to WPML > Support > Troubleshooting.
2. Click on the following buttons:
- Clear the cache in WPML
- Remove ghost entries from the translation tables
- Fix element_type collation
- Fix WPML tables collation
- Synchronize local job IDs with ATE jobs
- Synchronize translators and translation managers with ATE
- Assign translation status to duplicated content
- Set language information
After completing these steps, clear the cache on your site and in your browser. Then, check if the Translation Management section still shows any items to be reviewed. If it does, revisit the Pending Review section to see if any items are now visible.
Regarding the issue with translations not appearing on the frontend: It's correct that translations will not be visible on the frontend until they are either published or reviewed. However, if you built the page using Elementor widgets that are not registered for translation, the content within those widgets will also not appear translated. Please share the link to the page where the translation is not showing so I can check and suggest the next steps.
Let me know the update. I will be happy to help if you need further assistance in this matter.
Thanks for your answer. I have completed all tasks mentioned by you but i still see that 62 62 translations are waiting for review but the table is still empty.
So the suggested steps didn't solve the issue.
Hello There,
Thank you for trying out the suggestions.
While checking, I came across a ticket that closely resembles the issue you're experiencing. Could you please try the solution mentioned in this ticket and check if that helps in solving the issue?
[Before executing any SQL query, it is STRONGLY recommended to take a full backup of the site and Database.]
If the issue persists, a closer inspection will be required to understand the root cause of the issue.
I would like to request temporary access (wp-admin and FTP) to your site to take a better look at the issue. It would be better to have a testing site where the issue is replicated.
You will find the needed fields 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.
Maybe I'll need to replicate your site locally. For this, I’ll need to temporarily install a plugin called “Duplicator” or "All in One WP Migration" on your site. This will allow me to create a copy of your site and your content. Once the problem is resolved I will delete the local site. Let me know if this is ok with you.
IMPORTANT
-Please backup 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
Hello There,
Thank you for sharing the access information.
It appears that not only are the Pending Review items not displaying, but the Translation section is entirely empty. By default, it should show the Completed translations, but these are also missing. To investigate further, I enabled WordPress Debug mode. The error log indicates that a column is missing in the `wp_icl_translation_status` table, which seems to be the primary cause of the issue.
As I don't have access to your site's database, please try the following steps and see if they help solve the issue.
- Please take a full backup of your site including the database.
- Open the site Database from your Hosting panel.
- Run the following SQL query:
ALTER TABLE wp_icl_translation_status ADD COLUMN translation_service VARCHAR(255);
[Please note that the database prefix `wp` could be different for your database. Ensure you adjust the prefix according to your site's database configuration.]
- Once done, create a new page and translate it automatically.
- Navigate to "WPML > Translation" and filter the Status column by "Pending Review".
Please let me know how it goes. I will be happy to help if you need further assistance in this matter.
I checked the error log and noticed that the 'Unknown Column' error is still appearing in the Debug log file. If you have already created the table and the issue persists, there might be additional missing columns in the database or another database-related problem causing the issue.
It would be helpful if you could share access to your database so that I can investigate the issue further. I have enabled the private box for you to securely share the information.
I tried several probable solutions, but unfortunately, the issue persists. Therefore, I have escalated this issue to our 2nd tier team for further investigation. As soon as I have any update on this issue, I will surely inform you.
Please keep the site and database access active until we complete the investigation.
Thank you for your patience and kind cooperation in this matter.
Hello Krisztián,
I hope you're doing well. Sorry for the delay in responding due to the weekend.
The ticket is still being investigated by our second-tier team. Initially, we suspected the issue might be due to the SQL mode set in your database, but updating the mode did not resolve it.
Therefore, I have made a copy of your site for a more in-depth investigation. It will be deployed in a local development environment for further analysis. As soon as I have any information from the 2nd tier team, I will surely inform you.
I appreciate your patience and kind cooperation in this matter.
I'd like to share an update with you. We have identified that the following query is failing:
AND translation_status.translation_service = "local"
It appears that the term `local` is being misinterpreted as a column name rather than a string. This mostly happens due to the ANSI_QUOTES mode being enabled on the SQL server.
On my local server, the ANSI_QUOTES mode is disabled by default, which is why I'm unable to replicate this issue by deploying your site copy. To resolve this, I recommend contacting your server support team and requesting that they disable the ANSI_QUOTES mode globally for MySQL.
Once this change has been made, please check the "Translations Queue" and check if you're still having the issue. I'll be happy to help.
It seems the ANSI_QUOTES change has solved the Translations Queue issues and I was able to approve the changes. In spite of that I still see english texts on all pages.
Glad to hear that updating the SQL Mode solves the issue.
Regarding the issue of seeing English content on the translated pages, it’s possible that the translations haven't been fully completed yet. I created a new page and translated it into German, and the German content displays correctly when switching to the German language. You can view the German translation here: hidden link
Could you please share on which page you're exactly having the issue? I will check that page and advise you on what to do next.
I don't know what I am doing wrong. I translated the whole site but when I choose german language 95% of texts are in english. For example: hidden link
Could you help how can I solve this?
