Skip Navigation

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

Problem: I have some issues with "translate everything" mode because my site has over 4000 jobs to translate.

Solution: The resources on your site are important here. however all you need is time and it depends on your server resources. if you see that the number of translations is not decreasing even after 1h, please flush your server-side cache and try again. if the problem remains, then feel free to open a support ticket.

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.

This topic contains 42 replies, has 2 voices.

Last updated by Alejandro 1 year, 5 months ago.

Assisted by: Alejandro.

Author Posts
November 13, 2023 at 10:21 pm #14792673

erikL-24

Dear WPML Support Team,

I hope this message finds you well. I am writing to report a critical issue I am facing while attempting to translate the remaining non-automatically translated items on my website, specifically WooCommerce products.

I have been encountering significant challenges and frustrations in this process, compounded by the fact that the automatic translation of the site has been running for over 5 days without completion. This has resulted in a considerable loss of time and budget in my efforts to resolve this matter.

When attempting to enable automatic translations for the remaining non-translated items, particularly WooCommerce products, I encounter a critical error. Despite my efforts to ensure that the server/app settings meet the required values, as indicated in the documentation, the problem persists.

I have verified that all indicators in the Plugin support area show green, and I have carefully reviewed server/app settings, but the issue persists. Additionally, I came across a suggestion to change records with status 2 in the 'wp_icl_translation_status' table, but upon investigation, I couldn't find any records with status 2.

At this point, I am unsure about the next steps and how to proceed to resolve this issue. The frustration is escalating, and I am reaching out to your support team with the hope that you can urgently investigate and provide guidance on resolving this matter.

I appreciate your prompt attention to this critical issue and would be grateful for any assistance you can provide to expedite the resolution. I understand that your support is crucial in ensuring a smooth experience with WPML, and I look forward to your guidance on resolving this matter as soon as possible.

Thank you for your time and assistance.

November 15, 2023 at 8:37 am #14805515

erikL-24

I wanted to provide an update regarding the slow response time we've been experiencing with the WPML translations on our live website.

Due to the ongoing performance issues, I have taken the initiative to migrate all translated content managed by WPML to a staging area. Details can be shared.

November 15, 2023 at 11:09 am #14807389

Alejandro
WPML Supporter since 02/2018

Languages: English (English ) Spanish (Español ) Italian (Italiano )

Timezone: Europe/Rome (GMT+02:00)

Hello!

Before i can access, i would need to know what type of critical error you're getting.

Please enable the debug.log: https://wpml.org/documentation/support/debugging-wpml/
then try to recreate the error and check if a file "debug.log" was created in the wp-content directory of your site.

If that's the case, please share that file with me (you can upload it in any platform of your preference like wetransfer or gdrive and then share it with me so i can download it).

--------------------

Since the problem is with WooCommerce, could it be it happens only when you select products with variations? because we discovered an issue recently that you can check here: https://wpml.org/errata/woocommerce-multilingual-multicurrency-504-gateway-time-out-error-when-updating-variations/

it's not exactly the same as your description but you can check if it's the case and let me know.

November 15, 2023 at 2:42 pm #14810161

erikL-24

Hi,

Thanks for your reply.

The problem is the automatic translations are getting stuck each and every time. I have tried the fix from the other thread and it did succeed me to continue the import for a couple of items. Now it is stuck again.

I have added all error logs I have in this folder:
hidden link

Please let me know if you need any other information.

November 15, 2023 at 5:37 pm #14819505

Alejandro
WPML Supporter since 02/2018

Languages: English (English ) Spanish (Español ) Italian (Italiano )

Timezone: Europe/Rome (GMT+02:00)

The logs you sent me are the server logs, those are different types of files. please read my last message, go to the link i sent you and follow the instructions to enable the debug.log, the log from WordPress.

You mention that the translations are "stuck" but then you talk about an Import and another thread but i don't see any other past threads from you.

Please do not touch anything in the database unless we specifically tell you to because what can be ok for one specific site might not be ok for another.

from what i can see the latest jobs for hidden link (this link is masked and can't be seen apart from us) were sent on oct 31st and they were then cancelled. there aren't recent jobs here, so i'd like to maybe have access to your site (and FTP if the error crashes the site) and have a reference page you want to translate so i can better investigate what's going on.

If you accept, then please write the steps you follow on your next answer so i can understan better what you're doing and how and try to recreate the problem.

Regards,

November 16, 2023 at 11:16 am #14824865

Alejandro
WPML Supporter since 02/2018

Languages: English (English ) Spanish (Español ) Italian (Italiano )

Timezone: Europe/Rome (GMT+02:00)

I checked your site and tried to look for possible issues with the configuration or similar and everything was ok apart from some configuration issues, specifically with ACF where the ield groups weren't configured at all, and at this point i ask you to check this guide and configure the field groups and retranslate the content so they are applied to the translations as well:
https://wpml.org/documentation/related-projects/translate-sites-built-with-acf/

I recorded myself with everything i saw because apart from the ACF issue i didn't encounter anything cumbersome, difficult or critical errors: hidden link

I wonder if i did something different from what you did or if i missed something. can you watch the video and let me know?

I'll wait for your feedback so i can understand what to do next.

November 16, 2023 at 12:26 pm #14826385

erikL-24

Firstly, thank you for your detailed response. You even organized the video into chapters. Wow! :-).

Let me first answer your questions:
Is the website from a different CMS?
Yes, the website has been migrated from Magento to WooCommerce. This project was outsourced and set up both the Dutch and French languages. We've already deleted all product data once and performed a completely new import, removing all Dutch and French content in the process. In essence, you can infer that the migration was necessary at that time but is now entirely redundant in terms of data.

Why Locotranslate?
We installed it before the entire WPML project began to translate theme/plugin strings into Dutch. I'll create a task to transfer everything fully to WPML so we can remove Loco Translate.

ACF settings?
I've now set all ACF field groups to the first option.

"No more automatic translation is running."
Correct. I'm a bit lost. Initially, I activated the "Translate everything automatically" version. After completing several thousand tasks, it kept freezing. I consulted your support forums and switched the translation module to "self-manage" to remove ongoing tasks. Sometimes it worked well, other times it got stuck again. I also noticed that the translator claimed to have translated almost all products into French and German. However, it's at 97% for French and around 20% for German. I wonder what went wrong there.

I've now re-enabled the module for "Translate everything automatically," hoping that the plugin will pick up the remaining products for French and German as well.

My questions for now:
It's currently filling the queue with around 3k translations. I get the impression that the translations aren't being executed yet. Is it correct that the queue needs to be filled first before the translations are carried out and the products are marked as translated? I'll monitor it for now.

Any idea why the slugs of these translated products at the product level are still in Dutch?
hidden link
hidden link
Is it possible to fix this quickly in bulk?

Any idea why the product variations aren't visible for the translated products? In the backend, I see some options with a padlock icon:
hidden link

Please let me know if you have any insights or solutions. Thanks!

November 16, 2023 at 2:14 pm #14827741

Alejandro
WPML Supporter since 02/2018

Languages: English (English ) Spanish (Español ) Italian (Italiano )

Timezone: Europe/Rome (GMT+02:00)

you mention

"After completing several thousand tasks, it kept freezing"

When checking for possible issues there were some jobs that couldn't be correctly translated (this happened more or less at the end of october) could this timeline fit the time when you used translate everything and had the issue? because if it was stuck it was because of lack of credits but i'm not sure at this point why the system didn't tell you, it should've displayed a "something went wrong" notice in the translation management dashboard and then invite you to get more credits.

Is it correct that the queue needs to be filled first before the translations are carried out and the products are marked as translated?

that's correct, the system will first check all the different pages that need to be translated and then start executing the translations in batch. since there are 3k jobs as you mention, this could take a while, plus i'd suggest you clear your cache or disable it while you run this procedure, because it seems to interfere sometimes. when i tested it, it was just a visual issue but it's usually better to disable all caching mechanisms while you work on your site.

I just checked the site and it's correctly running, it was initially in 3145 i believe and it was already translating and it's currently in 3128.

If you have cache on your server, please disable it for the time being because with a queue this big, chances are at one point they won't be uploaded correctly because of it.

November 16, 2023 at 2:16 pm #14827751

Alejandro
WPML Supporter since 02/2018

Languages: English (English ) Spanish (Español ) Italian (Italiano )

Timezone: Europe/Rome (GMT+02:00)

by the way, let's wait first for the translations to finish before jumping into other issues (we can only handle one issue per ticket), i'll keep them in mind and help you with them when the time comes as to not pollute and complicate this ticket.

Regards.

November 17, 2023 at 8:22 am #14832365

erikL-24

Good morning Alejandro,

Once again, thank you for your helpful response. I ran the plugin last night, and it seems to have made significant progress. However, since 08:51, it appears to be stuck, and I've noticed that there are still quite a few products missing for the French and German languages. Could you please take a look at the situation? Thank you in advance.

November 17, 2023 at 10:19 am #14836597

Alejandro
WPML Supporter since 02/2018

Languages: English (English ) Spanish (Español ) Italian (Italiano )

Timezone: Europe/Rome (GMT+02:00)

there is indeed something weird on your site, but it seems to be a result of a server-side cache.

do you happen to have some cache enabled on your server? if you do, can you brefly deactivate it and let me know?

At the same time, and i believe this is a problem related to the products, i can see this error:

Call to a member function is_in_stock() on null /home/778854.cloudwaysapps.com/zbdaxqavte/public_html/wp-content/themes/blocksy-child/inc/custom-functions.php:9

This means there's a "custom function" on your child theme that is breaking the process. please verify what that is and then try to sent those products again, try with just a few products first and then, if they work, send them all.

i checked the code and it seems it's this one:

the code seems to be a shortcode you created:

add_shortcode('display_stock_message', function($atts) {
	global $product;
    if ( $product->is_in_stock() ) {
        $text = '<div class="stock in-stock" ><i class="fa-solid fa-circle"></i>' . __( ' Op voorraad', 'blocksy' ) . '</div>';
    } else {
        $text = '<div class="stock out-of-stock" ><i class="fa-solid fa-circle"></i>' . __( 'Niet op voorraad', 'blocksy' ) . '</div>';
    }
	return $text;
});

Custom code is out of the scope of this support so i can't debug that for you but i guess that the global product function is returning something that is not what you expect.

since this is a shortcode, there are things you should do to first verify if WooCommerce is enabled and that you're actually looking at a product before you run everything else.

I suppose that if you fix this, you'll be able to have everything else working smoothly.

Regards.

November 17, 2023 at 11:04 am #14861219

erikL-24

Hi,

I have disabled Varnish Cache. No other server-side cache is active.

I have also removed the custom code you've mentioned.

November 17, 2023 at 11:23 am #14861391

erikL-24

Now all my default language product variations are gone?!

November 17, 2023 at 12:41 pm #14862659

erikL-24

I find myself completely lost in the current state of affairs. Since the recent changes, there are no longer any pending tasks in the queue for automatic translations. However, I've encountered a significant issue - all products with variations no longer display those variations. Additionally, under "Tasks -> In Need of Translation," there's a list of hundreds of products. What should I do with this list?

Regrettably, this situation has impacted our online store, as visitors in the default language can no longer place orders for essential products, leading to potential revenue loss. I sincerely hope that you can swiftly guide me through resolving these issues so that customers can resume their orders.

For the next 60 minutes, I'll refrain from making any changes in the hope of a prompt and concrete response. If not, I may attempt to revert the Dutch default products to a backup, which is something I would prefer to avoid.

Your urgent assistance is highly appreciated.

Thank you for your attention to this matter.

November 17, 2023 at 2:39 pm #14863745

erikL-24

Still haven't touched anything. Example of product missing variations: hidden link