Announcement

Collapse
No announcement yet.

Pruning Soft-Deleted Posts

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • lifanovsky
    replied
    Any news on this one?

    Leave a comment:


  • Dora
    replied
    Originally posted by Dbreh View Post

    HTML Code:
    http://www.xxxxxx/vb/moderation.php?do=viewposts&type=deleted&pp=50&daysprune=100&sort=dateline&order=desc&page=1
    thank you
    Very helpful.

    Leave a comment:


  • Pocket Aces
    replied
    80,000 soft-deleted posts for the past 5 years,
    still a pain in the ass permanently deleting those posts in batches of 200.

    Leave a comment:


  • Dbreh
    replied
    Take Care,

    You can do it from forum interface no need to get in to Forum Control Panel
    OK, I'll give you simple way to get red of that

    1- You Should be Admin
    2- See this Code, change & paste it in your browser:

    HTML Code:
    http://www.xxxxxx/vb/moderation.php?do=viewposts&type=deleted&pp=50&daysprune=100&sort=dateline&order=desc&page=1
    xxxxxx = your domain
    deleted&pp=50 means number of posts will be viewed in each page,
    100&sort=dateline, means how many previous days you would like to check and prune. (If it's for last 2 years change it to be 700 or more)

    3- do select all, than do normal delete.
    Note, Don't prune more than 50 posts in each cycle this may over load you server.

    Leave a comment:


  • ablaye
    replied
    I was looking for the same thing. Does anyone know if there is a mod that supports this?

    Leave a comment:


  • Will.Spencer
    replied
    Originally posted by mikeinjersey View Post
    I've been waiting for that function for years as well... And quite frankly im not sure why vBulletin hasnt added it yet.
    4 April 2011 -- still not implemented.

    Leave a comment:


  • MoMan
    replied
    In that case do we have to resort to mysql queries?

    Code:
    DELETE FROM deletionlog WHERE type = 'post'
     
    DELETE FROM post WHERE visible = 2;

    Leave a comment:


  • mikeinjersey
    replied
    Originally posted by MoMan View Post
    I've now successfully pruned all my old deleted threads, but I still can't find a tool that will allow me to prune deleted posts in undeleted / current threads.
    I've been waiting for that function for years as well... And quite frankly im not sure why vBulletin hasnt added it yet.

    Leave a comment:


  • MoMan
    replied
    I've now successfully pruned all my old deleted threads, but I still can't find a tool that will allow me to prune deleted posts in undeleted / current threads.

    Leave a comment:


  • mikeinjersey
    replied
    be careful with the pruning tool. And only prune threads that are already in the "deleted" state.

    Leave a comment:


  • David Grove
    replied
    You can use the ACP pruning option to prune all deleted threads and see how many that takes care of. Of course there will still be some deleted posts left over.

    Leave a comment:


  • MoMan
    started a topic Pruning Soft-Deleted Posts

    Pruning Soft-Deleted Posts

    My moderation.php?do=viewposts&type=deleted page in the UserCP currently indicates that I nearly have 3,000 soft-deleted posts sitting in the database, but deleting the posts through this interface would take ages, as only four posts are shown per page.

    While I know that opening moderation.php and modifying this line:

    PHP Code:
    sanitize_pageresults($totalposts$pagenumber$perpage2004); 
    would lengthen the list on that page, is there any other way to efficiently prune such deleted posts (and threads, for that matter)?
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X