WordPress - Clear Unapproved Comments

To make it easier to get in touch with us, from the 24th of March 2016 all support tickets will need to be submitted from your Crucial Control Panel.

How to Clear Unnaproved WordPress Comments From The Database

Step 1 - Log in to cPanel (click here for a guide) and click on phpMyAdmin

d78eed727e4570bc3f777003ad1776395e837fb5?t=7b13ad93398d875195ea78fca5e1272c

 

Step 2 - Click on the Database you want to clear comments from (if you have multiple databases, you'll need to find the name of the correct one. Click here for a guide on doing that)

3e02b7ee6c938e2291e099910f04b887c3c60893?t=b7eb3fd5d0234e155e881581c58d79c4

 

Step 3 - Click on the SQL tab

 

Step 4 - Take note of the name of the comments table

 

Step 5 - Add in the bellow code. Make sure to replace wpov_comments with the name of your comments table. Click Go to start the clean up.

DELETE FROM wpov_comments WHERE comment_approved = 0

 

Click OK to confirm the action

 

Once it's done, you'll see a screen that looks like this. For larger databases, you may need to wait a few minutes before this completes.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk