sql-mode 'TRADITIONAL' breaks installation
|Reported by:||tsunami7||Owned by:||anonymous|
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.
Change History (9)
- Keywords reporter-feedback added; mysql TRADITIONAL sql-mode removed
- Milestone changed from 2.7.2 to 2.8
- Version set to 2.7