[Resolved] Remove content from database that was deleted in ACF fields

Problem:
The client deleted a field from a field group associated with a Custom Post Type (CPT) using a custom SQL query to remove all instances of

field_name

and

_field_name

due to a large number of posts.

Solution:
We recommend updating the original post and then its translation. This action will remove the content from the translation editor and from the

icl_translation_status

table. To remove it from the

icl_translate

table, the client will need to write a custom SQL query. Additionally, we found an errata that might be related to the size of the

icl_translate

table. We suggest looking at the workaround provided in the errata to help reduce the size of the table:

• Reducing size of icl_translate_job, icl_translate, and other WPML tables

Please note that the solution provided might be outdated or not applicable to your case. If the issue persists, we highly recommend checking the related known issues, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins. If you still need assistance, please open a new support ticket with us.