| Author |
 Topic Search  Topic Options
|
ljamal 
Mod Builder Group
Joined: 16 April 2003
Status: Offline
Points: 888
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: BUG: Delete Thread
Posted: 21 March 2006 at 3:49pm |
|
If you delete the first message of a topic that has replies, then the topic is still assessible from the last post for the forum, but the topic is not listed on the forum topics page.
It's like the topic doesn't exist unless you have a direct link to it.
Edited by ljamal - 21 March 2006 at 4:02pm
|
|
|
 |
ljamal
Mod Builder Group
Joined: 16 April 2003
Status: Offline
Points: 888
|
Post Options
Thanks(0)
Quote Reply
Posted: 21 March 2006 at 4:01pm |
|
Looking at that database it appears to be caused by the fact that the Start_Thread_ID does not not have a record in the Thread Table. Maybe the entire thread should be deleted if the first post in the thread is deleted or the Start_Thread_ID should be updated.
|
|
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 21 March 2006 at 4:15pm |
|
I'm not sure if I just don't understand exactly waht you are saying or if I can not replicate the error you mention.
When the first post is deleted in a topic the Start_Thread_ID should be updated with the ID of the next post in the topic. In tests I have done and just run again this is how it is working.
Try reuploading the files again incase you have a corruption, if you still have the problem could you please post what database version you are using and a step by step guide on how you are getting this error.
Edited by -boRg- - 21 March 2006 at 4:17pm
|
|
ljamal
Mod Builder Group
Joined: 16 April 2003
Status: Offline
Points: 888
|
Post Options
Thanks(0)
Quote Reply
Posted: 21 March 2006 at 4:36pm |
|
I'm using SQL Server 2000
I post new topic
I post a reply to the topic
Using the delete button underneath the first (start_thread_ID) post, I delete the post
I click the link to forum_topics.aps and the topic is gone even though there is one post in the topic.
I click the link to the default page and it shows the post in the topic as the most recent post.
Looking at the code for delete_post.asp, it does update the last_thread_ID for the thread. However, it doesn't update the Start_Thread_ID for the thread.
If I manually change the Start_Thread_ID then the thread reappears.
Edited by ljamal - 21 March 2006 at 4:39pm
|
|
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 21 March 2006 at 4:42pm |
|
Thanks, I've found the problem now.
Looks like the Start_Thread_ID is not updated correctly. Shame this type of thing didn't come up in beta testing, but I guess not enough people beta tested the software.
|
|
ljamal
Mod Builder Group
Joined: 16 April 2003
Status: Offline
Points: 888
|
Post Options
Thanks(0)
Quote Reply
Posted: 21 March 2006 at 4:44pm |
|
My suggestion would be to update the function (UpdateTopicReplyDetails) to update the Start_Thread_ID as well as the Last_Thread_ID.
I wish I could have been part of the Beta Testing, but I was swamped with work all year. I just cleared everything off my plate but 2 projects.
Edited by ljamal - 21 March 2006 at 4:46pm
|
|
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 21 March 2006 at 4:50pm |
|
You must have read my mind as that is exactly what I am looking at, at the moment.
Just got a few bits to workout through as the function is called in a number of places.
|
|
