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.
Sun | Mon | Tue | Wed | Thu | Fri | Sat |
---|---|---|---|---|---|---|
- | 12:00 – 14:00 | 12:00 – 14:00 | 12:00 – 14:00 | 12:00 – 14:00 | 12:00 – 14:00 | - |
- | 17:00 – 21:00 | 17:00 – 21:00 | 17:00 – 21:00 | 17:00 – 21:00 | 17:00 – 21:00 | - |
Supporter timezone: Europe/Vienna (GMT+01:00)
Tagged: Exception, Performance
This topic contains 69 replies, has 4 voices.
Last updated by Bigul 9 months ago.
Assisted by: Bigul.
Author | Posts |
---|---|
September 28, 2023 at 8:03 pm #14484373 | |
louisN-4 |
any news/updates? |
September 29, 2023 at 12:45 pm #14487725 | |
Bigul Supporter
Languages: English (English ) Timezone: Europe/Vienna (GMT+01:00) |
Hello, We have an update from our developers. The slow queries you have mentioned and the following slow queries showing in Query Monitor will be resolved in WPML 4.7. It is in the QA stage now and is expected to be released in a month. So kindly wait for the fix. SELECT wpml_translations.element_id, tax.term_id, tax.taxonomy FROM lsk_icl_translations wpml_translations JOIN lsk_term_taxonomy tax ON wpml_translations.element_id = tax.term_taxonomy_id AND wpml_translations.element_type = CONCAT('tax_', tax.taxonomy) JOIN lsk_terms terms ON terms.term_id = tax.term_id WHERE tax.term_id != tax.term_taxonomy_id SELECT jobs.rid, jobs.job_id as jobId, jobs.editor_job_id as ateJobId, jobs.automatic , translation_status.status, translation_status.review_status, jobs.ate_sync_count > 100 as isLongstanding FROM lsk_icl_translate_job as jobs INNER JOIN lsk_icl_translation_status translation_status ON translation_status.rid = jobs.rid INNER JOIN lsk_icl_translations translations ON translation_status.translation_id = translations.translation_id INNER JOIN lsk_icl_translations parent_translations ON translations.trid = parent_translations.trid AND parent_translations.source_language_code IS NULL LEFT JOIN lsk_posts posts ON parent_translations.element_id = posts.ID WHERE jobs.job_id IN ( SELECT MAX(job_id) FROM lsk_icl_translate_job GROUP BY rid ) AND jobs.editor = 'ate' AND ( translation_status.status IN (1,2,40) OR 1=0 ) AND translations.language_code IN ('nl','en','de','he','ru') AND ( posts.post_status IS NULL OR posts.post_status <> 'trash' ) SELECT jobs.rid, jobs.job_id as jobId, jobs.editor_job_id as ateJobId, jobs.automatic , translation_status.status, translation_status.review_status, jobs.ate_sync_count > 100 as isLongstanding FROM lsk_icl_translate_job as jobs INNER JOIN lsk_icl_translation_status translation_status ON translation_status.rid = jobs.rid INNER JOIN lsk_icl_translations translations ON translation_status.translation_id = translations.translation_id INNER JOIN lsk_icl_translations parent_translations ON translations.trid = parent_translations.trid AND parent_translations.source_language_code IS NULL LEFT JOIN lsk_posts posts ON parent_translations.element_id = posts.ID WHERE jobs.job_id IN ( SELECT MAX(job_id) FROM lsk_icl_translate_job GROUP BY rid ) AND jobs.editor = 'ate' AND ( translation_status.status IN (30) OR translation_status.review_status IN ( 'NEEDS_REVIEW','EDITING' ) ) AND translations.language_code IN ('nl','en','de','he','ru') AND ( posts.post_status IS NULL OR posts.post_status <> 'trash' ) Also, there are some improvements after we sync the translation jobs in our ATE server. Please check it on the staging site now and let us know your feedback. -- Bigul |
October 1, 2023 at 7:11 pm #14493779 | |
louisN-4 |
we confirm their is an improvement in speed shall we copy the plugin, or just wait for you to release the update to everyone? |
October 2, 2023 at 4:21 am #14494055 | |
Bigul Supporter
Languages: English (English ) Timezone: Europe/Vienna (GMT+01:00) |
Hello, Thank you for the updates. Please upgrade to the latest version of WPML(4.6.6) on your live site after a full site backup{mandatory}. Because it also included some performance improvements. We will get back to you soon when we have an update from our developers about the WPML 4.7 releases. Please wait. -- Bigul |
October 2, 2023 at 5:23 am #14494213 | |
louisN-4 |
can we just wait for 4.7 and then upgrade to it? |
October 3, 2023 at 8:49 am #14502553 | |
Bigul Supporter
Languages: English (English ) Timezone: Europe/Vienna (GMT+01:00) |
Hello, Thank you for the updates. That is also fine. You can try WPML 4.7 RC in the staging when it is ready. We will ping you when we have an update from our developers about the WPML 4.7 releases. Please wait. -- Bigul |
October 3, 2023 at 12:40 pm #14504771 | |
louisN-4 |
ok also give me zip, so i can deploy on production in case staging works |
October 3, 2023 at 4:50 pm #14507499 | |
Bigul Supporter
Languages: English (English ) Timezone: Europe/Vienna (GMT+01:00) |
Hello, Thank you for the updates. Do you mean the WPML 4.7 version files or the 4.6.6 version currently used on the staging site? You can download the WPML 4.6.6 version from https://wpml.org/account/downloads/ -- Bigul |
October 3, 2023 at 4:54 pm #14507599 | |
louisN-4 |
i am not enthusiastic to upgrade to 4.6.6 because of this so i prefer to go from 4.6.4 that we have on production to 4.7 directly |
October 3, 2023 at 5:21 pm #14507941 | |
Bigul Supporter
Languages: English (English ) Timezone: Europe/Vienna (GMT+01:00) |
Hello, Thank you for the updates. WPML 4.7 is currently in the QA stage. We will ping you soon when we have an update from our developers about the WPML 4.7 releases. Please wait. -- Bigul |
October 4, 2023 at 11:22 am #14512257 | |
louisN-4 |
we still have this code implemented shall we remove it before we upgrade to 4.7? |
October 4, 2023 at 4:56 pm #14515033 | |
Bigul Supporter
Languages: English (English ) Timezone: Europe/Vienna (GMT+01:00) |
Hello, Thank you for the updates. As per our internal tickets, that issue is already resolved and patched in the latest versions of WPML. So our suggestion is please wait for the WPML 4.7 beta release. So you can test with the beta version on your staging site before the final release. -- Bigul |
October 8, 2023 at 9:16 pm #14535433 | |
louisN-4 |
good week bigul, any update when 4.7 be released? |
October 9, 2023 at 5:06 pm #14541889 | |
Bigul Supporter
Languages: English (English ) Timezone: Europe/Vienna (GMT+01:00) |
Hello, As of now, we don't have an exact date for the release of WPML 4.7. It is still in the QA stage. Please wait. -- Bigul |
October 9, 2023 at 10:28 pm #14543001 | |
louisN-4 |
we are bleeding money because of your software component failure, i need to know when you will release this fix or alternativly, give me the fixed query |