Beezly’s Blog

It looks like my tax had been miscalculated for the entirety of my 6 month contract. I had been paying Basic Rate on all of my earnings. This got fixed this month so I got a nice rebate from the tax man.

In related news, my 6-month contract expired on 19th September, but was extended to the end of the month. From 1st October I will be working in a permanent position for @Road, A Trimble Company.

Update: Yippee… tax paid this month = £7.44. Excellent.

Sarah, Nick and Eleanor came over last weekend. We had a great time… nothing to strenuous on the Friday evening. Saturday we went to Thorpeness and Aldeburgh and buried Eleanor in pebbles. In the evening we went to the Ipswich Beer Festival and met up with some of my colleagues. Sunday we went to Easton Farm Park and saw lots of animals.

Photos are on flickr

As I’ve just migrated to using Wordpress for my blog, I thought I’d add some useful information in my first post.

Wordpress caches comment counts for each individual article in wp_posts.comment_count. If for some reason these cached values don’t match up to the real comment counts per article, you can fix this using the following SQL. This applies to Wordpress 2.3. I don’t know if it will work for anything else.

UPDATE wp_posts
  SET comment_count = (
   SELECT COUNT(*)
     FROM wp_comments
     WHERE wp_posts.ID=wp_comments.comment_post_id
     GROUP BY wp_comments.comment_post_id
   );