Archive

Archive for September, 2007

The Emporer’s New Clothes

September 28th, 2007 beezly No comments

Or more accurately, my new slippers. I wear slippers at work because I get terrible static shocks from the building otherwise.

My old slippers were past their best;

Out with the old...

So time for some new ones!

... and in with the new.

Categories: Life Tags: ,

A Long Day

September 28th, 2007 beezly No comments

Today is going to be a long day. I’ve come in to work early as my car is being fixed (it’s been making a weird space alien metallic whirring sound — and no, it’s not the brake pads!) and one of my colleagues was kind enough to give me a lift in to work at 7:15 when he comes in.

Wallpaper4 Thumb
I’m going to visit my parents over the weekend, although I’m hiring a van as a need to transport a bed back down here. Normally it takes me roughly 3 and a half hours to get up to my parents, although in a van I suspect it might take a bit longer.

Categories: Life Tags:

Mooolah

September 27th, 2007 beezly No comments

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.

Categories: Life Tags: , ,

Visitors

September 27th, 2007 beezly No comments

Sarah in the Woods

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

Fixing Comment Counts in WordPress

September 27th, 2007 beezly No comments

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
   );
Categories: Computing Tags: ,

Bad user…

September 20th, 2007 beezly No comments
# uptime

  2:05pm  up 49 day(s), 20:17,  45 users,  load average: 7938.89, 5199.82, 1657.09
Categories: Computing Tags: