Alex Poole

Pragmatic PHP, MySQL, Marketing & Technology

Alex Poole header image 4

“Boy gets arm crushed by car”

November 30th, 2009 by alex
Respond

I received an email just now purporting to show a series of photos where a young Iranian lad had his arm crushed by a car as punishment for stealing some bread.

A few moments of research showed that it was likely that the photos were taken out of context, and the lad - a performer in a street circus - suffered no permanent damage from the event

Now don’t get me wrong - some of the world’s worst atrocities have certainly been carried out in one of the many names of God. Spanish Inquisition anyone? What bothers me though is when highly emotive content is sent around willy nilly and trusted by the masses at face value.

When I receive information - especially emotionally-charged information that has such a clear intent to rabble-rouse - I ask, “what is the motive?” Usually its a simple question to answer, and that answer can be quite illuminating!

Do you blindly trust what you read at face value, or do you ask yourself who could be trying to manipulate your opinions?

Tags: No Comments.

SEO Ely

November 26th, 2009 by alex
Respond

If you’re searching for an SEO Ely specialist, you should definitely contact ISVirtual.

We specialise in all aspects of Search Engine Optimisation including:

  • Keyword research - finding out what people who are looking for your products and services actually search for, in the real world.
  • On-page SEO - editing and/or creating the following tags to make sure they contain the most relevant keywords which you’ve identified above:
    • Page <title> tag
    • <H1>, <H2> and <H3> heading tags
    • Internal <a href…> links to other pages on your site
    • Image “alt” attributes
    • <meta…> tags  - whilst meta keyword tags are not desperately important for SEO any more, the meta description tag usually provides the search result “snippet” in Google, which can provide a strong call-to-action
  • Off-page SEO - building links to the site to demonstrate to the search engines that the site is a relevant and valuable for them to show to their searchers. We can employ many strategies including the following:
    • Article link-building - writing and distributing valuable and useful content to sites that publish articles, and will then link to the client’s site.
    • Video SEO - producing videos that can quickly insert themselves into the top 10 Google results
    • Guest blog posting  - creating content to post on other peoples’ sites, who then link back to your site
    • Affiliate programs - offering a “cut” of sales to people who refer the customers - this can be a very powerful technique to grow traffic quickly, if the site can convert visitors into buyers effectively
    • Directories - most are pretty worthless but there are a few directories that are still worth submitting to
    • Social Bookmarking - “spreading the word” about useful and valuable content using sites like Digg, Del.icio.us,
    • Social Media - “spreading the word” about useful and valuable content with sites such as Facebook and Twitter
  • Link Bait - creating content that is so compelling (an addictive game, controversial editorial or super-useful resource,) that other webmasters choose to link to it.

We’re finding more and more customers  locally, in Ely and the surrounding area (Cambridgeshire, West Norfolk, North Suffolk, etc) - its great for us because it costs us less fuel and time to go to meetings, and its great for you because we can pop round and talk face-to-face at the drop of a hat. Why engage an SEO company half way across the country (or indeed half way across the world!) when there’s a highly experienced one on your doorstep?!

Tags:   · · No Comments.

SugarCRM issue: CentOS, PHP 5.2.11, Junk Characters, Plesk, OneandOne

November 20th, 2009 by alex
Respond

This post is just a pointer to a solution which it took me a *long* time to find on the SugarCRM forums.

The symptoms are that you install (or migrate) SugarCRM and are presented with a pile of  ”junk characters” instead of a normal login screen.

The reason, I eventually discovered after a tedious amount of trial, error and Googling, is that PHP 5.2.11 has a fiddly Zlib implementation.

The solution, (along with a screenshot of the symptom to ensure that this is indeed the same issue that you are experiencing,) is posted here:

http://www.sugarcrm.com/forums/showthread.php?t=53231

The other keywords in this post title relating to CentOS, PHP 5.2.11, Plesk and OneandOne are things I thought might be causing the problem.  (Turns out the PHP version is significant, whilst the hosting company and hosting control panel are not.) Hopefully others with the same issue will be able, therefore, to find this post quicker than the deeply buried SugarCRM forum entry.

As always - hope that helps :)

Tags:   · · · · 1 Comment

IM Success Notes Down

November 10th, 2009 by alex
Respond

I’m so sorry.

Here’s what happened:

When we set up ISVirtual we bartered a server from a business associate in return for setting up and maintaining a SugarCRM install for them.

I hosted IM Success Notes on this server as it was very over-spec and could deal with huge traffic spikes. (It had 4Gb of RAM and an 8 core processor, if that means anything to you.)

It was a good decision and the site ran smoothly through a very spikey launch.

Well, the other day the server disappeared off the ‘net. No HTTP, no SSH, no nothing. No warning :/

Turns out our associate had neglected to pay their hosting bill - many many hundreds of pounds (it pertained to a large number of servers, not just the one we’d bartered.)

Trusting to the top-notch RAID 5, I hadn’t kept regular off-site backups. I have all the code for IMSN of course, but no up-to-date database backups.

In layman terms, that means I don’t know who I owe commissions too, and I’ve lost the entire user database.

I’m beyond anger on this. I’m doing absolutely everything I possibly can to retrieve the data.

In the meantime, if you know what commission I owe you, please email me at alexpoole (at) gmail (dot) com and I’ll paypal you immediately - I know that payments were already overdue.

I understand how badly this has potentially affected my reputation, and I would never have done this on purpose - please believe at least that.

I’ll do everything I can to make amends.

Again, I’m very very sorry.

Tags: No Comments.

Online Bass Lessons and Collaboration Bands - Wikinomics Working

October 14th, 2009 by alex
Respond

I read Don Tapscotts’s Wikinomics a while ago - (in my own interpretation) it proposes that the almost limitless collaboration which today’s internet at last genuinely enables will change every facet of how the world goes around.

Heady stuff for sure and indeed during and after reading the book my head was in a whirl of possibilities for weeks.

Pragmatically though - real world - what does this all  mean?

Well I’ve been happening upon something recently that is a perfect and bang up-to-date example…

I bought a bass guitar the other day. I haven’t played one in pretty much 20 years but thought it would be fun to get blisters again. Naturally enough to help get back up to speed I researched online bass lessons.

Sure the usual info-products are there, as in pretty much every niche nowadays, but also a world of bass lessons on youtube which people had recorded and distributed for free. Which was cool.

It gets a whole heap better though.

Turns out people aren’t just recording and uploading themselves playing Red Hot Chili Peppers covers any more.

Now they’re forming “Youtube collaboration bands” - passing tracks around, editing them up into a vid and posting the finished version. These are people who’ve never met - may never meet - and can quickly and easily form loose networks of collaboration as suits their purpose at the time.

In other words if you’re a drummer or a bass player who wants to show off their talent with a specific song, you can quickly and easily search Youtube and other networks for guitarists who’ve already demonstrated their prowess with the song you want to record, or at least a similar song. That’s the audition taken care of.

Then its a snip to contact the person, move to realtime on IM or Skype, and to send audio or video files to each other across the web.

The result could be something like this stonking version of Higher Ground.

So just think about this for a moment…

Someone with just a laptop with a webcam, an  internet connection and an instrument can now find musical partners anywhere on the planet in pretty much real time, and create a multitrack multimedia recording with them, (using only free software and services if they so choose.)

Now that is f****ng exciting!

Tags: 1 Comment

The Time Traveler’s Wife Movie

September 11th, 2009 by alex
Respond

I was one of perhaps only a handful of men who fell, totally, for the tear-inducing charms of Time Traveller’s Wife, (I’m sorry. There really must be 2 “Ls” in traveller,) when I read the novel some years ago. It combined the gorgeous sun-soaked wishy-washyness of a Maeve Binchy novel with the heart-ripping loss of Romeo and Juliet - a romantic classic, finely and precisely crafted - I suspect over years and multiple iterations, by, literally, an expert artist. (Audrey Niffeneger is an artist first, a novelist second.)

The film certainly has the hue. Every colour is overblown, over-saturated beautifully. Similar the soundtrack offers a soft bed of late summer leaf fall, thick with multi-layered strings. Whilst not personally interested in Eric Bana’s behind, I can imagine this would also be of interest to the majority of the market for the movie!

The paradox of the story, of course, is that both the chicken and the egg arrived together - time in this cleverly plausible almost-reality is a moebus strip. When Clare meets Henry for the first time, he already knows they’ll meet, fall in love and marry. When Henry meets Clare for the first time, she has loved him since she was a child.  The scriptwriter teases us with this just once - Henry tells the doctor “You call the condition Chrono-displacement, but now I’ve told you that, its difficult to know what comes first…”

No other review I’ve read (they’re all here on Rotten Tomatoes by the way,) really seems to have identified, and accepted, this ultimate paradox.

Finally, for me, though, the leading actors didn’t quite click. They were best friends certainly, but seemed to fall into the mildly embarassing “how do I tell my best friend I love her?” category rather than the out & out passion than Niffeneger portrays so sensitively.

And to cut the final, (in Clare’s chronology at least,) scene was a travesty. Henry re-visits Clare when she’s an old woman. That was the one that had me red-eyed for days, and is making me well up just thinking about it again. That scene embodied the magic of the paradox most beautifully, but they cut it completey from the movie. Boo, but considerably less hoo.

Afterwards? We got home not so much with the overwhelming need to rip up the bed, but instead to cuddle the sleeping kids, then each other. That was nice for sure, but not the expected outcome!

Enjoyable enough but middling. A tough book to translate to the screen, certainly. Nevertheless, a mild shame.

Tags: No Comments.

Download These IM Success Notes

August 26th, 2009 by alex
Respond

I launched a new site yesterday at http://www.IMSuccessNotes.com

There you can download - for free - all the notes I took at the Bristol LFMpire Builders Workshop. It was focused on 2 things - traffic and conversion - so if you could use a boost in either department, you’ll almost certainly find something useful to you in the ebook.

I’m testing lots of supposedly conversion-boosting things like a bright minisite and squeeze video. I was hoping to get near to Eric Graham’s famed 75% squeeze page conversion, but I’m not too unhappy with the ~35% the site is currently doing.

The site is focussed on list building, whilst making a little revenue from enabling people to put their own affiliate links into the rebrandable report. There’s a viral marketing element too - anyone who signs up (for free) can also make commissions by referring new members - commission is a whopping 75% of one-time-offer price.

I’ll report back with more details of the launch when the dust has settled. In the meantime, why not dig out your own golden nuggets at http://www.IMSuccessNotes.com

Tags:   · · · · No Comments.

Spillers Millennium Mills

August 18th, 2009 by alex
Respond

Since photographing the wonderful Spillers Millennium Mills building in London’s Royal Victoria Docks at the weekend  during a family trip to Thames Barrier Park, (highly recommended for a day out with young kids by the way - take swimmies & towels,) I’ve become rather fixated with this building.

Spillers Millennium Mills

Nestled between the barrier and the ExCel exhibition centre, its described by some as “brooding” which seems rather an understatement - juxtaposed against the sleek chrome of Pontoon Dock DLR station it appears to me almost malevolent in its unapologetic dereliction. This is only heightened when you start to look at some of the photos taken by explorers inside the bulding - with 10 storey drops, missing steps and even whole walls, its a proper genuine deathtrap.

The history of the building spans a little over 100 years. It was built in 1905 by William Vernon and Sons, bought by Spillers shortly afterwards and named after their “Millennium Flour” of the time, though apparently the mill was also used for making the dog food for which Spillers were famous. It was partially destroyed by a massive explosion at the neighbouring Brunner Mond’s works in 1917, extended massively around 1933 and de-commissioned in the mid 1980’s when Spillers moved their milling activities East to Tilbury.

The Millennium Mills building was used as the backdrop to Jean Michelle Jarre’s 1988 “Destination Docklands” concert, (along with the even larger neighbouring  Cooperative Wholesale Society mill which was demolished shortly afterwards,) and has featured in a number of pop videos,  in Kubrick’s Full Metal Jacket and as the backdrop to Life on Mars, since. As soon as someone decides its safe enough to stump up the capital again, it will be turned into up to 5000 (yes, that was thousand! This is a *big* place!) luxury flats as part of the proposed Silvertown Quays development. This would have gone ahead already except for the fact that the money was due to come from Bank of Scotland, who have recently had quite enough on their plate without funding more Docklands development!

Millennium Mills is a favourite destination for Urban Explorers and you’ll find loads of reports and internal photos on sites like 28DL. Urban Explorers are understandably rather tight-lipped about the exact way they gain access to buildings like the Mills; the best hints I could find online were ironically in an Evening Standard interview - basically from the old Rank Hovis mill you can.. well, work it out yourself! Judging from the chronological order most of the  photo sets I’ve seen come in, one might gain entrance to the site somewhere near the corner of North Woolwich Road and Mill Road and pass by the “D” silo (where the grain would originally have been removed from the ship,) before covering the ground to the main building.

So without further ado, the best links I can find, after some conderable Googling, to the dark, brooding, majestic and malevolent Millenium Mills. These are in no particular order…

http://www.google.co.uk/search?q=site:28dayslater.co.uk+millenium+mill (all the 28DL stuff)

http://www.forever-changes.com/Millenium%20Mills/Millenium%20Mills.htm

http://striped.online.fr/friched/inheritance/millennium/index.html

http://www.flickr.com/photos/paulholmes/sets/72057594070422686/

http://greenie.deviantart.com/art/Millenium-Mills-53431088

http://www.contaminationzone.com/Gallery9.php

http://www.derelictplaces.co.uk/main/showthread.php?t=4403

http://www.thederelictsensation.com/c_interviews/interviews2.htm

http://www.beyondthefence.fpic.co.uk/c1723487.html

http://mrswift.me.uk/derelict/Millenium%20Mills/

Hope you enjoy these photos as much as I did.

Obviously if you want to take your own photos, you take your own risk too. Please be very clear that this post is not an incitement to do so!

I think I got most of ‘em, but if I missed any good sets of photos, please comment. Thanks.

Tags: 3 Comments

Paste-in Keyword Density Calculator

August 11th, 2009 by alex
Respond

I just knocked this keyword density calculator together for my own use - there are plenty online that take a URL but I wanted one to automatically show the keyword density for offline documents - in other words I wanted to paste in the entire document, not just the URL.

Here’s the keyword density checker source - as you can see I’m using the standard English stopword list from Ranks.nl

The checker automatically calculates the density of every word and 2, 3 and 4 word phrases, ranking the output by density. It strips punctuation and HTML - I’m sure this bit isn’t perfect but it works most of the time.

I haven’t prettied it up either, but I hope its useful to you as is.

Feel free to use the source for anything you like, with no warranty given or implied. Of course I’d always appreciate a link to www.alexpoole.name if you find it useful :)

Tags:   · · · 3 Comments

PDFTK on Fedora Core 8 x86_64

July 30th, 2009 by alex
Respond

PDFTK rocks, but the fact you can’t just “yum install” it in FC8 doesn’t. You can read all the gory details somewhere else. This is just the solution.

Wow. That took nearly 2 hours Googling. I spent a while trying to make from source too… Nope :(

Just do what it says here:

http://thevedic.net/wordpress/2008/12/02/building-pdftk-pdf-toolkit-on-fc9/

(it worked for the x86_64  FC8 I’m using as well)

Be aware there are a *lot* of errors, but it gets there in the end :)

[root@xyz123]# rpm -ivh /usr/src/redhat/RPMS/x86_64/pdftk-1.41-5.fc8.x86_64.rpm

Preparing…                ########################################### [100%]

1:pdftk                  ########################################### [100%]

yea baby :)

Hope that helps you.

Tags: No Comments.