[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:  1.2.2
Keywords:  strict mode, mysql  |  
-------------------------------+--------------------------------------------

Comment(by Zooney):

 I just noticed that the complete error text was cut off in the system log.
 The full error for user 'admin' posting 'Update.' looks like this:

 [24-Feb-2010 14:23:43] 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:', 'Update.',
 'http://localhost.localdomain/BuddyPress/members/admin/', '2010-02-24
 14:23:43', '', '', 0 ) made by require_once, require_once, do_action,
 call_user_func_array, bp_core_add_ajax_hook, do_action,
 call_user_func_array, bp_dtheme_post_update, bp_activity_post_update,
 bp_activity_add, BP_Activity_Activity->save

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