Skip to:
Content
Pages
Categories
Search
Top
Bottom

Not being able to post any updates…

  • Avatar of Marcus
    Marcus
    Participant

    @netweblogic

    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)
  • Avatar of r-a-y
    r-a-y
    Moderator

    @r-a-y

    Did you upgrade from a previous version of BP?

    Or is this a fresh install of BP 1.2?

    Avatar of Marcus
    Marcus
    Participant

    @netweblogic

    I got this for a fresh install of WP 2.9.1.1 + BP 1.2 and also for an upgraded 2.9.1.1 + 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)

You must be logged in to reply to this topic.