Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForumForumForum MaintenanceForum Maintenance
Previous
 
Next
New Post
7/12/2006 3:19 AM
 

I have a site running on DNN 3.2.2, the most used module is "forum", it has been a while the site is running and the size of DB is getting bigger and bigger, since I have limitation imposed by my web host so I am wondering if we have a way to remove the forum posts which are old, say about 6 months old.   Since the site targets latest stuff so removing old posts and replies would be fine.  Now my question is;

1) Is there any such option for DNN administrator or host to remove old postings to free up space ?

2) If not, how can we do it thru DB directly ? any hints…… I understand there will be whole lot of Foreign Keys here and there so removing entries directly from tables is not as safe unless you have idea of complete schema…..may be someone has made a script for such task.

Please advice.

 
New Post
7/12/2006 8:45 PM
 

There is nothing built in to do this nor is anything readily available. I would look at finding all the postid's based on the threads and then passing through the deletepost sproc.

 


Chris Paterra

Get direct answers to your questions in the Community Exchange.
 
New Post
7/13/2006 3:39 AM
 
Thanks a lot Crispy for the pointer, it certainly is very helpful.... Hope the forum module developers add this feature in future releases as it is more a generic kind of issue.
 
New Post
7/18/2006 8:25 AM
 

Guys here are more details on the workaround.....

1) Run query on table forum_posts where createddate < xdate and parentpost = 0

where xdate is the date from which you want to keep the posts

2) Then call the SP dbo.Forum_PostDelete once for every post_id that you received from query in step # 1

NOTE: please check the exact spellings for field names in table forum_posts

 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForumForumForum MaintenanceForum Maintenance


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out