php-activerecord
php-activerecord copied to clipboard
jpfuentes2
MySQL Invalid date exception
Depending on your MySQL configuration, errors like this can appear:
PDOException' with message 'SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '2014-07-19 09:59:36 UTC' for column 'updated_at' at row 1
The error does make sense, because MySQL does not know about timezone (UTC part).
So I tried to find where it does add the timezone, but yet without success.
This error can be suppressed, (or ignored?) by removing STRICT_TRANS_TABLES from the sql_mode: http://dev.mysql.com/doc/refman/5.1/en/sql-mode.html#sqlmode_strict_trans_tables
Just poking my nose in but isn't this similar to https://github.com/jpfuentes2/php-activerecord/issues/412 ?
You can also start mysql server with --sql-mode=ALLOW_INVALID_DATES switch.
more disturbingly, this is what I pushed #317 over a year ago to fix, but it still hasn't gotten merged. koenpunt is apparently starting to work on it now.
@andyleap I think he hasn't :)
Why not just setting \ActiveRecord\Connection::$datetime_format = 'Y-m-d H:i:s'; prior to creating the connection?
It seems to fix the issue for me (after migrating from PHP 5.6 to PHP 7 and from MySQL 5.6 to MySQL 5.7)
