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 2

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, ...

Talking to Joe: What’s a mention by Joe Duffy worth? 1

Talking to Joe: What's a mention by Joe Duffy worth?
Yesterday on Daft we launched a Property Tax Calculator. The idea is to try to help homeowners estimate their property value ahead of the introduction of the Local Property Tax (LPT) this summer. Initial feedback we’ve received on it has been quite positive, not least because it’s a little more detailed than the tool which ...

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 ...

A 3 minute phone call, a €300 saving!

A 3 minute phone call, a €300 saving!
A brief departure from the usual tech-orientated posts around here… Recently my car insurance came up for renewal. As my insurance last year was with Quinn Direct, I received a renewal quote from them automatically in the post. In 2010 I paid a little over €600 for a year’s cover. The renewal quote came through ...