Reset Views Count

[tbrothers]

Hello,

I have just setup a forum for our church. I haven't announced its availability yet because the rest of the site isn't complete yet.

There are some threads in my forum that show they have been viewed 30 and 40 times ... but they are all mine while I've been dink'n around. It's not a show stopper ... but is there any way to reset the count to zero?

Thanks,
Terry

[MattRogowski]

Run this query in phpMyAdmin:

PHP Code:

UPDATE `mybb_threads` SET `views` = '0'; 


[tbrothers]

Worked Perfect!

Thank you

[redsox]

Hello,

I have been working on one forum section in particular, adding up some strange view counts. Would it be possible to recount the hits on the threads in just one forum section whilst leaving the rest of the forums view counts alone?

Would appreciate any help

[Prentice]

Go into PHPMyAdmin and edit the view count for each specific forum/thread!

[redsox]

(04-07-2010 10:10 AM)Prentice Wrote:  Go into PHPMyAdmin and edit the view count for each specific forum/thread!

Thanks for the quick answer, sorry I'm pretty amateur , how do I select individual forums/threads within PHPMyAdmin?

Thanks

[MattRogowski]

PHP Code:

UPDATE `mybb_threads` SET `views` = '0' WHERE `fid` = '1'; 


Change the 1 to the FID of the forum and all threads in that forum will have no views.

[redsox]

(04-07-2010 11:16 AM)MattRogowski Wrote:  

PHP Code:

UPDATE `mybb_threads` SET `views` = '0' WHERE `fid` = '1'; 


Change the 1 to the FID of the forum and all threads in that forum will have no views.

Great just worked,

Cheers!

[Prentice]

Lol, Thanks for that Matt... I'm still learning

[akm]

(03-07-2010 01:08 AM)MattRogowski Wrote:  Run this query in phpMyAdmin:

PHP Code:

UPDATE `mybb_threads` SET `views` = '0'; 


Talk about 'novice', am not even able to find phpMyAdmin... is that somewhere in the forum admin interface ?