FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » FUDforum 3.0+ » pruning private messages
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
pruning private messages [message #162224] Fri, 09 April 2010 11:03 Go to next message
littleking is currently offline  littleking   United States
Messages: 187
Registered: January 2007
Karma: 2
Senior Member
add to buddy list
ignore all messages by this user
i've got 17,000 private messages in my forum, how can i prune those?
icon6.gif  Re: pruning private messages [message #162227 is a reply to message #162224] Sat, 10 April 2010 00:23 Go to previous messageGo to next message
The Witcher is currently offline  The Witcher   United States
Messages: 662
Registered: May 2009
Location: USA
Karma: 2
Senior Member
add to buddy list
ignore all messages by this user
That's a sticky wicket ain't it, users can get awful cantankerous when they think Admins are messing with their PM's (in some ways I agree in others I don't) either way it is a touchy and delicate subject.

On the one hand you need to respect the users privacy, yet on the other hand not all users respect the privacy of others (Abusing PM's in various ways), and you really don't know which users all these PM's are going to or from. And it is most likely just users not deleting old messages.

However it has been my experience that some users register yet never or seldom post publicly. Yet PM prolifically (again for a variety of reasons, such as gossip or undermining the forum).

Version 3.0.1RC1 allows the admin to review selected "sent' PM's for spammers using PM's to send their spam to other users, but that might well be a laborious and time consuming process (member list> user>edit>Private messages at the bottom of the screen); this would allow you to delete certain sent messages from all mailboxes (I would delete the oldest 1st, I just checked one of my moderators accounts and it still had messages from Jan 2007 through yesterday including messages from a user who has been deceased for 2 years, so as an example I would just delete the oldest ones)

Personally I would use the announcement manager on all forums (or global E-mail) to ask/tell members to delete their excess messages on their own as part of forum maintenance/upgrade and hope for their voluntary compliance.

If that does not work to reduce the number of PM's you might try a different approach (WARNING) I don't know if this would actually work or not But I believe it would, hopefully naudefj will know more but you could try it and let us know..

First compress, re-index and do a forum consistency, make a data dump and save it (just in case)

Second drastically reduce the allowed size of PM folders or turn them off altogether, then repeat the first step and see if the messages are gone.

If I understand the workings of the forums correctly excess PM's above the set limit will be removed in the process hopefully leaving just the most current ones.

(Removing or deleting forums work on a 1st in last out order and I have no idea if that works the same way with PM's or not).

If that fails you still have the option of restoring the data dump.


"I'm a Witcher, I solve human problems; not always using a sword!"

[Updated on: Sat, 10 April 2010 05:18]

Report message to a moderator

Re: pruning private messages [message #162238 is a reply to message #162227] Tue, 13 April 2010 15:44 Go to previous messageGo to next message
littleking is currently offline  littleking   United States
Messages: 187
Registered: January 2007
Karma: 2
Senior Member
add to buddy list
ignore all messages by this user
im not running RC1 so that feature is not available
icon6.gif  Re: pruning private messages [message #162256 is a reply to message #162238] Sat, 17 April 2010 04:18 Go to previous messageGo to next message
The Witcher is currently offline  The Witcher   United States
Messages: 662
Registered: May 2009
Location: USA
Karma: 2
Senior Member
add to buddy list
ignore all messages by this user
I tried the above on a forum with very few users and little activity, with no luck, however I was able to delete PM's with 3.01RC PM management and remove half of them so far.

So I guess we have to start over again with how to delete them with or without 3.0.1!


"I'm a Witcher, I solve human problems; not always using a sword!"
Re: pruning private messages [message #162326 is a reply to message #162256] Mon, 26 April 2010 12:47 Go to previous messageGo to next message
littleking is currently offline  littleking   United States
Messages: 187
Registered: January 2007
Karma: 2
Senior Member
add to buddy list
ignore all messages by this user
i can delete them with 3.01 but only one at a time Sad
Re: pruning private messages [message #162331 is a reply to message #162326] Mon, 26 April 2010 17:03 Go to previous messageGo to next message
The Witcher is currently offline  The Witcher   United States
Messages: 662
Registered: May 2009
Location: USA
Karma: 2
Senior Member
add to buddy list
ignore all messages by this user
littleking wrote on Mon, 26 April 2010 11:47
i can delete them with 3.01 but only one at a time Sad


From what I see and understand of it you can remove all the recently sent emails from "all mail boxes" if you view the message and choose that option! If you just delete it that does not delete it from all mail boxes. However depending on how many users each message was sent to "Buddy List" each sent message may delete dozens of messages.

But those still leaves messages that are not included in the recently sent list and are instead received or stored in draft, sent, save or un-emptied trash folders.

In the example I used above I managed to delete all but 2 messages which still show in my forum dashboard and forum statistics, I presume those are the systems PM's it sends to new registered users for approved avatars etc.

But to remove all messages may require a 1 at a time approach the hard way which may require admin access to the Sql database! You know your forums makeup better than I.





"I'm a Witcher, I solve human problems; not always using a sword!"
Re: pruning private messages [message #167643 is a reply to message #162331] Sun, 19 August 2012 18:51 Go to previous messageGo to next message
littleking is currently offline  littleking   United States
Messages: 187
Registered: January 2007
Karma: 2
Senior Member
add to buddy list
ignore all messages by this user
I wish I could remove all PM's older than 12 months... that would clean up a BOAT load of data!
Re: pruning private messages [message #167713 is a reply to message #167643] Wed, 05 September 2012 01:59 Go to previous message
naudefj is currently offline  naudefj   South Africa
Messages: 3632
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Quote:
I wish I could remove all PM's older than 12 months... that would clean up a BOAT load of data!


That is exactly why we have an Attachment Pruning function in the ACP.
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: forum width
Next Topic: Having an IE spacing problem. This forum looks perfect
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 17 09:03:55 EST 2017

Total time taken to generate the page: 0.00846 seconds