Changeset 8921 for trunk/wp-admin/includes/upgrade.php

Timestamp:

09/17/2008 09:47:27 PM (15 years ago)

Author:

ryan

Message:

Update post_date for old drafts during upgrade. see #5698

File:

• trunk/wp-admin/includes/upgrade.php (modified) (3 diffs)

trunk/wp-admin/includes/upgrade.php

@@ -211 +211 @@
         upgrade_260();
 
-    if ( $wp_current_db_version < 8539 )
+    if ( $wp_current_db_version < 8921 )
         upgrade_270();
 
@@ -753 +753 @@
 
 function upgrade_260() {
+    global $wp_current_db_version;
+
     if ( $wp_current_db_version < 8000 )
         populate_roles_260();
@@ -763 +765 @@
 
 function upgrade_270() {
+    global $wpdb, $wp_current_db_version;
+
     if ( $wp_current_db_version < 8530 )
         populate_roles_270();
+
+    // Update post_date for unpublished posts with empty timestamp
+    if ( $wp_current_db_version < 8921 )
+        $wpdb->query( "UPDATE $wpdb->posts SET post_date = post_modified WHERE post_date = '0000-00-00 00:00:00'" );
 }