[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:  critical            |   Milestone:  1.2.2
Keywords:  strict mode, mysql  |  
-------------------------------+--------------------------------------------
Changes (by netweblogic):

 * cc: marcus@… (added)


Comment:

 I get this too.

 Fix can be done either in the code SQL statements by adding inserts for
 mptt left and righ, or just editing the SQL.

 To fix it on the current 1.2.x releases:
 ALTER TABLE  `wp_bp_activity` CHANGE  `mptt_left`  `mptt_left` INT( 11 )
 NOT NULL DEFAULT  '0',
 CHANGE  `mptt_right`  `mptt_right` INT( 11 ) NOT NULL DEFAULT  '0'

 To fix it for future BP release:
 bp-activity.php replace lines 47-48 with :
                                 mptt_left int(11) NOT NULL DEFAULT '0',
                                 mptt_right int(11) NOT NULL DEFAULT '0',

 Sorry, don't use SVN much so couldn't generate a patch... must learn to do
 that actually....

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