I have not yet found a way to reset the study hit counters to zero. Now that I am 95% satisfied with my installation it's time to make it available to registered users on my site, but I would like to measure their use from this date - not my numerous tests during development. What have I missed?

If you have access to phpmyadmin, you could use sql:


(the jst prefix for table name might be different for you..)

Could temporarily install the joomMyAdmin component if you don't have access to phpmyadmin easily..
extensions.joomla.org/extensions/hosting...base-management/3284

But you must uninstall it straight away afterwards cos it would be a security issue otherwise.

Thanks Richard. That's what I thought was the only way. That's more trouble and risk than this it is worth to me right now. I will just save a screenshot of the study listing showing current hit values and subtract those figures from future ones. Thanks again!

If you want to reset the counters for all of your studies, what you can do is go into PHPmyAdmin to the "jos_bsms_studies" and delete the "hits" attribute. That will delete the hits from all of the records (and temporarily break the component). Then, re-add the "hits" attribute, and set a default value of to "0". That will set the hits for all of the studies to 0. Make sure you maintain the same properties of the original attribute. I believe you just have to make it an INT() dataType.

I'll put in a feature request to make this an option - maybe as a custom button on the top of a study.

SQL might be EMPTY hits FROM #__bsms_studies where id = $cid

Tom

Is there any way to stop search robots from upping the hit counter, without stopping them from indexing your sermons? (Probably a generic Joomla! question.)