[wp-trac] Re: [WordPress Trac] #9224: sql-mode 'TRADITIONAL' breaks
installation
WordPress Trac
wp-trac at lists.automattic.com
Tue Feb 24 06:35:43 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
--------------------------+-------------------------------------------------
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
More information about the wp-trac
mailing list