On Internet there are many users complaining about Feedbacks of Contact form Plugin in JetPack Thrashing their database. Even I got almost over 11 Thousand Spams in Feedbacks, Deleting them one by one is a hassle and WordPress throws an Error when I try selecting around 100 feedbacks and deleting them, so I had to find another way to delete Feedbacks all together and it’s useless data.
The method by which we are going to delete feedback is directly from database by running Queries for Searching Feedbacks and deleting them. But before all of this make sure to backup your WordPress Database.
- Login into your SQL Manager (PHPmyAdmin)
- Select your WordPress Database
- Click on
SQL
- Run this Queries :
DELETE FROM wp_posts WHERE post_type='feedback'
DELETE FROM wp_postmeta WHERE 'meta_key' LIKE '%feedback%'
Note : According to Sam Small The above code might fail, so if it fails please remove the quote around meta_key
and try again. It usually happens due different versions of PHPMyAdmin software.
Now your Database is clear of feedbacks from JetPack, Now you know How to Delete Feedbacks from JetPack Contact Form
I have also made a video for this tutorial so you can understand it easily
Updated – 2 Feb 2014 : Added the Note suggested by Sam.