Changeset 1975

Timestamp:

12/18/04 21:21:50 (4 years ago)

Author:

saxmatt

Message:

Delete duplicate options.

Files:

• trunk/wp-admin/upgrade-functions.php (modified) (1 diff)
• trunk/wp-admin/upgrade-schema.php (modified) (1 diff)

trunk/wp-admin/upgrade-functions.php

@@ -198 +198 @@
-    $wpdb->query("UPDATE $wpdb->comments SET comment_type='pingback', comment_content = REPLACE(comment_content, '<pingback />', '') WHERE comment_content LIKE '<pingback />%'");
-
+    // Some versions have multiple duplicate option_name rows with the same values
+    $options = $wpdb->get_results("SELECT option_name, COUNT(option_name) AS dupes FROM `$wpdb->options` GROUP BY option_name");
+    foreach ( $options as $option ) {
+        if ( 1 != $option->dupes ) { // Could this be done in the query?
+            $limit = $option->dupes - 1;
+            $dupe_ids = $wpdb->get_col("SELECT option_id FROM $wpdb->options WHERE option_name = '$option->option_name' LIMIT $limit");
+            $dupe_ids = join($dupe_ids, ',');
+            $wpdb->query("DELETE FROM $wpdb->options WHERE option_id IN ($dupe_ids)");
+        }
+    }
-}
-

trunk/wp-admin/upgrade-schema.php

@@ -79 +79 @@
-  option_admin_level int(11) NOT NULL default '1',
-  autoload enum('yes','no') NOT NULL default 'yes',
-
+
+
-);
-CREATE TABLE $wpdb->post2cat (