PDA

View Full Version : Thread/Post view counts are not increasing all stuck at 0 throughout the forum


ppatil007
09-28-2011, 02:45 AM
None of the Views are increasing past couple of weeks
I was forced to open new thread as my earlier query was probably missed and this is an independent issue from what I faced earlier


https://vborg.vbsupport.ru/showthread.php?t=270286&page=2

already tried

1)Server Settings and Optimization Options -> Update Thread Views Immediately
No change

then i tried

2) Maintenance -> Repair / Optimize Tables -> threadviews table select

got this

threadviews Check Status: OK
threadviews Optimize Status: Table is already up to date

ppatil007
09-29-2011, 09:19 PM
can any one guide me ?

Lynne
09-29-2011, 10:34 PM
How about Maintenance > Update Counters > Rebuild Thread Information and then Rebuild Forum Information.

ppatil007
09-30-2011, 02:08 AM
How about Maintenance > Update Counters > Rebuild Thread Information and then Rebuild Forum Information.
Thanks Lynne
I had already tried that in vain , in fact tried updating all counter :confused:
How does that number of view counter logic work ? is that a separate php file may be if i replace that particulate code or file it might stat working? just a thought
I have seen several people on the net with similar issue but no one has responded back how they finally got it fixed :(
any guidance trail error methods will be greatly appreciated

Lynne
09-30-2011, 02:45 AM
Rebuilding the thread information should have fixed the post count issue. The view issue though is just not something that can be fixed by running the counters. I have seen a query that basically just sets them to the post count + 2.
UPDATE thread
SET views = replycount * 2
WHERE views < replycount
(only run after replycount is fixed)

ppatil007
09-30-2011, 03:19 PM
Rebuilding the thread information should have fixed the post count issue. The view issue though is just not something that can be fixed by running the counters. I have seen a query that basically just sets them to the post count + 2.
UPDATE thread
SET views = replycount * 2
WHERE views < replycount
(only run after replycount is fixed)

Thanks for the response but i was looking for something else :erm:
May be I did not explain properly (attached image this time):p
I dont have any issues with Thread Replies Or Post Replies - if i have 3 people reply on thread I see
Replies as 3
My original issue is the Number of times some one views a thread (this counter) i.e Thread views
is always " Views: 1 " its not changing at all

Also I am no expert kindly elaborately explain what I need to do step wise , I did not follow where you want me to put that code and what needs to be changed and its impacts

http://img831.imageshack.us/img831/6610/viewissue.jpg

Lynne
09-30-2011, 04:26 PM
And that query would change the Views to 6 for the thread that has "Replies: 3" It would not affect the others since Views > Replies.

ppatil007
09-30-2011, 10:37 PM
And that query would change the Views to 6 for the thread that has "Replies: 3" It would not affect the others since Views > Replies.

Unfortunately your response is not very clear & too high level for me to understand
I just want the number of Views to work " Views: 1 "
as shown in the above screenshot it not working its stuck to "1" this should change as per the number of users entering the thread

I dont follow what you want me to do to fix the issue in both you earlier resonse ? what query are you talking about
where should I navigate and what should i fix ? please mention files names / locations

If i have interpreted correct you area asking me to make changes to some code logic in some xyz file

still your logic does not work in case no one replies
SET views = replycount * 2 = 0 which will equal 0 as reply might be 0 but views may be 1000 Views and Replies are independent they dont have any logic or realtionship

PLEASE PLEASE ready my question properly and respond in detail
Thanks for your time :up: