| Author |
 Topic  |
|
|
scorpswolle
Starting Member
39 Posts |
 Posted - 26 November 2005 : 08:11:59
|
I have a problem
I tried to archiving topics older than three months.
I got a timeout message.
Now all these topics are not in the forum and not in the archive.
Are they deleted.
The database size didnīt change ( 370 MB ).
I use:
MSSQL 2000 (MSDE)
Windows Server 2003 Service Pack 1 (IIS 6)
Here is my forum:
http://www.the-scorpions.com/forum/ |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
scorpswolle
Starting Member
39 Posts |
Posted - 27 November 2005 : 07:47:25
|
Yes, there are more than 100 pages missing!
quote:
Originally posted by ruirib
Are you sure they are not in the archive? Did you try to browse the archive to find them?
|
 |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 27 November 2005 : 08:53:40
|
| it shouldn't lose posts, the archiving is designed so that it first archives the posts before deleting them, so if anything I would expect duplicate posts in your live and archive rather than no posts at all |
|
|
|
scorpswolle
Starting Member
39 Posts |
Posted - 30 November 2005 : 18:36:28
|
The Forum has started on January 2003.
Now i canīt find topics from 2004 wheter in FORUM_A_TOPICS or FORUM_TOPICS. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 03 December 2005 : 19:47:12
|
| It's very weird, since as HuwR wrote, topics are copied first and then deleted. You have looked in the database, I presume? Have you tried to execute update counts in Admin Options? |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 04 December 2005 : 04:10:50
|
| Are you sure you archived them and didn't use the delete function by mistake |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 04 December 2005 : 04:16:52
|
quote:
Originally posted by scorpswolle
The Forum has started on January 2003.
Now i canīt find topics from 2004 wheter in FORUM_A_TOPICS or FORUM_TOPICS.
You have lots of topics from 2004, here is one for example http://www.the-scorpions.com/forum/topic.asp?TOPIC_ID=4662, maybe what you don't understand is that archiving of a topic is based on the LAST REPLY date not the TOPIC date |
|
|
|
golfmann
Junior Member
United States
450 Posts |
Posted - 09 December 2005 : 20:31:23
|
This may not be the right spot to ask but I am anyway...
What does archiving achieve for you, anyway?
What is improved?
When should one start archiving? 100,000 posts more? less?
(There is very little information on this I could find, maybe it was archived)  |
Edited by - golfmann on 09 December 2005 20:42:49 |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 10 December 2005 : 04:09:51
|
The question as to whem you should archive really depends on the speed of your servers and database, the better the db performs, the less likely you are to need to archive.
Archiving basically reduces the number of records in forum_topic and forum_reply, thus improving the performance when searching posting or browsing the forums. |
|
|
|
golfmann
Junior Member
United States
450 Posts |
Posted - 10 December 2005 : 08:30:02
|
| Thanks Huw... |
|
|
|
scorpswolle
Starting Member
39 Posts |
Posted - 12 December 2005 : 17:49:09
|
Thanks for your answers, i really appreciate your support!
Well the problem in detail iīm talking about is the Forum Scorpions General Discussion In Category Scorpions Talk (http://www.the-scorpions.com/forum/default.asp?CAT_ID=1). The last topic is from July 13 2005 and in the archived topics there is only one topic from 2004 and the rest is from 2003. Áll other topics from 2004 in this forum are missing.
What have i done? I used the Archive topics from a forum function in the Admin Options for this forum and received after a few minutes a server timeout. Thatīs all! Iīm very confused...
quote:
Originally posted by HuwR
quote:
Originally posted by scorpswolle
The Forum has started on January 2003.
Now i canīt find topics from 2004 wheter in FORUM_A_TOPICS or FORUM_TOPICS.
You have lots of topics from 2004, here is one for example http://www.the-scorpions.com/forum/topic.asp?TOPIC_ID=4662, maybe what you don't understand is that archiving of a topic is based on the LAST REPLY date not the TOPIC date
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 13 December 2005 : 03:56:22
|
scorpswolle,
Are you absolutely positive you chose "Archive topics" and not "delete topics", as I have said, the code can not do what you are experiencing, this is the sequence of events in the code.
1) move replies to archive table
2) delete the original replies
3) move the corresponding topics to archive table
4) delete original topics
so, NOTHING is deleted until after it has been archived so your scenario can not occur since it can't not archive them and then subsequently delete them, it is not possible. The only event that could possibly explain your situation would be running the "delete arcive" by mistake |
|
|
| |
Topic |
|
Topic Locked
