WordPress Comments Restored

May 20th, 2009

I took a few minutes this morning to put a script together that would convert the comments from the old blog into the new WordPress format – another time-saving excercise that allowed me to convert 300+ comments in a few minutes.

The only hurdle I had with this was that the rowId for posts in the old table doesn’t marry up to the new one, so the process had to go something like this:

  1. Get the entry lookup for a comment.
  2. Find the titles of that entry from the old posts table.
  3. Look for that title in the new posts table.
  4. Grab the rowId from step 3.
  5. Save the comment with the new lookup.

So!  Comments are restored and visitors can continue their ranting and raving (especially on this post!), only with extra Spam protection for me, which is nice.

Edit:
Two posts in two days!  We’re on a roll!

The Move to WordPress

May 19th, 2009

I finally gave up resisting all the peer pressure and installed WordPress on the site.  As expected, the installation went just fine and the basic install worked OK right out of the box.  There were a couple of things I needed to do though:

Converting the old blog posts to the new format was fairly simple – just read them all out from my existing database table and put them into the wp_posts table for WordPress to use.  I wrote a script to do this bit and after a couple of false starts it went through the thousand-odd entries and moved them over.

The only real problem I had was getting the old blog URLs to work in the new format.  For reasons lost to me now, I had decided to use only 2 digits for the year, whereas WordPress uses 4.  A quick RewriteRule to affect a 301 redirect to the new URLs, and all my cached Google links are working again.

I better investigate some themes and plugins later.

Wait, is this thing still here?

April 17th, 2009

So you may have noticed – assuming you are sad enough to actually check the front page more than once in a blue moon – that the site hasn’t been updated for quote some time.

The main reason is that I’ve been working on a pet project that I just launched this week, but I’ve also been messing about with Twitter, and since it’s more ADHD-pleasing than coming up with a decent-length entry on a bl0g, plus you get other people’s thoughts as well, I’ve actually rather been enjoying it.

Of course, all is not roses and sunshine. More and more frequently the Twitter hamster runs out of puff as the sheer number of people using the website brings things to a crawl. Spammers are legion as with all new tech, and the thought of people automatically seeing what you type instead of having to visit a dedicated website can be a little offputting. On the whole, however, it’s a Good Thing.

Let’s face it, if I had to fill this thing in every day, you’d get variations on the theme of “Got up, performed ablutions, did some work, ate, watched TV, went to bed” every single time.

XHTML 1.0 Strict and CSS 2.1 Update

June 4th, 2008

After adding the comments the other day I noticed that the website code was, quite frankly, a mess, so I’ve taken a couple of hours out to rewrite the bl0g structure in Strict XHTML 1.0 as well as CSS v2.1 – this should make the site more compatible with more browsers (looking forward to IE8 here…) as well as cleaner and better for Search Engines.

The older content will most likely break all this, since much of it is HTML4, and probably not very legit at that, so I haven’t bothered linking to the validation for that reason. Any content from this entry forward, however, should be perfectly OK. I’ll probably run this through the w3c validators, JUST to be sure.

Nothing will help with my typos though. Meh.

Now on the new server…

March 17th, 2006

Aftger a week of intensive headscratching, moans of frustration and outright cursing at our new overlords hosting company, I’ve managed to get maybe 2/3rds of our websites over onto the new server including this one. It’s been… interesting.

The new server is actually shared, thus it’s only a virtual one, but it does mean that we get all the features of the old one up to and including root access on our own virtual machine. There have been a few hiccups during the move (our server number is 001-01 so we feel like a bit of a guinea pig) but the tech guys have been pretty good about sorting things out.

The machine specs are slightly better on all fronts except for the amount of disc space which is roughly halved. Since we used about 6% of our previous machine, howevere, this isn’t really cause for concern.

I’ve got until the end of the month to move the rest of the websites over, so plenty to do.