Deleting pending comments on wp blog - GoFuckYourself.com

beks001 · 07-28-2012, 12:40 PM

Is there an easier way to delete all my pending comments besides in the wp admin area? I have like 2k comments pending. Need to wipe em out faster than 20 at a time.

fris · 07-28-2012, 12:42 PM

Code:

DELETE FROM wp_comments WHERE comment_approved=0

via mysql command

SuziQT · 07-28-2012, 02:23 PM

Also, if you are not comfortable with fris's solution, you can change the amount of comments that appear under "Screen Options". The default is 20 but I have mine set to 100.

papill0n · 07-28-2012, 02:27 PM

or you can just use the 'delete pending comments' plugin
http://wordpress.org/extend/plugins/...ding-comments/

fris · 07-28-2012, 02:27 PM

also a plugin exists do delete them all

http://wordpress.org/extend/plugins/...omment-remove/

Colmike9 · 07-28-2012, 02:28 PM

Either use Akismet's 'delete all' button if you use that, setting the max in screen options or this in phpMyAdmin but always back up your database before doing it:

DELETE FROM wp_comments WHERE comment_approved = 0

Note: If your comments table is prefixed with wp_something will need to use the correct table name.

Colmike9 · 07-28-2012, 02:28 PM

Quote:

Originally Posted by fris

also a plugin exists do delete them all

http://wordpress.org/extend/plugins/...omment-remove/

That too

beks001 · 07-29-2012, 08:20 AM

Quote:

Originally Posted by fris

Code:

delete from wp_comments where comment_approved=0

via mysql command

Quote:

Originally Posted by suziqt

also, if you are not comfortable with fris's solution, you can change the amount of comments that appear under "screen options". The default is 20 but i have mine set to 100.

Quote:

Originally Posted by papill0n

or you can just use the 'delete pending comments' plugin
http://wordpress.org/extend/plugins/...ding-comments/

Quote:

Originally Posted by colmike7

either use akismet's 'delete all' button if you use that, setting the max in screen options or this in phpmyadmin but always back up your database before doing it:

Delete from wp_comments where comment_approved = 0

note: If your comments table is prefixed with wp_something will need to use the correct table name.

thank you all!

07-28-2012, 12:40 PM	#1
beks001 Confirmed User Join Date: Oct 2006 Posts: 1,837	Deleting pending comments on wp blog Is there an easier way to delete all my pending comments besides in the wp admin area? I have like 2k comments pending. Need to wipe em out faster than 20 at a time. __________________ [B]341 people reviewed this!?!?! Blogging Thread! Teen Cams Gay Webcam Best Free File Storage

07-28-2012, 12:42 PM	#2
fris Too lazy to set a custom title Industry Role: Join Date: Aug 2002 Posts: 55,372	Code: DELETE FROM wp_comments WHERE comment_approved=0 via mysql command __________________ Since 1999: 69 Adult Industry awards for Best Hosting Company and professional excellence. WP Stuff

07-28-2012, 02:27 PM	#5
fris Too lazy to set a custom title Industry Role: Join Date: Aug 2002 Posts: 55,372	also a plugin exists do delete them all http://wordpress.org/extend/plugins/...omment-remove/ __________________ Since 1999: 69 Adult Industry awards for Best Hosting Company and professional excellence. WP Stuff

07-28-2012, 02:28 PM	#6
Colmike9 (>^_^)b Industry Role: Join Date: Dec 2011 Posts: 7,224	Either use Akismet's 'delete all' button if you use that, setting the max in screen options or this in phpMyAdmin but always back up your database before doing it: DELETE FROM wp_comments WHERE comment_approved = 0 Note: If your comments table is prefixed with wp_something will need to use the correct table name. __________________ Join the BEST cam affiliate program on the internet! I've referred over $1.7mil in spending this past year, you should join in. I make a lot more money in the medical field in a lab now, fuck you guys. Don't ask me to come back, but do join Chaturbate in my sig, it still makes bank without me touching shit for years..

07-28-2012, 02:23 PM	#3
SuziQT Confirmed User Join Date: Nov 2003 Location: here Posts: 167	Also, if you are not comfortable with fris's solution, you can change the amount of comments that appear under "Screen Options". The default is 20 but I have mine set to 100.

07-28-2012, 02:27 PM	#4
papill0n Unregistered Abuser Industry Role: Join Date: Oct 2007 Posts: 15,547	or you can just use the 'delete pending comments' plugin http://wordpress.org/extend/plugins/...ding-comments/