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 with WPML (SitePress) preventing the deletion of media files in BuddyBoss when a user uploads an image but then cancels the post (draft/discard), and the file remains on the server despite being deleted from the site interface, this might be due to a conflict between WPML and BuddyBoss. Solution: We recommend trying the following steps: 1. Go to WPML > Settings > Posts and pages synchronization. 2. Enable the option "When deleting a post, delete translations as well".
This setting should help ensure that when a post is deleted, its translations and associated media files are also removed from the server.
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. If the problem persists, please open a new support ticket.
