Skip Navigation

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 NUMERIICA 1 week, 5 days ago.

Assisted by: Long Nguyen.

Author Posts
November 15, 2024 at 1:39 am #16405472

Long Nguyen
Supporter

Languages: English (English )

Timezone: Asia/Ho_Chi_Minh (GMT+07:00)

Hi,

Our 2nd tier support solved the issue on the staging site by running this SQL query

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';

then register reviews again, now you can see all reviews are registered and available on the String Translation page.
Before applying the workaround to your production site, please ensure you have a full site and database backup.

Looking forward to your reply.
Thanks

String Translation ‹ Pilote et Filles — WordPress 2024-11-15 08-37-05.png
November 15, 2024 at 2:23 pm #16408897

NUMERIICA

Ok it works, many thanks for this help.

Another question, there a way to translat the wcml-reviews string with the automatic WPML translation?

When I try to export as a .pot file, for translation in a Poedit software didn't recognize the original language as fr_CA

November 15, 2024 at 2:27 pm #16408901

NUMERIICA

Also how can I clean the spam review deleted in the past, they are still there, see the printscreen.

hidden link

November 15, 2024 at 8:08 pm #16409670

NUMERIICA

I finally deleted the spam review one by one and the problem is solved, thsnk you for you help! 😉

November 15, 2024 at 8:26 pm #16409724

NUMERIICA

Thank you for you help