Converting WordPress database tables from MyIASM to InnoDB

      Comments Off on Converting WordPress database tables from MyIASM to InnoDB

There are numerous web pages discussing the advantages on InnoDB over MyISAM in different scenarios, and naturally there are conflicting views on the subject.  My view however is that all MySQL database tables should now be InnoDB unless there is a compelling reason otherwise. However WordPress does not specify the… Read more »

Adding a new WordPress admin user when you don’t have an admin login

      Comments Off on Adding a new WordPress admin user when you don’t have an admin login

If you need to take over the management of a client’s WordPress site but they don’t have or can’t remember the admin login, you are stuck! However if you have FTP or some other file management access to the server you can put the following PHP file in the website… Read more »

Firefox and Thunderbird settings backup and restore (Windows)

      Comments Off on Firefox and Thunderbird settings backup and restore (Windows)

When transferring settings between PCs it is often useful to be able to transfer all our Firefox (web browser) and Thunderbird (email) settings, complete with stored passwords, cookies, cache data and everything else, so that they work exactly the same on the new PC. I created these batch files to… Read more »

Windows GWX and Telemetry updates to avoid

      Comments Off on Windows GWX and Telemetry updates to avoid

Update 26th September 2016: Now the free update to Windows 10 period is over, those users who still have Windows 7 or 8.1 installed should be left in peace. Install KB3184143 – “Remove software related to the Windows 10 free upgrade offer” which should remove the main Windows 10 nagging… Read more »

Stand-Alone WordPress Plugin Deactivator

      Comments Off on Stand-Alone WordPress Plugin Deactivator

If you have ever got the “white screen of death” or another error in WordPress due to activating too many plugins or a dodgy plugin, and cannot get into wp-admin to sort it, you will appreciate this simple stand-alone plugin deactivator script. The problem is that if WordPress cannot load… Read more »

Mustek ScanExpress A3 USB Scanner (early version) on Windows 7

      Comments Off on Mustek ScanExpress A3 USB Scanner (early version) on Windows 7

Update 2nd September 2016: This scanner is now supported in VueScan (it was added in version 9.5.39 which was released earlier this year).  This works with no fuss on Windows 7, 8.1 and 10, and has a better interface than the Mustek software.  VueScan Standard Edition costs $39.95 (approx £30)… Read more »

PHP 5.4 Replacement HTML Functions

      Comments Off on PHP 5.4 Replacement HTML Functions

In PHP 5.4 the default character set encoding for the htmlspecialchars(), htmlentities(), html_entity_decode() and get_html_translation_table() functions changed from ISO-8859-1 to UTF-8. If the encoding is specified when the functions are used then they will continue to work as before when upgrading to PHP 5.4. However a lot of PHP code… Read more »

UK Towns and Counties List

      Comments Off on UK Towns and Counties List

Originally compiled for Campsite Finder, this CSV file contains a list of UK towns and cities sorted by county and country (England, Scotland, Wales and Northern Ireland). It is compiled from various sources, primarily Wikipedia lists of towns such as http://en.wikipedia.org/wiki/Category:Towns_in_Dorset with additional information from other websites. Below is a… Read more »