Not sure if this is a known bug but I can't seem to find this anywhere. There is an extra forum topic total update when an on-hold reply gets approved.
Line 521 and 522 of pop_moderate.asp:
********************************************************
strSql = "UPDATE " & strTablePrefix & "FORUM "
strSql = strSql & " SET " & strTablePrefix & "FORUM.F_COUNT = " & strTablePrefix & "FORUM.F_COUNT + 1, "
strSql = strSql & strTablePrefix & "FORUM.F_TOPICS = " & strTablePrefix & "FORUM.F_TOPICS + 1 "
********************************************************
My suggested fix:
********************************************************
strSql = "UPDATE " & strTablePrefix & "FORUM "
strSql = strSql & " SET " & strTablePrefix & "FORUM.F_COUNT = " & strTablePrefix & "FORUM.F_COUNT + 1 "
if UpdateType = "Topic" then
strSql = strSql & ", " & strTablePrefix & "FORUM.F_TOPICS = " & strTablePrefix & "FORUM.F_TOPICS + 1 "
end if
********************************************************
- atoms
Edited by - atoms on 18 June 2002 16:07:50
Topic Locked
Posted - 17 June 2002 : 17:43:47
