XF 2.2 Newest Members Widget showing recent user upgrades

[bengineer]

Hi,

One of our long standing forum members (from 2012) has recently started seeing his username in the Newest Members widget. The only recent change he did was to upgrade his account with a paid subscription. Does the Newest Members Widget ignore a user's join date when upgrading a subscription?

Thanks,

Ben

 

[Paul B]

The date the member registered should be the one which is used for the widget.

Can you link to where it's happening?

 

[bengineer]

Home

www.a2oc.net

In this Newest Members section there’s a user called Colin 540. His join date is 2012. The only thing he did recently was pay for an upgrade.

I’m using latest build.

Thanks

Ben

 

[Paul B]

This is what I see:

 

[bengineer]

Ah. We don’t show that to anonymous users. Here’s a screen grab:





The other users in the list all have 2021 join dates

Thanks

 

[Paul B]

No idea then.

It would require further investigation at the database level.

 

[bengineer]

Can you suggest what to check?

When I run:

SELECT * FROM `xf_user` order by register_date desc

I don't see this Colin 540 user anywhere at all in the top 100 new users.

And when I run:

SELECT username, register_date, DATE_FORMAT(FROM_UNIXTIME(register_date), '%e %b %Y') FROM `xf_user` WHERE username = 'Colin 540'

Colin 540

1345621200

22 Aug 2012

Are there any caches involved in those widgets?

Thanks

 

[bengineer]

False alarm.

It appears that our 'Newest members' widget was actually mapped to a Latest upgrades module. Sorry for the confusion. I've switched it over to the Newest members widget and it's now correctly showing only the newest members.