# How do I clear user warnings?
**URL:** https://meta.discourse.org/t/how-do-i-clear-user-warnings/79460
**Category:** Support
**Created:** [January 31, 2018, 3:36pm UTC](https://meta.discourse.org/t/how-do-i-clear-user-warnings/79460 "2018-01-31T15:36:01Z")
**Posts on this page:** 20
**Page:** 1
### Author:  [@Cyclops](https://meta.discourse.org/u/Cyclops)
#### Post date: [January 31, 2018, 3:36pm UTC](https://meta.discourse.org/t/how-do-i-clear-user-warnings/79460/1 "2018-01-31T15:36:01Z")
I have a user who was warned on an issue but it was resolved. I would like to learn the warning, since it has been successful resolved. How would I do that?
---
### Author:  [@zogstrip](https://meta.discourse.org/u/zogstrip)
#### Post date: [January 31, 2018, 4:29pm UTC](https://meta.discourse.org/t/how-do-i-clear-user-warnings/79460/2 "2018-01-31T16:29:26Z")
I don’t think there’s a way to clear/remove a warning.
---
### Author:  [@HAWK](https://meta.discourse.org/u/HAWK)
#### Post date: [January 31, 2018, 8:32pm UTC](https://meta.discourse.org/t/how-do-i-clear-user-warnings/79460/3 "2018-01-31T20:32:41Z")
The intention is to keep them as a paper trail in case there are further issues in the future…
---
### Author:  [@Cyclops](https://meta.discourse.org/u/Cyclops)
#### Post date: [January 31, 2018, 9:38pm UTC](https://meta.discourse.org/t/how-do-i-clear-user-warnings/79460/4 "2018-01-31T21:38:51Z")
> [@Cyclops](#):
>
> I have a user who was warned on an issue but it was resolved. I would like to learn the warning, since it has been successful resolved. How would I do that?
While I can understand that, I would prefer it if I could keep the paper trail, including when I cleared the warning, but not have it show up for every mod when they look at that persons profile. Or at least have a log or something that says how long ago that was warned. I think it is reasonable to say that a person who had a warning 18 months ago, likely should have a different response for a second issue after 18 months vs after 2 days.
Just my opinion, but that sounds like it would have to be a feature request then.
---
### Author:  [@HAWK](https://meta.discourse.org/u/HAWK)
#### Post date: [January 31, 2018, 9:45pm UTC](https://meta.discourse.org/t/how-do-i-clear-user-warnings/79460/5 "2018-01-31T21:45:06Z")
I’d personally question why you’d have moderators that you can’t trust to be privy to all moderation, but perhaps I’m not understanding your situation.
---
### Author:  [@Cyclops](https://meta.discourse.org/u/Cyclops)
#### Post date: [January 31, 2018, 10:12pm UTC](https://meta.discourse.org/t/how-do-i-clear-user-warnings/79460/6 "2018-01-31T22:12:22Z")
> [@HAWK](#):
>
> I’d personally question why you’d have moderators that you can’t trust to be privy to all moderation, but perhaps I’m not understanding your situation.
That isn’t the case at all. However, I do not see where the system shows a log of when the user when warned or why. Perhaps I’m missing that? I don’t mean to come off as if I don’t like how Discourse works, and perhaps I’m a weird-o, which is highly possible, just trying to get some information is all.
I appreciate all the help.
---
### Author:  [@HAWK](https://meta.discourse.org/u/HAWK)
#### Post date: [January 31, 2018, 10:27pm UTC](https://meta.discourse.org/t/how-do-i-clear-user-warnings/79460/7 "2018-01-31T22:27:27Z")
I think we might be talking at cross purposes.
The title of your topic says how do I ‘clear’ warnings so we’ve been responding to that – there is no way to clear a warning.
Are you actually asking about how you can find the details of a warning?
---
### Author:  [@Cyclops](https://meta.discourse.org/u/Cyclops)
#### Post date: [January 31, 2018, 10:44pm UTC](https://meta.discourse.org/t/how-do-i-clear-user-warnings/79460/8 "2018-01-31T22:44:13Z")
> [@HAWK](#):
>
> I think we might be talking at cross purposes.
>
> The title of your topic says how do I ‘clear’ warnings so we’ve been responding to that – there is no way to clear a warning.
>
> Are you actually asking about how you can find the details of a warning?
I apologize for being unclear. I actually would like to clear the warning but since that isn’t possible. I would like to know how I can view the history of where the warning was given and more particularly when.
I have not had time to really dig into a lot of the moderation features of Discourse yet, which I would like to, but work and school keep me very busy. Normally I would play around with it until I found it on my own but this seemed like it might be more expedient. Sorry if I was confusing, and if etiquette here would lead to me doing a whole new post, I would be happy to do so.
---
### Author:  [@Mittineague](https://meta.discourse.org/u/Mittineague)
#### Post date: [January 31, 2018, 10:45pm UTC](https://meta.discourse.org/t/how-do-i-clear-user-warnings/79460/9 "2018-01-31T22:45:38Z")
A moderator does not always need to issue an official warning. I myself quite often send “friendly messages” at another forum I’m a moderator for. I consider them to be a kind of “free pass” for a first offense.
---
### Author:  [@Cyclops](https://meta.discourse.org/u/Cyclops)
#### Post date: [January 31, 2018, 10:49pm UTC](https://meta.discourse.org/t/how-do-i-clear-user-warnings/79460/10 "2018-01-31T22:49:38Z")
> [@Mittineague](#):
>
> A moderator does not always need to issue an official warning. I myself quite often send “friendly messages”. I consider them to be a kind of “free pass” for a first offense.
Well, to go into more detail. I have a user, which has a warning. I don’t know why, I’ve asked my Moderators but none of them remember doing it. Now I have gone through a few Moderators in the early days of setting things up, so it is possible one of them did it.
I know the person personally and I can’t imagine why they were issued a warning, but I can’t find it anywhere when it was issued. This is what lead to the small issue of wanting to clear it. Since that isn’t possible, I have become curious as to why it was done and when and by whom. I know this is a bit specific and a lot of information that isn’t needed, but that is this minor situation in a nutshell.
---
### Author:  [@Mittineague](https://meta.discourse.org/u/Mittineague)
#### Post date: [January 31, 2018, 10:57pm UTC](https://meta.discourse.org/t/how-do-i-clear-user-warnings/79460/11 "2018-01-31T22:57:54Z")
> [@Cyclops](#):
>
> I can’t find it anywhere
Unfortunately, Warnings aren’t logged. But it should be possible do dig up some information using the [Data Explorer](https://meta.discourse.org/t/32566?silent=true) plugin.
---
### Author:  [@jomaxro](https://meta.discourse.org/u/jomaxro)
#### Post date: [January 31, 2018, 11:38pm UTC](https://meta.discourse.org/t/how-do-i-clear-user-warnings/79460/12 "2018-01-31T23:38:37Z")
I thought warnings appeared on top of a user’s public profile…let me look.
Nope…just the count, no link to them.
If you have the staff notes plugin installed warnings are automatically added as a note to the user, but that only helps if you had the plugin installed before issuing the warnings.
---
### Author:  [@Mittineague](https://meta.discourse.org/u/Mittineague)
#### Post date: [February 1, 2018, 12:49am UTC](https://meta.discourse.org/t/how-do-i-clear-user-warnings/79460/13 "2018-02-01T00:49:10Z")
This should help in tracking it down. It requires needing to know the member’s id
```plaintext
-- [params]
-- int :member_id = 1
SELECT user_warnings.topic_id
, user_warnings.user_id
, user_warnings.created_by_id
, user_warnings.created_at
, user_warnings.updated_at
, users.username AS moderator
FROM user_warnings
JOIN users ON user_warnings.created_by_id = users.id
WHERE user_warnings.user_id = :member_id
```
---
### Author:  [@Cyclops](https://meta.discourse.org/u/Cyclops)
#### Post date: [February 1, 2018, 5:51am UTC](https://meta.discourse.org/t/how-do-i-clear-user-warnings/79460/14 "2018-02-01T05:51:44Z")
What is that, where would I put those commands in?
---
### Author:  [@Mittineague](https://meta.discourse.org/u/Mittineague)
#### Post date: [February 1, 2018, 6:01am UTC](https://meta.discourse.org/t/how-do-i-clear-user-warnings/79460/15 "2018-02-01T06:01:32Z")
That’s capable to do in the [Data Explorer](https://meta.discourse.org/t/32566?silent=true) plugin page.
You could run the query in the database console by replacing “:member\_id” with the member’s id number and omitting the “params” part. (it wouldn’t look as nice or give you links to click, but it would work)
```plaintext
SELECT user_warnings.topic_id
, user_warnings.user_id
, user_warnings.created_by_id
, user_warnings.created_at
, user_warnings.updated_at
, users.username AS moderator
FROM user_warnings
JOIN users ON user_warnings.created_by_id = users.id
WHERE user_warnings.user_id = :member_id
```
> [@Discourse Data Explorer](https://meta.discourse.org/t/data-explorer-plugin/32566):
>
> discourse2Summary Discourse [Data Explorer](https://meta.discourse.org/t/32566?silent=true) allows you to make SQL queries against your live database, allowing for up-to-the-minute stats reporting.open_bookInstall Guide This plugin is bundled with Discourse core. There is no need to install the plugin separately.information_source If you’re looking for examples or support for any custom queries, you can find lots of topics in our #data-reporting category under the #sql-query tag. If there’s not one to suit your par…
---
### Author:  [@ggurbet](https://meta.discourse.org/u/ggurbet)
#### Post date: [February 10, 2018, 9:24pm UTC](https://meta.discourse.org/t/how-do-i-clear-user-warnings/79460/16 "2018-02-10T21:24:07Z")
Thanks for the tip. Is it safe to delete these warnings from [Data Explorer](https://meta.discourse.org/t/32566?silent=true)? I have a warning given to me by myself while testing and it kind of needs to be taken care of 🙂
---
### Author:  [@Mittineague](https://meta.discourse.org/u/Mittineague)
#### Post date: [February 10, 2018, 10:01pm UTC](https://meta.discourse.org/t/how-do-i-clear-user-warnings/79460/17 "2018-02-10T22:01:30Z")
The Data Explore plugin does SELECTs only. It is a very safe way to interact with the database and can not break your database.
An improperly crafted DELETE query could result in bugs or worse, an unusable database. (AFAIK, Discourse does not have any “on delete cascade” code in the Core)
If this is only because you don’t like having an “embarrassing stain” associated with your account, IMHO it would be better to leave the database alone and make it publically known to those that need to know that the warning has no importance.
If the warning is interfering with your Admin abilities in some way, that is much more of a concern and it should be addressed. Is the warning causing problems for you?
---
### Author:  [@ggurbet](https://meta.discourse.org/u/ggurbet)
#### Post date: [February 10, 2018, 11:15pm UTC](https://meta.discourse.org/t/how-do-i-clear-user-warnings/79460/18 "2018-02-10T23:15:55Z")
> [@Mittineague](#):
>
> Is the warning causing problems for you?
It has no effect on any admin abilities nor cause any misunderstandings, only cosmetic concerns 🙂 Thank you for the reply, I guess I could stick with it.
---
### Author:  [@Mittineague](https://meta.discourse.org/u/Mittineague)
#### Post date: [February 11, 2018, 2:06am UTC](https://meta.discourse.org/t/how-do-i-clear-user-warnings/79460/19 "2018-02-11T02:06:01Z")
It may not be as visible as you think it is.
Admins can see the red warning icon on a member’s profile page and the red envelope icon next to the warning message
Moderators can see the red warning icon, but _not_ the warning message
The member does _not_ see the red warning icon but can see the red envelope warning message
Other members can _not_ see the warning _nor_ the message icons.
So the only ones that might wonder about the warning are the moderators.
---
### Author:  [@riking](https://meta.discourse.org/u/riking)
#### Post date: [February 11, 2018, 5:57pm UTC](https://meta.discourse.org/t/how-do-i-clear-user-warnings/79460/20 "2018-02-11T17:57:10Z")
> [@Mittineague](#):
>
> Moderators can see the red warning icon, but not the warning message
On that note, it might be a good idea to add the [@staff](https://meta.discourse.org/groups/staff) group to warning messages when you tick the “This is an official warning” checkbox. (Allow it to be removed before sending, but that should be the default.)
[Next page](https://meta.discourse.org/t/how-do-i-clear-user-warnings/79460.md?page=2)