[buddypress-trac] [BuddyPress] #1999: "There was a problem posting your update, please try again." when running MySQL in Strict Mode

[buddypress-trac at lists.automattic.com]

#1999: "There was a problem posting your update, please try again." when running
MySQL in Strict Mode
-------------------+--------------------------------------------------------
Reporter:  Zooney  |       Owner:     
    Type:  defect  |      Status:  new
Priority:  major   |   Milestone:     
Keywords:          |  
-------------------+--------------------------------------------------------

Comment(by Zooney):

 On attempting to post "Sooper dooper" into the activity box for an account
 called 'admin' I ended up with the following PHP error in my error log:

 php[1524]
 WordPress database error Field 'mptt_left' doesn't have a default value
 for query INSERT INTO wp_bp_activity ( user_id, component, type, action,
 content, primary_link, date_recorded, item_id, secondary_item_id,
 hide_sitewide ) VALUES ( 1, 'activity', 'activity_update', '<a
 href=\"http://localhost.localdomain/BuddyPress/members/admin/\"
 title=\"admin\">admin</a> posted an update:', 'Sooper dooper',
 'http://localhost.localdomain/BuddyPress/members/admin/', '2010-02-23
 21:35:11', '', '', 0 ) made b

-- 
Ticket URL: <http://trac.buddypress.org/ticket/1999#comment:3>
BuddyPress <http://buddypress.org/>
BuddyPress