Our site had some spammer send out massive amounts of private messages. I bulk deleted them directly out of the database table bp_messages_messages, marked the users as spam and deleted them… Then also deleted the bp notifications for messages. (We have a fairly low number of actual messages on the site so it didn’t seem like a big deal.) Unfortunately now on the front-end profile tabs it indicates the presence of messages with whatever # were deleted. I can’t figure out how to reset that – even resetting to 0 across the board would be fine, if there isn’t a recount/repair function somewhere…
Any suggestions for how I could fix this? And would deleting the users first have avoided this altogether by automatically cleaning up the messages and repairing the message counts?
Thank you!