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: Performance, String Translation
Related documentation:
This topic contains 7 replies, has 2 voices.
Last updated by Bigul 3 years, 10 months ago.
Assigned support staff: Bigul.
Author | Posts |
---|---|
March 30, 2017 at 1:24 pm #1243439 | |
davidG-36 |
Hello, I have more than 12 000 unused/waiting for translations strings. |
March 31, 2017 at 11:26 am #1244255 | |
Bigul Supporter
Languages: English (English ) Timezone: Asia/Kolkata (GMT+05:30) |
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. -- Bigul |
March 31, 2017 at 12:43 pm #1244338 | |
davidG-36 |
I want to delete all 'Translate need' and 'Waiting for translation' strings. I have more than 12000 strings, so I can't delete them 100 by 100. So I thought maybe there is a better way to do this in DB? |
March 31, 2017 at 4:01 pm #1244576 | |
Bigul Supporter
Languages: English (English ) Timezone: Asia/Kolkata (GMT+05:30) |
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) 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 -- Bigul |
March 31, 2017 at 4:15 pm #1244595 | |
davidG-36 |
Thanks Bigul, I will do it and let you know. But are you sure, I will not lost all or part of translated links? |
April 3, 2017 at 6:01 am #1245326 | |
Bigul Supporter
Languages: English (English ) Timezone: Asia/Kolkata (GMT+05:30) |
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. -- Bigul |
April 11, 2017 at 1:33 pm #1252124 | |
davidG-36 |
It doesn't work. It still shows 11,339 translate need strings on string translation page. |
April 12, 2017 at 9:30 am #1252791 | |
Bigul Supporter
Languages: English (English ) Timezone: Asia/Kolkata (GMT+05:30) |
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 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 Also, please unselect the string domains from WPML>>String Translation>>Auto register for translation to avoid the auto-registering of strings for translation. -- Bigul |
The topic ‘[Closed] How to find & delete waiting for translations strings’ is closed to new replies.