By robertdouglass on

Last week I ran a test conversion using Sam Revitch’s WordPress-to-Drupal conversion script. Everything carried over to Drupal beautifully, even the custom URL setup, but I noticed there were nearly 2000 comments in Drupal—a lot more than I’d ever seen on the blog or in the WordPress admin pages. I looked in the WordPress database with phpMyAdmin and found the extra comments in there, flagged with comment_approved = spam. Most of those really were spam, but there were a couple dozen legitimate comments that had been mistakenly tagged as spam.

That wouldn’t be so bad if the WordPress admin UI had given me any clue that these false positives (and the actual spam comments) were hiding in the database. But they don’t show up anywhere in the admin pages. The first time I ever noticed them was when the conversion script copied them over. (I suppose that could be considered a bug in the script—should it copy spam-tagged comments? But I’m glad it happened or the comments might have been lost completely.)

From Michael Geary to Earth

Comments

billturner’s picture

billturner commented

The same thing happened to me when I imported WordPress entries into Drupal. I used the WP SpamKarma plugin to catch spam, and it worked quite well, but I forgot about it (and all the spam it captured) before I imported. Luckily, I just had a few hundred, and not 2000. Yikes.

Bill Turner | brilliantcorners.org
drmike’s picture

drmike commented

Not sure why you didn't see your spam count. It's listed on your Dashboard very first page....