Resetting view count

[s2kinteg9166]

I ran a query to update the thread view count to 0

The database shows 0 but the front end now im seeing view count is the number of replies + 1

Any ideas how i can get this to 0?

The database shows the correct number

 

[wang]

UPDATE `xf_thread` SET view_count = 0;

That sql query should reset all thread view counts to 0.

Can you screenshot that part where thread view count is not correct?

 

[s2kinteg9166]

Thanks for the reply. I did run that query but on the front end its showing this.

http://www.evernote.com/shard/s54/s...d077c97d94ea/f6344619408b365ecb7c9978cbbf05b6

Its the same for all my threads. reply count + 1

 

[wang]

I have to ask, are you really sure that you excecuted that query in the database of your forum, and say, not in a database used for another forum?

Can you please screenshot the view_count field for threads from phpmyadmin?

 

[s2kinteg9166]

Heres the screenshot from the phpmyadmin. I just ran it again and it updated 5000 records. I have 106k threads in total.

http://www.evernote.com/shard/s54/s...a307d3266a0d/aed1e5b2d6b17594a0d33b6084f3cdfe

 

[wang]

And do thread views still appear like before?

Can you please post here the link to your forum?

 

[s2kinteg9166]

No the view count now is the thread + replies + 1

http://www.twinstuff.com/forums/forums/twinstuff-club.120/

Should i run any of the crons or caches rebuild?

 

[wang]

Can you go to Crons in your Admin Panel and run this one, Update View Counters?

 

[s2kinteg9166]

Just ran it says
"
Cron entry was run successfully.

"

 

[wang]

This is an odd issue. The only reasons that I can think of for this not working, is that either the query is not being run in the right database, or you have a third party add on that it is manipulating thread views.

 

[s2kinteg9166]

Well the numbers are right in the database but front end shows a different number

 

[wang]

Well the numbers are right in the database but front end shows a different number

Right, but if view count field for threads is 0 in the database, they should be 0 on front end too. That is why I suspect that the query maybe has not been excecuted in the right database.

 

[s2kinteg9166]

I agree, but the fact the front end shows the view count as the reply count + 1 makes me think it has to do with how view counts are calculated.

 

[wang]

View counts are separated from reply counts. Your situation is very strange.

Can you check thread_list_item template, and see if you have this code there?

<dl class="minor"><dt>{xen:phrase views}:</dt> <dd>{xen:if $thread.isRedirect, '&ndash;', {xen:number $thread.view_count}}</dd></dl>

What add ons do you have installed? Can you list them here? Do you have custom made crons that perhaps manipulate thread views? Because this is not a default behavious of xenforo. There must be an outside thing causing this.

 

[s2kinteg9166]

Uninstalled all my plugins
http://www.evernote.com/shard/s54/s...8d348da37bb3/4ddc5773819bdf21cb531085b127535c

Went back to default theme...

Ran the query again
Ran the counter again

Nothing

 

[wang]

Do you mind to give me access to your forum so I can have a look into this?

I do not know if this is covered by the support policy of Xenforo, but you can open a Ticket at your Helpdesk, and maybe one of Xenforo 's Team members can look into this. Because this is a very odd issue.

I will have to ask you again, are you 100% sure that you have run the query at the database where your forum is installed?

 

[s2kinteg9166]

I submitted a ticket to support and they said theres no support =) since its not recommended.

yes i only have one db and it works just the front end view is different. If you look in the DB it works how it should.

when i use the batch update tool in xenforo the data is right as well. Its a front end view issue.

 

[Paul B]

The view count is always going to be at least the post count (which is reply count +1).

Check the model code.

 

[wang]

The view count is always going to be at least the post count (which is reply count +1).

Check the model code.

You are correct sir. I thought that they would have been independent from each other. Is there any reason why it is being calculated like that?

This is for the OP. If you do not want to be calculated like that, remove this code from the Thread.php file inside the Model folder.

if ($thread['view_count'] <= $thread['reply_count'])
{
        $thread['view_count'] = $thread['reply_count'] + 1;
}

 

[Paul B]

Is there any reason why it is being calculated like that?

Logically, it is impossible for a thread to have 0 views.
It has to have at least 1 view per post.