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:

Enable Badge SQL

Enabling Badge SQL entails security and performance risks. 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 grants them raw access to the database. Generally, we opt that raw access to the database from the web UI as a feature you opt-in for. Even though the queries only return user_ids, an admin attacker can discover any information in …

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”