Doing a web-based installation of C5 5.3.2 with Apache 2.2.12, PHP5 5.2.10, MySQL server 5.1.34-standard-log. Installation seems to begin since it creates a few tables but croaks before finishing:

==

mysql> show tables;
+---------------------+
| Tables_in_mydb_c5 |
+---------------------+
| AreaGroupBlockTypes |
| AreaGroups |
| Areas |
| BlockRelations |
| BlockTypes |
+---------------------+
5 rows in set (0.00 sec)


mysql error: [1067: Invalid default value for 'bDateAdded'] in EXECUTE("CREATE TABLE Blocks ( bID INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT, bName VARCHAR(60), bDateAdded DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', bDateModified DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', bFilename VARCHAR(32), bIsActive VARCHAR(1) NOT NULL DEFAULT '1', btID INTEGER(10) UNSIGNED NOT NULL DEFAULT 0, uID INTEGER(10) UNSIGNED, PRIMARY KEY (bID) )")

==

Looks like MySQL's not happy about DATETIMEs looking like "0000-00-00 00:00:00".

Anyone seen this happening, or any ideas for a fix?


***********************
RESOLVED

Hacked concrete/config/db.xml setting DATETIME defaults to DEFAULT value="1970-01-01 00:00:00"
***********************