Badge SQL triggered on post content

zogstrip · February 10, 2026, 2:32pm

I’m unfortunately not able to reproduce

That said, I found a couple bugs in BadgeGranter that could prevent badges from being granted.

github.com/discourse/discourse

FIX: improve badge granter resilience (#37674)

main ← fix/badge-granter-resilience

merged 03:31PM - 10 Feb 26 UTC

ZogStriP

+51 -2

Two issues were found in BadgeGranter that could prevent badges from being grant…ed. First, `Array#compact!` returns `nil` when no elements are removed. For PostAction triggers, `[post_id, related_post_id].compact!` returns `nil` when `related_post_id` is present (nothing to compact), causing the post_ids payload to be silently lost. Using `compact` instead always returns the array. Second, `process_queue!` had no error isolation between badges. A single badge with a broken SQL query would raise an exception and abort processing of all remaining badges in the queue. Since queue items are already popped from Redis at that point, they are lost. Each badge is now rescued individually so one failure doesn't block the rest. https://meta.discourse.org/t/394444

Maybe once it’s merged, you could upgrade and try again?

Topic		Replies	Views
Badges for posting Data & reporting sql-triggered-badge	4	394	August 27, 2024
Creating triggered custom badge queries Site Management badges , how-to , sql-triggered-badge	0	12680	August 27, 2014
Need some Help with my Triggered Custom Badge Query Support sql-triggered-badge	3	44	February 5, 2026
Creating Custom Badges and Triggers Data & reporting sql-triggered-badge	0	1656	August 8, 2020
Badge not working Data & reporting sql-triggered-badge	4	1447	June 8, 2024

Badge SQL triggered on post content

Related topics