Remembrance Sunday – Poppies at Conisbrough Castle

In remembrance for 100 years of the Battle of the Somme, local people and businesses donated towards lighting up Conisbrough Castle. The castle was lit up for 3 days, and raised well over £1500 for British Legion and the renovation of the local cenotaph/park. It is estimated over 5000 people…

Free Gousto Meal Box (well near enough…)

Following on from my last post, I’ve had an email through to allow 1 person to try a meal box for £1. Plus then 50% off your 4th box (if you subscribe, if you dont, just have the 1 box!) First come first served..! ONEPOUND3SCY Code expires 10th November 2016.

Gousto Meal Box – £25 off First Box

A few weeks ago I visited a country fair and got talking to a rep from Gousto. Having taken up his time, I signed up for a reduced rate trial of their boxes… The idea behind the boxes are to have fresh “meals” delivered to your door, (well the ingredients,…

Magento Order Status Flow

With Magento, the order status flow can be quite confusing. The following diagram from MBS is useful in understanding the status flow: It’s worth noting the following too: An order can be “held” from any state/status in Magento When “Unholded”, it goes back to the previous state/status Once an order…

URL Encode String in SQL

URL Encoding is the transformation of special characters into a form which can be passed over the internet. A good example being ” ” (space) which should be replaced by “%20%”. The following SQL function can be used to URL Encode a string in SQL: CREATE FUNCTION dbo.UrlEncode(@url NVARCHAR(1024)) RETURNS…

Magento Web Service Calls Maintenance Mode – SOAP-ERROR: Parsing WSDL

I’ve had an ongoing issue with a Magento installation. When the maintenance mode is turned on (with access restricted to a few ip’s), web service calls using v2 SOAP API throws the following error: SOAP-ERROR: Parsing WSDL: Couldn't load from 'http://**URL**/index.php/api/v2_soap/index/?wsdl=1' : failed to load external entity "http://**URL**/index.php/api/v2_soap/index/?wsdl=1" The web…

Tesco Flowers

This blog post may sound like another advert for Tesco… In actual fact, it pretty much is. I’m a member of Tesco’s Orchard Program. Through this program, I receive money off vouchers for products, and in return need to tweet on twitter, share on facebook, write blog posts etc. Also…

Fitbit One Not Syncing Android

I’ve recently been having an issue with the Fitbit One. The fitbit is an electronic pedometer/sleep tracker, with nice graphical display and syncs to your mobile device /computer, showing your stats online. All of a sudden the fitbit stopped syncing with my HTC One M8. Fitbit’s website has several instructions…

Raspberry PI 2

Just seen the release of Rapberry PI v2. All I have to say is.. wow… I love the Raspberry Pi, with its ability to solder on wires which can do funky things such as turn on a light, detect motion or even spin motors. The new version 2 comes with…