Problem: The client was experiencing an issue where the Spanish translation of their WordPress site using WPML was not working, displaying an error: 'Uncaught Error: Unknown format specifier "S"'. Solution: 1. We asked the client to increase the WordPress memory limit by adding the following code to their wp-config.php file:
If this solution does not resolve your issue, or if it seems outdated or irrelevant 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. If needed, please open a new support ticket at WPML support forum for further assistance.
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.