# Badges not being assigned
**URL:** https://meta.discourse.org/t/badges-not-being-assigned/38220
**Category:** Support
**Created:** [January 20, 2016, 12:32am UTC](https://meta.discourse.org/t/badges-not-being-assigned/38220 "2016-01-20T00:32:18Z")
**Posts on this page:** 17
**Page:** 1
### Author:  [@stevenpslade](https://meta.discourse.org/u/stevenpslade)
#### Post date: [January 20, 2016, 12:32am UTC](https://meta.discourse.org/t/badges-not-being-assigned/38220/1 "2016-01-20T00:32:18Z")
Any reason the badge query preview would read:
> 91 badges to be assigned.
But the badge never gets assigned. How can this be?
---
### Author:  [@sam](https://meta.discourse.org/u/sam)
#### Post date: [January 20, 2016, 2:15am UTC](https://meta.discourse.org/t/badges-not-being-assigned/38220/2 "2016-01-20T02:15:38Z")
Backlog badge assignments run daily
---
### Author:  [@fefrei](https://meta.discourse.org/u/fefrei)
#### Post date: [January 20, 2016, 9:58am UTC](https://meta.discourse.org/t/badges-not-being-assigned/38220/3 "2016-01-20T09:58:42Z")
If you don’t want to wait, visit `/sidekiq/scheduler` and click `Trigger` on `Jobs::BadgeGrant`.
---
### Author:  [@stevenpslade](https://meta.discourse.org/u/stevenpslade)
#### Post date: [January 20, 2016, 5:19pm UTC](https://meta.discourse.org/t/badges-not-being-assigned/38220/4 "2016-01-20T17:19:32Z")
@sam even though backlog badge assignments run daily, shouldn’t the badge still be assigned at some point? The query proved to work in postgres (identifying user’s who should be receiving the badge) and the preview query has listed the number of badges to be assigned weeks ago yet 0 have been given.
This is the query (let me know if the backfill might be screwing me up):
```sql
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 granted_at
FROM topics
JOIN posts ON topics.id = posts.topic_id
JOIN users ON users.id = posts.user_id
WHERE posts.like_count > 0
AND users.title = 'Real Estate Agent'
AND (:backfill OR ( users.id IN (:user_ids) ))
GROUP BY topics.id, posts.id, users.id, users.title
HAVING MAX(posts.like_count) >= (SELECT MAX(p.like_count)
FROM topics t
JOIN posts p ON t.id = p.topic_id
JOIN users u ON u.id = p.user_id
WHERE t.id = topics.id
GROUP BY u.id order by max desc limit 1)
ORDER BY MAX(posts.like_count) DESC
```
The settings are set as below:
---
### Author:  [@stevenpslade](https://meta.discourse.org/u/stevenpslade)
#### Post date: [January 20, 2016, 5:51pm UTC](https://meta.discourse.org/t/badges-not-being-assigned/38220/5 "2016-01-20T17:51:59Z")
@fefrei thanks for this. I did just use `/sidekiq/scheduler` for the first time because your suggestion. Really great tool, however, my badge is still not being assigned. It is so odd because I would think if the preview query lets me know that X amount of people are set to get the badge, and then I run `Jobs::BadgeGrant` …you would think the badge would definitely be assigned afterwards, but still 0. 😣
---
### Author:  [@stevenpslade](https://meta.discourse.org/u/stevenpslade)
#### Post date: [January 20, 2016, 6:25pm UTC](https://meta.discourse.org/t/badges-not-being-assigned/38220/6 "2016-01-20T18:25:47Z")
@sam UPDATE: upon looking at `/logs` I see this error:
` Job exception: 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)=(118, 139, 0) already exists.`
---
### Author:  [@sam](https://meta.discourse.org/u/sam)
#### Post date: [January 20, 2016, 9:33pm UTC](https://meta.discourse.org/t/badges-not-being-assigned/38220/7 "2016-01-20T21:33:05Z")
You have a query that is targetting posts there no? If not, you need to be selecting distinct user ids, looks like you are selecting dupes.
---
### Author:  [@stevenpslade](https://meta.discourse.org/u/stevenpslade)
#### Post date: [January 20, 2016, 11:07pm UTC](https://meta.discourse.org/t/badges-not-being-assigned/38220/8 "2016-01-20T23:07:28Z")
Can’t a badge be given more than once though? The query gives a badge for the person with the most likes on a post in a topic (if they are part of a particular group). A person could achieve this on multiple topic threads, thus their user id would appear more than once in the query.
---
### Author:  [@sam](https://meta.discourse.org/u/sam)
#### Post date: [January 21, 2016, 12:54am UTC](https://meta.discourse.org/t/badges-not-being-assigned/38220/9 "2016-01-21T00:54:37Z")
In that case you want to return the post\_id cause then you associate the badge with a post.
---
### Author:  [@stevenpslade](https://meta.discourse.org/u/stevenpslade)
#### Post date: [January 22, 2016, 11:06pm UTC](https://meta.discourse.org/t/badges-not-being-assigned/38220/10 "2016-01-22T23:06:28Z")
Hate to be a pain but even by using `(:backfill OR ( posts.id IN (:post_ids) ))` instead of relating the user\_id doesn’t do the trick. I am mostly frustrated because if the preview says its working, why shouldn’t it give those users the badge? 😣
---
### Author:  [@riking](https://meta.discourse.org/u/riking)
#### Post date: [January 26, 2016, 8:11am UTC](https://meta.discourse.org/t/badges-not-being-assigned/38220/11 "2016-01-26T08:11:35Z")
Err, wait a second, what do you think that query is actually doing?
Also, you need to make the (user\_id, post\_id) pairs unique or you crash the grant.
The `:backfill` snippet is for triggered badges, this should be a “check once per day” badge.
---
### Author:  [@sam](https://meta.discourse.org/u/sam)
#### Post date: [January 26, 2016, 8:14am UTC](https://meta.discourse.org/t/badges-not-being-assigned/38220/12 "2016-01-26T08:14:44Z")
Please … look at the existing badge queries, you need your select list for the query to match the columns it expects.
---
### Author:  [@stevenpslade](https://meta.discourse.org/u/stevenpslade)
#### Post date: [January 26, 2016, 5:54pm UTC](https://meta.discourse.org/t/badges-not-being-assigned/38220/13 "2016-01-26T17:54:45Z")
> [@sam](#):
>
> you need your select list for the query to match the columns it expects
This sounds like a riddle. These are the coloumns:
```plaintext
topic | post_id | user_id | title | like_count | granted_at
-------+---------+---------+-------------------+------------+-------------------------------
119 | 161 | 61 | Real Estate Agent | 5 | 2016-01-26 17:22:24.152271+00
277 | 477 | 118 | Real Estate Agent | 5 | 2016-01-26 17:22:24.152271+00
123 | 168 | 68 | Real Estate Agent | 4 | 2016-01-26 17:22:24.152271+00
125 | 156 | 56 | Real Estate Agent | 4 | 2016-01-26 17:22:24.152271+00
133 | 382 | 139 | Real Estate Agent | 3 | 2016-01-26 17:22:24.152271+00
122 | 183 | 73 | Real Estate Agent | 3 | 2016-01-26 17:22:24.152271+00
238 | 385 | 119 | Real Estate Agent | 3 | 2016-01-26 17:22:24.152271+00
115 | 349 | 119 | Real Estate Agent | 3 | 2016-01-26 17:22:24.152271+00
209 | 308 | 90 | Real Estate Agent | 3 | 2016-01-26 17:22:24.152271+00
300 | 565 | 156 | Real Estate Agent | 3 | 2016-01-26 17:22:24.152271+00
132 | 169 | 68 | Real Estate Agent | 3 | 2016-01-26 17:22:24.152271+00
120 | 205 | 87 | Real Estate Agent | 3 | 2016-01-26 17:22:24.152271+00
142 | 391 | 139 | Real Estate Agent | 3 | 2016-01-26 17:22:24.152271+00
249 | 405 | 139 | Real Estate Agent | 3 | 2016-01-26 17:22:24.152271+00
115 | 331 | 111 | Real Estate Agent | 3 | 2016-01-26 17:22:24.152271+00
```
From @sam and others who have supported me on this problem, from what I gather, these are the possible issues:
- The query is pulling multiple user\_ids resulting in a duplicate key value violation
- The query, for the aforementioned reason, should target post\_id as it would be unique
- As per Sam’s tongue twister, the select list for the query needs to match the column it expects
I have looked at many other badge queries and successfully written a handful as well. I am posting in support because that’s what I need. As you can see from the table, those are the columns I expect. I want to see the user with the most likes on a post in a topic. :yuno:
---
### Author:  [@stevenpslade](https://meta.discourse.org/u/stevenpslade)
#### Post date: [January 26, 2016, 6:25pm UTC](https://meta.discourse.org/t/badges-not-being-assigned/38220/14 "2016-01-26T18:25:40Z")
Good news, everyone. :goodnews:
I got a query to work. I wrapped my original query in:
```plaintext
SELECT DISTINCT(user_id), CURRENT_TIMESTAMP granted_at
FROM (my existing query here) AS top_answerers
WHERE (:backfill OR ( user_id IN (:user_ids) ))
```
So in this case, the multiple user\_ids was the issue. I guess users won’t be able to get this badge multiple times, but I can live with that for now.
---
### Author:  [@riking](https://meta.discourse.org/u/riking)
#### Post date: [January 27, 2016, 1:38am UTC](https://meta.discourse.org/t/badges-not-being-assigned/38220/15 "2016-01-27T01:38:08Z")
> [@stevenpslade](#):
>
> top\_answerers
This sounds like a badge that should only be awarded once per person anyways 🙂
---
### Author:  [@stevenpslade](https://meta.discourse.org/u/stevenpslade)
#### Post date: [January 27, 2016, 7:44pm UTC](https://meta.discourse.org/t/badges-not-being-assigned/38220/16 "2016-01-27T19:44:23Z")
@riking I think it could go either way. Having a top answer would certainly be rare enough that having the badge once would feel like an accomplishment. However, in the same regard, it’s rarity would make having more than one top answer an even bigger feat, which is why granting the badge multiple times would be nice.
My personal opinion is that having one badge is all it takes to accomplish what getting a badge is supposed to do (that special feeling), which is why I’m totally ok with it only being awarded once 🙂
---
### Author:  [@JammyDodger](https://meta.discourse.org/u/JammyDodger)
#### Post date: [June 8, 2024, 12:45pm UTC](https://meta.discourse.org/t/badges-not-being-assigned/38220/17 "2024-06-08T12:45:54Z")
This topic was automatically closed after 3062 days. New replies are no longer allowed.