[OJS 3.4.0.5] Usage statistics Bar Chart has not updated since December

Software Support
1

Describe the issue or problem
We’ve noticed that the bar chart that shows download numbers on an article page has not updated since December. We are not entirely sure on what cycle it is supposed to update, but something seems to be going wrong. The problem seems to be platform wide (40+ journals), rather than journal specific, but I don’t know where to start searching for a solution and could not find relevant forum topics. No big changes or updates were made in December.

Steps I took leading up to the issue
For example:

  1. Go to Usage statistics display options
  2. Click on Use bar type of the chart for usage statistics display.
  3. Click on save.
  4. The bar charts show 0 downloads in January 2025 for our articles, even if there are downloads registered in the statistics overview of the journal.

What application are you using?
For example, OJS 3.4.0.5

Additional information

image
image809×499 15.2 KB

2

Update: the bar has updated for some articles with one, or two, downloads, but not close to the actual number for the month.

image
image820×503 13.8 KB

3

Hi everyone,

Has anyone found a solution for debugging this issue? I’m experiencing the same problem with an instance recently updated to version 3.3.0-19.

What’s strange is that this issue only affects one journal. The backend graphs display correctly, but on the frontend, the download chart in the single article page is missing months seemingly at random.

I’ve checked both the PHP/Apache error logs and the JavaScript console in the browser, but neither shows any relevant errors.

Any suggestions would be greatly appreciated.

Thanks
Alfredo

4

Hi Alfredo,

No, unfortunately we have not yet found a solution!

5

Hi @KayWP and @Alfredo_Cosco,

Maybe to mention that the graph only shows file downloads, and not abstract views. This could maybe be a reason why the numbers are different? Could you maybe double check this?
To see the number of article downloads for a month in the DB table (from where the numbers for the graph are taken from), you could execute this SQL for OJS 3.4, where you would need to adapt the submission ID and date/month:
SELECT SUM(metric) FROM metrics_submission WHERE submission_id = 1 AND assoc_type = 515 AND date_format(date, '%Y-%m') = '2025-02';
For OJS 3.3 it would be, I think:
SELECT SUM(metric) FROM metrics WHERE submission_id = 1 AND assoc_type = 515 AND month = '202502' AND metric_type = 'ojs::counter';

Also, the numbers are cached for a day. It is probably why the numbers for January above appeared later.

Best,
Bozana