Make WordPress Core

Opened 11 years ago

Closed 5 years ago

Last modified 5 years ago

#25347 closed defect (bug) (fixed)

mysql2date() limitation for scheduled posts

Reported by: nofearinc's profile nofearinc Owned by: sergeybiryukov's profile SergeyBiryukov
Milestone: 5.3 Priority: normal
Severity: normal Version: 3.0
Component: Date/Time Keywords: has-patch has-unit-tests
Focuses: Cc:


The latest Theme Unit Test data is available here for theme reviewers (and theme developers) to test against.

There is a post scheduled for year 2050. During the import process in wp_insert_post there is this snippet:

    } elseif( 'future' == $post_status ) {
                $now = gmdate('Y-m-d H:i:59');
              if ( mysql2date('U', $post_date_gmt, false) <= mysql2date('U', $now, false) )
                      $post_status = 'publish';

mysql2date uses strtotime and the future date could return false which would update the status of the future post to publish.

This is probably related to the date limitation for 32-bit systems, as described on

    The valid range of a timestamp is typically from Fri, 13 Dec 1901
 20:45:54 UTC to Tue, 19 Jan 2038 03:14:07 UTC. (These are the dates
 that correspond to the minimum and maximum values for a 32-bit
 signed integer.)

Since that's still fine given the current date, it might be a minor issue, but it's being exposed in a use case such as the import process where a future post is being published instead while migrating to another site.

For that specific use case scenario adding a non-false check would help, but is probably an overhead:

if ( false !== mysql2date('U', $post_date_gmt, false) && mysql2date('U', $post_date_gmt, false) <= mysql2date('U', $now, false) )

Attachments (1)

wp-insert-post-future-comparison.patch (1.9 KB) - added by Rarst 5 years ago.

Download all attachments as: .zip

Change History (10)

#1 @Rarst
11 years ago

  • Cc contact@… added

#2 @SergeyBiryukov
11 years ago

  • Keywords reporter-feedback removed
  • Version changed from 3.6.1 to 3.0

Introduced in [14062].

#3 @nofearinc
11 years ago

The Theme Reviewers team updated the Test data to 2020 to avoid issues until this one is resolved in some way.

#4 @chriscct7
9 years ago

  • Keywords needs-patch needs-unit-tests added
  • Severity changed from minor to normal

The year 2038 problem is going to come up more and more.

#7 @Rarst
5 years ago

  • Keywords has-patch has-unit-tests added; needs-patch needs-unit-tests removed

Changed to string comparison to not depend on int range and added unit test.

This ticket was mentioned in Slack in #core-datetime by rarst. View the logs.

5 years ago

#9 @SergeyBiryukov
5 years ago

  • Milestone set to 5.3
  • Owner set to SergeyBiryukov
  • Status changed from new to reviewing

#10 @SergeyBiryukov
5 years ago

  • Resolution set to fixed
  • Status changed from reviewing to closed

In 45851:

Date/Time: In wp_insert_post(), when checking the post date to set future or publish status, use string comparison to work around far future dates (year 2038+) on 32-bit systems.

Props Rarst, nofearinc.
Fixes #25347.

#11 @SergeyBiryukov
5 years ago

In 45852:

Coding Standards: Fix WPCS violations in [45851].

See #25347.

Note: See TracTickets for help on using tickets.