Sorry for the delay. This issue is forwarded to our developers and our developers are currently working on it. We will get back to you soon when we have an update from our developers on this. Please wait. Thank you for your patience.
For your kind updates, our developers are still working on this bug. It is taking time because of the major changes to resolve this issue. So as of now, we don't have an exact release date for this fix. We will update you on the status soon when we have feedback from our developers on this. Thank you for your understanding and patience. Please wait
still open? We have some issue and many other user talking about that bug in other topics here and on wpml facebook groups and wordpress groups. 3 months for bug fixing?! 🙁
Sorry for the delay. Our developers are still working on this bug. As of now, we don't have an exact date for the fix release of this bug because of the major changes. We will get back to you as soon as possible when we have an update from our developers on this. Please wait. Thank you for your understanding and patience.
We have a workaround for this case. But we have to clean the database manually. Here's an approximate guide of how it can be done. Important: Make a full site backup before doing anything!
Need to look in 2 tables: wp_icl_translate_job and wp_icl_translate.
If you take the page Home for example, then in table wp_icl_translate_job there are a number (X) of rows for it:
SELECT * FROM `wp_icl_translate_job` WHERE `title` LIKE 'Home' ORDER BY `wp_icl_translate_job`.`job_id` DESC
We only need to keep the very last translation job, with the largest values of job_id column (e.g. 797). So it needs to be excluded from the query, so we get (X - 1) rows:
SELECT * FROM `wp_icl_translate_job`
WHERE `title` LIKE 'Home'
AND `job_id` != (SELECT MAX(job_id) FROM `wp_icl_translate_job` WHERE `title` LIKE 'Home')
ORDER BY `wp_icl_translate_job`.`job_id` DESC
All these rows could be deleted AFTER the related rows will be deleted from wp_icl_translate table (below).
To select the related rows from wp_icl_translate, we give the list of job_id from our previous query using keyword IN:
SELECT * FROM `wp_icl_translate` WHERE `job_id` IN (SELECT `job_id` FROM `wp_icl_translate_job`
WHERE `title` LIKE 'Home'
AND `job_id` != (SELECT MAX(job_id) FROM `wp_icl_translate_job` WHERE `title` LIKE 'Home')
ORDER BY `wp_icl_translate_job`.`job_id` DESC)
This query can generate results of thousands of rows - if you multiply it by the number of pages that need cleaning up, it is evident that the table will become much lighter after you're done.
that looks nice but, as newbit, it's too complicated to me and I'm worried to break something. Do you think WPML will add some "clean up" feature in future?
Thank you for the feedback. Our developers trying hard to improve it and in the future, you can expect more features related to clean up and fast performance. But we don't have the exact time frame for it because of the major & complex changes.
We will get back to you as soon when we have an update from our developers on this. Kindly wait. Thank you for your understanding and patience.
