Continuing the discussion from Badges not being assigned : I originally posted the linked topic under support because I had the following badge query not working: SELECT topics.id AS topic, posts.id AS post_id, users.id AS user_id, users.title, MAX(posts.like_count) AS like_count, CURRENT_TIMESTAMP…

Badge preview working, badge assignment not working

Mittineague (Mittineague) 25. Januar 2016 um 19:44 2

Only a wild guess, does
CURRENT_TIMESTAMP granted_at
need an AS ?

EDIT
Hmmm, Lokking at a few of the default badge queries, none of them had CURRENT_TMESTAMP in them.

Thema		Antworten	Aufrufe
Badges not being assigned Support	15	3143	27. Januar 2016
Previewed Badges not Awarding Support badges	4	1197	4. September 2015
SQL Querying in Badges Data & reporting sql-triggered-badge	1	1097	4. Dezember 2015
Query 'Preview' not working in SQL badge page Bug badges	3	389	25. August 2023
Custom badge query is not targeting posts Support	1	791	2. Januar 2019