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.
Problem:
There is an SSL error when using different domains per language Solution:
If you are using the language URL Format "different language per domain" you should have an SSL certificate for each site translation or one multi-domain SSL certificate.
Problem: The client reported a WordPress database error related to invalid data in some tables, specifically mentioning an issue with a Jetpack plugin error message that persisted even after uninstallation. Solution: We identified that the error message contained an emoji, which might have contributed to the database issue. We removed the specific message from the database, and the error did not reappear. We recommend checking your site to confirm that the error message no longer displays. If you're experiencing similar issues, we suggest removing any special characters or emojis from database entries that could potentially cause errors.
Please note that this solution might be outdated or not applicable to your specific case. 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 the problem persists, please open a new support ticket.
