Skip Navigation

This thread is resolved. Here is a description of the problem and solution.

Problem:
The client is experiencing an issue with the Translation Management dashboard showing "2 translations waiting for review" even though there are none when checked.

Solution:
First, we recommend backing up the database before making any changes. If the client is comfortable with database operations, we suggest running the following SQL query to resolve the issue:

UPDATE `wp_icl_translation_status` SET `review_status` = NULL WHERE `review_status` LIKE ''

If the client is not familiar with database operations, we can install the PHPmyadmin plugin to assist with the process. Alternatively, the client can manually check the

icl_translation_status

table for the

review_status

column and set it to "ACCEPTED" to clear the stuck queue. If these solutions do not resolve the issue, we are ready to provide further assistance and may involve our 2nd Tier Support.

If this solution doesn't look relevant, 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.

Tagged: 

This topic contains 13 replies, has 2 voices.

Last updated by Kor 1 year, 1 month ago.

Assisted by: Kor.

Author Posts
December 5, 2023 at 5:43 pm #15001687

tannerT

Here is the Query that will display what is needed:
SELECT * FROM `eb21icl_translation_status` WHERE review_status = 'NEEDS_REVIEW';

Here is the SQL Download for these 2 rows for further inspection of your dev team (please mark this as private) or remove download link from public: hidden link