[ojs3.3.0-17 with postgres] Problem with statistical data

Dear all,

I’m experiencing an issue with statistical data on my OJS (Open Journal Systems) platform, version 3.3.0-17 with Postgres.

While some journals display statistical data correctly on article pages, I have one journal that doesn’t display any statistics and another journal that only shows data up to a certain issue. All statistical reports provide results. However, when I use the “Generate custom report” feature and select “Article file downloads,” I encounter the following issues:

The journal that doesn’t display statistics for any articles generates an empty CSV file.
The other journal, which displays statistics for some articles, provides a CSV file with data only up to the last article with statistics.
Interestingly, if I use the “Advanced Options” and select ID, Type, Article, Month, and Issue, along with filtering all Object Types (Submission Files, Journal, Issue, Issue Galley, and Article), even the journal that doesn’t show any information sends the complete file.

I believe this could be a way to understand why the data isn’t being displayed on the site.

I’ve also checked the ‘usageEventLogs’ file, from which I extracted a snippet:

189.40.77.72 - - "2024-07-15 00:02:19" https://periodicos.ufes.br/simbiotica/simbiotica/article/download/39249/25727/127941 200 "Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Mobile Safari/537.36"
52.167.144.235 bot - "2024-07-15 00:02:21" https://periodicos.ufes.br/argumentum/argumentum/article/download/14476/12879/53742 200 "Mozilla/5.0 (iPhone; CPU iPhone OS 7_0 like Mac OS X) AppleWebKit/537.51.1 (KHTML, like Gecko) Version/7.0 Mobile/11A465 Safari/9537.53 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)"
143.54.174.76 - - "2024-07-15 00:02:21" https://periodicos.ufes.br/rbps/rbps/article/download/18870/12847/53514 200 "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36"
66.249.66.168 bot - "2024-07-15 00:02:22" https://periodicos.ufes.br/sebivix/sebivix/article/download/35002/23253/106720 200 "Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.6422.175 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
35.88.4.49 bot - "2024-07-15 00:02:23" https://periodicos.ufes.br/abrapem/abrapem/issue/view/479 200 "Mozilla/5.0"

"I’m not sure if it’s common for journal names to repeat, but in any case, among these journals, only RBPS (Brazilian Journal of Political Science) is unable to display statistical data.

I’m not sure if it’s related, but my config.ini.php contains the following snippet:

; Examples:
base_url[index] = https://periodicos.ufes.br/index
base_url[argumentum] = https://periodicos.ufes.br/argumentum
base_url[rbps] = https://periodicos.ufes.br/rbps
base_url[simbiotica] = https://periodicos.ufes.br/simbiotica
base_url[sebivix] = https://periodicos.ufes.br/sebivix
base_url[abrapem] = https://periodicos.ufes.br/abrapem
base_url[lemm] = https://periodicos.ufes.br/lemm
base_url[cnafricab] = https://periodicos.ufes.br/cnafricab
base_url[anaisconesef] = https://periodicos.ufes.br/anaisconesef

When inspecting the site, I find the following:


This one works.

However, when inspecting the other journal that doesn’t work, I see the following message:

Files generated by the statistical report for the same journal (RBPS):
Without advanced options:

With advanced options:

I apologize for the lengthy text, but I’ve been researching for days and trying to understand what might be happening.

Before, I had founded this error:

PHP Fatal error: Uncaught Error: Call to a member function getIssueIdentification() on null in /plugins/reports/views/ViewReportPlugin.inc.php:86\nStack trace:\n#0 /lib/pkp/pages/stats/PKPStatsHandler.inc.php(450): ViewReportPlugin->display()\n#1 /lib/pkp/pages/stats/PKPStatsHandler.inc.php(395): PKPStatsHandler->report()\n#2 /lib/pkp/classes/core/PKPRouter.inc.php(395): PKPStatsHandler->reports()\n#3 /lib/pkp/classes/core/PKPPageRouter.inc.php(246): PKPRouter->_authorizeInitializeAndCallRequest()\n#4 /lib/pkp/classes/core/Dispatcher.inc.php(144): PKPPageRouter->route()\n#5 /lib/pkp/classes/core/PKPApplication.inc.php(362): Dispatcher->dispatch()\n#6 /index.php(68): PKPApplication->execute()\n#7 {main}\n thrown in /plugins/reports/views/ViewReportPlugin.inc.php on line 86 

I’ve already followed the suggestions in this post:
View Report fails with PHP Fatal error: Uncaught Error: Call to a member function getIssueIdentification() on null in /plugins/reports/views/ViewReportPlugin.inc.php:86 - #8 by Nason_Bimbe, and removed all orphaned articles.
Thenceforth, the log file doesn’t record any errors.However, I’m still unable to find a solution. :blush:

If anyone has insights or suggestions on how to resolve this issue, I would greatly appreciate your help. Thank you! :blush: