Open
Reported for: WPML Multilingual CMS 4.5.8
Overview of the issue
You may see some of the WPML tables growing too large, specifically:
- icl_translate
- icl_translate_job
- icl_translation_status
This may occur if there is a lot of data in the posts and postmeta tables and you are using a page builder or the Gutenberg block editor.
You may wish to delete the old translation jobs data while keeping the current content intact, however, we do not have any method to delete these jobs. This feature is still under consideration because it carries the risk of data loss, but we have an experimental script that can delete the old jobs data.
Workaround
Please make sure you have a complete database backup. If anything doesn’t seem to be right, there is only one option which is to restore the database. If you agree, then please proceed.
- Download this temporary plugin
- Activate the plugin provided.
- Visit Tools → WPML Delete jobs
- You will see a text area prefilled with job IDs, these are 50 suggested job IDs to delete first. These job IDs are the same that you will see in WPML → Translation Management → Jobs. You can uncheck some job IDs in case you don’t want to touch a few pages or posts.
- Click Delete and wait. Once the content is deleted, you will see a new batch of 50 IDs to delete, and so on until there are no jobs for revision.
- Finally click on Optimize _icl_translation_status table to reduce the size of icl_translation_status table.
- Deactivate and remove the cleaning plugin.
Is there a way to delete more jobs at a time? There are over 15000 jobs in my database, this would take forever to click 50 at a time
Hello!
In the plugin that we shared with you in your support ticket, there is a line that sets the limit:
$suggested_job_ids = $wpdb->get_col("SELECT DISTINCT rid FROM {$wpdb->prefix}icl_translate_job WHERE revision IS NOT NULL AND (completed_date is NOT NULL OR editor != 'ate') ORDER BY job_id ASC LIMIT 50");You can change the limit to higher than 50 there.
Do mind that you might have issues with the server if you increase the limit to a higher than your servers capabilities value.
Hello,
We have a similar experience here on our website. The autoload data from the WPML plugin is huge and the main options and its data values are listed below. Due to this, we are experiencing too much delay on the admin side when updating, changing, creating, or translating a post. Sometimes translation won’t work, and we need to wait for some time for the proper working of the WPML ATE editor.
wpml_strings_need_links_fixed(411084)
ATE_RETURNED_JOBS_QUEUE(83389)
icl_sitepress_settings(17141)
otgs-installer-log(9747)
wpml_shortcode_list(7599)
wpml_language_switcher_template_objects(6803)
How can we reduce the data overload of these options and optimize the database for the smooth running of the website? Please let us know your feedback.
Thanks in advance 🙂
Hello there,
In that case, please open a chat in our assistance. We will provide you the required plugin for following the workaround here provided with the assistance of one of our specialists.
Regards
Is this temporary plugin to delete translation jobs still available?
I downloaded it, installed it, and tried to use it, but it was not clear where the “delete” button was at all;
I’m a hobbyist writer, and I would like to produce rough translations directly from inside the post (for proofreading and editing later by a native speaker). I do not require “translation management”, but would also like the option to update the translation, if I edit the original post. I now have a long list of translation jobs, and it is not clear to me where this came from and how to delete the ones that appear to be pending (but not required). Thanks for your time and attention.
Hi there,
Yes, the plugin is still available. You’ll find the download link and instructions included in the documentation. Once you’ve uploaded and activated the plugin on your site, please refer to this screenshot for a clearer idea of where the “Delete” option is located: https://snipboard.io/bzsOS2.jpg
If you see job IDs in the plugin’s text area, you should be able to delete those specific translation jobs.
Please note: this plugin is designed to delete old translation jobs. If you’re looking to delete jobs currently in progress, please go to “WPML > Translation Management > Jobs”, and remove them from there.
You don’t need to use the translation management system. You can manage translations more simply by editing posts directly.
In the WordPress editor, look for the “Language” section in the right-hand sidebar. From there, you can access your translations.
Hope that helps! If you need any further assistance, feel free to start a chat on our support forum.
Thanks for the tip. I accept your advice about using wpml only from the editor. Also I’d like to minimize the database and also minimize any excess wpml autoload.
I installed and activated the WPML Delete Jobs plugin, deleted the jobs by the IDs suggested, and then went to Translation Mnagament -> Translation Jobs and would like to clear this list out, including Completed and Publishing – pending review,, all jobs.
So I sellect a series, but there is no option to delete, only “Cancel jobs”, which has no effect, because they are already complete.
Is there any way to clear this list?
How can I minimize the WPML overhead when loading translated pages and posts?
Thanks for your time and attention.
Hi Ben,
Thanks for the update. I’m glad to hear the WPML Delete Jobs plugin was helpful.
The “Cancel jobs” action is only applicable to jobs that are still in progress. Completed jobs remain listed to maintain a record of translation activities.
If you need further help, feel free to start a chat on our support forum.