It looks like the “Promoter” badge isn’t getting assigned properly, at least on our forum.
The SQL for it is:
SELECT u.id user_id, current_timestamp granted_at
FROM users u
WHERE u.id IN (
SELECT invited_by_id
FROM invites i
JOIN users u2 ON u2.id = i.user_id
WHERE i.deleted_at IS NULL AND u2.active AND u2.trust_level >= 0 AND not u2.blocked
GROUP BY invited_by_id
HAVING COUNT(*) > 1
) AND u.active AND NOT u.blocked AND u.id > 0 AND
(:backfill OR u.id IN (:user_ids) )
The problem appears to be the HAVING COUNT(*) > 1… shouldn’t that be HAVING COUNT(*) >= 1? Requiring someone to have invited more than one person to get the Promoter badge seems strange.