| Author |
 Topic  |
|
|
clj
Junior Member
145 Posts |
 Posted - 20 April 2005 : 09:56:14
|
Hi all,
Deleting topics from archives has been timing out for me, so I printed the SQL to screen and went into the database (SQL) to delete directly from the FORUM_A_REPLY table (the one which was timing out).
Great I thought, but then I noticed there are some topics towards the end of my archive where the replies have been deleted (presumably because of the date I entered into the SQL) thus making a topic which says it has 5 pages actually only have 1 page.
Take a look at the topic "That's it, it's too cold" on here to see what I mean... (link removed)
It says there are 5 pages but there is really only 1
I know I could update forum counts to knock off the page listing for pages 2, 3, 4 & 5 (as they don't exist) and I know that the replies are gone forever, however, I am now concerned about the delete from archive process accidentally deleting half of the replies from topics like this.
Does anyone know if the deleting from archive process ensures that the topic has been deleted before it deletes the replies? I wonder if I accidentally bypassed this when I deleted straight from the database?
If anyone has understood this and can shed some light I would be really grateful
Many thanks
Clare |
Edited by - clj on 18 July 2005 10:50:34 |
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 20 April 2005 : 13:14:56
|
| This is something you have done, the forum functions delete the topic before deleting the replies, so you could never get a topic with only half its replies. |
 |
|
|
clj
Junior Member
145 Posts |
Posted - 20 April 2005 : 19:12:22
|
Ah righto, thanks Huw!! :-)
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
Topic Locked
