Skip to:
Content
Pages
Categories
Search
Top
Bottom

Broken activity

  • Avatar of Arghagain
    arghagain
    Participant

    @arghagain

    Even before the upgrade of wpmu 2.8.5.2, I was using 2.4.8a and buddypress 1.1.2, the problem is that site wide activity, and each member’s activity, and rss feed for activity is completely broken. It’s not working at all. I remember buddypress 1.1.0 has no problem of such. Is there a way to fix the activity?

Viewing 5 replies - 1 through 5 (of 5 total)
  • Avatar of John James Jacoby
    John James Jacoby
    Keymaster

    @johnjamesjacoby

    (I renamed your topic since the title wasn’t very clear. Don’t worry we don’t mess with other peoples posts very often.)

    I’m in the process of updating to 2.8.5.2 so I’ll let you know what I find out…

    Avatar of levin
    levin
    Participant

    @levinng

    i was getting similar behavior, a user commented on a main blog post, but the entry didnt shown up in RSS feed. Somewhat 19 hour later, the entry raise in RSS feed. weird!

    the site is running 2.8.4a and 1.1.2 BP without caching stuff.

    Avatar of Arghagain
    arghagain
    Participant

    @arghagain

    I hope this post help some of smart people on buddypress.org to help me figure out an easy solution to this problem. http://premium.wpmudev.org/forums/topic/activity-broken-for-buddypress-112-and-wpmu-2852

    Avatar of Arghagain
    arghagain
    Participant

    @arghagain

    bump

    Avatar of Arghagain
    arghagain
    Participant

    @arghagain

    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?

Viewing 5 replies - 1 through 5 (of 5 total)

You must be logged in to reply to this topic.