Problem: The client reported issues with WPML on their WordPress site hosted on Kinsta, including a disconnected license and error messages indicating a 'Division by zero' in the WPML code. Additionally, the 'jobs' page within WordPress was not loading translation jobs correctly, displaying messages that jobs could not be loaded or that the Advanced Editor jobs synchronization had failed.
Solution: We resolved the issue by running SQL queries to update the status of translation jobs in the 'icl_translation_status' table. First, we changed the status of jobs that were 'In Progress' (status 2) to 'Needs Update' (status 1) with the following query:
UPDATE `{wpdbPrefix}_icl_translation_status` SET `status` = 1 WHERE `status` = 2
Then, we set all remaining ongoing jobs to 'Finished' (status 10) using these queries:
UPDATE `{wpdbPrefix}_icl_translation_status` SET `status` = 10 WHERE `status` = 1;
UPDATE `{wpdbPrefix}_icl_translation_status` SET `status` = 10 WHERE `status` = 9;
After applying these fixes, we advised the client to go to WPML > Translation Management and resend any pages they wish to translate.
Please note that this solution might be irrelevant if it's outdated or not applicable to your case. If you're still experiencing issues, we highly recommend checking the related 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 persists, please open a new support ticket with us.
Problem: The client updated a number in a sentence on the original page and expected to see only one segment needing adjustment in the WPML Advanced Editor. Instead, they found that the translation of half the translated segments on the page disappeared. Solution: We suggested that the issue might be related to how the original content was created. If the text was part of the same Block in the Block Editor or the same widget of a page builder, the observed behavior would be expected. To prevent this from happening, we recommend not placing all the text in one block or text widget. Instead, create one block or widget for each paragraph.
