MASSMEDIUMS - Responsive Web Design Cincinnati MASSMEDIUMS - Responsive Web Design Cincinnati

Reset Joomla 3.x article hits & revisions in SQL

When you're in the midst of a Joomla web development project, it is of course a necessity that you view the pages of the website as you are working on the site. The unfortunate side effect is that the site will in-turn show a bloated view count by the time you are ready to launch the project.

If you're like me, you find this unnerving. Fortunately, there is an easy way to reset the article count in MySQL just before you deploy the. Simply run the following SQL command (make sure to replace XXXX_ with your table prefix) and your site will return to a clean and orderly state:

# Update a all articles 
UPDATE `XXXXX_content` SET `hits` = 0 ;
UPDATE `XXXXX_content` SET `version` = 1 ;
# Update a single article 
UPDATE `XXXXX_content` SET `hits` = 0 WHERE `id` = * ;
UPDATE `XXXXX_content` SET `version` = 1 WHERE `id` = * ;
  • Home
  • Blog
  • Cheatsheet for SSH & Linux Shell commands
Ready to get started? Let us take your website to the next level. LET'S TALK
MASSMEDIUMS has been essential in the growth of our company, delivering high-impact marketing tools and a first-rate web presence

, VP, Ziegler Practice Transitions