Home›Support›English Support›[Resolved] MySQL DB growing too big because of icl_translate and icl_translation_status tables
[Resolved] MySQL DB growing too big because of icl_translate and icl_translation_status tables
This thread is resolved. Here is a description of the problem and solution.
Problem: If you're experiencing an issue with your database growing too large due to the icl_translate (4.3 GB) and icl_translation_status (3.2 GB) tables, it might be due to how WPML retains data. Solution: We recommend updating to the latest version of WPML where this issue has been addressed. After updating, you can find a new option to clear old translation data under WPML > Support > Troubleshooting. To update WPML, navigate to Plugins > Add new in your WordPress dashboard, click on the "Commercial" tab, and then click "Check for WPML Updates".
Please note that this solution might be irrelevant if it's outdated or not applicable to your case. We highly recommend checking related known issues at https://wpml.org/known-issues/, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins. If the issue persists, please open a new support ticket at WPML support forum.
This is the technical support forum for WPML - the multilingual WordPress plugin.
Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.
I've updated one page using the Beaver Builder and published it but still no translation jobs available to be deleted appeared in "Tools > WPML Delete Jobs" UI.
I suppose I am not doing it correctly.
Can you please provide me a step by step example of what I should do in order to get the old translations jobs available to be deleted in the "Tools > WPML Delete Jobs" plugin?
To trigger the jobs the WPML Translation Editor needs to be used but I am seeing a new issue on the site.
1) Open the original page inside the WordPress Editor and open the page builder
2) Make a small edit and save the page
3) Go back to the WordPress Editor and access the translations inside the right sidebar
You should see now an arrowed circle, which means the translation needs an update but for some reason, the status is not updating. We would need to investigate this further.
Could you please update all plugins so that we can continue testing? I see that the Astra PRO and the Fluent Booking PRO plugins have not been updated for a long time. Also, our plugins are not updated and it says that you currently do not have a valid subscription.
Did you not extend your subscription? Please take note that support can only be granted if you have a valid subscription on wpml.org.
In case you do have a valid subscription, it might be that you need to register the site again on your wpml.org account and register WPML using a new site key.
IMPORTANT:
Take note, that you should never mix translation methods. If you plan to create translations directly inside the page builder, then you should set the translation method on the original content to "WordPress Editor".
You find this option inside the right sidebar of the WordPress Editor for every original page or post.
Take note, that the WPML Translation Editor will overwrite any edits taken on the page builder on translations.
To trigger the jobs the WPML Translation Editor needs to be used but I am seeing a new issue on the site.
1) Open the original page inside the WordPress Editor and open the page builder
2) Make a small edit and save the page
3) Go back to the WordPress Editor and access the translations inside the right sidebar
You should see now an arrowed circle, which means the translation needs an update but for some reason, the status is not updating. We would need to investigate this further.
Could you please update all plugins so that we can continue testing? I see that the Astra PRO and the Fluent Booking PRO plugins have not been updated for a long time. Also, our plugins are not updated and it says that you currently do not have a valid subscription.
Did you not extend your subscription? Please take note that support can only be granted if you have a valid subscription on wpml.org.
In case you do have a valid subscription, it might be that you need to register the site again on your wpml.org account and register WPML using a new site key.
IMPORTANT:
Take note, that you should never mix translation methods. If you plan to create translations directly inside the page builder, then you should set the translation method on the original content to "WordPress Editor".
You find this option inside the right sidebar of the WordPress Editor for every original page or post.
Take note, that the WPML Translation Editor will overwrite any edits taken on the page builder on translations.
There will already be some enhancements in minor updates before 4.8 but I do not have any dates or further details about this available.
As we only recently released 4.7 it might take some time until 4.8 will be available. It is more likely that this would be in the second half or by the end of this year.
