Issue with views n download

Hi
i am reviewing the community and unfortunately unable to find the solution. Scheduling tasks include working on and sending emails to reviewers before their due dates. Statis usage plugin is installed.

Is there any suggestion

[11-Jun-2024 16:45:58 UTC] PHP Warning: assert(): assert(is_a($plugin, $classToCheck ?: ‘Plugin’)) failed in /home/aimsacademics/immi.se/lib/pkp/classes/plugins/PluginRegistry.inc.php on line 242
[11-Jun-2024 16:45:58 UTC] PHP Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1066 Not unique table/alias: ‘issue_p’ in /home/aimsacademics/immi.se/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:80
Stack trace:
#0 /home/aimsacademics/immi.se/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(80): PDO->prepare(‘select s.*, `…’, Array)
#1 /home/aimsacademics/immi.se/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(361): Doctrine\DBAL\Driver\PDOConnection->prepare(Object(Illuminate\Database\Query\Expression))
#2 /home/aimsacademics/immi.se/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database{closure}(Object(Illuminate\Database\Query\Expression), Array)
#3 /home/aimsacademics/immi.se/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback(Object(Illuminate\Database\Query\Expressi in /home/aimsacademics/immi.se/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 671
[11-Jun-2024 16:46:10 UTC] PHP Warning: assert(): assert(is_a($plugin, $classToCheck ?: ‘Plugin’)) failed in /home/aimsacademics/immi.se/lib/pkp/classes/plugins/PluginRegistry.inc.php on line 242

OJS 3.3.0-17

Hi @Rohaan123,

I’m not sure if the fatal error:

PHP Fatal error: Uncaught PDOException: SQLSTATE[42000]:
Syntax error or access violation: 1066
Not unique table/alias: ‘issue_p’ in .../pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:80

…is related to the stats processing issue, but I took a look through the 3.3.0-17 codebase, and the issue_p alias is only used in one place. I also can’t see any way that it could be getting added to the query twice. Do you have any customizations or 3rd-party plugins that might be interfering?

Regards,
Alec Smecher
Public Knowledge Project Team

Hi @Rohaan123,

Hmm, I still have the feeling there’s something outside of stock OJS interfering, but I can suggest a few ways to find it. Are you hosting on a Linux platform? If so, go to your OJS installation directory and run the following…

find . -name \*.php -not -path "./lib/pkp/lib/vendor/*" | xargs fgrep -l issue_p

…and…

find . -name \*.php -not -path "./lib/pkp/lib/vendor/*" | xargs fgrep -l appGet

…and…

find . -name \*.php -not -path "./lib/pkp/lib/vendor/*" | xargs fgrep -l modifySubmissionListQueryObject

…and…

find . -name \*.php -not -path "./lib/pkp/lib/vendor/*" | xargs fgrep -l Submission::getMany::queryObject

Regards,
Alec Smecher
Public Knowledge Project Team

Hi @asmecher
thanks
Here are some results. Are these fine or need further action?

[aimsacademics@s1088 ~]$ cd immi.se
[aimsacademics@s1088 immi.se]$ find . -name *.php -not -path “./lib/pkp/lib/vendor/*” | xargs fgrep -l issue_p
./classes/services/queryBuilders/SubmissionQueryBuilder.inc.php

[aimsacademics@s1088 immi.se]$ find . -name *.php -not -path “./lib/pkp/lib/vendor/*” | xargs fgrep -l appGet
./classes/services/SubmissionService.inc.php
./classes/services/queryBuilders/SubmissionQueryBuilder.inc.php
./lib/pkp/classes/services/queryBuilders/PKPSubmissionQueryBuilder.inc.php

[aimsacademics@s1088 immi.se]$ find . -name *.php -not -path “./lib/pkp/lib/vendor/*” | xargs fgrep -l modifySubmissionListQueryObject
./classes/services/SubmissionService.inc.php

[aimsacademics@s1088 immi.se]$ find . -name *.php -not -path “./lib/pkp/lib/vendor/*” | xargs fgrep -l Submission::getMany::queryObject
./classes/services/SubmissionService.inc.php

./lib/pkp/classes/services/queryBuilders/PKPSubmissionQueryBuilder.inc.php
[aimsacademics@s1088 immi.se]$

Hi @Rohaan123,

Those look as expected… Can you cause the error to appear in the log when you execute a particular action?

Regards,
Alec Smecher
Public Knowledge Project Team

Hi @asmecher

I have encountered the same error. I have observed that the abstract count functionality is not working, and the file download is functioning for the old issue. However, it is not working for new issues since 2023.

Hi @Rohaan123,

There are a few issues you’re raising here, and it’s a bit hard to follow them all at once; let’s stick with the error message in the post above. Can you cause this to appear in the error log by clicking a certain button or visiting a certain page?

Regards,
Alec Smecher
Public Knowledge Project Team