BuddyPress.org

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