Changeset 49572

Timestamp:

11/12/2020 05:53:41 PM (4 years ago)

Author:

SergeyBiryukov

Message:

Database: Clean up the post_category column removed from DB schema for new installations in WordPress 2.8.

Its presence may conflict with WP_Post::__get(), which should generally fill the non-existent post_category property, but is not triggered if the column exists in the database.

Follow-up to [10895].

Props leogermani, davidbaumwald, hellofromTonya.
Fixes #51288.

Location:

trunk/src

Files:

• wp-admin/includes/upgrade.php (modified) (2 diffs)
• wp-includes/version.php (modified) (1 diff)

trunk/src/wp-admin/includes/upgrade.php

@@ -875 +875 @@
     }
 
+    if ( $wp_current_db_version < 49572 ) {
+        upgrade_560();
+    }
+
     maybe_disable_link_manager();
 
@@ -2238 +2242 @@
 
 /**
+ * Executes changes made in WordPress 5.6.0.
+ *
+ * @ignore
+ * @since 5.6.0
+ */
+function upgrade_560() {
+    global $wpdb;
+
+    // Clean up the `post_category` column removed from schema in version 2.8.0.
+    // Its presence may conflict with WP_Post::__get().
+    $post_category_exists = $wpdb->get_var( "SHOW COLUMNS FROM $wpdb->posts LIKE 'post_category'" );
+    if ( ! is_null( $post_category_exists ) ) {
+        $wpdb->query( "ALTER TABLE $wpdb->posts DROP COLUMN `post_category`" );
+    }
+}
+
+/**
  * Executes network-level upgrade routines.
  *

trunk/src/wp-includes/version.php

@@ -21 +21 @@
  * @global int $wp_db_version
  */
-$wp_db_version = 49534;
+$wp_db_version = 49572;
 
 /**