Skip to:
Content

Opened 9 years ago

Closed 9 years ago

#1234 closed defect (bug) (no action required)

Activity Stream SQL Error

Reported by: netweblogic Owned by:
Milestone: 1.1.2 Priority: critical
Severity: Version:
Component: Keywords:
Cc:

Description

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

Change History (1)

#1 @DJPaul
9 years ago

  • Resolution set to invalid
  • Status changed from new to closed

Works for me.

Note: See TracTickets for help on using tickets.