https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 13 Apr 2026 07:14:14 +0000 Mon, 20 Jun 2005 06:18:40 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=15517 https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ https://forums.webwiz.net/minor-bug-email-notification-not-deleted_topic15517_post85416.html#85416 Author: sfd19
Subject: 15517
Posted: 20 June 2005 at 6:18am

Also polls and poll choices get not deleted when you move the last remaining post of a topic with a poll somwhere else.]]> Mon, 20 Jun 2005 06:18:40 +0000 https://forums.webwiz.net/minor-bug-email-notification-not-deleted_topic15517_post85416.html#85416 https://forums.webwiz.net/minor-bug-email-notification-not-deleted_topic15517_post85415.html#85415 Author: sfd19
Subject: 15517
Posted: 20 June 2005 at 6:12am

Also move_post.asp is concerned when the last remaining post in a topic gets moved.]]> Mon, 20 Jun 2005 06:12:57 +0000 https://forums.webwiz.net/minor-bug-email-notification-not-deleted_topic15517_post85415.html#85415 https://forums.webwiz.net/minor-bug-email-notification-not-deleted_topic15517_post85411.html#85411 Author: sfd19
Subject: 15517
Posted: 20 June 2005 at 4:47am

I found a minor bug in the code, when deleting a category, a forum, atopic or the last post in a topic then the email notifications for thetopic or forum do not get deleted.


Something like this will fix it in delete_category.asp and delete_forum.asp:

strSQL = "DELETE FROM " & strDbTable & "EmailNotify WHERE "& strDbTable & "EmailNotify.Topic_ID="  & lngTopicID& " OR " & strDbTable & "EmailNotify.Forum_ID=" & intForumID & ","
adoCon.Execute(strSQL)

In delete_topic.asp and delete_post.asp use the same code without the check for intForumID.

It is not really a bug but can slow down the forum a little when youhave thousands of entries in tblEmailNotify that are not neededanymore, like we had.

Maybe boRg wants to update the code.


Edited by sfd19 - 20 June 2005 at 7:02am]]> Mon, 20 Jun 2005 04:47:30 +0000 https://forums.webwiz.net/minor-bug-email-notification-not-deleted_topic15517_post85411.html#85411