Maxxius Posted December 12, 2019 Share Posted December 12, 2019 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? Link to comment Share on other sites More sharing options...
flashpoint Posted December 13, 2019 Share Posted December 13, 2019 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. Link to comment Share on other sites More sharing options...
Maxxius Posted December 13, 2019 Author Share Posted December 13, 2019 Thank you @flashpoint Can anyone else confirm that this is the way to go? @Adriano Faria @Daniel F @DawPi (good morning guys 😄 ) Link to comment Share on other sites More sharing options...
DawPi Posted December 13, 2019 Share Posted December 13, 2019 Also: UPDATE core_members SET warn_level = 0; UPDATE core_members SET warn_lastwarn = 0; Link to comment Share on other sites More sharing options...
Maxxius Posted December 13, 2019 Author Share Posted December 13, 2019 @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. Link to comment Share on other sites More sharing options...
Adriano Faria Posted December 13, 2019 Share Posted December 13, 2019 Just truncate core_members_warn_logs and update columns pointed by Dawpi. Link to comment Share on other sites More sharing options...
DawPi Posted December 13, 2019 Share Posted December 13, 2019 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. Link to comment Share on other sites More sharing options...
flashpoint Posted December 13, 2019 Share Posted December 13, 2019 My apologies. Should've double checked. :p. I'll remove that part from my post in case someone finds it in the future... 🙂 Link to comment Share on other sites More sharing options...
Maxxius Posted December 14, 2019 Author Share Posted December 14, 2019 Truncate * FROM core_members_warn_actions; strike that out too 🙂 this one also has to stay Link to comment Share on other sites More sharing options...
Adriano Faria Posted December 14, 2019 Share Posted December 14, 2019 On 12/13/2019 at 6:35 AM, Adriano Faria said: Just truncate core_members_warn_logs and update columns pointed by Dawpi. 👆 Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.