Like me.

I just upgraded and found that every single PM the site has ever generated are back. Purged PMs, weren't. Everybody's mailbox is full, full, full.

Any way to delete everything before a certain date, or let's not be picky, by ANY orderly means en masse???

Rick

Well, theres a reason they're "back"; they never where gone...

Keep in mind that there are 2 parties in a PM, not just one. So when one person deletes, it's still there for the other user, until they delete the message as well.

There where two differant ways to go about pm importing:
A. Don't import them, gone forever.
B. Import all pm's and assign them to the users who had posted in them.

Seeing as most users use pm's, we all harassed rick till he went with B :x...

And you could purge pm's by using the datestamp and a unix epoch date...

hmm.. I hope Rick can fix it..

the only real "fix" would be to not import PM's... Theres not much of a grey area, as in there isn't really a way to check if they exist for both or one user with the import scripts.

I'm not sure and have not looked, but don't ALL messages regardless of type or area contain a unique id ? If not perhaps it would be a good idea to implement a unique ID for all messages that way in the future it could be used for multiple purposes of tracking or other uses.

All messages do have a unique id; it'd be their index id in the database

Well then perhaps I'm off base but if he's trying to keep out duplicates can't some type of query be written to ignore duplicates based on the unique id ?

just becuse it's the same content in the message doesn't mean it's the same message; a new message is created when a user signs up, it's not the same message at all, so each message would have it's own id

True, I get ya

Thank you for the script Gizmo.
I am one of the large site owners that does not have a clue about MySQL that welcomes anything that can make my look like if I did :-)