Solved: 4 Years, 1 Month, 3 Days, 23 Hours, 27 Minutes, 8 Seconds ago Reset Views Count
#1
Solved: 4 Years, 1 Month, 3 Days, 23 Hours, 27 Minutes, 8 Seconds ago
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
Regards,
Terry
#2
Solved: 4 Years, 1 Month, 3 Days, 23 Hours, 27 Minutes, 8 Seconds ago
Run this query in phpMyAdmin:

PHP Code:
UPDATE `mybb_threadsSET `views` = '0'
Can you still feel the butterflies?

Free never tasted like pudding.
#3
Solved: 4 Years, 1 Month, 3 Days, 23 Hours, 27 Minutes, 8 Seconds ago
Worked Perfect! Big Grin

Thank you
Regards,
Terry
#4
Solved: 4 Years, 1 Month, 3 Days, 23 Hours, 27 Minutes, 8 Seconds ago
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

Big Grin
#5
Solved: 4 Years, 1 Month, 3 Days, 23 Hours, 27 Minutes, 8 Seconds ago
Go into PHPMyAdmin and edit the view count for each specific forum/thread!
#6
Solved: 4 Years, 1 Month, 3 Days, 23 Hours, 27 Minutes, 8 Seconds ago
(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 Blush, how do I select individual forums/threads within PHPMyAdmin?

Thanks
#7
Solved: 4 Years, 1 Month, 3 Days, 23 Hours, 27 Minutes, 8 Seconds ago
PHP Code:
UPDATE `mybb_threadsSET `views` = '0' WHERE `fid` = '1'

Change the 1 to the FID of the forum and all threads in that forum will have no views.
Can you still feel the butterflies?

Free never tasted like pudding.
#8
Solved: 4 Years, 1 Month, 3 Days, 23 Hours, 27 Minutes, 8 Seconds ago
(04-07-2010, 11:16 AM)MattRogowski Wrote:  
PHP Code:
UPDATE `mybb_threadsSET `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!Big Grin
#9
Solved: 4 Years, 1 Month, 3 Days, 23 Hours, 27 Minutes, 8 Seconds ago
Lol, Thanks for that Matt... I'm still learning Big Grin
#10
Solved: 4 Years, 1 Month, 3 Days, 23 Hours, 27 Minutes, 8 Seconds ago
(03-07-2010, 01:08 AM)MattRogowski Wrote:  Run this query in phpMyAdmin:
PHP Code:
UPDATE `mybb_threadsSET `views` = '0'
Talk about 'novice', am not even able to find phpMyAdmin... is that somewhere in the forum admin interface ?

Thanks again for your help !
akm


Forum Jump:


Users browsing this thread: 1 Guest(s)