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

WordPress Trac wp-trac at lists.automattic.com
Tue Feb 24 06:14:17 GMT 2009


#9224: sql-mode 'TRADITIONAL' breaks installation
--------------------------+-------------------------------------------------
 Reporter:  tsunami7      |       Owner:  anonymous                   
     Type:  defect (bug)  |      Status:  new                         
 Priority:  normal        |   Milestone:  2.7.2                       
Component:  General       |     Version:                              
 Severity:  normal        |    Keywords:  mysql, TRADITIONAL, sql-mode
--------------------------+-------------------------------------------------
 The installation script for WordPress relies on a bug in MySQL which
 allows invalid times and dates, as well as input which is not in an ENUM
 specification list.  In MySQL the solution for this problem is to set sql-
 mode = 'TRADITIONAL'

 But when the database server is set this way, the installation script for
 WordPress crashes while building the database.  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.

 WordPress should not rely on bugs in MySQL.

 This bug is related to #2148 which was supposedly fixed, but apparently
 the solution wasn't complete.

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


More information about the wp-trac mailing list