This thread is resolved. Here is a description of the problem and solution.
Problem: You are trying to translate product reviews on your WooCommerce site and have followed the standard procedure, but you're unable to see all 400 reviews, and old deleted reviews are still visible. Solution: First, ensure you have registered the reviews for translation by following these steps: 1. Navigate to WooCommerce > WooCommerce Multilingual & Multicurrency and select the Status tab. 2. Click the Troubleshooting link at the bottom right corner. 3. In the Troubleshooting tab, check the box next to 'Register product reviews for translation' and click the Start button. 4. Proceed to WPML > String Translation to translate the reviews. If issues persist, our second-tier support can apply a specific SQL query to adjust database tables, which has resolved the issue on a staging site:
ALTER TABLE `rqcv_icl_strings`
CHANGE `language` `language` varchar(7) COLLATE 'utf8mb4_unicode_ci' NOT NULL AFTER `id`,
CHANGE `context` `context` varchar(160) COLLATE 'utf8mb4_unicode_ci' NULL AFTER `language`,
CHANGE `name` `name` varchar(160) COLLATE 'utf8mb4_unicode_ci' NULL AFTER `context`,
CHANGE `value` `value` longtext COLLATE 'utf8mb4_unicode_ci' NOT NULL AFTER `name`,
CHANGE `wrap_tag` `wrap_tag` varchar(16) COLLATE 'utf8mb4_unicode_ci' NOT NULL AFTER `location`,
CHANGE `type` `type` varchar(40) COLLATE 'utf8mb4_unicode_ci' NOT NULL DEFAULT 'LINE' AFTER `wrap_tag`,
CHANGE `title` `title` varchar(160) COLLATE 'utf8mb4_unicode_ci' NULL AFTER `type`,
CHANGE `gettext_context` `gettext_context` text COLLATE 'utf8mb4_unicode_ci' NOT NULL AFTER `status`,
CHANGE `domain_name_context_md5` `domain_name_context_md5` varchar(32) COLLATE 'utf8mb4_unicode_ci' NULL AFTER `gettext_context`,
CHANGE `translation_priority` `translation_priority` varchar(160) COLLATE 'utf8mb4_unicode_ci' NOT NULL AFTER `word_count`,
COLLATE 'utf8mb4_unicode_ci';
Ensure you have a full backup before applying this solution to your production site.
If this solution does not apply to your case, or if it seems outdated, 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 you need further assistance, please open a new support ticket at WPML support forum.
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.
Thank you for contacting WPML support, I’m happy to help you with this issue.
I suggest you follow the last point in the documentation to register reviews for translation:
1. Go to WooCoomerce > WooCommerce Multilingual & Multicurrency and click over to the Status tab.
2. Click the Troubleshooting link in the bottom right corner of the page.
3. The Troubleshooting tab will open. Check the box next to Register product reviews for translation and hit the Start button.
4. Then go to WPML > String Translation to translate reviews.
If it does not help, I would like to request temporary access (wp-admin and FTP) to your site so I can take a better look at the issue. It would be better to have a testing site where the issue is replicated. Your next reply is set to private to share the info.
I tried to register reviews for translation with the steps above on your site but it doesn't work. However, after restoring your site on my localhost, I can register reviews and they are available in WPML > String Translation as well. Please check the attached screenshots.
I suggest you copy your site to a staging site and enable a minimal environment as below, try to register reviews again and see if it helps:
- Deactivate all plugins except WPML plugins and WooCommerce.
- Switch to a standard theme of WordPress.
I compared the PHP settings on your site and on my local site, most of them are the same. There are some settings that have a lower value like PHP max input variables, PHP time limit. Please try to increase the value of those settings and see if it helps.
If not, please share the new test site credentials (wp-admin), I will check the issue there.
Based on your details, I suspect that there is an issue with the caching on your hosting. Do you try to restore the site on your computer (local host) and register the reviews?
Also, please share the new test site credentials (wp-admin), I will check the issue there.
When I try to move some reviews to the trash, I'm blocked by the Sucuri secure module. Please check the attached screenshot. This secure module prevents modifying the database on your site and might cause the issue. Can you please disable or turn it off and register reviews again?
I can delete reviews on your site properly. However, I still cannot register reviews for translation. I'm discussing this issue with our 2nd tier support and I will update you here when I have something to share.
The staging site was removed from your hosting. Can you please restore it or create a new one and share the credentials with me? Your next reply is set to private to share the info.
Our 2nd tier support is investigating the issue and agrees with me: we suspect that the Sucuri security module would prevent our plugin from registering reviews on your site.
If it is possible, please disable Sucuri on the staging site or copy your site to another hosting and recheck the issue.
I deleted the test website cause it was attacked by a virus.
I move to another location without Sucuri firewall and the problem still there. Here the new connection link, use the same login I aldready sypply to you
