Project

General

Profile

Bug #11209

Activity timestamp errors

Added by Matt Gold 2 months ago. Updated 28 days ago.

Status:
Resolved
Priority name:
Normal
Assignee:
Category name:
BuddyPress (misc)
Target version:
Start date:
2019-03-11
Due date:
% Done:

0%

Estimated time:

Description

I searched for Colin on the People page and it showed him as having been active 5 months ago. On his profile, I see he was active 3 days ago. I know we dealt previously with errors on the homepage activity timestamps; I'm not sure whether these are related. Screenshots attached


Related issues

Related to CUNY Academic Commons - Feature #10687: Stop mirroring BP last_activity to usermetaResolved2018-11-08

Related to CUNY Academic Commons - Bug #11388: Rewrite member search queriesResolved2019-04-23

History

#1 Updated by Matt Gold 2 months ago

BTW, Colin -- lest you think I was worried about your activity, I was just trying to find your profile page link so that I could update our staff page -- https://commons.gc.cuny.edu/about/project-staff/

#2 Updated by Boone Gorges 2 months ago

  • Assignee changed from Boone Gorges to Raymond Hoh

Ray, could you please bring your timestamp expertise to bear?

#3 Updated by Boone Gorges about 2 months ago

  • Target version set to 1.14.10

#4 Updated by Raymond Hoh about 1 month ago

  • Target version changed from 1.14.10 to 1.14.11

#5 Updated by Raymond Hoh 28 days ago

  • Status changed from Assigned to Staged for Production Release

The issue is we are using the legacy BuddyPress user query on the People page, which looks up the wrong last activity timestamp. The legacy query uses the timestamp from the user meta DB table instead of the activity DB table.

To fix this, we need to patch the legacy user query in BuddyPress. I've done so here - https://github.com/cuny-academic-commons/cac/commit/b6fca8943b14573c40bfcbea9e86c19ae55a34a2.

Boone, I'll open a ticket on BP Trac about this.

#6 Updated by Raymond Hoh 28 days ago

  • Related to Feature #10687: Stop mirroring BP last_activity to usermeta added

#7 Updated by Raymond Hoh 28 days ago

This bug popped up because we stopped mirroring last activity to user meta in #10687.

We might need to reinstate the user meta mirroring due to sorting by last active on the People page... the alternative is to rewrite the Members search to stop relying on the legacy user query.

#8 Updated by Boone Gorges 28 days ago

  • Status changed from Staged for Production Release to Resolved

#9 Updated by Raymond Hoh 28 days ago

The immediate timestamp display issue is resolved, but the sorting on the People page is incorrect due to stale last activity timestamps in usermeta.

Boone, can you let me know what you think about my last comment?

#10 Updated by Boone Gorges 28 days ago

Oh, sorry - I missed the question.

I'd say let's rewrite the query. I'll create a new ticket.

#11 Updated by Boone Gorges 28 days ago

  • Related to Bug #11388: Rewrite member search queries added

Also available in: Atom PDF