Skip Navigation

This thread is resolved. Here is a description of the problem and solution.

Problem:
When I try to access the Translation Management > Jobs or WPML > Translations page, I get an error "Jobs could not be loaded" and no jobs are displayed.
Solution:
The issue mostly is the database corruption and related to content that is translating (In Progress status) but was deleted. To fix this issue, you can follow steps below:
- Make a full backup of your site and database first.
- Access the database > edit the table "wp_icl_translation_status" > search for the status "2" > you will find some rows.
- Edit the row and change the status to 1.
Relevant Documentation:
https://wpml.org/documentation/support/wpml-tables/

0% of people find this useful.

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: 

This topic contains 4 replies, has 2 voices.

Last updated by Long Nguyen 1 year, 3 months ago.

Assisted by: Long Nguyen.

Author Posts
September 4, 2023 at 3:31 pm #14338323

andreiM-21

Tell us what you are trying to do?
I try to acces the Translations queue/Jobs and I get error "Jobs could not be loaded". When I check "Advanced Translation Editor Error Logs" I have there 7 errors. All are similar to this one:
2023/09/04 12:37:11 PM ATE Server Communication Started attempt to download xliff file. The process did not finish. 25 76626491 {"xliff_url":"https:\/\/ate-production.s3proxy.wpml.org\/translated_xliffs\/xliffs\/051\/809\/922\/original\/translated_75375516_Contul_meu20230904-12131-bqb9tk.xliff20230904-4962-zlu052.xliff?Expires=1694435831&Signature=YqsPb4YLhBvYCckNu6hS9YO6bz02JpKM4x2rIoOY52K1bbAvH~EOZivCTiBnQfU8yP4VxUM5yLq3rzEb6-zf94bSnMAfSJpmWBHaCYWiWecPaPtU1GoYoDnFrSn2eWgptc4sxioQkb22aU2GgpkLLvmmG3Zza~lVgGCkM9WQMZu0wwAJGPD3AkV4yql5JCGsJB1P9eBK3oSCfpm4vlAdmeDwB-zoj1PFa4Gf~C8JJXeTiA4Ca0CISFNxE3jfK5Legibh2DwTqYrWrjfHotbpTA5t4VqHJ6BMATsMq-a9pzOrk~b4Jz6XGjzKbHSoyeDeAeM3bcfVnSgClRrmKxw3NA__&Key-Pair-Id=K1C11UVRQNXLRQ"}
Is there any documentation that you are following?
I did follow the instructions to allow more memory in my wp-config.php and also to display my errors (no error regarding this issue was displayed)
Is there a similar example that we can see?

What is the link to your site?
hidden link

September 5, 2023 at 7:28 am #14340363

Long Nguyen
Supporter

Languages: English (English )

Timezone: Asia/Ho_Chi_Minh (GMT+07:00)

Hi Andrei,

Thank you for contacting WPML support, I'd be happy to help you with this issue.

Please enable WP debug log and visit the Translation queue/Jobs page again and share the error log with me. There could be a fatal error in the log that causes the issue. If you don't know how to enable WP debug, please follow the documentation
https://wordpress.org/documentation/article/debugging-in-wordpress/

You can also enable a minimal environment as below and see if it helps:
- Deactivate all non-WPML plugins
- Switch to a standard theme of WordPress
❌ IMPORTANT: Please backup your database and website before proceeding ❌
You can use this plugin to create the backup:
https://wordpress.org/plugins/duplicator/

Look forward to your reply.
Thanks

September 5, 2023 at 9:35 am #14342341

andreiM-21

Hello, thank you for your support. I did try to see if the error exists if I change the theme and deactivate the non-essential plugins but it didn`t work. I'll add my log errors under:

[04-Sep-2023 14:49:23 UTC] PHP Fatal error: Uncaught DivisionByZeroError: Division by zero in /home/u712499202/domains/oanca.ro/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/API/REST/jobs/class-wpml-tm-rest-job-progress.php:41
Stack trace:
#0 /home/u712499202/domains/oanca.ro/public_html/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()
#1 /home/u712499202/domains/oanca.ro/public_html/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()
#2 /home/u712499202/domains/oanca.ro/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/API/REST/class-wpml-tm-rest-jobs.php(215): WPML_TM_Rest_Jobs_View_Model->build()
#3 /home/u712499202/domains/oanca.ro/public_html/wp-includes/rest-api/class-wp-rest-server.php(1188): WPML_TM_REST_Jobs->get_jobs()
#4 /home/u712499202/domains/oanca.ro/public_html/wp-includes/rest-api/class-wp-rest-server.php(1035): WP_REST_Server->respond_to_request()
#5 /home/u712499202/domains/oanca.ro/public_html/wp-includes/rest-api/class-wp-rest-server.php(447): WP_REST_Server->dispatch()
#6 /home/u712499202/domains/oanca.ro/public_html/wp-includes/rest-api.php(418): WP_REST_Server->serve_request()
#7 /home/u712499202/domains/oanca.ro/public_html/wp-includes/class-wp-hook.php(310): rest_api_loaded()
#8 /home/u712499202/domains/oanca.ro/public_html/wp-includes/class-wp-hook.php(334): WP_Hook->apply_filters()
#9 /home/u712499202/domains/oanca.ro/public_html/wp-includes/plugin.php(565): WP_Hook->do_action()
#10 /home/u712499202/domains/oanca.ro/public_html/wp-includes/class-wp.php(398): do_action_ref_array()
#11 /home/u712499202/domains/oanca.ro/public_html/wp-includes/class-wp.php(779): WP->parse_request()
#12 /home/u712499202/domains/oanca.ro/public_html/wp-includes/functions.php(1335): WP->main()
#13 /home/u712499202/domains/oanca.ro/public_html/wp-blog-header.php(16): wp()
#14 /home/u712499202/domains/oanca.ro/public_html/index.php(17): require('/home/u71249920...')
#15 {main}
thrown in /home/u712499202/domains/oanca.ro/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/API/REST/jobs/class-wpml-tm-rest-job-progress.php on line 41

September 5, 2023 at 10:06 am #14342883

Long Nguyen
Supporter

Languages: English (English )

Timezone: Asia/Ho_Chi_Minh (GMT+07:00)

Hi,

It looks like a database corruption. I would like to request temporary access (wp-admin and FTP) to your site to take a better look at the issue. It would be better to have a testing site where the issue is replicated. Your next reply is set to private to share the info.

❌ IMPORTANT: Please backup your database and website before proceeding ❌
You can use this plugin to create the backup: https://wordpress.org/plugins/duplicator/
✙ I would need your permission to de-activate and re-activate Plugins and the Theme to change configurations on the site if needed. This is also a reason the backup is critical.

Look forward to your reply.
Thanks

September 6, 2023 at 3:20 am #14348221

Long Nguyen
Supporter

Languages: English (English )

Timezone: Asia/Ho_Chi_Minh (GMT+07:00)

Hi,

I've fixed that issue on your site. Now you can access the Translations queue/Jobs page.

Look forward to your reply.
Thanks

September 6, 2023 at 3:17 pm #14353665

andreiM-21

Ty for the support Long, you did a good job. Appreciate it!

I wish you all the best!