Urgent Bug Report - Critical Error in Automatic Translation for WPML

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.

Tagged: WCML

This topic contains 42 replies, has 2 voices.

Last updated by Alejandro 1 year, 6 months ago.

Assisted by: Alejandro.

Author	Posts
November 24, 2023 at 9:59 am #14915155
erikL-24	That's fine!
November 24, 2023 at 1:29 pm #14917723
Alejandro WPML Supporter since 02/2018 Languages: English (English ) Spanish (Español ) Italian (Italiano ) Timezone: Europe/Rome (GMT+02:00)	Please check this video: hidden link It's long because i recorded the entire session. The problem is not there with this product either and as i thought, the issue in the front-end was cache-related (Server-side cache). The next steps would be: - Take a backup of your site - Update the plugin to the latest version (WooCommerce Multilingual 5.3.0) - Run the troubleshooting options from WooCommerce > WooCommerce Multilingual > Settings > Troubleshooting - Translate the same reference product translated on the video as you requested - Check it out in the back-end: is it ok in both languages? was it ok before the translation? did something change? - if everything was ok, make another backup - Translate only the variable products first and check them out - Flush the server cache if needed - Take another backup - Translate the rest Try it out and let me know how it goes.
November 24, 2023 at 3:41 pm #14919041
erikL-24	I want to start right away with your advice, but... We are currently experiencing significant issues with our database for kaderspecialist. It appears our database has been overwhelmed due to an exceedingly high number of queries being executed from WPML. The issue has reached a point where our database is virtually grinding to a halt, severely impacting our website's performance and accessibility. The support team at Cloudways has identified the source of these queries as WPML. However, even upon terminating these queries, they are immediately repopulated, causing our database to crash again. This recurring problem is preventing us from addressing the issue effectively and restoring our website to its optimal functionality. Given the urgency of this matter, particularly as today is Black Friday, one of the busiest shopping days of the year, it is imperative that we resolve this issue promptly. Our inability to have our website functioning correctly is causing a considerable disruption to our customers who are unable to access our site. Could you please advise on any possible solutions or steps that we can take to rectify this situation? We are keen to implement any recommendations that could help reduce the volume of WPML queries, stabilize our database, and ultimately improve the overall performance of our website.
November 24, 2023 at 3:44 pm #14919107
erikL-24	From the chat transcript: Also I can see this plugin repeatedly in slow logs: sitepress-multilingual-cms I see, That is why server is under huge load as these are the queries running me: There is no way to terminate it? Actually once I terminate it will be regenerate From application
November 24, 2023 at 4:03 pm #14919299
Alejandro WPML Supporter since 02/2018 Languages: English (English ) Spanish (Español ) Italian (Italiano ) Timezone: Europe/Rome (GMT+02:00)	Can you please allow me access to that site so i can check why is this happening? the last credentials i had were changed and i can't access with them anymore. if you have any cache on the server site, specially the REDIS cache (Which is very particular), please disable it and check if the queries stop because it could be that the site was cached and WPML is "stuck" sending queries because it never receives answers from the server (since the queries are all cached). Regards.
November 24, 2023 at 4:05 pm #14919309
erikL-24	I can't because i can't access wp admin but they should be the same as the staging environment. In the meanwhile I will look @ redis.
November 24, 2023 at 4:07 pm #14919319
erikL-24	I have disabled Redis now and will reboot the server.
November 24, 2023 at 4:10 pm #14919409
erikL-24	Server is rebooted. Varnish is still on. I will disable it as well
November 24, 2023 at 4:35 pm #14919777
Alejandro WPML Supporter since 02/2018 Languages: English (English ) Spanish (Español ) Italian (Italiano ) Timezone: Europe/Rome (GMT+02:00)	I'm not sure why cloudways support mentioned us because the issue you have is with the object cache, as i thought: hidden link you can see it yourself from the debug.log file found on your wp-content directory. it seems something in blocksy triggered a redis action, it failed but tried to reset and failed again and again creating an infinte loop. Redis is a very powerful but very advanced tool that needs to be configured based on the site and not on some generic configuration so, since you're on cloudflare, i suggest you disable redis and enable instead varnish which is more "automatic" on its configuration. However, there's nothing that WPML is doing here, the problem is not being created by query requests from WPML and maybe WPML is indeed stuck requesting calls because the cache keeps telling it to do so. The solution here? disable redis altogether, at least for now.
November 24, 2023 at 4:40 pm #14919791
erikL-24	It's back working after i removed an unused plugin (MailPoet). I am done with it for now and going to enjoy the weekend. But I'll be back at it on Monday, armed with all your fantastic advice about the productvariatons. I really want to say a big THANK YOU for all the extra effort you've put in. It's really given me a boost, and I'm raring to get stuck in again come Monday. I'll keep you posted with updates as I tick off those tasks. Once again, thanks a million and have an absolutely awesome weekend!
November 24, 2023 at 5:00 pm #14919885
Alejandro WPML Supporter since 02/2018 Languages: English (English ) Spanish (Español ) Italian (Italiano ) Timezone: Europe/Rome (GMT+02:00)	Please read my last anwer because the issue is not with mailpoet, it might've been one plugin that was stuck on a loop or something because of the cache but the issue is with your object cache config.
November 27, 2023 at 10:38 am #14928819
erikL-24	Hi Alejandro, I hope your weekend was great. I used this weekend to get the translationwork done and I succeeded! Your advise really helped me. There is only one issue remaining: not all products have the images in the translated products. For example: hidden link Is there a way to get this done in bulk?
November 27, 2023 at 12:31 pm #14929761
Alejandro WPML Supporter since 02/2018 Languages: English (English ) Spanish (Español ) Italian (Italiano ) Timezone: Europe/Rome (GMT+02:00)	Yes, there should be. Go to WPML > Settings > Media Translation and click both buttons "apply" and "start" so it applies this to new and old content alike. that should do it. If it still doesn't work, try to resend the page to translate and i should apply it. What you're doing with the process i mentioned is setting the "media attachment" option found on every page (screenshot attached), selected by default which is likely the reason why you are missing images in some places. Regards.