[wp-trac] Re: [WordPress Trac] #9224: sql-mode 'TRADITIONAL' breaks installation

[WordPress Trac]

#9224: sql-mode 'TRADITIONAL' breaks installation
--------------------------+-------------------------------------------------
 Reporter:  tsunami7      |       Owner:  anonymous        
     Type:  defect (bug)  |      Status:  new              
 Priority:  normal        |   Milestone:  2.8              
Component:  General       |     Version:  2.7              
 Severity:  normal        |    Keywords:  reporter-feedback
--------------------------+-------------------------------------------------
Changes (by DD32):

  * keywords:  mysql, TRADITIONAL, sql-mode => reporter-feedback
  * version:  => 2.7
  * milestone:  2.7.2 => 2.8


Comment:

 See Also: #8857

 > The installation script for WordPress relies on a bug in MySQL which
 allows invalid times and dates

 I'm not aware of any times when WordPress stores a non-valid date
 (Excluding the Zero value)

 >  There are numerous dateTime fields which have a default set to
 '0000-00-00 00:00:00' These values are not allowed when sql-mode is set to
 TRADITIONAL.

 Looking through the manual, I don't see anything defining this, It does
 say that DateTime's have to have valid data, however, that the Zero value
 ('0000-00-00 00:00:00') Is still valid - I dont see how it couldn't be
 valid either, It would be hideously stupid to require a date all the time,
 there are many use-cases(like this) where the date will not be known.



 Can you supply the '''exact''' config (or something that allows for
 reproduction) under which !WordPress/MySQL has the errors?(ie. That forces
 you to set traditional mode)

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/9224#comment:1>
WordPress Trac <http://trac.wordpress.org/>
WordPress blogging software