Hey guys. We have a pretty big board (2175 Active Members/55000+ registered, 89835 posts in 8071 topics) running Snitz and I've had numerous complaints from my users about an Overflow error that occurs when posting. I think I've narrowed it down to this bit of code in post_info.asp:
'## Forum_SQL - Update Last Post and count
strSql = "UPDATE " & strTablePrefix & "TOPICS "
strSql = strSql & " SET T_LAST_POST = '" & DateToStr(strForumTimeAdjust) & "'"
strSql = strSql & ", T_REPLIES = T_REPLIES + 1 "
strSql = strSql & ", T_LAST_POST_AUTHOR = " & rs("MEMBER_ID")
if Request.Form("lock") = 1 then
strSql = strSql & ", T_STATUS = 0 "
end if
strSql = strSql & " WHERE TOPIC_ID = " & Request.Form("TOPIC_ID")
my_Conn.Execute (strSql)
'## Forum_SQL
strSql = "UPDATE " & strTablePrefix & "FORUM "
strSql = strSql & " SET F_LAST_POST = '" & DateToStr(strForumTimeAdjust) & "'"
strSql = strSql & ", F_LAST_POST_AUTHOR = " & rs("MEMBER_ID")
strSql = strSql & ", F_COUNT = F_COUNT + 1 "
strSql = strSql & " WHERE FORUM_ID = " & Request.Form("FORUM_ID")
my_Conn.Execute (strSql)
More specifically the second statement is the line usually reported in the error. Is there anything in here that you can see would cause something like this on a big board?
Thanks in advance for your help.
Topic Locked
Posted - 26 March 2002 : 23:35:36
