whos online widget not working in some configuration due a timezone mismatch

[francescolaffi]

problem described and solved in this forum post http://buddypress.org/forums/topic/whos-online-widget-not-working-think-its-a-mysql-timezone-problem

Short sum: last activity is stored as utc and compared to mysql NOW() that return the time in the server timezone.

Solution: change in bp-core-classes.php:139 (in the get_users function)

$sql['where_online'] = "AND DATE_ADD( um.meta_value, INTERVAL 5 MINUTE ) >= NOW()";

with

$sql['where_online'] = "AND DATE_ADD( um.meta_value, INTERVAL 5 MINUTE ) >= UTC_TIMESTAMP()";

Going to make a diff with this solution. If there are other queries that compare an utc timestamp with now() probably they should be changed too.

[NickRita]

The solution worked for me! wp 292, bp 123

[johnjamesjacoby]

Fixed by r2890.

[NickRita]

Okay, call was too early. The solution still works, BUT

I'm on UTC+2 (Germany).

The widget works, but now, in the list of messages, there is shown "message 30 minutes ago" althought it in fact was 2 hours and 30 minutes ago.

For me it is more important, that the widget works, but maybe someone can find a solution for the message-problem, too.

[apeatling]

Messages bug is unrelated.

[courtneybostdorff]

Hello, wow this is an old topic. I recently installed a fresh copy of both WP and BP. For whatever reason, the WHO's ONLINE widget shows me nothing though I have multiple users logged in at the same time. Also, the "RECENTLY ACTIVE MEMBERS" widget shows me nothing, however, the "MEMBERS" widget shows the members and their latest activity.

It seems that this topic has been resolved since 7 years ago as I can find no recent posts with the same issue. I attempted the solution in this post but the bp-core-classes.php file no longer contains the same code as it did back then.

I tried using the default wp theme, tried disabling all plugins and then reactivating to check for compatibility issues, tried removing and then adding the widgets, tried changing timezones.......but no dice.

Anyone have any suggestions? Thanks!

Courtney