Question Recount statistics cron job?

Hello,

We're having an issue on our forum where the topic counts keep being off. However, that issue is quickly fixed whenever we use the "recount statistics" tool. But we have to manually use it for the counts to be correct. Is there a way we could run the recount statistics function on a cron job or something a like? Totally possible for us to code a plugin to run it as well.

Thanks!

Bumping this question. Hoping to get an answer.

inspry wrote:

Hello,

We're having an issue on our forum where the topic counts keep being off. However, that issue is quickly fixed whenever we use the "recount statistics" tool. But we have to manually use it for the counts to be correct. Is there a way we could run the recount statistics function on a cron job or something a like? Totally possible for us to code a plugin to run it as well.




Thanks!

thanks for the awesome information
jackyjoy
 

I think people on the forum have responded to this so many times that they have got fed up with it as by searching the forum you should find the answer. If you are talking about overall postings and not individual topic postings then Kunena counts come from Joomla, and Joomla  used to, and probably still does, counts everybody that visits the Joomla site even if they never login etc.  So all those bots trying to access Joomla get counted.  If you do a manual recount it does reset the count for the forum temporarily but then gets set to the Joomla counts.  Now I am not responsible for any Kunena forums at present and when I was they were not the very latest so things may have changed a bit.  I suggest that you look into other forum postings on this subject that will probably have more up to date information if this has changed.  There is also a security issue as if BOTs get through, as more appear to be doing so on Kunena's own forum. then they will get counted at the topic level.  You may have deleted postings in a subject and though locally recalculated the original number may still be in the database.

Hey Jackjoy,

The recounting is executed via Ajax requests running this function \KunenaAdminControllerTools::dorecount (administrator/components/com_kunena/controllers/tools.php).

You could extract the calls within this function into a custom CLI script or system plugin to automate this process.

Have success!

Kubik-Rubik wrote:

Hey Jackjoy,

The recounting is executed via Ajax requests running this function \KunenaAdminControllerTools::dorecount (administrator/components/com_kunena/controllers/tools.php).

You could extract the calls within this function into a custom CLI script or system plugin to automate this process.

Have success!
 

I did find that function and try to use it on a seperate script and allow the server to run a cron job on it, but it didn't seem to work as it was expecting soem sort of tokens from Joomla or the session? Unsure, but would it be possible for you to extract that working code for me and then I could run it with a cron job and see it it works?

Thanks! 

Any update on this?