Opened 2 years ago

Closed 9 months ago

Last modified 9 months ago

#16821 closed defect (bug) (wontfix)

Wordpress does not work properly when particulars sql_mode are set

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

Description

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 2 years ago.
Patch for running normally

Download all attachments as: .zip

Change History (4)

Dan1975 — 2 years ago

Patch for running normally

comment:1   SergeyBiryukov — 22 months ago

  • Keywords has-patch added

comment:2   pento — 9 months 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.

comment:3   nacin — 9 months ago

  • Milestone Awaiting Review deleted
Note: See TracTickets for help on using tickets.