[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
--------------------------+-------------------------------------------------

Comment(by tsunami7):

 Probably correct.

 I doubt most MySQL admins have even run into this problem.  It's a pretty
 obscure bug that I ran into in one of my production machines, which forced
 me to start setting things up this way.

 However the change to the schema should be pretty trivial.  Just pick a
 valid date as the default, and never use it again.  The only problem would
 be if the WP code is using those default dates somewhere.  Hopefully it
 isn't.  In theory fixing this should make WP more portable to alternate DB
 servers.

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