[wp-trac] [WordPress Trac] #22194: PHP x64 compatibility issue with date values

[WordPress Trac]

#22194: PHP x64 compatibility issue with date values
-----------------------------+--------------------------
 Reporter:  Whissi           |       Type:  defect (bug)
   Status:  new              |   Priority:  normal
Milestone:  Awaiting Review  |  Component:  General
  Version:                   |   Severity:  major
 Keywords:                   |
-----------------------------+--------------------------
 Hi,

 seems like WordPress is using the "0000-00-00 00:00:00" value as magic
 value for date values, which aren't set instead of NULL.

 This is working fine for any PHP x86 builds, because the magic value is
 also an invalid date.

 But PHP x64 builds support this value. It is no longer invalid. It is now
 a valid date! This will result in problems, because some functions are
 expecting that parsing this date will return false, but now on x64 systems
 they won't get an invalid date, when they are expecting one.

 So the problem is, that WordPress is using a valid date as magic value for
 an invalid date aka default value.

 Fixing this issue will require a SQL schema change and to update all the
 code, checking for "0000-00-00 00:00:00"...

 For references, see ticket #21987 and
 https://bugs.php.net/bug.php?id=53662

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