A nice tip to perfrom some “spring cleaning” in wordpress

The original post is here.
My blog has been here for almost five years now. It is time to do some “spring cleaning”. I am using the tip from Marco Luthe to clean/reset my counter.

Resetting Popularity Contest and WP-PostViews

To make the WordPress plugin “Popularity Contest” start from the beginning, deactivate the plugin and empty the table wp_ak_popularity with the following SQL-Statement:

TRUNCATE TABLE `wp_ak_popularity`

Then, reactivate the plugin.

If you want to reset the WordPress plugin “WP-PostViews” to make it count from scratch, deactivate the plugin, then use

UPDATE `wp_postmeta` SET meta_value = 0 WHERE meta_key = "views"

Then, reactivate the plugin.

(”wp_” is the default table prefix for WordPress, which might be different in your installation.)