Hi, I’m not sure if I’m posting in the correct category. anyway theres a badge for the forum called help desk and its not working, users get 10 accepted answers yet they dont get a badge here’s the SQL code: SELECT p.user_id, p.id post_id, p.updated_at granted_at FROM badge_posts p WHERE p.post_…

I don’t know if the query change in the meanwhile but the original code is this: SELECT id user_id, current_timestamp granted_at FROM users WHERE id IN ( SELECT p1.user_id FROM post_custom_fields pc JOIN badge_posts p1 ON p1.id = pc.post_id JOIN topics t1 ON p1.topic_…

@Trash, in this code, with the last version of discourse I get this error: [图片] Could you check it please? My mistake, solved here: https://meta.discourse.org/t/10-accepted-answer-badge-giving-an-error/34560/3?u=sidv Thanks!

徽章无法工作

社区数据与报告

zainab (Zainab) 2016 年2 月 12 日 03:10 3

thank you.. I shall change it

话题		回复	浏览量
Badges for posting Data & reporting sql-triggered-badge	4	520	2024 年8 月 27 日
Badges for X Number of Solutions Created? Data & reporting solved , sql-triggered-badge	3	864	2022 年6 月 6 日
Custom badge SQL query based on how many solved topics in a certain category Data & reporting solved , sql-triggered-badge	0	633	2021 年8 月 2 日
Badge not being applied, sql error Bug solved	1	2323	2018 年12 月 14 日
Badge SQL Error: q.user_id Data & reporting sql-triggered-badge	3	1316	2018 年5 月 2 日

徽章无法工作

相关话题