# 如何清除用户警告？

**URL:** https://meta.discourse.org/t/how-do-i-clear-user-warnings/79460
**Category:** Support
**Created:** [2018年一月31日 15:36 UTC](https://meta.discourse.org/t/how-do-i-clear-user-warnings/79460 "2018-01-31T15:36:01Z")
**Posts on this page:** 1
**Showing post:** 15

<div class="post-metadata">

### Author: ![Mittineague](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/mittineague/32/114259_2.png) [@Mittineague](https://meta.discourse.org/u/Mittineague)
#### Post date: [2018年二月1日 06:01 UTC](https://meta.discourse.org/t/how-do-i-clear-user-warnings/79460/15 "2018-02-01T06:01:32Z")

</div>

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…

---

_[View the full topic](https://meta.discourse.org/t/how-do-i-clear-user-warnings/79460)._