In my installation of 1.3.0.beta1, Badge that ‘Update daily’ won’t trigger automatically. SQL: SELECT u.id AS user_id, MIN(u.created_at + interval '8 day') AS granted_at FROM users u JOIN posts p ON p.user_id = u.id WHERE u.id > 0 AND u.active AND NOT u.blocked …

What does /sidekiq/scheduler and /logs show? Is the Jobs::BadgeGrant failing?

[图片] riking: Jobs::BadgeGrant /sidekiq/scheduler : Jobs::BadgeGrant FAILED /logs: Job exception: PG::UniqueViolation: ERROR: duplicate key value violates unique constraint “index_user_badges_on_badge_id_and_user_id_and_seq” DETAIL: Key (badge_id, user_id, seq)=(104, 1, 0) already exists. …

[solved] Badges 'update daily' won't trigger

支持

话题		回复	浏览量
Badge grant fails if any throw exception Bug	4	1096	2017 年11 月 23 日
Previewed Badges not Awarding Support badges	5	1111	2015 年9 月 4 日
Immediate query for custom badge that is updated daily Support	11	1537	2021 年12 月 13 日
Badges not being assigned Support	16	2988	2024 年6 月 8 日
SQL Querying in Badges Data & reporting sql-triggered-badge	2	1047	2024 年6 月 8 日

[solved] Badges 'update daily' won't trigger

相关话题