XF 2.2 Users with warning points but member never warned

[daimpa]

Hello, I've some users with 1 warning point, but 0 warnings received.
How can this be possible? And how can I reset them?

 

[Mike]

Was this an imported user perhaps? If so, I'd guess that the points total was incorrect at the time of import.

Any change here is going to require a manual database query. Assuming you only want to update specific users, you'd need to identify the user ID (in the URL of their profile page). Then you'd run this query:

UPDATE xf_user SET warning_points = 0 WHERE user_id = 12345;

Change 12345 to the correct user ID.

(We always recommend taking a backup before running any queries directly against the database.)