Professional web developer, graphic designer & network tech.
Music listener, player & lover.


For enquiries please contact me here


If you would like to feature on the website as a blogger, please get in touch.

Airbnb £25 Discount Code

​Click this link to get your £25 off!
Rate this blog entry:
Continue reading
21 Hits
0 Comments

PhpMyAdmin Invalid Column Count in CSV input on line 1

If you are receiving this error while tryng to import a CSV file, make sure that the number of columns in your CSV matches that of your existing database table.I had an existing table with 10 columns, the first column was `id` an auto-increment field. I omitted this from my CSV file presuming it would be auto geberated but it's not.number of c...
Rate this blog entry:
Continue reading
207 Hits
0 Comments

Google In-Page Analytics Not Working

I find this Chrome plugin very useful. However recently it stopped working, the solution (always works for me) appears to be;​open Chromemanage extensionsdisable In-Page Analyticsre-enable In-Page Analyticsreload page (Ctrl+F5)Hope this helps!
Rate this blog entry:
Continue reading
86 Hits
0 Comments

Tsohost UK Web Host Review & Promo Discount Code

I recently moved hosts from SiteGround to Tsohost, mainly because my SiteGround renewal was coming in at far too much money for what I was receiving in my opinion. My first year was approximately £90, whereas my second year was approximately double this at £180 - for no extra services. I began my hunt for an alternative provider... enter ...
Rate this blog entry:
Continue reading
116 Hits
0 Comments

REGEX PostgreSQL Replace

​Working with MARC format, remove pipes and letters.Before;|aShakespeare, William,|d1564-1616.Regex;REGEXP_REPLACE(|aShakespeare, William,|d1564-1616.,'\|.',' ','g')After;Shakespeare, William, 1564-1616.
Rate this blog entry:
Continue reading
368 Hits
0 Comments

Ubuntu Remotely Connect to MySQL Database

In order to remotely access a MySQL database in Ubuntu it's necessary to edit the following file; /etc/mysql/my.cnf Find the following line; bind-address = 127.0.0.1 Comment it out, and change it to the following; #bind-address = 127.0.0.1 bind-address = 0.0.0.0 You then need to restart the MySQL service using the...
Rate this blog entry:
Continue reading
298 Hits
0 Comments

PHP 7.1 with Win 10, XAMPP & SQLSRV Driver

​If you're trying to use XAMPP on Windows and connect to a SQL server using PHP, hopefully the following will help.Firstly download XAMPP for Windows (32 bit). Follower the installer, default options.Then download the Microsoft Drivers 4.3 for PHP for SQL Server.  Extract the contents of this download to your PHP extensions directory...
Rate this blog entry:
Continue reading
4753 Hits
0 Comments

Ubuntu 14 Install and Configure SSH

Ensure the OS is up to date.Install OpenSSH server on the OS.It's also a good idea to make a copy of the default SSH configuration, so that if you ever mess up your SSH settings you can revert to the original.That's all you need in order to get SSH working. You should now be able to use a program like Putty in order to connect to the remote OS...
Rate this blog entry:
Continue reading
543 Hits
0 Comments

Server Side Events with MySQL and PHP

​I wanted to build an application that would display a 'real time' feed of data on my web page.I had access to a MySQL database that contained a 'transactions' table, this table received numerous events every second. I needed to display the transactions in real time (or close enough). Not only did I need to display the live data, but I also wa...
Rate this blog entry:
Continue reading
778 Hits
0 Comments

Phoca Download Empty Categories

Phoca Download is am amazing free document repository for Joomla. However I found one feature lacking, when a category was empty (contained no files), there was no obvious message to the visitor - there was simply the category name and a blank page.I always thought there should be a message 'Oops - nothing here!', or similar.To save you some time, ...
Rate this blog entry:
Continue reading
1002 Hits
0 Comments

Chrome “disable developer mode extensions” pop up

This is how to get rid of that popup appearing every time you create your own local extension in Chrome.Create a .bat file and name it `DevWarningPatch.bat`. Save this to the desktop.Add the contents below to the bat file.Make sure to close Chrome and end all chrome.exe processes. Rightclick the batch file and run it as administrator: it will find ...
Rate this blog entry:
Continue reading
14690 Hits
0 Comments

Laravel and XAMPP

Instructions on how to get up and running with Laravel on an XAMPP environment.Assuming XAMPP has already been installed, the steps involved are;​download composer from here and install it https://getcomposer.org/download/create a folder in htdocs named 'laravel'open a command prompt and cd to this newly created directory cd c:\xampp\htdo...
Rate this blog entry:
Continue reading
1788 Hits
0 Comments

Omeka Install & Setup LAMP

Having worked with Omeka the past few days I'll explain how to set it up on a LAMP stack. Firstly, what is Omeka? Well, taken from their website;Omeka.net is web-publishing platform that allows anyone with an account to create or collaborate on a website to display collections and build digital exhibitions. No technical skills or special server req...
Rate this blog entry:
Continue reading
1835 Hits
0 Comments

A Very Chrome Kiosk

I recently had to create a web application that would be used on a public touch screen kiosk. The kiosk had be be secure, and require certain custom functionality - explained below.The web app would be built using html/php and running on a LAMP stack, nothing too advanced. The most important thing regarding the kiosk way that it offered a...
Rate this blog entry:
Continue reading
1842 Hits
0 Comments

Java Keytool Keystore Commands

Here's a list of some useful Java keytool keystore commands;Java Keytool Commands for Creating and ImportingThese commands allow you to generate a new Java Keytool keystore file, create a CSR, and import certificates. Any root or intermediate certificates will need to be imported before importing the primary certificate for your domain.Generate a J...
Rate this blog entry:
Continue reading
1246 Hits
0 Comments

SSL Certs & Apache Tomcat

​Some tips on dealing with SSL Certificates and Apache Tomcat. If you have to renew your SSL cert or install a new one hopefully these instructions will help.I'll be using Apache Tomcat 7, so the steps may differ with other servers.Firstly you have to generate a CSR on the server (basically a single file), and then send this to whoever you are plan...
Rate this blog entry:
Continue reading
959 Hits
0 Comments

FTP Users & Windows Server 2012

In order to add FTP users to Windows Server 2012 r2 follow these steps. This example users XAMPP Control Panel v3.2.1 however the process is the same for other versions.Firstly open the XAMPP control panel as an administratorInstall the Filezilla Module as a service by clicking the 'Service' box to the left of the 'Module' nameThis will ask you to ...
Rate this blog entry:
Continue reading
921 Hits
0 Comments

Netflix Stuck at 25%

Does your Netflix shows stop at 25% too? Seems to be a common issue that is effecting many people however Netflix are unable to provide a solution. Restarting the app, box, internet connection, cache, settings etc seems to have no effect. Perhaps it's related to the make/model of tv? Nope. Leads changed? Yep. Able to Chromecast? Yep. The frust...
Rate this blog entry:
Continue reading
2382 Hits
0 Comments

XAMPP or WAMP

Considering some web development work with PHP, MySQL and Apache and not sure which to go for? I've gathered some useful information that hopefully should help in the decision making.WAMPP is available only for Windows. XAMPP is available for multiple OS's.Obviously if you want to use WAMP you need to use Windows, otherwise the choice is prett...
Rate this blog entry:
Continue reading
1167 Hits
0 Comments

Joomla! 3.4.5 Released

​Joomla! 3.4.5 is now available. This is a security release for the 3.x series of Joomla which addresses a critical security vulnerability. Joomla strongly recommends that you update your sites immediately. This release only contains the security fixes; no other changes have been made compared to the Joomla 3.4.4 release. Version 3.4...
Rate this blog entry:
Continue reading
773 Hits
0 Comments