BUG: Delete Thread
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=18829
Printed Date: 12 April 2026 at 8:42pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: BUG: Delete Thread
Posted By: ljamal
Subject: BUG: Delete Thread
Date 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.
-------------
L. Jamal Walton
http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming
|
Replies:
Posted By: ljamal
Date 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.
-------------
L. Jamal Walton
http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming
|
Posted By: WebWiz-Bruce
Date 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.
|
Posted By: ljamal
Date 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.
-------------
L. Jamal Walton
http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming
|
Posted By: WebWiz-Bruce
Date 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.
|
Posted By: ljamal
Date 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.
-------------
L. Jamal Walton
http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming
|
Posted By: WebWiz-Bruce
Date 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.
|
|