BuddyPress.org

OK, I saw this in bp-activity.php:

/* Drop the old sitewide and user activity tables */

$wpdb->query( “DROP TABLE IF EXISTS {$wpdb->base_prefix}bp_activity_user_activity” );

$wpdb->query( “DROP TABLE IF EXISTS {$wpdb->base_prefix}bp_activity_sitewide” );

And so I look in the db and saw there is no bp_activity_user_activity table, and there is no bp_activity_sitewide table. This means it’s a good thing since these got dropped.

Though I saw this

$sql[] = “CREATE TABLE {$bp->activity->table_name}

but to my lack of knowledge of programming, I see this and think it’s bp_activity_something (but no idea)…

Looked everywhere and I only saw this in db bp_activity_user_activity_cached. This table doesn’t look like it was created by

$sql[] = “CREATE TABLE {$bp->activity->table_name}, but I could be wrong because I looked at the part under $sql[] = “CREATE TABLE {$bp->activity ->table_name} and saw similar rows get created and these rows are in my bp_activity_user_activity_cached table.

For example, in bp-activity.php,

function bp_activity_install() {

global $wpdb, $bp;

if ( !empty($wpdb->charset) )

$charset_collate = “DEFAULT CHARACTER SET $wpdb->charset”;

$sql[] = “CREATE TABLE {$bp->activity->table_name} (

id bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY,

user_id bigint(20) NOT NULL,

component_name varchar(75) NOT NULL,

component_action varchar(75) NOT NULL,

content longtext NOT NULL,

primary_link varchar(150) NOT NULL,

item_id varchar(75) NOT NULL,

secondary_item_id varchar(75) NOT NULL,

date_recorded datetime NOT NULL,

hide_sitewide bool DEFAULT 0,

KEY date_recorded (date_recorded),

KEY user_id (user_id),

KEY item_id (item_id),

KEY component_name (component_name)

) {$charset_collate};”;

require_once( ABSPATH . ‘wp-admin/upgrade-functions.php’ );

dbDelta($sql);

In my current db, table bp_activity_user_activity_cached has everything except hide_sitewide row. In my current db, table bp_activity_user_activity_cached has extra rows that function_bp_activity_install doesn’t have such as date_cached and is_private rows.

Any suggestion? What rows should I add or remove? Am I looking at the right stuff?

Looked like at the end of the function bp_activity_install(), it has require_once( ABSPATH . ‘wp-admin/upgrade-functions.php’ );

dbDelta($sql);

Maybe the upgrade-functions.php had not gone smoothly?