Badge Query SQL edit box is disabled until page is refreshed

[Mark_Schmucker (mark78)]

I’ve enabled badge queries following this:

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 …

Now I see the “Badge Query (SQL)” edit box, but it’s read-only. I can’t copy/paste/edit, either for existing badges or new badges. What am I missing?

This may be a duplicate of Locked query field for system badges, which was closed as solved, but I don’t think it was really a solution.

[simon]

For the default badge queries, the badge SQL edit form is displayed, but disabled, when enable_badge_sql is set to true.

If you have been browsing your Admin / Badges page, and then click the ‘New’ button to create a new badge, the badge SQL edit form will be disabled until you refresh the page. Possibly this is a minor bug, but the issue can be solved with a full refresh of the page.

[Mark_Schmucker (mark78)]

Thanks, refreshing the page did the trick.