Changeset 5953

Timestamp:

03/29/2012 11:46:45 PM (13 years ago)

Author:

boonebgorges

Message:

Revert part of r5490, which suggests a date_recorded index for the main activity query. This causes problems when viewing single item activity streams. See #4045

File:

• trunk/bp-activity/bp-activity-classes.php (modified) (1 diff)

trunk/bp-activity/bp-activity-classes.php

@@ -107 +107 @@
         $select_sql = "SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name";
 
-        $from_sql = " FROM {$bp->activity->table_name} a USE INDEX (date_recorded) LEFT JOIN {$wpdb->users} u ON a.user_id = u.ID";
+        $from_sql = " FROM {$bp->activity->table_name} a LEFT JOIN {$wpdb->users} u ON a.user_id = u.ID";
 
         // Where conditions