TEXT 28
WPML bulk delete database By micha on 5th August 2019 12:47:33 PM
  1. BACKUP FIRST !
  2.  
  3. WPML has the following defines:
  4.  
  5. define( 'ICL_STRING_TRANSLATION_PARTIAL', 2 );
  6. define( 'ICL_STRING_TRANSLATION_COMPLETE', 10 );
  7. define( 'ICL_STRING_TRANSLATION_NEEDS_UPDATE', 3 );
  8. define( 'ICL_STRING_TRANSLATION_NOT_TRANSLATED', 0 );
  9. define( 'ICL_STRING_TRANSLATION_WAITING_FOR_TRANSLATOR', 1 );
  10.  
  11.  
  12. SQL:
  13. DELETE FROM {wp-prefix}_icl_strings WHERE status IN (1, 2, 3, 10);
  14. DELETE FROM {wp-prefix}_icl_string_translations WHERE string_id NOT IN (select id from {wp-prefix}_icl_strings);
  15.  
  16. TRUNCATE {wp-prefix}_icl_string_packages;
  17. TRUNCATE {wp-prefix}_icl_string_positions;
  18.  
  19. Choose menu WPML > Support
  20. Click on Troubleshooting link
  21. *Recreate ST DB cache tables* button of Clean up to recreate the string translation DB cache tables

Paste is for source code and general debugging text.

Login or Register to edit, delete and keep track of your pastes and more.

Raw Paste

Login or Register to edit or fork this paste. It's free.