This thread is resolved. Here is a description of the problem and solution.
Problem:
You are experiencing an issue where the translation process for your home page is stuck. It indicates 'less than a minute' and queues all files, but no translations are being updated, and this has persisted for weeks.
Solution:
1. Identified affected jobs by running the following SQL query:
```sql
SELECT `job_id`, `editor_job_id`, `ate_sync_count`
FROM `wp_icl_translate_job`
WHERE `editor` = 'ate' AND `automatic` = '1' AND `translated` = '0'
ORDER BY `ate_sync_count` DESC
LIMIT 50;
```
2. Observed the `ate_sync_count` column incrementing upon refreshing the admin page, confirming the issue.
3. Resolved the issue by setting the `automatic` field of these high-count jobs to `0`, allowing them to progress correctly.
If the issue persists, it might be helpful to clear any stuck processes in the translation management queue. Additionally, reviewing the debug report you attached could provide insights into what might be causing the translation to halt.
If these steps do not resolve the issue, or if the solution seems 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 problem continues, please open a new support ticket with us for further assistance 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.
Tagged: Exception
This topic contains 17 replies, has 2 voices.
Last updated by Bruno Kos 1 month, 3 weeks ago.
Assisted by: Bruno Kos.
Author | Posts |
---|---|
October 25, 2024 at 10:23 am #16330091 | |
alainC-25 |
Background of the issue: Symptoms: Questions: |
October 25, 2024 at 12:56 pm #16330676 | |
Bruno Kos Supporter
Languages: English (English ) German (Deutsch ) French (Français ) Timezone: Europe/Zagreb (GMT+01:00) |
Hi, Thank you for contacting WPML support! Perhaps in your case it is about this, as I see that you have 0 credits. https://wpml.org/forums/topic/how-to-move-past-first-safety-limit-charge-threshold/#post-15582795 Can you check this and try? Regards, |
October 25, 2024 at 1:38 pm #16330932 | |
alainC-25 |
no i dont have any messages about payment, it just staying in the queue saying it will be finish in less a minute |
October 28, 2024 at 5:53 am #16335837 | |
Bruno Kos Supporter
Languages: English (English ) German (Deutsch ) French (Français ) Timezone: Europe/Zagreb (GMT+01:00) |
Would you be willing to provide me with WordPress credentials so I could investigate the issue directly? I marked your next reply as private so that you can safely add credentials. |
October 28, 2024 at 11:18 am #16337415 | |
Bruno Kos Supporter
Languages: English (English ) German (Deutsch ) French (Français ) Timezone: Europe/Zagreb (GMT+01:00) |
I tried would a troubleshooting function which should cancel these translation jobs, however it hasn't worked. I am checking this with our 2nd tier and will keep you posted. |
October 29, 2024 at 12:13 pm #16342047 | |
Bruno Kos Supporter
Languages: English (English ) German (Deutsch ) French (Français ) Timezone: Europe/Zagreb (GMT+01:00) |
Can you install https://wordpress.org/plugins/pexlechris-adminer/? We would like to check something in database, the wp_icl_translation_status table -> review_status. |
October 29, 2024 at 12:36 pm #16342167 | |
alainC-25 |
Hello, I gave you full admin access in previous message plz install whatever you need to solve this issue |
October 29, 2024 at 1:57 pm #16342614 | |
Bruno Kos Supporter
Languages: English (English ) German (Deutsch ) French (Français ) Timezone: Europe/Zagreb (GMT+01:00) |
Can you check now? |
October 29, 2024 at 2:10 pm #16342714 | |
alainC-25 |
ok the loading bug has disappear, now about other issue i mentioned to you yesterday: when user switch language and then want to go to my account or member access which should take him to the universal login page then from different language it does not take him there. can you please as requested cancel all translation for all pages and menu except for homepage ( i dont know where al those are stored ), in order when people click on the menu url stay the same and not getting some translated url. i dont know why but when i am logged in i dont have the issue , when i am log out and change language and try to access my account or login page it change the url and not getting me access to the required page i add you a short clip of the issue. |
October 30, 2024 at 5:39 am #16344697 | |
Bruno Kos Supporter
Languages: English (English ) German (Deutsch ) French (Français ) Timezone: Europe/Zagreb (GMT+01:00) |
If I open hidden link I see that is shows correct French content, so this would work for the site visitors, or? The page is not available for non-logged users because it is not published: What if you publish this (and other) such pages, would that work? I think it would be a better user experience. |
October 30, 2024 at 6:06 am #16344719 | |
alainC-25 |
Well even this i dont know from to publish those pages. I really prefer to keep only original english pages version to avoid any confusions. Also my website is super heavy with all those translated pages. |
October 30, 2024 at 6:48 am #16344771 | |
Bruno Kos Supporter
Languages: English (English ) German (Deutsch ) French (Français ) Timezone: Europe/Zagreb (GMT+01:00) |
Can you please try the following: 1. To publish translations, click the "Publish" button when viewing any translation you want to make live. 2. If you need to delete any translations: 3. To prevent automatic re-creation of deleted translations: |
October 30, 2024 at 8:52 am #16345423 | |
alainC-25 |
hello, ok it helped and i made the required changes. however i still have on private page of my courses: hidden link that wpml did not translate ( before it was but now all text are staying in english ). also i need to get this page texts translated in french but all the media videos that are on the page should not be changed by the translation, i went ot setting and tried to set that when i active a translation it does not change the media video file however i am not sur e if what i have setted is for image or video player. so to resume: 1. i need to have clear settings that saying when i lunch a transaltion for my home page that pictures and video player to be also copied to the new translated page but for my private access video courses when i active translation i dont want it change any video player ( because for each page i have manually added video player for each different lamgauges ). 2. if you can help for the page hidden link to get the text translated to french ( without changing the media player content ) thanks for your support |
October 30, 2024 at 9:01 am #16345439 | |
Bruno Kos Supporter
Languages: English (English ) German (Deutsch ) French (Français ) Timezone: Europe/Zagreb (GMT+01:00) |
If I check hidden link, it seems like that videos are the same, or? Is this not what you are trying to achieve? But if you want to change some things to be different in translations, you can go with this: |
October 30, 2024 at 11:14 am #16346512 | |
alainC-25 |
the thumbmail is the same but the video file ( if you check the video vimeo link ) is different. i read your article and yes this what i do to manually makes changes. but still i have the issue i am not getting the page hidden link translated in french, text are still in english |