edit: i now checked with “preview granted badges”, it now shows the following:
I don’t see it in my profile yet, when will it be added? What is the best trigger time for the badge?
i just installed solved and added the following sql. After solving one thread, the badge was not applied.
We tried running the sql query inside the data explorer. Here is the error i got in the data explorer:
ActiveRecord::PreparedStatementInvalid: missing value for :backfill in /* * DataExplorer Query * Query: /admin/plugins/explorer?id=3 * Started by: lost */
It’s a ubuntu 18.04 w/ docker, fresh install from two days ago. I was using the following sql query i got form Discourse Solved (Accepted answer plugin)
SELECT p.user_id, p.id post_id, p.updated_at granted_at FROM badge_posts p WHERE p.post_number > 1 AND p.id IN ( SELECT post_id FROM ( SELECT pc.post_id, row_number() OVER (PARTITION BY p1.user_id ORDER BY pc.created_at) as rnum FROM post_custom_fields pc JOIN badge_posts p1 ON p1.id = pc.post_id JOIN topics t1 ON p1.topic_id = t1.id WHERE name = 'is_accepted_answer' AND value IS NOT NULL AND p1.user_id <> t1.user_id AND ( :backfill OR p1.user_id IN ( select user_id from posts where p1.id IN (:post_ids) ) ) ) X WHERE rnum = 1)