| Author |
 Topic  |
|
|
clj
Junior Member
145 Posts |
 Posted - 12 July 2004 : 13:49:42
|
Hello
When I try to delete archived topics over 1 year old, I get the following:
"Topics older than 7/12/2003 6:33:44 PM have been deleted from the selected archive forum."
(which they have) but then I get an error....
Error Number: -2147217871
Source: Microsoft OLE DB Provider for SQL Server
File: /forum/admin_forums.asp
Description: Timeout expired.
Code: No code available
Line: 430
Time: 12/07/2004 17:50:00
Script name : /forum/admin_forums.asp
Line 429/430 are
strsql = "DELETE FROM " & strArchiveTablePrefix & "REPLY WHERE R_DATE < '" & strDateOlderThan & "'" & fIDSQL
my_conn.execute(strsql),,adCmdText + adExecuteNoRecords
so I think it's the replies that are not being deleted.
I have tried changing the timeout value at line 436 in admin_forums.asp but this makes no difference.
Does anyone have any ideas what to do please?
Should I manually delete the replies from the database?
Thanks for your advice,
Clare |
Edited by - clj on 13 July 2004 13:23:49 |
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 14 July 2004 : 04:34:44
|
Do you have many topics over a year old? Try upping the time period (e.g., 2 years) to start with and try deleting batches of topics rather than all of them at once.
|
 Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
 |
|
|
clj
Junior Member
145 Posts |
Posted - 14 July 2004 : 06:38:33
|
Hi Shaggy, Thanks for your reply.
No I don't have many topics over 1 year old, infact if I look on the forum I can't see any because I think they have been deleted, but not their replies (I can't see the replies on the site - but I think they are still in the database).
I'm not sure how to 'up' the time period - the maximum option on the drop down is one year.
I have just been through and deleted each forum section one by one. This seemed to work (although I had to do some twice or 3 times as they timedout to start with) so I think this is something I will have to keep on top of.
If anyone has any insight into how I can delete from all forums archives without a timeout error I would appreciate it.
Thanks!
PS: The forum is about 2 years old |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
clj
Junior Member
145 Posts |
Posted - 19 July 2004 : 13:18:41
|
Hi ruirib
Thanks for your advice, I wrote the SQL to screen and copied it to Query Analyser which worked a treat!
Many thanks again,
Clare |
|
|
| |
Topic |
|
Topic Locked
