Failed approving translations in bulk

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 is split from https://wpml.org/forums/topic/acf-options-pages-not-translating-2/

Sun	Mon	Tue	Wed	Thu	Fri	Sat
-	9:00 – 13:00	9:00 – 13:00	9:00 – 13:00	9:00 – 13:00	9:00 – 13:00	-
-	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	-

Supporter timezone: America/Los_Angeles (GMT-07:00)

Tagged: Documentation request

This topic contains 7 replies, has 2 voices.

Last updated by Bobby 1 year ago.

Assisted by: Bobby.

Author	Posts
October 23, 2024 at 12:37 pm #16321847
tom@hive.agency	I started auto-translating I set items to publish but to mark for review - but now I have over 100 items for review and it won't allow me to bulk approve them. I get the same error as here: https://wpml.org/forums/topic/failed-approving-translations-for-the-following-posts-2/ I can individually review and accept, but I need to bulk accept them. I've set all future translations to publish without review so I really just need to clear all 'Pending review' from the translations queue.
October 24, 2024 at 7:12 pm #16328086
Bobby WPML Supporter since 04/2015 Languages: English (English ) Timezone: America/Los_Angeles (GMT-07:00)	Hi there, When you are attempting to bulk approve, instead of grabbing all of them at once please try doing them in batches. Start with batches of 10 and increase. Also, before trying again I highly advise increasing the WP Memory Limit from 40M to 256M or higher. https://wpml.org/faq/checklist-before-opening-a-ticket-in-wpml-support/#how-can-i-increase-my-sites-memory-limit Along with the PHP time limit from 60 to 90. These two changes should help. Let me know your results, please.
October 27, 2024 at 12:16 pm #16334571
tom@hive.agency	Our memory limit is currently set at 512MB, PHP limit has been increased from 60 to 90. We're on a premium 4GB/2CPU VPS with Cloudways so I'm confident this isn't resource related. We get the same error from ticking 10 or even just 1 item and trying to 'Approve translation reviews'. I've tried random items from the list to make sure it's not just the first in the list that have a problem. There are currently 120 that we need to bulk approve - these work if we click 'Review' next to each item and approve one by one.
October 28, 2024 at 8:44 pm #16339700
Bobby WPML Supporter since 04/2015 Languages: English (English ) Timezone: America/Los_Angeles (GMT-07:00)	Thank you for updating me! One by one is not ideal for that many jobs. I would like to request temporary access (wp-admin and FTP) to your site to test the issue. (preferably to a test site where the problem has been replicated if possible) Before we proceed It is necessary to take FULL BACKUP of your database and your website. Providing us with access, you agree that a backup has been taken I often use the Duplicator plugin for this purpose: http://wordpress.org/plugins/duplicator/ You will find the needed fields for this below the comment area when you log in to leave your next reply. The information you enter is private which means only you and I have access to it. NOTE: If access to the live site is not possible and the staging site does not exist please provide me with a duplicator package created with the duplicator plugin. Thank you, Bobby
October 29, 2024 at 8:04 pm #16344164
Bobby WPML Supporter since 04/2015 Languages: English (English ) Timezone: America/Los_Angeles (GMT-07:00)	Thank you for the access details! Unfortunately my tests have been unsuccessful so far. We have a known issue with the batch approval when using Rankmath, however, I can see you are using Yoast. https://wpml.org/errata/rank-math-seo-user-cannot-publish-product-translation-pending-to-be-reviewed/ Did your site every use the Rankmath plugin before? Maybe some settings are left in the database, I have seen this cause issues before and it required re-installing the problematic plugin and fully removing it properly.
October 30, 2024 at 9:04 am #16345478
tom@hive.agency	I'm afraid we've never used Rankmath, this is a new site in development and we've only used Yoast. We did have over 300 translations to review here so some bulk approvals are working, I believe we were able to bulk approve all of the main page & post translations, it's the little details like Field Groups that are stuck. Not sure if that helps diagnose the issue. If there is a way to manually approve/remove these in the database then that would work for us temporarily, we've decided to publish without reviewing so manually clearing this list would be fine for now.
October 31, 2024 at 6:56 am #16349694
Bobby WPML Supporter since 04/2015 Languages: English (English ) Timezone: America/Los_Angeles (GMT-07:00)	Thank you for updating me! I am not aware of a way to do this in the database, however, I am consulting with our team about this and will update you as soon as I have news.
November 1, 2024 at 5:53 pm #16355820
Bobby WPML Supporter since 04/2015 Languages: English (English ) Timezone: America/Los_Angeles (GMT-07:00)	Hello, I escalated this thread to our 2nd tier support and they will take a look at this issue. You will be notified as soon as new information is available. Thank you, Bobby
December 6, 2024 at 6:07 am #16484600
Bobby WPML Supporter since 04/2015 Languages: English (English ) Timezone: America/Los_Angeles (GMT-07:00)	Hi there, You can try using this SQL query which worked for our team to clear the stuck jobs pending review. DELETE FROM `wp_icl_translation_status` WHERE `review_status` = 'NEEDS_REVIEW'; NOTE: please make sure that the db prefix matches with the one for your database Unfortunately, there is no other way of approving those jobs as they keep giving the same warning of a job not found each time.

The topic ‘[Closed] Failed approving translations in bulk’ is closed to new replies.