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

WordPress Trac wp-trac at lists.automattic.com
Wed Feb 25 01:26:34 GMT 2009

#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):

 See http://dev.mysql.com/doc/refman/5.1/en/server-sql-

 Zero dates are not allowed when using TRADITIONAL.  This mode is used to
 "Make MySQL behave like a “traditional” SQL database system. A simple
 description of this mode is “give an error instead of a warning” when
 inserting an incorrect value into a column." - from the top of that

 The reason I found out about this is, the standard configuration of MySQL
 allows you to insert an empty string, even when the column type is an ENUM
 and the field is set to NOT NULL.  This caused a major problem in another
 database, so now I configure all installations to act according the SQL

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

More information about the wp-trac mailing list