[Closed] How to find & delete waiting for translations strings

Hi ,

Thank you for contacting the WPML support. We are happy to help you.

Hope you are using the latest version of WPML(3.6.3) and WordPress(4.7.3). To help you faster, I've enabled debug information for this support ticket. Please see this link for how to get this information from your site and give it to us: http://wpml.org/faq/provide-debug-information-faster-support/

Please explain little more about the requirement. You can do a bulk delete of strings from WPML>>String Translation, after choosing a Strings domain. Please try it after a full site backup. Check the attached images for more details.

--
With Regards

Bigul

Hi ,

Please try the following steps after a full site backup(Which is mandatory because we are altering the database directly). For your updates, we are using the following definitions in our wp-config.php file to declare the status of strings. In your case, we will be using 1,3.

define( 'ICL_STRING_TRANSLATION_PARTIAL', 2 );
define( 'ICL_STRING_TRANSLATION_COMPLETE', 10 );
define( 'ICL_STRING_TRANSLATION_NEEDS_UPDATE', 3 );
define( 'ICL_STRING_TRANSLATION_NOT_TRANSLATED', 0 );
define( 'ICL_STRING_TRANSLATION_WAITING_FOR_TRANSLATOR', 1 );

(The code above goes in wp-config.php right after the database information)
1) Run the following queries one by one
a)

DELETE FROM wp_icl_strings WHERE status IN (3, 1);

b)

DELETE FROM wp_icl_string_translations WHERE string_id NOT IN (select id from wp_icl_strings);

c)

TRUNCATE wp_icl_string_packages;
TRUNCATE wp_icl_string_positions;

2) After that visit WPML>>Support page
3) Click on Troubleshooting link(blue link at the bottom of page)
4) Then click on *Recreate ST DB cache tables* button of Clean up to recreate the string translation DB cache tables

--
With Regards

Bigul

Hi,

This query will only delete the string that's status is *Translate need* or *Waiting for translation*. Therefore it will not effect the already translated strings.

Please try it in a staging/testing environment first or after a full site backup. Then let me know your feedback.

--
With Regards

Bigul

Hi,

Thank you for the updates. Please try the following steps after a full site backup and let me know your feedback.

1) Run the following queries one by one
a)

DELETE FROM wp_icl_strings WHERE status IN (3, 1, 0);

b)

DELETE FROM wp_icl_string_translations WHERE string_id NOT IN (select id from wp_icl_strings);

c)

TRUNCATE wp_icl_string_packages;
TRUNCATE wp_icl_string_positions;

2) After that visit WPML>>Support page
3) Click on Troubleshooting link(blue link at the bottom of page)
4) Then click on *Recreate ST DB cache tables* button of Clean up to recreate the string translation DB cache tables

Also, please unselect the string domains from WPML>>String Translation>>Auto register for translation to avoid the auto-registering of strings for translation.

--
With Regards

Bigul