I've found that when creating a new forum the selected Subscription choice is not inserted into the database correctly with the new record.
The problem occurs in post_info.asp in the section beginning with if MethodType = "Forum" then
Several lines down, the code reads:
' DEM --> Start of Code added for moderation and subscription
if strSubscription = 1 and CatSubscription > 0 then
strSql = strSql & ", " & fSubscription
else
strSql = strSql & ", 0"
end if
The problem occurs with strSubscription = 1 which means that Whole Board subscription was set as the highest level of subscription (I think). If another level was chosen, Category for example, the subscription selection when creating a new forum won't work. I replaced the above snippet of code with the following, and it seems to work:
' DEM --> Start of Code added for moderation and subscription
if (strSubscription > 0 and strSubscription < 4) _
and CatSubscription > 0 then
strSql = strSql & ", " & fSubscription
else
strSql = strSql & ", 0"
end if
I don't think strSubscription < 4 is necessary, but I included it because 4 indicates that the highest subscription level is Topic.
Nikkol
Edited by - Nikkol on 10 February 2002 02:27:21
Edited by - Davio on 26 February 2002 20:54:25