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.
Hey there, there seems to be a bug internally. On Translation Management I always see "
2 translations waiting for review", when I click on it there are none
Hi Kor, deactivating the plugin and reactiving the plugin would definitely not break translations. I noticed you activated the Child Theme and restored the original Them
Yes, the site broke when I deactivated the plugins and when I checked the debug logs, it's saying that the theme is causing issues. So, I've switched themes to fix the site. Could you restore the site from the backup so that I can continue escalating this to our 2nd Tier Support for further assistance?
[04-Dec-2023 18:53:08 UTC] PHP Fatal error: Uncaught Error: Call to undefined function is_checkout() in /home/dev2ellasbubbles/public_html/wp-content/themes/flatsome/functions.php:793
Stack trace:
#0 /home/dev2ellasbubbles/public_html/wp-settings.php(611): include()
#1 /home/dev2ellasbubbles/public_html/wp-config.php(71): require_once('/home/dev2ellas...')
#2 /home/dev2ellasbubbles/public_html/wp-load.php(50): require_once('/home/dev2ellas...')
#3 /home/dev2ellasbubbles/public_html/wp-blog-header.php(13): require_once('/home/dev2ellas...')
#4 /home/dev2ellasbubbles/public_html/index.php(17): require('/home/dev2ellas...')
#5 {main}
thrown in /home/dev2ellasbubbles/public_html/wp-content/themes/flatsome/functions.php on line 793
I'm sorry to hear that you cannot restore from a backup. I will check and see if there is anything I can do from my end to fix the "broken language" and "Translation waiting for review" issues.
Waiting for update, of course we need to get this resolved. We started with a pesky translation notice, and now have no languages. Please escalate to corresponding departments or higher tiers to get this resolved immediately.
Like asking for a tire change and the company breaks your engine.
I've rechecked and it looks like you've fixed the languages. I will proceed with escalating to our 2nd Tier Support to check on the "Translation waiting for review" issue.
I have some feedback, and I kindly request access to the server database to execute the following SQL query. However, before proceeding, please ensure that a full backup is performed.
If you are unsure about the process, I would also like to request permission to install the PHPmyadmin plugin, which will allow me to run the following SQL query:
UPDATE `wp_icl_translation_status` SET `review_status` = NULL
WHERE `review_status` LIKE ''
Could you try checking the icl_translation_status table for the review_status column? Then manually set it to "ACCEPTED" and clear it from the stuck queue. Let me know if this method works. If not, I will ask for another feedback from our 2nd Tier Support.
