Support Forum
Support Forum
Offline
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!
Simple:Press powers the Tripawds Discussion Forums.
It's better to hop on three legs than to limp on four.
The Tripawds Blogs Community is made possible by The Tripawds Foundation.
Offline
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...
Visit Cruise Talk Central and Mr Papa's World
Offline
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?
Simple:Press powers the Tripawds Discussion Forums.
It's better to hop on three legs than to limp on four.
The Tripawds Blogs Community is made possible by The Tripawds Foundation.
Offline
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...
Visit Cruise Talk Central and Mr Papa's World
Offline
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!
Simple:Press powers the Tripawds Discussion Forums.
It's better to hop on three legs than to limp on four.
The Tripawds Blogs Community is made possible by The Tripawds Foundation.
Offline
okay... let us know if you have anymore on this topic...
Visit Cruise Talk Central and Mr Papa's World
All RSS1 Guest(s)