Reset Post Views

Posted in: Newspaper
Post count: 85
sunkast
#3569
Dec 19, 2013 at 3:49 am

Due to working on the theme on a staging server, some posts are getting higher post views due to all of the testing I am performing.

Is there a way to reset the post views count?

Post count: 3343
Marius
#3575
Dec 19, 2013 at 9:25 am

Hello,
If you want only for some particular post you can edit the value from post edit http://screencast.com/t/NtmENZvr

or you can reset all to 0 running this SQL on the database

update wp_postmeta
set meta_value=0
where meta_key = post_views_count

Thanks for your message

Post count: 85
sunkast
#3576
Dec 19, 2013 at 9:29 am

Awesome. Thanks as always for your help Marius.

Post count: 85
sunkast
#8822
Mar 18, 2014 at 1:35 am

Hey Marius,

I tried using this SQL today, but it didn’t work. It gave me an error:

#1054 – Unknown column ‘post_views_count’ in ‘where clause’

Post count: 3343
Marius
#8848
Mar 18, 2014 at 10:15 am

Hi,
Try this: 

update wp_postmeta
set meta_value=0
where meta_key = 'post_views_count'

Thanks!

Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic.