Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 DEV-Group
 DEV Bug Reports (Closed)
 BUG (3.1sr4)+ FIX: Incorrect Read Counts
 Forum Locked  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

fido
Starting Member

30 Posts

Posted - 05 June 2001 :  12:32:24  Show Profile
This was originally posted under General Help, but someone said it was a bug, so I am making a copy of this message here.



I have a thread that has been replied to 278 times (19 pages long). However, I noticed that the number of times the thread has been read only shows 107.

Thread: Here
Page Showing Counts: Here
Topic name is "Word Games"

I did some investigation, and discovered that when you have "Quick Paging" enabled, and someone jumps directly to page number 19 for example, it doesn't count that as a 'thread read'. But if you go to page 1 via the quick paging link it does count it as a read.

Is this a bug or is this type of behavior expected?

<img src="http://www.littlewhitedog.com/forum/icon_smile_spider.gif" border=0><img src="http://www.littlewhitedog.com/forum/icon_smile_shooter3.gif" border=0>

Fido
Fido@littlewhitedog.com
http://www.littlewhitedog.com/forum/





Wixxerd
Starting Member

25 Posts

Posted - 23 June 2001 :  15:38:22  Show Profile
What's the fix for this? I have quick paging off, yet some of my read counts aren't incrementing? (*Only some of of them too... how wacky is that??*) I've moved the read count code like Kal suggested, and that only resolved a few of them? (I'm turning quick paging back off)

Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 24 June 2001 :  07:36:03  Show Profile  Visit HuwR's Homepage
Okay, you need to look for this code


'## Forum_SQL
strSql = "UPDATE " & strActivePrefix & "TOPICS "
strSql = strSql & " SET " & strActivePrefix & "TOPICS.T_VIEW_COUNT = (" & strActivePrefix & "TOPICS.T_VIEW_COUNT + 1) "
strSql = strSql & " WHERE (" & strActivePrefix & "TOPICS.TOPIC_ID = " & Topic_ID & ");"

my_conn.Execute (strSql)


It should be in the getfirst() function, select all the code and cut it to the clipboard, now do a search for

if mypage = 1 then
Call GetFirst()
end if

and insert the code you just cut after the end if.



This bug has been fixed in the latest source

Go to Top of Page

Old Ager
New Member

Italy
59 Posts

Posted - 24 June 2001 :  17:19:42  Show Profile  Visit Old Ager's Homepage  Send Old Ager an ICQ Message
HuwR,

quote:
Okay, you need to look for this code

'## Forum_SQL
strSql = "UPDATE " & strActivePrefix & "TOPICS "
strSql = strSql & " SET " & strActivePrefix & "TOPICS.T_VIEW_COUNT = (" & strActivePrefix & "TOPICS.T_VIEW_COUNT + 1) "
strSql = strSql & " WHERE (" & strActivePrefix & "TOPICS.TOPIC_ID = " & Topic_ID & ");"
my_conn.Execute (strSql)

It should be in the getfirst() function, select all the code and cut it to the clipboard, now do a search for

if mypage = 1 then
Call GetFirst()
end if

and insert the code you just cut after the end if.



What file is this code supposed to be changed in? I have searched through topic.asp and several other files, but could not find a match for "strActivePrefix."

Old Ager
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 24 June 2001 :  17:34:18  Show Profile  Visit HuwR's Homepage
sorry that is my fault,
the code is from the latest 33, just replace strActivePrefix with strTablePrefix

Go to Top of Page

Old Ager
New Member

Italy
59 Posts

Posted - 25 June 2001 :  01:03:12  Show Profile  Visit Old Ager's Homepage  Send Old Ager an ICQ Message
Thanks!



Old Ager
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.12 seconds. Powered By: Snitz Forums 2000 Version 3.4.07