- Details
- Written by Super User
- Category: Joomla's Help
- Hits: 2043
I am not aware of any article hits reset feature built directly into Joomla 3.3. The are some Joomla extensions which can perform such an action.
This can be done also by manipulating data in the Joomla database.
Go to your database management tools provided by your hosting provider. Open phpMyAdmin.
You need to run the following SQL statement on the database for your Jommla instalation.
UPDATE `TABLE PREFIX_content` SET `hits` = 0
Replace the 'TABLE PREFIX' with your table prefix.
The above SQL statement will reset ALL article hits to 0.
In order to reset one article's hits value the SQL statement is :
UPDATE `TABLE PREFIX_content` SET `hits` = 0 WHERE `id` = ID
Replace the 'TABLE PREFIX' with your table prefix and replace the 'ID' with the article ID number.
These SQL statements can be run from SQL query section of phpMyAdmin in a typical hosting environment.
Please note the 'hits" = 0 can be substituted with 'hits' = [some other value] if you want to set the hit count to some other value.
This was tested on Joomla 3.3 installation and worked in our hosting environment. You environment may be different and the above instructions may result in unpredictable outcome. Therefore use the above instructions at your own risk.