WordPress Automatic Upgrades - One of the pitfalls

This morning I woke up to announcements of a security upgrade (3.0.4) for WordPress. It is highly recommended that everyone upgrade their installs. I set to the task of upgrading this and a couple of other websites I look after. All of my sites are on 3.0,…

How to view and extract Plesk backups

Have you ever had a minor developmental nightmare and needed quick access to a Plesk backup? Lost some data or needed a reference point and just wanted to get at a database's SQL without having to do a full restore? Perhaps you've just wondered what a Plesk backup was &…

WordPress: link_before and link_after don't display in wp_list_pages

Have you ever stumbled across the issue where wp_list_pages isn't spitting out the text you define for link_before and link_after? I came across this some time ago: one minute my lovely pipe bars '|' where there, the next they weren't. It turns out this is…

Getting Rid of Non Breaking Spaces (&nbsp)

Have you ever tried to parse, process or preg_replace some HTML? Ever tried to do it when the HTML is UTF-8 encoded? Getting rid of white space can be tricky, here's a few tricks I've learned. I was playing around with debugging some HTML output from Symfony the other…

Upgrading old WordPress installs - not as scary as you think!

Earlier this week I received an email requesting some help with a WordPress install that had been hacked. The site was almost 3 years old and was still running WordPress 2.2. It was quite funny getting to see and play with retro WordPress again, but it had to go.…

Snippet: Creating & Debugging Complex SQL queries in Symfony

When working with large and complex datasets in Symfony, there comes a point where the ORM layer (Propel or Doctrine) causes more problems than it solves. Sometimes it's necessary to debug large SQL queries built using the ORM layer, and at other times it'sĀ appropriate to bypass the ORM layer…