[buddypress-trac] [BuddyPress Trac] #5404: Can't go on the latest page of "Members"

[buddypress-trac]

#5404: Can't go on the latest page of "Members"
-------------------------------+------------------------------
 Reporter:  elpix              |       Owner:
     Type:  defect (bug)       |      Status:  new
 Priority:  highest            |   Milestone:  Awaiting Review
Component:  Members            |     Version:  1.9.2
 Severity:  critical           |  Resolution:
 Keywords:  reporter-feedback  |
-------------------------------+------------------------------

Comment (by elpix):

 Hi !

 I've maybe an idea.

 As some users have never been active on my website, I had to activate them
 manually like that :

 {{{
 $users = $wpdb->get_results("
 SELECT  `ID` ,  `user_registered`
 FROM  `wp_users`
 WHERE ID NOT
 IN (

 SELECT DISTINCT (
 user_id
 )
 FROM  `wp_usermeta`
 WHERE  `meta_key` =  'lastvisit'
 OR  `meta_key` =  'last_activity'
 )
 ");

 foreach($users as $user){
         $wpdb->query("INSERT IGNORE INTO wp_usermeta(user_id , meta_key ,
 meta_value) VALUES (".$user->ID." , 'lastvisit' ,
 '".$user->user_registered."')");
         $wpdb->query("INSERT IGNORE INTO wp_usermeta(user_id , meta_key ,
 meta_value) VALUES (".$user->ID." , 'last_activity' ,
 '".$user->user_registered."')");

 }
 }}}

 As many of them had this problem, it's maybe the source of the bug !

--
Ticket URL: <https://buddypress.trac.wordpress.org/ticket/5404#comment:7>
BuddyPress Trac <http://buddypress.org/>
BuddyPress Trac