How to remove plugin meta key with sql query

  • Resolved nokian95

    (@nokian95)


    3 years, 5 months ago

    hi thanks for the great plugin you’ve made. unfortunately it increased my database site with lot of entry record
    tried to remove meta key manually via phpmyadmin but there are thousands of them and i couldnt even delete them all putting table show to 500 over 20 hours clicks
    kindly give me sql query command how to delete all kksr meta key record
    thank you

Viewing 1 replies (of 1 total)
  • Plugin Contributor Kamal Khan

    (@bhittani)

    All the post meta keys are prefixed with ‘_kksr_’.

    For a quick fix, in your theme’s functions.php file, paste the code below and load your website once. After that, remove the below code.

    
$ids = get_posts([
  'fields' => 'ID',
  'posts_per_page' => -1,
  'post_type' => 'any',
]);

foreach ($ids as $id) {
  delete_post_meta($id, '_kksr_avg');
  delete_post_meta($id, '_kksr_casts');
  delete_post_meta($id, '_kksr_ratings');
  delete_post_meta($id, '_kksr_ref');
  delete_post_meta($id, '_kksr_status');
  delete_post_meta($id, '_kksr_avg_default');
  delete_post_meta($id, '_kksr_count_default');
  delete_post_meta($id, '_kksr_ratings_default');
  delete_post_meta($id, '_kksr_fingerprint_default');
  delete_post_meta($id, '_kksr_status_default');
}
Viewing 1 replies (of 1 total)
  • The topic ‘How to remove plugin meta key with sql query’ is closed to new replies.

Tags