[wp-trac] [WordPress Trac] #41785: I don't think the default date "0000-00-00 00:00:00" is good idea in MySQL 5.7+

WordPress Trac noreply at wordpress.org
Fri Sep 22 11:52:42 UTC 2017


#41785: I don't think the default date "0000-00-00 00:00:00" is good idea in MySQL
5.7+
--------------------------+------------------------
 Reporter:  kmvan         |       Owner:
     Type:  defect (bug)  |      Status:  closed
 Priority:  normal        |   Milestone:
Component:  Database      |     Version:  4.8.1
 Severity:  normal        |  Resolution:  duplicate
 Keywords:                |     Focuses:
--------------------------+------------------------
Changes (by dd32):

 * status:  reopened => closed
 * resolution:   => duplicate


Comment:

 @Collizo4sky I'm aware of the issue, and it's covered well in #8857

 Unfortunately many plugins expect the exact string "0000-00-00 00:00:00"
 Which is where the backwards compatibility issues come in, we can't simply
 change it easily.

 Further discussion should occur on #8857 in order to reduce as much
 duplication as possible.

 > Invalid default value for 'post_date'.
 If the correct sql modes are set (as they are during the WordPress
 install) then that warning shouldn't be hit, if you're getting that error
 from within WordPress (rather than through a sql import or other sql
 application) then extra details would be appreciated on how you're hitting
 it.

--
Ticket URL: <https://core.trac.wordpress.org/ticket/41785#comment:4>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform


More information about the wp-trac mailing list