And we are back…

After a bit ‘o time we are back again. In the space between the last post, I’ve managed to gain my Intermediate AND Advanced Ham radio licence. Yay me eh? For those hammers out there look out for M0XHT.

Next thing to tackle, 3D design software. Been wanting to get my head around this for a while, now is the time I think. 3D printers are getting cheaper and I’m getting more tempted by one.

Only Index page working after migrating your WordPress site?

As you can see from the previous post, I am in the process of moving some WordPress installations to a new server. I’ve done this before however like with the update script, always need forget the exact steps needed to get the newly migrated site fully working.

Step 1.

First thing to do is double check the httpd.conf file and check that AllowOverride is set to All for the directory. If not, make the change and then save the file.

<Directory /var/www/>
Options Indexes FollowSymLinks
AllowOverride All
Require all granted

Step 2.

Go to the WordPress dashboard for the site, visit settings > permalinks. I’ve been told that just opening the page is enough to get the new configuration working, but I don’t think pressing save hurts.

Changing Domain Name With WordPress

Simple one this but I always have to look up the code so thought I’d write it somewhere I can find it at ease.

If you move a site to a new domain and are using WordPress your CMS, after restoring your database you will need to run the below script to change the references in the database to the new domain you are configuring the site for.

SET @newURL = '';
SET @oldURL = '';

SELECT @newUrl;
SELECT @oldUrl;

UPDATE wp_options SET option_value = replace(option_value, @oldUrl, @newUrl) WHERE option_name = ‘home’ OR option_name = ‘siteurl’;
UPDATE wp_posts SET guid = replace(guid, @oldUrl, @newUrl);
UPDATE wp_posts SET post_content = replace(post_content, @oldUrl, @newUrl);
UPDATE wp_postmeta SET meta_value = replace(meta_value,@oldUrl, @newUrl);

Open Source Contributions – 2016

This blog is going very slowly, I’ve not yet got into the habit or pattern of regular writing. That was the main reason for starting this thing, to improve my writing and hopefully in turn improve upon my thinking.

For this post I decided to list the Open Source projects I’ve contributed to this year. All of them are financial donations rather than code contributions however, something I hope to change in 2017. Part of the problem is finding an Open Source project that lights my fire and I’ve not come across many so far. I’m thinking of something around the .Net Core stack and explore .Net on the Linux ecosystem.

So, the list of projects is below. I genuinely can’t remember the donation amounts however no one alone would be over £20. I hope whatever I donate can be of some help to the teams. Keep a server on for a few more hours!

Heidi SQL – I use this daily and it’s perfect for my needs. I’m used to MS SQL Server tooling and this software to me lives up to that standard.

DataTables.Net – This is a fantastic client-side datagrid component. I’ve used this in several projects and really enjoyed it every time. I’ve sponsored this product now for a few years and hope to for years to come.

Wikipedia – I have probably visited Wikipedia at least once every day this year (and most likley last year, and the year before that…) and can’t begin to think of a world without it. I’m more than happy to keep the site running, ad-free, sponsorship-free, open to all.

There are other projects that I’ll add to the list when I remember what they were!

Tool repair – Circular Saw

A fiend came to me the other day with a dead circular saw and wondered if I could take a look. It is an old bit of kit but a good quality tool that would be expensive to replace. Fault was easy to replicate, plug it in and turn it on. Nothing. I thought initially it would be the brushes needing replacing after years of daily wear, but on inspection it was something a little more basic.


Yes indeed. Someone had been in here before and I assume attempted to replace the cable. As the wire wasn’t securely fastened the slightest of tugs and the join would pull apart. In the end I replaced the flex and did a better, neater and safer job of installing it properly.


The only thing I have doubts over is the strain relief for the cable. I tried with some zip ties to secure it to the casing as much as possible, it’s all I could really do without the proper clamp that would have been there when new.


As you can see from the pictures it’s a beautiful neat repair that will give the saw many more years of use. By the way, while the guts of the motor were out I did check the brushes and there was plenty more wear left in them.


I love repairing stuff. It’s always given me a great sense of satisfaction to make something broken work again. Shame a lot of electronics these days don’t really allow for any user servicing. We have a culture where we don’t fix things we replace them. This 15 minute fix and the cost of 3 meters of cable and a plug is massively more cost efficient than getting a new £250 saw just because of a small fault.

Software person with Hardware ambitions.