Private Messages

[kellyandmike]

We were trying to figure a way to mass delete PM's and couldn't figure out how. So we went to the database and emptyed the folders that say PM, PMreceipts, PMText. So now all of the PMs are gone like we wanted but when a user logs in it says you have 92 messages taking up storage but there are no messages. How can I fix this?

[akanevsky]

We were trying to figure a way to mass delete PM's and couldn't figure out how. So we went to the database and emptyed the folders that say PM, PMreceipts, PMText. So now all of the PMs are gone like we wanted but when a user logs in it says you have 92 messages taking up storage but there are no messages. How can I fix this?

UPDATE user SET pmtotal = 0, pmunread = 0

[kellyandmike]

Can you tell me where to do that? Thanks in advance, I am still new to vb.

Done, thank you