WordPress.org

Make WordPress Core

Opened 9 years ago

Closed 7 years ago

Last modified 6 years ago

#16821 closed defect (bug) (wontfix)

WordPress does not work properly when particular sql_modes are set

Reported by: Dan1975 Owned by:
Milestone: Priority: normal
Severity: normal Version: 3.1
Component: Database Keywords: has-patch
Focuses: Cc:

Description (last modified by SergeyBiryukov)

When sql_mode contains NO_ZERO_DATE or NO_ZERO_IN_DATE WordPress does not allow to add a new post because invalid value errors (I could trace them with WP_DEBUG activated).

Attachments (1)

wp-includes__load.patch (935 bytes) - added by Dan1975 9 years ago.
Patch for running normally

Download all attachments as: .zip

Change History (5)

@Dan1975
9 years ago

Patch for running normally

#1 @SergeyBiryukov
8 years ago

  • Keywords has-patch added

#2 @pento
7 years ago

  • Resolution set to wontfix
  • Status changed from new to closed

Fixing this properly would involve changing the schema to use NULL instead of zero dates. This is not viable - there are thousands of plugins that expect the zero date format, which will all break horribly if we switch to NULL dates.

Changing the sql_mode is not a proper fix for this edge case.

#3 @nacin
7 years ago

  • Milestone Awaiting Review deleted

#4 @SergeyBiryukov
6 years ago

  • Description modified (diff)
  • Summary changed from Wordpress does not work properly when particulars sql_mode are set to WordPress does not work properly when particular sql_modes are set

Follow-up: #26847

Note: See TracTickets for help on using tickets.