What is the bug reporter badge?

[Simon_Manning]

You might not be finding where you can add the code because editing badge SQL editing is now disabled by default. See here:

Badge SQL can no longer be edited by default

Starting from Discourse 1.6 badge sql can no longer be edited by admins unless explicitly enabled. This change was made for a couple of reasons Security: allowing admins to enter SQL directly allows them raw access to the database, generally we are opting that raw access to the database from the web UI is a feature you opt-in for. Even though the queries only return user_ids, an admin attacker can discover any information in the database using badge queries. If column A of table Y has the le…

So I think the process would be to:

1. Enable badge SQL editing (instructions in the linked topic)
2. Create a new badge in Admin > Badges (or edit an existing badge if you’ve already created it)
3. Add your SQL to the badge and save
4. Disable badge SQL editing

Then if you haven’t already done so, going by the values in the SQL you posted:

1. Create a category called “bug”
2. Create a user group called “team”
3. Add the users that you want to be able to accept bug reports to “team”