Thanks Christian, that fixed it.

Did this have something to do with MySQL running in strict mode?