• WordPress comment count

    This statement corrects all the comment count in WP posts by querying every posts actual comments:

    UPDATE wp_posts p SET p.comment_count = (
        SELECT count(*) FROM wp_comments
        WHERE comment_post_id = p.id AND
           comment_approved = 1 );
  • WordPress comment count

    This statement corrects all the comment count in WP posts by querying every posts actual comments:

    UPDATE wp_posts p SET p.comment_count = (
        SELECT count(*) FROM wp_comments
        WHERE comment_post_id = p.id AND
           comment_approved = 1 );
  • Oh yes, Techcrunch is so right.

    http://www.techcrunch.com/2009/04/15/apple-your-mighty-mouse-sucks-please-fix...

    The Mighty Mouse is in my opinion the proof that even great hardware manufacturers have product failures.

  • Blog Relaunch

    All those sick days (of the last three weeks, I've spent two in bed) had one advantage: I had time to tackle some things.

    One of those things was consolidating my old Serendipity blog and the current one, running on Drupal, into one Wordpress blog. I wanted to switch from Drupal to Wordpress because WP is more focused on blogging and there are some features (e.g. trackbacks, remote blogging via XML-RPC) that Drupal doesn't do as well.

    It took me about 12 hours of Perl hacking to write a converter that reads posts and comments from a source database (Drupal or S9Y) and writes them into a destination database (WP). So, all posts since 2004 including their comments should have made their way into the new blog!

    Let's see if the new possibilities help me in writing posts in shorter intervals. Of course, that's what I've been telling myself for weeks now. ;-)

  • Tweenbots

    http://feedproxy.google.com/~r/oreilly/radar/atom/~3/YpcjizorWqo/tweenbots-cu...

    Sometimes, cute and simple trumps expensive and sophisticated.

    I’d like to have this experiment myself. Those robots are just too cute.