Problem: You encountered a fatal error on the WPML troubleshooting page when trying to fix the collation of the
element_type
column in
icl_translations
. The error was caused by a duplicate entry for key
el_type_id
.
Solution: First, ensure you take a full backup of your website and database. Then, access your database using a database client like phpMyAdmin or Adminer. Execute the following SQL query to remove the corrupted records:
DELETE FROM tpw_icl_translations WHERE element_type = 'package_page-builder-shortcode-strin' AND translation_id NOT IN ( SELECT translation_id FROM ( SELECT t1.translation_id FROM tpw_icl_translations t1 LEFT JOIN tpw_icl_translations t2 ON t1.element_id = t2.element_id AND t2.element_type = 'package_page-builder-shortcode-strings' WHERE t1.element_type = 'package_page-builder-shortcode-strin' AND t2.translation_id IS NULL ) AS keepers );
After running this query, retry the "Fix element_type collation" option on the WPML Troubleshooting page.
If this solution does not resolve your issue or seems outdated, we 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.
Problem: If you're experiencing issues accessing the Estonian language category page on your WordPress site, while the Russian language category page functions correctly, it might be due to the known issue where product category links do not use translated slugs. Solution: We recommend following these steps: 1. Navigate to WPML → Settings → Taxonomies Translation. 2. Locate Product Categories and ensure the option “Set different slugs in different languages for Product categories” is selected. 3. Click Save to confirm the settings.
If this solution does not resolve your issue or seems irrelevant due to being outdated or not applicable to your 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. Additionally, if you need further assistance, please open a new support ticket at WPML support forum.
