Wordpress Please Help Me With Spam Comments Delete Them All!!!

OKAY I DELETED the wp_comments it says there is no comments but on the blog there still says "567" or whatever

 

Don't know about an offer, but you might want to double check your Askimet key is valid. If it is then you better talk to the guys at Askimet, I'm sure they would love to hear how great their system is working for your blog.

 

So far so good, all the comments are not there anymore. Except that it still shows the number of comments. Did you drop the whole wp_comments? o.o You're only supposed to clear it.

 

clearing it did nothing, I called someone who is very good with WP and he said a case like this is crazy. Never has he seen so much shit go through akemist.

 

All the comments are gone i think? But it still says there is 100's of comments on the blog but none inside?

 

You probably need to replace that table with a fresh copy. Do you have a backup copy of your database ? You can open that SQL file and grab the commands you will need. These will depend on the type of database you haveA*. For my setups... I am running WP 2.3.x and MySQL 5.0.27-standard and I would enter the following in the SQL command box:

DROP TABLE IF EXISTS `wp_comments`;
CREATE TABLE `wp_comments` (
  `comment_ID` bigint(20) unsigned NOT NULL auto_increment,
  `comment_post_ID` int(11) NOT NULL default '0',
  `comment_author` tinytext NOT NULL,
  `comment_author_email` varchar(100) NOT NULL default '',
  `comment_author_url` varchar(200) NOT NULL default '',
  `comment_author_IP` varchar(100) NOT NULL default '',
  `comment_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `comment_date_gmt` datetime NOT NULL default '0000-00-00 00:00:00',
  `comment_content` text NOT NULL,
  `comment_karma` int(11) NOT NULL default '0',
  `comment_approved` enum('0','1','spam') NOT NULL default '1',
  `comment_agent` varchar(255) NOT NULL default '',
  `comment_type` varchar(20) NOT NULL default '',
  `comment_parent` bigint(20) NOT NULL default '0',
  `user_id` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`comment_ID`),
  KEY `comment_approved` (`comment_approved`),
  KEY `comment_post_ID` (`comment_post_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

Code (markup):

* You may be running something else there and the syntax may differ.

 

scoopy i tried it, it didn't fix the problem. I'm just getting so stressed I'm about to delete all my sites! Web-design always screws up for me!

 

Don't do that. Just give them to me. Better have someone look it up for you, volunteers are everywhere. Just not me, you already rejected my offer. Haha.

 

I didn't reject you the dumb guy from my hosting said he had it all worked out. Than it didn't work!

 

At least those comments are gone now... that was the most important item... and you accomplished that! Don't give up yet

 

The story of the past 10 hours on my computer today!

 

I don't understand, lol. Going emo?

 

You need to go to the "Posts" table in PhpMyAdmin and clear out the "comment_count" entries for each of the posts. This will reset the comment count to zero.

 

Okay, I did it. All comments were deleted last night. But I woke up with 2,000 Porn comments again today.

 

Spammers had a field day with your site. It will take awhile before they realize they're not getting free backlinks anymore...

 

Double check that your options are set the way you want... such as, "Users must be registered and logged in to comment"... don't forget to click that "Update Options" button after each change

These "comments" may also be "pingbacks" being abused by bots? I just cleared a friends site of 50,000 spam comments... and found they were still coming in faster than we could delete them.

What I did was turn off the pingback feature on all posted articles by going to that SQL command box in phpMyAdmin and using this command:

UPDATE wp_posts SET ping_status=closed;

Code (markup):

To turn that option off for new stories... look in Options --> Discussion.

Haven't gotten any more spam for 3 days now