Changeset 2668

Timestamp:

02/11/2010 01:13:14 PM (15 years ago)

Author:

apeatling

Message:

Fixes #1884

Location:

trunk

Files:

• bp-activity.php (modified) (1 diff)
• bp-xprofile.php (modified) (1 diff)

trunk/bp-activity.php

@@ -18 +18 @@
 
     /* Rename the old user activity cached table if needed. */
-    if ( $wpdb->get_var( "SHOW TABLES LIKE '%{$wpdb->base_prefix}bp_activity_user_activity_cached%'" ) ) {
+    if ( $wpdb->get_var( "SHOW TABLES LIKE '%{$wpdb->base_prefix}bp_activity_user_activity_cached%'" ) )
         $wpdb->query( "RENAME TABLE {$wpdb->base_prefix}bp_activity_user_activity_cached TO {$bp->activity->table_name}" );
-    }
 
     /* Rename fields from pre BP 1.2 */
     if ( $wpdb->get_var( "SHOW TABLES LIKE '%{$bp->activity->table_name}%'" ) ) {
-        $wpdb->query( "ALTER TABLE {$bp->activity->table_name} CHANGE component_action type varchar(75) NOT NULL" );
-        $wpdb->query( "ALTER TABLE {$bp->activity->table_name} CHANGE component_name component varchar(75) NOT NULL" );
+        if ( $wpdb->get_var( "SHOW COLUMNS FROM {$bp->activity->table_name} LIKE 'component_action'" ) )
+            $wpdb->query( "ALTER TABLE {$bp->activity->table_name} CHANGE component_action type varchar(75) NOT NULL" );
+
+        if ( $wpdb->get_var( "SHOW COLUMNS FROM {$bp->activity->table_name} LIKE 'component_name'" ) )
+            $wpdb->query( "ALTER TABLE {$bp->activity->table_name} CHANGE component_name component varchar(75) NOT NULL" );
     }
 

trunk/bp-xprofile.php

@@ -77 +77 @@
 
     if ( '' == get_site_option( 'bp-xprofile-db-version' ) ) {
-        $sql[] = "INSERT INTO {$bp->profile->table_name_groups} VALUES ( 1, '" . get_site_option( 'bp-xprofile-base-group-name' ) . "', '', 0 );";
-
-        $sql[] = "INSERT INTO {$bp->profile->table_name_fields} (
-                    id, group_id, parent_id, type, name, is_required, can_delete
-                  ) VALUES (
-                    1, 1, 0, 'textbox', '" . get_site_option( 'bp-xprofile-fullname-field-name' ) . "', 1, 0
-                  );";
+        if ( !$wpdb->get_var( "SELECT id FROM {$bp->profile->table_name_groups} WHERE id = 1" ) )
+            $sql[] = "INSERT INTO {$bp->profile->table_name_groups} VALUES ( 1, '" . get_site_option( 'bp-xprofile-base-group-name' ) . "', '', 0 );";
+
+        if ( !$wpdb->get_var( "SELECT id FROM {$bp->profile->table_name_fields} WHERE id = 1" ) ) {
+            $sql[] = "INSERT INTO {$bp->profile->table_name_fields} (
+                        id, group_id, parent_id, type, name, is_required, can_delete
+                      ) VALUES (
+                        1, 1, 0, 'textbox', '" . get_site_option( 'bp-xprofile-fullname-field-name' ) . "', 1, 0
+                      );";
+        }
     }