This thread is resolved. Here is a description of the problem and solution.
Problem: The client is experiencing a critical site error due to two different ATEs being created with different strings, causing issues with translation jobs. Additionally, there are problems updating WPML plugins. Solution: We recommend the following steps to resolve the issues: 1. Navigate to WPML > Support > Troubleshooting. 2. Perform the following actions: - Synchronize posts taxonomies by selecting 'Pages'/'Posts' from the dropdown before clicking the button. - Clear the cache in WPML. - Remove ghost entries from the translation tables. - Fix element_type collation. - Fix WPML tables collation. - Synchronize local job ids with ATE jobs. - Synchronize translators and translation managers with ATE. - Assign translation status to duplicated content. - Set language information. - Fix post type assignment for translations. 3. Clear the caches from your site and browser. 4. Cancel the in-progress job by following the instructions outlined here. 5. Open the default page in the WordPress editor, make a small change in the Title, save the changes to trigger a translation update, and then update the translation.
If these steps do not resolve the issue or if you encounter further problems, such as errors in the debug log or issues updating the plugin, we recommend checking your user profile settings or refreshing your WPML license data. If necessary, unregister and re-register WPML on your site.
If the solution provided here does not resolve your issue or seems outdated, please visit our known issues page, verify the version of the permanent fix, and ensure you have installed the latest versions of themes and plugins. If the problem persists, do not hesitate to open a new support ticket here.
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.
Background of the issue:
I am trying to resolve an issue on my site hidden link. I noticed that 2 ATE are created but with different strings. One of them is causing a critical site error. Please see hidden link. The error log is provided below:
I watched the video and understood the problem. Initially, the page was sent for translation, and the ATE created job ID 104321072, but this translation wasn't finished. Later, the default page was modified and sent for translation again, resulting in a new job ID, 104321074, which was completed. So, when you update the translation next time, job ID 104321074 should load, not the previous one. The issue with mismatched translation jobs might be due to the translation jobs not being synced.
Please try the following steps and check if they help in solving the issue:
- Please go to WPML > Support > Troubleshooting.
- Scroll down and click on the following buttons:
-- Synchronize posts taxonomies [Select 'Pages'/'Posts' from the dropdown before clicking the button.]
-- Clear the cache in WPML
-- Remove ghost entries from the translation tables
-- Fix element_type collation
-- Fix WPML tables collation
-- Synchronize local job ids with ATE jobs
-- Synchronize translators and translation managers with ATE
-- Assign translation status to duplicated content
-- Set language information
-- Fix post type assignment for translations
- Once done, clear the caches from your site and browser.
- Cancel the in-progress job by following the instructions outlined here.
- Next, open the default page in the WordPress editor.
- Make a small change in the Title and save the changes. It will trigger a translation update.
- Update the translation. The latest translation job should load and if you notice anything not translated there, make sure to complete the translation.
I hope the steps above will help in solving the issue.
Regarding the Errors in the debug log: The error usually happens due to incomplete setup of the Admin profile, specifically when the First Name and Last Name fields are left empty or if the Email format is incorrect. Could you please try the following steps to see if they resolve the problem?
1. Navigate to Users > Profile and make sure you've correctly entered your First and Last name in the Profile section.
2. Next, go to "WPML > Translation Management > Translator."
3. If you've already added your profile as a translator, please remove it and then re-add it. If you haven't configured the Translator yet, you can leave it as it is.
Regarding the issue with updating the plugin: Sometimes, due to a license issue or incorrect API communication between your site and the WPML server, you might encounter problems updating the plugins. In such cases, refreshing the license can help.
Here’s what to do:
1. Go to WPML > Support > Troubleshooting.
2. Scroll down and click the button labeled "Refresh license data to recognize license update."
3. If everything is in order, you should be able to update the plugin.
If the issue persists, try unregistering WPML from the site and then registering it again. This can also help resolve the problem.
I hope the information above will help in solving the issue. Feel free to let me know if you need further assistance in this matter. I will be happy to help.
thanks, I have followed your advice but counted a crucial error. Please see the attached images. I have rolled back the site for now. Please see below my comments with ***
-- Synchronize posts taxonomies [Select 'Pages'/'Posts' from the dropdown before clicking the button.]
-- Clear the cache in WPML. *** did it.
-- Remove ghost entries from the translation tables *** 'done' popup showed
-- Fix element_type collation *** 'done' popup showed
-- Fix WPML tables collation *** 'done' popup showed
-- Synchronize local job ids with ATE jobs *** 'done' popup did NOT showed
-- Synchronize translators and translation managers with ATE *** 'done' popup did NOT showed
-- Assign translation status to duplicated content *** 'done' popup showed
-- Set language information *** 'done' popup did NOT showed
-- Fix post type assignment for translations. *** 'done' popup showed
- Once done, clear the caches from your site and browser.
- Cancel the in-progress job by following the instructions outlined here. *** here I counted a big problem. There were TONS OF jobs, and there is no 'search' filed... so I decided to delete all jobs that are not done. I was deleting about 150 ... then WPML disappeared from admin panel ( it switched to an error page, and no left side bar)... then when I went to see 'plugin', the image is what I got.
error message:
An error of type E_ERROR was caused in line 41 of the file /www/raelorgi_146/public/wp-content/plugins/sitepress-multilingual-cms/classes/API/REST/jobs/class-wpml-tm-rest-job-progress.php. Error message: Uncaught DivisionByZeroError: Division by zero in /www/raelorgi_146/public/wp-content/plugins/sitepress-multilingual-cms/classes/API/REST/jobs/class-wpml-tm-rest-job-progress.php:41 Stack trace: #0 /www/raelorgi_146/public/wp-content/plugins/sitepress-multilingual-cms/classes/API/REST/jobs/class-wpml-tm-rest-jobs-view-model.php(116): WPML_TM_Rest_Job_Progress->get(Object(WPML_TM_Post_Job_Entity)) #1 /www/raelorgi_146/public/wp-content/plugins/sitepress-multilingual-cms/classes/API/REST/jobs/class-wpml-tm-rest-jobs-view-model.php(66): WPML_TM_Rest_Jobs_View_Model->map_job(Object(WPML_TM_Post_Job_Entity), Object(WPML_TM_Jobs_Search_Params)) #2 /www/raelorgi_146/public/wp-content/plugins/sitepress-multilingual-cms/classes/API/REST/class-wpml-tm-rest-jobs.php(215): WPML_TM_Rest_Jobs_View_Model->build(Object(WPML_TM_Jobs_Collection), 8910, Object(WPML_TM_Jobs_Search_Params)) #3 /www/raelorgi_146/public/wp-includes/rest-api/class-wp-rest-server.php(1230): WPML_TM_REST_Jobs->get_jobs(Object(WP_REST_Request)) #4 /www/raelorgi_146/public/wp-includes/rest-api/class-wp-rest-server.php(1063): WP_REST_Server->respond_to_request(Object(WP_REST_Request), '/wpml/tm/v1/job...', Array, NULL) #5 /www/raelorgi_146/public/wp-includes/rest-api/class-wp-rest-server.php(439): WP_REST_Server->dispatch(Object(WP_REST_Request)) #6 /www/raelorgi_146/public/wp-includes/rest-api.php(428): WP_REST_Server->serve_request('/wpml/tm/v1/job...') #7 /www/raelorgi_146/public/wp-includes/class-wp-hook.php(324): rest_api_loaded(Object(WP)) #8 /www/raelorgi_146/public/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters('', Array) #9 /www/raelorgi_146/public/wp-includes/plugin.php(565): WP_Hook->do_action(Array) #10 /www/raelorgi_146/public/wp-includes/class-wp.php(418): do_action_ref_array('parse_request', Array) #11 /www/raelorgi_146/public/wp-includes/class-wp.php(813): WP->parse_request('') #12 /www/raelorgi_146/public/wp-includes/functions.php(1336): WP->main('') #13 /www/raelorgi_146/public/wp-blog-header.php(16): wp() #14 /www/raelorgi_146/public/index.php(17): require('/www/raelorgi_1...') #15 {main} thrown
Hi Jasmin,
I hope you're doing well. Sorry for the delay in responding due to the weekend.
The 'DivisionByZeroError' sometimes occurs due to issues with the translation status in the WPML database table. However, in one case, another user reported the same issue, which was resolved by executing some SQL queries. Would you please follow the instructions outlined in this ticket and check if that helps in solving the issue?
Please give it a try and let me know how it goes. I'll be happy to help if you need further assistance in this matter.
[Please make sure to take a full backup of the site and database before executing the SQL.]
I will take a look...
meanwhile, is it possible to find the 'translation job' that I am looking for to delete (the problem ones)? Right now, it is impossible... there are way too many to go through page by page...
Thanks
The translation jobs should be available in WPML > Translation Management > Jobs tab and from the same section, you can cancel/delete the job. To cancel or delete a job, search for the name of the post or page you want to cancel, and it will appear in the list. Then, click on the 'Trash' icon to cancel the translation job.
If the job you want to delete is the one mentioned in the video you've shared, please search for Our Causes in the Jobs tab. If it appears in the results, simply delete the job by clicking the Trash icon.
Please let me know if the information above helps or if you need further assistance. I will be happy to help.
"- Cancel the in-progress job by following the instructions outlined here. *** here I counted a big problem. There were TONS OF jobs, and there is no 'search' filed... so I decided to delete all jobs that are not done. I was deleting about 150 ... then WPML disappeared from admin panel ( it switched to an error page, and no left side bar)... then when I went to see 'plugin', the image is what I got."
HOW can I search it????
see also the image I attach...
Sorry for not including the instructions on how to search for a job in the Jobs section in my previous message. In the Jobs section, you’ll find a column named "Title." To the left of the Title column, there is a search icon. Please check this screenshot for clarification: hidden link
Clicking on this icon will reveal a box where you can search for a job. Once the job appears in the result, you can cancel the job by clicking the Trash icon.
I hope it helps. Please feel free to let me know if you need further assistance in this matter. I will be happy to help.
Please feel free to let me know if you need further assistance. I will be happy to help.
Since you mentioned that there are still an issue exists, if you encounter a different issue than the one reported in this ticket, I kindly request you to create a new ticket for that specific issue, as we are allowed to discuss one issue per thread. However, if the issue is related to or a continuation of what you've reported in this ticket, feel free to share it here. I will be glad to assist you with that.
