Wiki Editor badge is awarded multiple times

sam · Março 27, 2020, 1:42am

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:

Tópico		Respostas	Visualizações
Earning Editor Badge twice Bug badges	3	1242	3 de Fevereiro de 2016
How do you get the Wiki Editor badge? Support	2	1433	20 de Junho de 2019
Custom badges show duplicated when saved Bug badges	2	1268	2 de Novembro de 2015
Bug reporter badge not granted Site feedback badges	8	179	10 de Abril de 2025
I can use this badge as a title improperly duplicates edit button Bug	4	847	18 de Agosto de 2017

Wiki Editor badge is awarded multiple times

Tópicos relacionados