Problem: The client stopped using WPML and encountered an issue with a large number of duplicated images in the media library, even after using the reset option to delete the icl tables. Solution: We recommend trying the following SQL query on a staging site to remove duplicate images:
DELETE p1
FROM wp_posts p1, wp_posts p2
WHERE p1.guid = p2.guid AND p1.ID > p2.ID AND p2.post_type = 'attachment'
It is crucial to back up the database and website before executing this query. Alternatively, the client can use the Media Cleaner plugin to clean up the media library. We also informed the client that WPML 4.6.3 was released recently and advised checking the changelog for more details.
Please note that this solution might be irrelevant if it's outdated or not applicable to your case. If the issue persists, we highly recommend checking related known issues, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins. If necessary, please open a new support ticket for further assistance.
