Comment Moderation bug?

Upgrade to a newer build first (it’s always a good idea anyways, but make a backup first).

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

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): https://www.macmanx.com/wordpress/bad.txt

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

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.

That makes seense… but aan option for deleting them would be nice, otherwise they will just accumulate in the db

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.

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

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.

More info:

https://mosquito.www.ads-software.com/view.php?id=936

An upcoming plugin to take care it for now:

https://www.ads-software.com/support/topic.php?id=23486#post-145711

Cool, should make things easier than manually deleting them from the database

Thank you very much ??

Gregor,

An upcoming plugin to take care it for now:

https://www.ads-software.com/support/topic.php?id=23486#post-145711