Spam Karma 2 SQL errors
An update to my previous post: I believe my Spam Karma 2 SQL errors are due to the use of MySQL 3.2.3. SK2 documentation strongly recommends MySQL 4+. Indeed, I have no trouble purging the SK2-captured spam using MySQL 5.




An update to my previous post: I believe my Spam Karma 2 SQL errors are due to the use of MySQL 3.2.3. SK2 documentation strongly recommends MySQL 4+. Indeed, I have no trouble purging the SK2-captured spam using MySQL 5.
I'm not yet sure how effective this is, but I just noticed that DreamHost's 1-click install of WordPress includes a hack that they claim helps protect your blog against comments spam. The added code is contained at the top of the wp-comments-post.php file:
if (!$_SERVER['HTTP_REFERER'] == dirname(__FILE__) . '/wp-comments.php'){ die ('Error: This file cannot be […]