Background of the issue:
I am cleaning up my database and noticed that I still have about 1,840 completed translation jobs listed under Translation Jobs. The related database tables are quite large, for example: wp_icl_translate → ~217 MB, wp_icl_translation_status → ~67 MB, wp_icl_translate_job → ~1.7 MB. I have already tried canceling jobs from the Translation Jobs interface, using the troubleshooting options under WPML → Support → Troubleshooting, and installing the wpml_delete_jobs.php plugin (WPML Delete Jobs, version 1.0).
Symptoms:
Completed translation jobs are not being removed from the database, leading to large database tables.
Questions:
Is it safe for me to use the wpml_delete_jobs.php plugin myself to remove the completed jobs?
Will it delete only the job entries from the database (and not affect the actual translations on my site)?
Is there an alternative/best practice way to reduce the size of the WPML job tables without risking my translated content?
We now have newer versions of our plugins than what is installed on your site. WPML's core plugin latest version is 4.8.1, and you have 4.7.6. If you don't see that we have new versions, please go here: hidden link and click the Check for updates button. After updating WPML to its latest version, you will find a new option in the troubleshooting section. It will be available at: hidden link. Specifically, there is a section called "Database Tables Optimization". Please see the attached screenshot. Please read the warning and then click the button. This troubleshooting option is a better alternative to the wpml_delete_jobs.php plugin. Please try using it.
**** Important! Please make a full site backup (files and DB) before you proceed with those steps****
It has been brought to my attention that we have a known issue with the troubleshooting option I mentioned in my previous reply. The known issue involves translations made before and after updating WPML 4.8. Please read about it here: https://wpml.org/errata/problem-with-wpml-4-8-database-tables-optimization/.
Suppose you have translations after updating to 4.8 (which may not be your case, as the information in this ticket indicates you have version 4.7.6 on your system). In that case, you should avoid the troubleshooting option I mentioned.
Please let me know if you have any further questions or need additional help with this issue.
Regards,
Itamar.
The topic ‘[Closed] Delete completed jobs’ is closed to new replies.
