I've got 3 translations that take a lot of time.

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

Problem:
You are experiencing unusually long delays when translating pages using WPML. The translations appear to be stuck and do not complete as expected.
Solution:
We discovered an issue related to the CMS Masters Importer plugin that was causing the translation process to stall. Here are the steps we recommend:
1. Disable the CMS Masters Importer plugin.
2. Test the translation process again to see if the issue is resolved.
If disabling the plugin resolves the problem, you may continue using WPML without this plugin or seek an alternative solution. If the issue persists or if you need further assistance, we recommend visiting the WPML support forum. Additionally, it's a good practice to check for related known issues, verify the version of the permanent fix, and confirm that you have installed the latest versions of themes and plugins.

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: Compatibility

This topic contains 14 replies, has 2 voices.

Last updated by alexandreD-58 4 months, 3 weeks ago.

Assisted by: Andreas W..

Author	Posts
February 4, 2025 at 5:20 pm #16668056
alexandreD-58	I just did so. WP phpMyAdmin is now activated. I have unchecked "Restrict access only to current IP".
February 4, 2025 at 10:59 pm #16668702
Andreas W. WPML Supporter since 12/2018 Languages: English (English ) Spanish (Español ) German (Deutsch ) Timezone: America/Lima (GMT-05:00)	Unfortunately, that doesn't work, I keep getting the 403 Forbidden error. Please make a backup of your database. Then go to the wp_icl_translation_status table. We might try checking for in-progress or failed jobs and delete them from the table. Please try deleting all entries with the status value "9". If this will not solve the issue, please let me know.
February 5, 2025 at 1:46 am #16668817
alexandreD-58	Oh. Hum. Sorry about that. I will try to do what you say tomorrow and keep you posted. Thanks a lot!
February 5, 2025 at 6:00 pm #16672609
Andreas W. WPML Supporter since 12/2018 Languages: English (English ) Spanish (Español ) German (Deutsch ) Timezone: America/Lima (GMT-05:00)	Would you mind testing if the WPML 4.7 Beta version can solve this issue? You can find the update at Plugins > Add new > Commercial while switching to the "Beta" channel. If this install fails, you can download the latest versions here: WPML: https://wpml.org/download/wpml-multilingual-cms/?section=changelog String Translation: https://wpml.org/download/wpml-string-translation/?section=changelog WCML: https://wpml.org/download/woocommerce-multilingual-multicurrency/?section=changelog WPML SEO: https://wpml.org/download/yoast-seo-multilingual/?section=changelog WPML ACF Multilingual: https://wpml.org/download/acfml/?section=changelog If these updates will not solve the issue, please let me know.
February 5, 2025 at 10:14 pm #16673120
alexandreD-58	Upgrading to 4.7 didn't seem to solve the issue. I'm testing the database cleaning instead.
February 5, 2025 at 10:44 pm #16673140
alexandreD-58	Ok so I did clear the lines with a status of 9 in the wp_icl_translation_status table but the translations are still not completing (and they are still visible).
February 5, 2025 at 10:50 pm #16673173
Andreas W. WPML Supporter since 12/2018 Languages: English (English ) Spanish (Español ) German (Deutsch ) Timezone: America/Lima (GMT-05:00)	Thank you for the confirmation! I will try now to create a copy of our site for debugging and then get back to you.
February 6, 2025 at 12:15 am #16673337
Andreas W. WPML Supporter since 12/2018 Languages: English (English ) Spanish (Español ) German (Deutsch ) Timezone: America/Lima (GMT-05:00)	When trying to migrate a copy of your site onto a local virtual server I receive the following error: DB INSTALL ERROR: DB install chunk process integrity check has been just failed. I would need to take a closer look at the DB of your live site to investigate. As GoDaddy does not allow access by plugin and I am not able to access your hosting platform due to 2FA validation, I would suggest for now, that you please contact GoDaddy, and ask them to revise/adjust/repair your database. Also, you could send me a SQL dump file of your database and I will take a look into it. I have enabled the private reply form including a special field for such dump files. Please take note: While migrating the site I was informed by Duplicator that the current database is using the collation utf8mb3 on some tables. This can cause unexpected issues, as this type of collation is outdated and does not support Asian characters. You can change the collation for such tables from utf8mb3 to utf8mb4 which is the new standard.
February 6, 2025 at 7:07 pm #16676954
Andreas W. WPML Supporter since 12/2018 Languages: English (English ) Spanish (Español ) German (Deutsch ) Timezone: America/Lima (GMT-05:00)	Something seems not to be right with the database, otherwise I should have been able to create a local copy of the site without getting any DB errors. I will try again to create a local copy using the received dump file and then get back to you.
February 6, 2025 at 7:29 pm #16677000
alexandreD-58	Ok I will ask them about the DB.
February 6, 2025 at 7:47 pm #16677028
Andreas W. WPML Supporter since 12/2018 Languages: English (English ) Spanish (Español ) German (Deutsch ) Timezone: America/Lima (GMT-05:00)	Trying to import the dump file into a new WordPress Install I get the same error: Fehler in der SQL-Abfrage (1064): Syntax error near 'PK' at line 1 --- After reviewing the site again I see the following error on the ATE Error Log: count(): Argument #1 ($value) must be of type Countable\|array, string given /var/www/wp-content/plugins/cmsmasters-importer/inc/cmsmasters-theme-importer.php:127 This error points to the CMS Masters Importer plugin and I have disabled this plugin now. This seems to have solved the issue. Please test for yourself now. If you would like us to investigate this issue further I can offer to provide a test site including WPML on which you can install theme and its plugin in their latest available version.
February 6, 2025 at 9:07 pm #16677354
alexandreD-58	Oh wow, it works indeed! According to my theme's documentation this specific plugin isn't critical for running the website so I think I will leave it at that for now. But I will definitely reach to Godaddy regarding the DB issues. I also will try to fix the other things you mentionned. In all cases, thank you very much for your help! Much appreciated.
February 6, 2025 at 9:08 pm #16677357
alexandreD-58	Very good service, quick and efficient as always. Thanks!