Bug
If you move a topic to a different category, the CAT_ID in the TOPICS and REPLY table doesn't get updated to the new CAT_ID.
This causes existing topics to no longer show up in Active.asp
Fix
In Post_info.asp change the code starting at around line 822 to:
if Err_Msg = "" then
'## Forum_SQL - Check if CAT_ID changed
strSql = "SELECT " & strTablePrefix & "FORUM.CAT_ID "
strSql = strSql & " FROM " & strTablePrefix & "FORUM "
strSql = strSql & " WHERE FORUM_ID = " & Request.Form("FORUM_ID")
set rsCatIDCheck = my_Conn.execute(strSql)
bolCatIDChanged = (rsCatIDCheck("CAT_ID") <> Request.Forum("Category"))
rsCatIDCheck.Close
set rsCatIDCheck = Nothing
'## Forum_SQL - Do DB Update
strSql = "UPDATE " & strTablePrefix & "FORUM "
strSql = strSql & " SET CAT_ID = " & Request.Form("Category")
if strPrivateForums = "1" then
strSql = strSql & ", F_PRIVATEFORUMS = " & Request.Form("AuthType") & ""
strSql = strSql & ", F_PASSWORD_NEW = '" & ChkString(Request.Form("AuthPassword"),"password") & "'"
end if
strSql = strSql & ", F_SUBJECT = '" & txtSubject & "'"
strSql = strSql & ", F_DESCRIPTION = '" & txtMessage & "'"
strSql = strSql & " WHERE FORUM_ID = " & Request.Form("FORUM_ID")
my_Conn.Execute (strSql)
if bolCatIDChanged then
'## Forum_SQL - Do DB Update
strSql = "UPDATE " & strTablePrefix & "TOPICS "
strSql = strSql & " SET CAT_ID = " & Request.Form("Category")
strSql = strSql & " WHERE FORUM_ID = " & Request.Form("FORUM_ID")
my_Conn.Execute (strSql)
'## Forum_SQL - Do DB Update
strSql = "UPDATE " & strTablePrefix & "REPLY "
strSql = strSql & " SET CAT_ID = " & Request.Form("Category")
strSql = strSql & " WHERE FORUM_ID = " & Request.Form("FORUM_ID")
my_Conn.Execute (strSql)
end if
Note #1 I didn't have time to live-check this yet !!
Note #2 As far as the site here, I updated the CAT_ID for then MOD-forums so that should be fixed for now.
Note #3 Mike, I didn't change this in the code for the site yet.
Pierre
Forum Locked
Topic Locked
Posted - 31 January 2001 : 04:35:39
