So…we had a spam user get through and compromise our PM system. I ran a db query to find the malicious message was sent to 12± members. So, I then deleted the messages from the pmmessages table.
A couple members, however, have reported that the Inbox button notification still indicates there is an unread message. But there is no message, since I deleted it.
How might I go about clearing that notice via PHP MyAdmin?
Thanks in advance for any direction!
a private message exists in more than just the pmmessages table… there is also an entry in the pmthreads table (one per thread) and in the pmrecipients table (once per recipient)… its a relational database, so each recipient points to the message table… and each message in a thread points to the threads table… so you only partially cleaned it out – hence the counts…
usually easier to delete the admin interface on forum – private messaging – pm stats… but given the instability in the db, may not work right now…
Mr Papa said
so you only partially cleaned it out – hence the counts…
I figured that much. But now that I’ve deleted the messages, and therefore don’t know the recipients or threads, any way to clear the count? Can that be done globally?
given the instability in the db, may not work right now…
Great, any suggestions?
look through the pmthreads table for the thread… you should be able to find it by the title which should be recognizable since you deleted the message… record the thread id… then delete it and delete any rows in the pmrecipients table that have that thread id…
Thank you for the direction! That helps.
So far it has been easy enough to just tell members to click the Mark Inbox Read button!