quote:

---

Originally posted by Carefree

If you're using 3.4.07, the default "pop_delete.asp" does delete subscriptions upon deletion of topics/forums/categories. Have you installed a mod which changed that file?

---

quote:

---

Originally posted by Webbo

Create a new blank file called lost_subscriptions.asp

---

quote:

---

Originally posted by Webbo

Create a new blank file called lost_subscriptions.asp and copy and paste the following code to it:

<!--#INCLUDE FILE="config.asp" -->

<%

Dim strSql, conn, lngCount


strSql = "DELETE " & strTablePrefix & "SUBSCRIPTIONS FROM " & strTablePrefix & "SUBSCRIPTIONS LEFT JOIN " & _
         strTablePrefix & "TOPICS ON " & strTablePrefix & "SUBSCRIPTIONS.TOPIC_ID = " & strTablePrefix & _
       "TOPICS.TOPIC_ID WHERE " & strTablePrefix & "TOPICS.TOPIC_ID Is Null;"



Set conn = Server.CreateObject("ADODB.Connection")

conn.Open strConnString

conn.Execute strSql, lngCount, 1 + 128

Response.Write lngCount & " Subscriptions to lost Topics were Deleted<br>"

conn.Close

%>

Upload it into your forum folder and then run the file via your browser to delete the blank topic subscriptions


(Not my work but I can't remember the name of the author)

---