[buddypress-trac] [BuddyPress] #1234: Activity Stream SQL Error

[buddypress-trac at lists.automattic.com]

#1234: Activity Stream SQL Error
------------------------+---------------------------------------------------
Reporter:  netweblogic  |       Owner:       
    Type:  defect       |      Status:  new  
Priority:  critical     |   Milestone:  1.1.2
Keywords:               |  
------------------------+---------------------------------------------------
 BP 1.1.1 WPMU 2.8.4

 I get the following SQL error when doing anything that merits an activity
 logging (Solution worked below):

 [15-Oct-2009 03:31:51] WordPress database error: [Field
 'date_cached' doesn't have a default value]
 INSERT INTO wp_bp_activity_user_activity_cached ( user_id, component_name,
 component_action, content, primary_link, date_recorded, item_id,
 secondary_item_id, hide_sitewide ) VALUES ( 9, 'profile',
 'new_wire_post', '<a
 href=\"http://x.com/members/x/\">x</a> wrote on their
 own wire: <span class=\"time-
 since\">%s</span><blockquote><p>x</p>\n</blockquote>',
 'http://x.com/members/x/', FROM_UNIXTIME(1255548711),
 '344', '', 0 )

 Solution:
 Allow the date_cached field to be null.

 ALTER TABLE `wp_bp_activity_user_activity_cached` CHANGE `date_cached`
 `date_cached` DATETIME NULL DEFAULT NULL

-- 
Ticket URL: <http://trac.buddypress.org/ticket/1234>
BuddyPress <http://buddypress.org/>
BuddyPress