Erase the old posts
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=26521
Printed Date: 03 April 2026 at 1:50am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Erase the old posts
Posted By: Flyman30
Subject: Erase the old posts
Date Posted: 12 November 2008 at 1:25pm
|
Hello I have Topics that have posts on several years
and I want to delete the old years (2005, 2006.2007) how to thank you.
|
Replies:
Posted By: 123Simples
Date Posted: 12 November 2008 at 2:39pm
Go into Forum Admin and choose batch delete topics You can decide what time span and which forums ------------- http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design |
Posted By: Flyman30
Date Posted: 12 November 2008 at 4:38pm
|
No, I know this option but it is not good, these are
topics that have answers and I want to remove the old messages.
Your solution works only if there is no answer for a
certain period.  |
Posted By: Putz22
Date Posted: 12 November 2008 at 4:54pm
|
Are you trying to say that you want to keep the Topic but delete the Posts? If so I think you might only be able to delete them one by one.. my best suggestion to you on this is why not just start a new topic of the same topic? and let it build up again.. |
Posted By: Flyman30
Date Posted: 12 November 2008 at 5:20pm
| Yes i think i have to do that thank |
Posted By: WebWiz-Bruce
Date Posted: 12 November 2008 at 5:57pm
|
You can also lock individual topics and from the admin area batch lock topics by date. This would then mean people would need to start new topics. If you find performance an issue on large topics then as long as you are using mySQL or SQL Server 2005/2008 then update to the latest version which uses faster server side paging to handle very large topics and forums. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: Flyman30
Date Posted: 12 November 2008 at 6:21pm
|
Borg thank you I have the latest version MSQL2005
I've got this error when I try to delete a big topic
But it works well on a normal topic
|
Microsoft OLE DB Provider for SQL Server error '80004005'Posted By: WebWiz-Bruce
Date Posted: 12 November 2008 at 6:42pm
|
This could be the sql server configured not to allow large queries to run.
------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: Flyman30
Date Posted: 12 November 2008 at 6:46pm
|
I need to clean my database because I'm 250% of my quota to my hosting How can I increase the time out to file
delete_topic.asp? |
Posted By: WebWiz-Bruce
Date Posted: 13 November 2008 at 8:16am
|
It is something that needs to be done by your web host on the SQL Server.
------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: Flyman30
Date Posted: 13 November 2008 at 8:43am
I have access to SQL Server 2005 by the Management Studio Express but what I have to do to clear the topic, included posts and update the counters? What is the SQL query ? TID=51&PN=1 |
Posted By: WebWiz-Bruce
Date Posted: 13 November 2008 at 11:01am
|
Time out increases and to increase the query governor so a large delete query like this can be run need to be done by a systems admin on the server.
------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: Flyman30
Date Posted: 13 November 2008 at 12:15pm
|
I do not have access to this kind of thing we're on a
shared host ...
|