|
|
|
|
||||
|
Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact us. |
 |
|
|||||||
| Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed. |
|
|
Thread Tools |
04-30-2012, 12:55 PM
|
#1 |
|
Confirmed User
Industry Role:
Join Date: Sep 2009
Location: Radelaide
Posts: 2,163
|
Best way to delete 150,000 wordpress comments?
Blog spam, totally didn't notice it on one of my main sites. How do I get rid of this shit?
|
|
|
|
04-30-2012, 01:03 PM
|
#2 |
|
Confirmed User
Join Date: Dec 2001
Location: SoCal
Posts: 1,651
|
Back your database up first in case something goes wrong. Go into phpadmin, then click the SQL icon and enter this command:
DELETE from wp_comments WHERE comment_approved = '0'; |
|
|
|
|
04-30-2012, 01:30 PM
|
#3 | |
|
Confirmed User
Industry Role:
Join Date: Sep 2009
Location: Radelaide
Posts: 2,163
|
Quote:
|
|
|
|
|
|
04-30-2012, 01:34 PM
|
#4 | |
|
Confirmed User
Industry Role:
Join Date: Apr 2011
Location: En la reverendisima concha de tu madre!
Posts: 3,034
|
Quote:
Just go to your cpanel and click the PHPmyadmin icon |
|
|
|
|
|
04-30-2012, 01:36 PM
|
#5 |
|
Likes Pie
Industry Role:
Join Date: Dec 2007
Location: The land that liberated porn
Posts: 12,401
|
Can't you installed the akismet plugin and have it process all comments? I seem to recall doing this on a site with 10K+ comments held for moderation. Could be remembering wrong though.
|
|
|
|
|
04-30-2012, 02:12 PM
|
#6 |
|
Confirmed User
Industry Role:
Join Date: Jul 2008
Location: In your back seat with duck tape
Posts: 4,568
|
__________________
High Performance Vps $10 Linode Manage your Digital Ocean, Linode, or Favorite Cloud Server. Simple, fast, and secure Server Pilot |
|
|
|
|
04-30-2012, 02:25 PM
|
#7 | |
|
Arthur Flegenheimer
Industry Role:
Join Date: Jul 2006
Location: New York City
Posts: 11,056
|
Quote:
use the plugin 'delete pending comments'. it works great. |
|
|
|
|
|
04-30-2012, 02:27 PM
|
#8 | |
|
aliasx
Join Date: Apr 2001
Posts: 19,010
|
Quote:
__________________
https://porncorporation.com |
|
|
|
|
|
04-30-2012, 05:01 PM
|
#9 |
|
Registered User
Industry Role:
Join Date: Dec 2011
Location: Los Angeles, CA
Posts: 52
|
Shit, just had that problem. I ended up deleting all the posts with 1000's of comments, it got so out of hand it was crashing my SQL database.
|
|
|
|
|
04-30-2012, 05:03 PM
|
#10 |
|
Confirmed User
Industry Role:
Join Date: Oct 2001
Location: Toronto
Posts: 7,103
|
Don't use Wordpress anymore.
|
|
|
|
