Changeset 2668

Timestamp:

02/11/2010 01:13:14 PM (17 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
+                                          );";
+                }
         }