Schrödinger’s Mysql table – does it exist?

Schrödinger's Mysql table - does it exist?
Recently I ran in to a particularly odd database problem – a mysql table that both existed and didn’t at the same time. Queries were failing, reporting that the table didn’t exist. Yet when I tried to recreate this Schrödinger’s table, mysql insisted that it already existed, and wouldn’t recreate it. So what gives? The ...

Encoding a euro symbol in email subject lines

Encoding a euro symbol in email subject lines
Character encoding in PHP can be fun at the best of times. Trying to send a non-ASCII character in a html email – a euro symbol, for example – can be just such one of those times. Setting up html and text versions of a mail is pretty straight-forward. What gets a bit trickier is ...

Mysqldump syntax error fixed

Mysqldump syntax error fixed
Recently I needed to move a database I had running in RDS to a machine on a new digitalocean account. A simple enough process, the first step of which was to export the database from RDS, but I pretty quickly ran in to a mysqldump syntax error. 1234mysqldump: Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=1': You have ...

CSS & Javascript truncated by nginx 3

CSS & Javascript truncated by nginx
On several recent projects I’ve been using VirtualBox and Vagrant to spin up new development machines. The simplicity and power of the two tools together is amazing, and stops me from cluttering up my main machine with tools and packages from random side projects. It hasn’t been all sweetness and light though. I wrote recently ...

Symlink shenanigans – node.js, npm, express and vagrant 5

Symlink shenanigans - node.js, npm, express and vagrant
Recently I was working on a new project on a virtual box set up through vagrant. For those of you who haven’t used it, vagrant is an amazing tool that makes it crazy-easy to set up and deploy uniform development environments on virtual servers. However, I ran in to a very frustrating issue when trying ...

Share and share alike – Facebook Tags and Twitter Cards

Share and share alike - Facebook Tags and Twitter Cards
Recently we launched a Property Tax Calculator on Daft. It’s quite a topical tool, as the Revenue Commissioners have just sent out letters inviting people to self-assess their property value ahead of the the new tax introduction. Topical pages like this tend to get shared more often on social networks, so we took a few ...

The Daft.ie Property Tax Calculator – how does it work?

The Daft.ie Property Tax Calculator - how does it work?
Last week we launched a property tax calculator on Daft.ie. It’s a simple tool which asks for information on a property’s location, bedrooms, bathrooms and type, before giving an estimated value for the property. This in turn calculates the Local Property Tax (LPT) due to be paid when the new scheme starts in July. So, ...

Will valid markup now help your Google ranking?

Will valid markup now help your Google ranking?
Google recently published a list of 30 updates made to search over the tail end of 2011. Tucked away in the middle of the list is mention of improved support for rich snippets. The snippet types listed are shopping, recipes and reviews. Amongst the other information on rich snippets is listed a point that a ...

Malkovich Malkovich Malkovich

Malkovich Malkovich Malkovich
In the film Being John Malkovich, John Cusack plays a puppeteer who finds a portal to inside John Malkovich’s head. Eventually John Malkovich himself goes through this portal, and the ensuing paradox means that every word he hears is “Malkovich”, and every face he sees is his own. Re-watching this film lately gave me an ...

Programmatically Detect AdBlock Plus 4

Programmatically Detect AdBlock Plus
One issue that comes up time and again when working on classified sites such as Daft.ie and Adverts.ie is the inadvertent blocking of site functionality by the AdBlock Plus extension. As so many parts of classified sites will logically have phrases like “ad” in the url, legitimate site content and features can be blocked inadvertently ...