Background of the issue:
We have a multisite install and are running a loop to clean up each subsite's WPML tables. The process involves deleting untranslated strings and optimizing the affected tables using the following queries:
DELETE FROM `wpif_{$site_id}icl_strings` WHERE `status` 10;
DELETE FROM `wpif_{$site_id}icl_string_translations` WHERE `status` 10;
TRUNCATE TABLE wpif_{$site_id}icl_string_pages;
TRUNCATE TABLE wpif_{$site_id}icl_string_urls;
OPTIMIZE TABLE `wpif_{$site_id}icl_strings`;
OPTIMIZE TABLE `wpif_{$site_id}icl_string_translations`.
Symptoms:
Questions:
Please validate that we understood right; this will delete any incomplete translations and to refill the tables (if need be), we can go ahead and scan the theme/plugins.
Are there other tables that should be emptied to further clean the database considering we have a high volume of subsites?
Welcome to the WPML support forum. Before passing this thread to my colleague, I would like to share some suggestions and possible solutions for the issues you mentioned.
Instead of deleting the tables directly from the database (which is not officially recommended ), the best option to clear the WPML data (including the translations) will be WPML Reset or WPML Troubleshooting. Because it is connected with multiple tables and may result in fatal errors - https://wpml.org/documentation/support/wpml-tables/
Refer to the following documentation for more details.
Thank you for the suggestions. Sadly, reseting seems to remove everything while we only want to remove untranslated/unused data in our large-scale installation.
Ideally, we need a suggestion that can be done programmatically since this would need to be done on 300+ sites. (it's a multisite)
