ZF-8365: Zend_Log_Writer_Db fails on MySQL
Zend_Log_Writer_Db fails on MySQL due to an incorrect date format being used.
Zend_Log creates timestamps in an ISO-8601 format including the timezone, using date('c').
MySQL can not write this data to a datetime field:
Input: 2009-11-21T03:35:13+01:00 Output: Zend_Db_Exception with text: SQLSTATE: Invalid datetime format: 1292 Incorrect datetime value: '2009-11-21T03:56:33+01:00' for column 'timestamp' at row 1
Problem seems to be with the timezone; MySQL manual makes no mention of the timezone at all, and removing it from the input renders it valid to MySQL.
Current Zend_Log_Writer_Db is unusable with MySQL in its default state (no column mapping), so considering this a major issue.