I have encountered this issue while installing demo data for the Magetique design theme:
Remove the NO_ZERO_DATE flag from the sql-mode option, and then restart the MySQL server.
NO_ZERO_DATE
sql-mode