1. Remove 8216 spam comments…

    March 16, 2009 by jerome

    … without clicking 8216 times on the spam link in worpdress; you do that like this:

    DELETE from wp_comments WHERE comment_approved = ’0′;

    * as Pierre just remarked, it has a name: WordPress macro via SQL
    ** if you didn’t install it already, Akismet will help drastically reduce any spam on your blog.

    Tags: , , , , | Comments (0)

  2. Comment author’s link broken…

    March 12, 2009 by jerome

    Just noticed that one: the link of author commenting on Capacity were broken. I managed to fix this by editing the comments-templates inside the /includes – I’m not sure this is a WP2.7 issue but i thought it might help to get a not on this in the future…

    /wp-includes/comment-templates.php line 148: replace the single quotes by escaped double quotes
    $return = "<a href=\"$url\" rel=\"external nofollow\" class=\"url\">$author\</a>";

    Comments (2)