[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