[Resolved] Issues that jobs could not be loaded - found out why

Hi,

This likely indicates that a translation job has a total = 0, causing WPML to attempt a division by zero when calculating progress.

Can you run this SQL to confirm that WPML tables have proper auto-increment on ID fields?

SHOW CREATE TABLE wp_icl_translation_jobs;
SHOW CREATE TABLE wp_icl_translation_status;
SHOW CREATE TABLE wp_icl_translations;

etc.

Look for AUTO_INCREMENT on fields like job_id, id, etc.

Let us know what you find and we can assist further if needed.

Hello,

Thanks.

Let me summarize the issue to check if I got it properly:

The Translation Jobs screen crashes with “Jobs could not be loaded”.
Debug log shows PHP Fatal error – DivisionByZeroError in class‑wpml‑tm‑rest‑job‑progress.php:41.
Investigation reveals a post whose excerpt was empty; its translation status row caused WPML to divide by zero, and the missing wp_icl_translation_jobs table rows left the queue in an inconsistent state.

Is that correct? If not, can you please elaborate?

If my understanding of the issue is correct, please try the following:
• Backup the DB.
• In WPML → Support → Troubleshooting, run:
• “Synchronize local job IDs with ATE”
• “Synchronize translators and translation managers with ATE”
• In phpMyAdmin run:

UPDATE wp_icl_translation_status
SET status = 1
WHERE status = 2;

• Refresh WPML → Translation Management → Jobs.

If this does not work:
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 a testing site where the issue is replicated.

The information you will enter is private which means only you and I can see and have access to it.
Maybe I'll need to replicate your site locally. For this, I'll need to temporarily install a plugin called “Duplicator” or "All in One WP Migration" on your site.
This will allow me to create a copy of your site and your content.
Once the problem is resolved I will delete the local site.

**IMPORTANT**
- Please make a backup of site files and database before providing us access.
- If you do not see the wp-admin/FTP fields this means your post & website login details will be made PUBLIC. DO NOT post your website details unless you see the required wp-admin/FTP fields.

Best Regards,
Otto