Wiki Editor badge is awarded multiple times

sam · 27 مارس 2020، 1:42ص

This looks like some bug, the badge itself is specifically not a multi grant badge:

Looking at the query I can see it is not grabbing min id like the other badges we have defined.

lib/badge_queries.rb

bed3f7f69


      
          WikiEditor = <<~SQL
            SELECT DISTINCT ON (pr.user_id) pr.user_id, pr.post_id, pr.created_at granted_at
            FROM post_revisions pr
            JOIN badge_posts p on p.id = pr.post_id
            WHERE p.wiki
                AND NOT pr.hidden
                AND (:backfill OR p.id IN (:post_ids))
          SQL

I did a fix here which should improve it:

الموضوع		الردود	مرات العرض
Earning Editor Badge twice Bug badges	3	1242	3 فبراير 2016
How do you get the Wiki Editor badge? Support	2	1433	20 يونيو 2019
Custom badges show duplicated when saved Bug badges	2	1268	2 نوفمبر 2015
Bug reporter badge not granted Site feedback badges	8	179	10 أبريل 2025
I can use this badge as a title improperly duplicates edit button Bug	4	847	18 أغسطس 2017

Wiki Editor badge is awarded multiple times

الموضوعات ذات الصلة