is this normal ? There are no errors, but i'm wondering if there are some integer / float values getting mixed.
My forum is still only on my localhost but i could replicate it on Davios forum [ hope you dont mind!] http://www.dsilvera.com/forum/forum.asp?FORUM_ID=6 see thread called "archiving error message". now click on "jump to last post". you'll see that whichpage=1.6 NB: this cant be replicated at this forum on snitz.com
which brings me to my second related query.
line #367 of topic.asp: arrReplyData = rsReplies.GetRows(intGetRows)
shouldnt this be wrapped in a
if not rsReplies.eof then
>>arrReplyData = rsReplies.GetRows(intGetRows)
else
iReplyCount = ""
End if
if there is an invalid "whichpage" value, then there is a server error generated. Unfotunately whoever wrote that code didnt put any comments with it, so it is hard to figure out what is going on. Part of the problem seems to be that iPageTotal is always > 0.
Didn't really look into it as it didn't cause any problems. Now that you mention that it is mysql only problem, it might give a good clue as what's the cause.
Around line 230 to 290 in topic.asp, you will find this bit of code. Add the code in red. That should solve it.
for iReply = 0 to iReplyCount
intReplyID = arrReplyData(rREPLY_ID,iReply)
if LastPostReplyID = intReplyID then
intPageNumber = ((iReply+1)/strPageSize)
if intPageNumber > cLng(intPageNumber) then
intPageNumber = cLng(intPageNumber) + 1
else
intPageNumber = cLng(intPageNumber)
end if
strwhichpage = "whichpage=" & intPageNumber & "&"
exit for
end if
next
Topic Locked
Posted - 28 January 2004 : 09:55:56
