Hi,
We recently upgraded our OJS from version 3.2.1.1 to 3.4.0.4.
We are using postgresql database.
We received a complaint that statistical download data was missing from a submission, but from a specific month (november):
As you can see from a snapshot taken by the internet archive, there should have been 123 downloads registered that month.
https://web.archive.org/web/20231208104428/https://www.revistas.usp.br/bjvras/article/view/205263
If I query directly in the database I find the downloads.
revistas=# select sum(metric) from metrics_submission where submission_id = 205263 and date BETWEEN ‘2023-11-01’ and ‘2023-11-30’ and file_type = 2;
sum
–
123
(1 row)
No error in the apache and postgresql logs.
We already had some similar problems, but when clearing both caches the count appeared correctly again.
Regards,
Tarcisio Pereira.