Common Spam Words and WordPress
I’ve had comment moderation turned off in my blog for a while now but it wasn’t working, everthing was still getting sent to the moderation queue. I initially assumed it was a problem related to my recent upgrade of WordPress to version 1.2.2 since after the upgrade the admin section was missing a lot of options that were there one version earlier. That was normal unfortunately.
After a full WordPress reinstall and database wipe it turns out that if you have any blank lines in your list of words it’ll catch all submitted comments. It’d be nice if it mentioned that on the admin page you submit all those words to, as it was I had to search the support section of the WordPress site.
Due to lazy SQL export parameters on my part I almost lost all my posts and comments during that fiasco. Fortunately I had a complete but very messy backup with Macintosh line endings, bunk SQL queries, and a lot of garbage filler but thanks to Vim it turned out to be a quick three minute job and I didn’t lose a thing.
I’ve still got to fix the design, but at least the site is working again.
January 27th, 2005 at 10:10
D’oh! That bites.
Yes, I remember reading (on the wordpress dev blog) that bad things would happen if you had a blank line at the end of the common spam words list—but you’re right—it doesn’t say that on the admin page.
January 27th, 2005 at 10:23
Oh, yeah—and I like the Vim icon. Très chic.