Make WordPress Core

Opened 19 years ago

Closed 18 years ago

#1620 closed defect (bug) (fixed)

Scheduled entries on Dashboard not ordering correctly.

Reported by: schulte's profile schulte Owned by:
Milestone: Priority: normal
Severity: trivial Version: 2.1
Component: Administration Keywords: bg|has-patch
Focuses: Cc:

Description

Let unfixed, the Scheduled Entries text on the Dashboard yields a list of entries in the order they were created instead of the correct post date/time order.

original wp-admin/index.php code:

if ( $scheduled = $wpdb->get_results("SELECT ID, post_title, post_date_gmt FROM $wpdb->posts WHERE post_status = 'publish' AND post_date_gmt > '$today'") ) :

corrected query:

if ( $scheduled = $wpdb->get_results("SELECT ID, post_title, post_date_gmt FROM $wpdb->posts WHERE post_status = 'publish' AND post_date_gmt > '$today' ORDER BY post_date_gmt") ) :

Attachments (1)

index.php.diff (363 bytes) - added by schulte 18 years ago.

Download all attachments as: .zip

Change History (4)

#1 @schulte
19 years ago

  • Keywords bg|2nd-opinion added

@schulte
18 years ago

#2 @schulte
18 years ago

  • Keywords bg|has-patch added; bg|2nd-opinion removed
  • Severity changed from normal to trivial
  • Version changed from 1.5.2 to 2.1

#3 @schulte
18 years ago

  • Resolution set to fixed
  • Status changed from new to closed
Note: See TracTickets for help on using tickets.