UBB.Developers Forums General Discussion Suggestions and Feedback How to purge all PM's?

After converting from UBBC to UBBT I have had nothing but trouble. Not so much because of bugs in UBBT or anything but because the import script screwed up.
My members are reporting all kind of strange things happening to there PM's.
Now I would like to purge all PM's and set the PM counter in the members profiles to 0.
Can anyone send me the right sql commands to do this?

Regards,

Ron.

I found it allready:-)

You should post the solution anyway, for the benefit of others.

Looking at delete.php, it should be

code:
DELETE FROM w3t_Messages;
UPDATE w3t_Users SET U_Privates = 0;

---

But don't try this until someone else confirms that this is correct.

Oops, sorry! That is what I did.

I'll post it next time:-))

Can't this be done from the admin section? By setting the the number of days the PM's are to be older than to 0 and then clearing. This is how I would do it in the past.

I would think so... "Delete Old Messages"

Just wondering, I know 5.4.6 will only show "1" message deleted when it really cleared many more. Does 6.0.1 do this?

That's been fixed for 6.0.1

hehe thanks for the update.

I been needing to get 6.0.1 up and running for myself... (it's on the list)

Thanks, I forgot about that feature.