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?
I donât think thereâs a way to clear/remove a warning.
The intention is to keep them as a paper trail in case there are further issues in the futureâŠ
3 curtidas
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.
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.
2 curtidas
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.
2 curtidas
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?
1 curtida
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.
1 curtida
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.
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.
Unfortunately, Warnings arenât logged. But it should be possible do dig up some information using the Data Explorer plugin.
2 curtidas
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.
1 curtida
This should help in tracking it down. It requires needing to know the memberâs id
-- [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
3 curtidas
What is that, where would I put those commands in?
Thatâs capable to do in the Data Explorer 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)
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
5 curtidas
Thanks for the tip. Is it safe to delete these warnings from Data Explorer? I have a warning given to me by myself while testing and it kind of needs to be taken care of 
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?
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.
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.
4 curtidas
On that note, it might be a good idea to add the @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.)
2 curtidas