Title: Comment Moderation bug? Last modified: August 18, 2016 --- # Comment Moderation bug? * [gregorsmith](https://wordpress.org/support/users/gregorsmith/) * (@gregorsmith) * [21 years, 4 months ago](https://wordpress.org/support/topic/comment-moderation-bug/) * Sorry if this has been asked before, I trie to look for a similar problem with no luck, so I dunno… * I’m currently running 1.5b1 2005-01-21 and I’ve noticed a distinct lack of spam comments, until I noticed the wp-comments table in the database, it’s completely bloated with comments marked as spam, but not appearing in the awaiting moderation queue * a recent example * INSERT INTO `wp_comments` VALUES (4892, 13, ‘online poker’, ‘absinth581@mail. ru’, ‘[http://www.example.com/’](http://www.example.com/’);, ‘69.148.200.14’,‘ 2005-02-03 12:38:17’, ‘2005-02-03 17:38:17’, ‘Please visit some information in the field of ‘[http://www.example.com/’](http://www.example.com/’); online poker\r\n…’, 0, ‘spam’, 0, ‘Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0; .NET CLR 1.0.3705)’, ”, 0); * is this a known error? should I enter it in mosquito? should I upgrade to a newer build? Viewing 15 replies - 1 through 15 (of 15 total) * Moderator [James Huff](https://wordpress.org/support/users/macmanx/) * (@macmanx) * [21 years, 4 months ago](https://wordpress.org/support/topic/comment-moderation-bug/#post-139581) * Upgrade to a newer build first (it’s always a good idea anyways, but make a backup first). * Thread Starter [gregorsmith](https://wordpress.org/support/users/gregorsmith/) * (@gregorsmith) * [21 years, 3 months ago](https://wordpress.org/support/topic/comment-moderation-bug/#post-139901) * Well, a little update to this problem… * I installed the lastest nightly at the time (02-04-05) fresh and imported evertything bar the options table, I only edited the date format and post display in th option( there by leaving it with default moderation or spam control on). Soon enought I got the usual backlog of emails saying that comments need moderated, so I turned the option marked “Comment author must have a previously approved comment” off and pasted in the comment spam words list from the codex and once again nothing is coming up as needing moderted and again the comments table is becoming more and more full with comments that have a ‘spam’ variable in it. * So I can only surmise that the comments spam words list is acting as a blacklist but not deleting the comments or WordPress is doing something by it’s own accord that I’ve not asked it to do * Moderator [James Huff](https://wordpress.org/support/users/macmanx/) * (@macmanx) * [21 years, 3 months ago](https://wordpress.org/support/topic/comment-moderation-bug/#post-139902) * So they’re still not appearing in the moderation que? And, are you sure that the words in the codex list apply to the words in your spam comments? For example, most of my spam is poker and casino-related. While the codex spam words list has “casino”, it lacks to work “poker” by itself. I had to add the word “poker” in order for the blacklist to catch the poker comments. If you’d like to see my blacklist, it’s here (but be warned, this subject matter is not suitable for children, or most adults for that matter): [http://www.macmanx.com/wordpress/bad.txt](http://www.macmanx.com/wordpress/bad.txt) * Thread Starter [gregorsmith](https://wordpress.org/support/users/gregorsmith/) * (@gregorsmith) * [21 years, 3 months ago](https://wordpress.org/support/topic/comment-moderation-bug/#post-139903) * The words apply, just the comments arent being markd for moderation, nor are they being published… they’re just in the comments table in the database * most odd * [hugo](https://wordpress.org/support/users/hugo/) * (@hugo) * [21 years, 3 months ago](https://wordpress.org/support/topic/comment-moderation-bug/#post-139905) * Comments that are recognized as spam by WordPress get the “spam” approved value. Those won’t show up in the moderation queue. There are several additional rules that make out comments as spam in WordPress – for example HTML numerical entities in the standard ASCII range. So spam showing up in the table but not the queue is perfectly fine with 1.5. Even though I think there should be a way for the user to see what happened and to give at least an overview by date to see _that_ something happened. * Thread Starter [gregorsmith](https://wordpress.org/support/users/gregorsmith/) * (@gregorsmith) * [21 years, 3 months ago](https://wordpress.org/support/topic/comment-moderation-bug/#post-139911) * That makes seense… but aan option for deleting them would be nice, otherwise they will just accumulate in the db * [gnukerman](https://wordpress.org/support/users/gnukerman/) * (@gnukerman) * [21 years, 3 months ago](https://wordpress.org/support/topic/comment-moderation-bug/#post-139912) * I am using the 2005-02-05 1230 release with Spam Karma and found it to stop all comment spam in it’s tracks…..so far. * If you have the plugin manager installed, you can do a one click install for spam karma. * [specialdark](https://wordpress.org/support/users/specialdark/) * (@specialdark) * [21 years, 3 months ago](https://wordpress.org/support/topic/comment-moderation-bug/#post-140031) * [specialdark](https://wordpress.org/support/users/specialdark/) * (@specialdark) * [21 years, 3 months ago](https://wordpress.org/support/topic/comment-moderation-bug/#post-140032) * I’m getting the same problem. I’m running the 1.5 public release. It doesn’t really effect gregorsmith as much… but I have a “Recent Comments” plugin on my sidebar and it picks up these ‘comments in limbo’ and displays it on my webpage. * You can find it here: allthingschill.com/wordpress/ * The spam comment isn’t anywhere on the admin side of the blog. Is there a way to edit the comments table DIRECTLY? * Is there a better way? I apologize for my n00b-ness. I really like having this feature. Thank you so much in advance for your help. * Herschell * Moderator [James Huff](https://wordpress.org/support/users/macmanx/) * (@macmanx) * [21 years, 3 months ago](https://wordpress.org/support/topic/comment-moderation-bug/#post-140033) * The “Spam” marking is in preparation for an upcoming feature (or an upcoming plugin), probably something that will analytically evaluate the spam comments and become an “intelligent” spam filter. Rest assured, the comments no longer appear on your site. * Moderator [James Huff](https://wordpress.org/support/users/macmanx/) * (@macmanx) * [21 years, 3 months ago](https://wordpress.org/support/topic/comment-moderation-bug/#post-140034) * More info: * [http://mosquito.wordpress.org/view.php?id=936](http://mosquito.wordpress.org/view.php?id=936) * Moderator [James Huff](https://wordpress.org/support/users/macmanx/) * (@macmanx) * [21 years, 3 months ago](https://wordpress.org/support/topic/comment-moderation-bug/#post-140035) * An upcoming plugin to take care it for now: * [http://wordpress.org/support/topic.php?id=23486#post-145711](http://wordpress.org/support/topic.php?id=23486#post-145711) * Thread Starter [gregorsmith](https://wordpress.org/support/users/gregorsmith/) * (@gregorsmith) * [21 years, 3 months ago](https://wordpress.org/support/topic/comment-moderation-bug/#post-140036) * Cool, should make things easier than manually deleting them from the database * [specialdark](https://wordpress.org/support/users/specialdark/) * (@specialdark) * [21 years, 3 months ago](https://wordpress.org/support/topic/comment-moderation-bug/#post-140037) * Thank you very much 🙂 * Moderator [James Huff](https://wordpress.org/support/users/macmanx/) * (@macmanx) * [21 years, 3 months ago](https://wordpress.org/support/topic/comment-moderation-bug/#post-140038) * Gregor, * An upcoming plugin to take care it for now: * [http://wordpress.org/support/topic.php?id=23486#post-145711](http://wordpress.org/support/topic.php?id=23486#post-145711) Viewing 15 replies - 1 through 15 (of 15 total) The topic ‘Comment Moderation bug?’ is closed to new replies. * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) * 15 replies * 5 participants * Last reply from: [James Huff](https://wordpress.org/support/users/macmanx/) * Last activity: [21 years, 3 months ago](https://wordpress.org/support/topic/comment-moderation-bug/#post-140038) * Status: not resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics