I was trying to add a new column to an old table and I ran into a problem:

Error running query: ALTER TABLE table ADD COLUMN column1 VARCHAR(255) NOT NULL
SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect date value: '0000-00-00' for column 'column' at row 2

It turns on something similar to this problem has existed for a long time (http://bugs.mysql.com/bug.php?id=33240) and the fix is to run the command below before running the alter:

set SQL_MODE = '';