WordPress.org

Ready to get started?Download WordPress

Forums

Blank page after clicking Check for Spam button - akismet_recheck_queue (6 posts)

  1. micropat
    Member
    Posted 4 years ago #

    Whenever I click the "Check for Spam" button ( thus landing on /wp-admin/admin.php?action=akismet_recheck_queue ), a totally blank page is returned (200 OK response).

    Any ideas? Suggested ways to troubleshoot?

    Thanks!

    http://wordpress.org/extend/plugins/akismet/

  2. wlindley
    Member
    Posted 4 years ago #

    I have the same problem, with WP 2.9.1 ... any resolution?

  3. wlindley
    Member
    Posted 4 years ago #

    In my case, apparently there were so many spam messages (over 17,000) that Akismet got some kind of out-of-memory conditon. I was able to get Akismet filtering running by manually starting mysql:

    $ mysql databasename -u dbusername -p

    and then deleting all the very old unapproved comments:

    mysql> delete from wp_comments where comment_approved = 0
    AND comment_date < '2010-1-1';

    You can see how many unapproved comments Akismet will try and filter:

    mysql> select count(comment_ID) from wp_comments where comment_approved=0;

    and after Akismet runs awhile, you can monitor its progress by counting the number of messages flagged as spam:

    mysql> select count(comment_ID) from wp_comments where comment_approved='spam';

  4. ccolvin
    Member
    Posted 4 years ago #

    I ran across this problem as well. Checking a blog with 108k comments, I needed to check them against the spam database but knew there would be legit comments mixed in so I didn't want to just delete them all. Instead, I put a limit statement in the askimet.php function.

    So in akismet_recheck_queue() I added the Limit below. Tweak the number for what your server can handle...

    $moderation = $wpdb->get_results( "SELECT * FROM $wpdb->comments WHERE comment_approved = '0' LIMIT 1000" , ARRAY_A );

  5. zomigi
    Member
    Posted 3 years ago #

    Thanks ccolvin! Worked great for me.

  6. jdalrymple
    Member
    Posted 3 years ago #

    Brilliant, worked perfectly!

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags