XF 1.4 delete "removed from view" messages.


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?


XenForo moderator
Staff member
You should never manually edit the database.
It is now in a non viable state.

Restore from a backup and use the Batch Update Threads function.