XF 1.5 Please help diagnose member promotion problem (it's not happening)

[Stuart Wright]

This user https://www.avforums.com/members/andykara2003.742228/
is a Novice Member, which is the primary user group for members.

This member *should* have been promoted to Standard Member.
< options | criteria >

So in a nutshell, once a member has

• posted at least 1 message
• has been registered for at least 1 day
• has received at least 3 positive post ratings

they get promoted to Standard Member.
The member in question satisfies all those criteria.
but has not been promoted.
I have rebuilt user trophies and user promotions twice.
The user has no entries in the user change log - so they haven't been promoted and later depromoted during the rebuilds.

Checking the database, running SELECT count(*) FROM `xf_liked_content` WHERE `content_user_id` = 742228 returns '21' as expected.
The user promotion settings have not been changed for years and there are other members in the same situation:
https://www.avforums.com/members/laserbeam.798280/
https://www.avforums.com/members/redlion.729069/
https://www.avforums.com/members/johnypotter.672146/

How can I diagnose why they are not being promoted?
Thanks

 

[Mike]

Unfortunately the difficulty is that the most likely culprit is the "3 positive post ratings" criteria and as that's from an add-on, we have no idea how that's implemented. Your query looks at raw likes, but we don't know if that's what the criteria actually uses itself.

 

[Stuart Wright]

Thanks, Mike. I changed the criteria from >=3 positive post ratings to >=3 likes and since the post ratings addon seems to accumulate likes when a positive post rating is given, that works.