Hello.
So I have had spammers come and spam my forums, but lucky the staff has spam cleaned all of them. Unfortunately like 10,000 messages still exist that only us staff can see. How do I in mysql remove all these removed from public view messages?
I tried DELETE from xf_post WHERE message_state='deleted'
it deleted 6000 rows. but the forums seem unaffected. Or maybe the forums updates the posts every x number of minutes? is there a mysql command that forces an update?
So I have had spammers come and spam my forums, but lucky the staff has spam cleaned all of them. Unfortunately like 10,000 messages still exist that only us staff can see. How do I in mysql remove all these removed from public view messages?
I tried DELETE from xf_post WHERE message_state='deleted'
it deleted 6000 rows. but the forums seem unaffected. Or maybe the forums updates the posts every x number of minutes? is there a mysql command that forces an update?
