Friendship request mystery.
Boone, Matt suggested I send this to you.
User Doris Grassbauer (https://commons.gc.cuny.edu/members/dgrasserbauer/) says she received a Friendship accepted notification from someone (Jean Eddy Saint Paul - http://cuny.is/drsaintpaul2016) she never sent a friendship invite to. She has sent other Friendship requests in the past. Do you have the power to see her requests? (In case she sent it a long time ago and forgot) Is there any possibility that Jean Eddy Saint Paul sent the request to her?
#2 Updated by Boone Gorges about 1 year ago
Some very odd things happening here. Looping in Ray for any thoughts.
I can confirm that, around 6pm on Dec 28, 71 friend requests were generated that had this member as a recipient. Obviously, it's unlikely that 71 people would send this request at the same time, so something weird is afoot.
I looked at the access logs for this period, and nothing jumped out as odd. Certainly, there's no series of 71 requests that would generate these friendship items separately, so whatever happened must have piggybacked on one or more normal-looking requests.
In what might be a related issue, the user's friends page https://commons.gc.cuny.edu/members/drsaintpaul2016/friends/ was reporting over 1400 friends in the pagination, with most of the last 1390 pages or so consisting of a single user. On further investigation, it appears that about 40 users in our database had more than one entry for 'last_activity', which was throwing off user counts (in the case of one user, there were over 1600 entries). I'm not sure how this happened. I ran a script to clean it up (deleted all 'last_activity' entries for these users, with the exception of the most recent one) and now pagination is looking correct.
Ray, any ideas?
#9 Updated by Boone Gorges about 1 year ago
- Status changed from New to Resolved
Here is a description of the bug and its proper fix: https://github.com/boonebgorges/invite-anyone/issues/141
I'll leave my hotfix in place until 1.10.7, when we'll get the proper fix from upstream.