How can I remove ALL warning for ALL members at once? Sql?

[Maxxius]

hi, this is quite a simple question, I'd like to offer my members a clean slate by removing all the warnings ever issued. Which myphpadmin query could accomplish that?

[flashpoint]

Truncate * FROM core_members_warn_actions;
Truncate * FROM core_members_warn_logs;
Truncate * FROM core_members_warn_reasons;

or

DELETE * FROM core_members_warn_actions;
DELETE * FROM core_members_warn_logs;
DELETE * FROM core_members_warn_reasons;

 

P.S. Always back up your database before making any changes, regardless of how sure you are.

[Maxxius]

Thank you @flashpoint

Can anyone else confirm that this is the way to go? @Adriano Faria @Daniel F @DawPi (good morning guys 😄 )

 

[DawPi]

Also:

UPDATE core_members SET warn_level = 0;
UPDATE core_members SET warn_lastwarn = 0;

 

[Maxxius]

@DawPi thanks , @flashpoint

Wouldn't Truncate * FROM core_members_warn_reasons; and core_members_warn_actions

simply just delete my warn reasons? I think I should leave it since I just want to clear up all the members but not my setup for future warnings.

[Adriano Faria]

Just truncate core_members_warn_logs and update columns pointed by Dawpi.

[DawPi]

20 minutes ago, Maxxius said:

@DawPi thanks , @flashpoint

Wouldn't Truncate * FROM core_members_warn_reasons; and core_members_warn_actions

simply just delete my warn reasons? I think I should leave it since I just want to clear up all the members but not my setup for future warnings.

Yes, do not do that. This is not necessary and would remove the reasons.

[flashpoint]

My apologies. Should've double checked. :p. I'll remove that part from my post in case someone finds it in the future... 🙂

[Maxxius]

Truncate * FROM core_members_warn_actions; 

strike that out too 🙂 this one also has to stay

[Adriano Faria]

On 12/13/2019 at 6:35 AM, Adriano Faria said:

Just truncate core_members_warn_logs and update columns pointed by Dawpi.

👆