Skip to:

Re: Site Wide Activity Widget not working

Jeff Sayre


Roy, what I think happened is that your activity tables were rewritten when you installed the most recent BP trunk. If you’ve been using the tagged version of 1.0.3 ( the one that is available via the big, orange download button) and not the trunk version of 1.0.3, then this is what happened.

In the newest version of BP, two of the original three activity tables are eliminated. Going forward, only one table is required. When you upgraded your live site to trunk, it eliminated two of the tables. When you reinstalled the earlier version (the tagged version 1.0.3) it reinstalled the two tables that were eliminated. But, they would have no data to display–at least at first.

Look at bp-activity.php in your 1.0.3 reinsall. Does the first line say thing?

define ( 'BP_ACTIVITY_DB_VERSION', '1300' );

Now, look at the bp-activity.php file from the most recent trunk (r1643 at the time of this post). Do you see the change in the schema-especially these lines of code?

/* 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" );

With the older version now reinstalled, and data being written back to the old tables, are you starting to see activity being reported in the widget?

Skip to toolbar