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.
This topic contains 2 replies, has 0 voices.
Last updated by 1 week, 5 days ago.
Assisted by: Long Nguyen.