How do I clear user warnings?

support
15

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 Likes