Skip to:

Not being able to post any updates…

  • Marcus (aka @msykes)


    I’m having some serious difficulties upgrading or installing 1.2! One problem is that once I do get the plugin to install and activate correctly, I can’t post updates. My error log says something like:

    WordPress database error Field ‘mptt_left’ doesn’t have a default value for query INSERT INTO wp_bp_activity (

    Surely enough, BP_Activity_Activity->save() doesn’t pass the mptt_left and _right fields, which can’t be null in the database.

    Simply making these null in the db, or correcting bp-activity/bp-activity-classes.php:75 to:

    $q = $wpdb->prepare( "INSERT INTO {$bp->activity->table_name} ( user_id, component, type, action, content, primary_link, date_recorded, item_id, secondary_item_id, hide_sitewide, mptt_left, mptt_right ) VALUES ( %d, %s, %s, %s, %s, %s, %s, %s, %s, %d, %d, %d )", $this->user_id, $this->component, $this->type, $this->action, $this->content, $this->primary_link, $this->date_recorded, $this->item_id, $this->secondary_item_id, $this->hide_sitewide, $this->mptt_left, $this->mptt_right );

    does the trick. However, I can’t find any further complaints about the issue, which is puzzling given the severity of it, so my question is, is anyone having this problem too? If so I’ll submit this to trac

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

  • r-a-y


    Did you upgrade from a previous version of BP?

    Or is this a fresh install of BP 1.2?

    Marcus (aka @msykes)


    I got this for a fresh install of WP + BP 1.2 and also for an upgraded + BP 1.2

    I think this must be a bug, because the SQL statement is missing two non-null fields, and the SQL in the buddypress plugin that creates the MYSQL tables shows it is not-null either.

    Do you not have this problem r-a-y?

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Not being able to post any updates…’ is closed to new replies.
Skip to toolbar