# \[solved\] Badges 'update daily' won't trigger
**URL:** https://meta.discourse.org/t/solved-badges-update-daily-wont-trigger/25659
**Category:** Support
**Created:** [25.Февраль.2015 06:30:44 UTC](https://meta.discourse.org/t/solved-badges-update-daily-wont-trigger/25659 "2015-02-25T06:30:44Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@jebwizoscar](https://meta.discourse.org/u/jebwizoscar)
#### Post date: [25.Февраль.2015 06:30:44 UTC](https://meta.discourse.org/t/solved-badges-update-daily-wont-trigger/25659/1 "2015-02-25T06:30:44Z")
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
AND u.created_at + interval '8 day' < now()
AND p.deleted_at IS NULL
AND NOT p.hidden
AND p.created_at + interval '8 day' > now()
AND (:backfill OR u.id IN (:user_ids))
GROUP BY u.id
HAVING COUNT(p.id) > 0
```
but Preview granted badges | Preview with query plan are working normally.
Badge Query Preview
5 badges to be assigned.
Sample:
… at Feb 21, 2015 8:44 am
… at Feb 21, 2015 12:03 am
… at Feb 20, 2015 9:03 pm
… at Feb 22, 2015 10:40 am
… at Feb 20, 2015 8:52 pm
Settings:
Trigger: Update daily
Allow badge to be used as a title
Show badge on the public badges page
Enable badge
---
### Author:  [@riking](https://meta.discourse.org/u/riking)
#### Post date: [25.Февраль.2015 06:38:38 UTC](https://meta.discourse.org/t/solved-badges-update-daily-wont-trigger/25659/2 "2015-02-25T06:38:38Z")
What does `/sidekiq/scheduler` and `/logs` show? Is the Jobs::BadgeGrant failing?
---
### Author:  [@jebwizoscar](https://meta.discourse.org/u/jebwizoscar)
#### Post date: [25.Февраль.2015 10:11:45 UTC](https://meta.discourse.org/t/solved-badges-update-daily-wont-trigger/25659/3 "2015-02-25T10:11:45Z")
> [@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.
Thanks, problem solved (by adding DISTINCT ON for user\_id of another badge)
---
### Author:  [@zogstrip](https://meta.discourse.org/u/zogstrip)
#### Post date: [25.Февраль.2015 10:14:10 UTC](https://meta.discourse.org/t/solved-badges-update-daily-wont-trigger/25659/4 "2015-02-25T10:14:10Z")
---
### Author:  [@riking](https://meta.discourse.org/u/riking)
#### Post date: [29.Март.2015 01:38:15 UTC](https://meta.discourse.org/t/solved-badges-update-daily-wont-trigger/25659/5 "2015-03-29T01:38:15Z")
I moved 3 posts to a new topic: [Badge grant fails if any throw exception](https://meta.discourse.org/t/badge-grant-fails-if-any-throw-exception/26935)