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]

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

I get that. But they would not have 0 views. After someone posts a thread, and gets redirected to it, the view count is increased automatically from 0 to 1. Unless Xenforo does not count views by thread starters. (I have not looked it up yet.)

 

[ARad]

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?

How do I run that sql query?

 

[wang]

How do I run that sql query?

Go to your phpmyadmin, select the database of your forum, click on the Sql tab and copy/paste there the query.

 

[ARad]

Go to your phpmyadmin, select the database of your forum, click on the Sql tab and copy/paste there the query.

Thanks for your help.

 

[wang]

Thanks for your help.

You are welcome sir.